Oracle DBA Automation Quick Reference

CHARLIE RUSSEL has extensive system administration and Oracle DBA experience, specializing in combined Windows and UNIX environments. He is co-author of more than 20 books for IT professionals, including Microsoft Windows Server 2003 Administrator's Companion (Microsoft Press) and UNIX and Linux Answers! Certified Tech Support (IDG). ROBERT CORDINGLEY is an Oracle DBA in Austin,Texas. Russel and Cordingley have co-authored Oracle DBA Scripting Quick Reference and Oracle DBA SQL Quick Reference (Prentice Hall PTR).

Introduction.


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.



Index.