Oracle DBA Automation Scripts

Rajendra Gutta is a Senior Principal Consultant and DBA with Oracle Corporation, holds a Bachelors degree in Computer Science, a Masters in Technology Management, and is an Oracle Certified Professional (OCP). More importantly, he spends his days solving the problems of experienced enterprise-level DBAs and knows the obstacles they face.

Introduction.


1. Oracle Software Installation.


General Installation Steps. Oracle Installation on Unix Systems: Example. Getting to Know Your Database. Managing Multiple Oracle Instances in Unix. Semaphores and Shared Memory Segments. Oracle Installation on Windows NT: Example. Post Installation Steps. Getting to Know Your Database. Managing Multiple Instances in Windows NT.



2. Building Blocks.


Writing Scripts in Unix. Writing Scripts in Windows Batch Programming.



3. Backup and Recovery Scripts.


Backup and Recovery under Unix. Hot Backup. Backup and Recovery under Windows NT. Recovery Principles. Backup and Recovery Tools. Sample Files.



4. Space Management Scripts.


Space Reporting Scripts for Unix and Windows NT. Datafile Space Utilization Report. Tablespace Space Utilization Report. Tablespace Freespace Fragmentation Report. Table Segment Space Usage Report. Index Segment Space Usage Report. Rollback and Temp Segment Usage Report. All Object Space Usage Report. Space Management Automation Scripts for Unix. Space Management Automation Scripts for Windows NT.



5. Database Performance Monitoring Scripts.


Database Tuning. Application Tuning. System Tuning.



6. Locking Scripts.


Regular Locks. Deadlock. Types of Locks. Common Locking Problems. Lock Resolution Process.



7. Net8.


Net8 Configuration. Net8 Configuration for Multiple Instances. Configuring Oracle Forms to Connect to Database. Reserving Port for Listener Services. Net8 Server Troubleshooting. Multithreaded Server Configuration. Load Balancing. Network Statistics. Using Net8 Assistant Configuration Tool.



8. Process Monitoring Scripts.


Background Process Checking. Listener Process Checking. Runaway and User Process Checking. Processes and CPU Usage. Process Monitoring Script. Connectivity Checking. Windows NT. Processes and CPU Usage.



9. User Management Scripts.


Default Accounts in the Database. DBA User Authentication and Connection. Creating Users. Auditing.



10. Database Maintenance and Reorganization.


Room for Maintenance. Why Reorganize? Planning Reorganization. Gathering Database Statistics Before Reorganization. Definitions of Fragmentation. Checking Row and Index Fragmentation. Changing Object Storage Parameters. Reorganizing the Whole Database. Manual Database Creation Process. Migrating the Database to a Different OS. Database Cloning. Recreating the Control File. Purging Old Log Files.



11. Database Sizing.


Sizing Tables. Sizing Indexes.



12. Automating Scripts.


Automation in Unix. Automation in Windows NT. Monitoring Messages.



13. Unix, Windows NT, and Oracle.


Administration of Oracle under Sun Solaris 2.x. Administration of Oracle under HP-UX 11.x. Administration of Oracle under AIX 4.x. Sample Output. Administration of Oracle under Windows NT.



14. Unix and Windows NT Commands for DBAs.


Unix Basic Commands. Unix Advanced Commands. Unix Startup and Shutdown Process. Windows NT Batch Programming. ipconfig.



Index.