Oracle DBA Automation Quick Reference

Charlie Russel, Robert L. Cord

  • 出版商: Prentice Hall
  • 出版日期: 2004-04-26
  • 售價: $1,180
  • 貴賓價: 9.5$1,121
  • 語言: 英文
  • 頁數: 312
  • 裝訂: Paperback
  • ISBN: 013140301X
  • ISBN-13: 9780131403017
  • 相關分類: Oracle





  • Fast, easy automation for every Oracle 9i and 10g DBA!
  • Quick access to real-world examples
  • Installation, database creation, management, monitoring, tuning, and backup/recovery
  • Oracle Universal Installer (OUI), Oracle Net Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)

      The fast, practical Oracle 9i/10g automation reference for every DBA!

      Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use. Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now!

      • Master scripting for both Oracle 9i and Oracle 10g!
      • Use Oracle Universal Installer to create response files for automating any installation
      • Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation
      • Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts
      • Manage files and tablespaces, tune memory, perform backup/recovery, schedule automated administration tasks, and more
      • Extend and customize any script to your own needs
      • Includes concise reference to Perl DBI and its Oracle-specific components—with real-world examples and syntax
    • Table of Contents:


      Why Automate? Improved Productivity. Improved Quality. Use What's Already There. Test Everything First. What's in this Book? Talk to Us. Acknowledgements.

      1. Oracle Universal Installer.

      Automated Installation. Reference. Sample Files.

      2. Network Configuration.

      Automated Network Configuration. Command Line Parameters. Oracle's Sample Response Files. Response File Syntax. Example NetCA Response File.

      3. Database Creation.

      Using the DBCA. Automating Database Creation without the DBCA. Automating Database Deletion without the DBCA. Reference. Sample DBCA Response File. Sample Database Template. Basic Initialization (init.ora) Parameters. oradim Command Line Parameters.

      4. Day-to-Day Administration.

      Use What's Already There. Test Everything First. File and Tablespace Management. Automatic Memory Tuning. Scheduling. Scheduling Reference.