Oracle DBA Automation Scripts shows you how to build the scripts that automate the daily operations of Oracle database management. These scripts will work in a variety of environments, including the Windows NT, Sun Solaris 2.x, Sun OS 5.x, HP-UX 11.x, and AIX 4.x operating systems. You'll learn the command differences between these operating systems and how to write scripts to integrate SQL with your OS. Whether you're an aspiring DBA or you have a few years under your belt, you'll be able to use the commands and scripts presented here to install, operate, manage, and tune Oracle databases.
The scripts developed for the book in one convenient downloadable Zip file -- Examples.zip (48 KB)
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.
Writing Scripts in Unix. Writing Scripts in Windows Batch Programming.
Backup and Recovery under Unix. Hot Backup. Backup and Recovery under Windows NT. Recovery Principles. Backup and Recovery Tools. Sample Files.
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.
Database Tuning. Application Tuning. System Tuning.
Regular Locks. Deadlock. Types of Locks. Common Locking Problems. Lock Resolution Process.
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.
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.
Default Accounts in the Database. DBA User Authentication and Connection. Creating Users. Auditing.
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.
Sizing Tables. Sizing Indexes.
Automation in Unix. Automation in Windows NT. Monitoring Messages.
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.
Unix Basic Commands. Unix Advanced Commands. Unix Startup and Shutdown Process. Windows NT Batch Programming. ipconfig.