Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9I coverage; and iAS--Internet Application Server.
Who Should Read This Book? What Makes This Book Different?
What Is a DBA? Types of DBAs. Database Administration Principles. Database Administration Responsibilities. Roles Within the IT Organization. DBA Mindset. Summary.
Oracle Products Relating to Database Servers. Database Versus Instance. Oracle File Types. Memory Structures. Oracle Processes. Transaction Control. Miscellaneous Database Files. Summary.
System Architecture. Capacity Planning/Sizing. Optimal Flexible Architecture. Application and Database Considerations. Summary.
Pre-Installation Setup. Installing Oracle. Summary.
Generating Creation Scripts. Creating the Database. Post-Creation Activities. Configuring Net8 for the New Database. Customizing Your .profile File. Summary.
Database Views. Oracle Startup/Shutdown. User Management. Space Management. Monitoring. Summary.
Oracle Enterprise Manager. TOAD. Summary.
Export and Import. Common Export/Import Uses. Maintenance Benefits of Export/Import. Advanced Export and Import Techniques. Using SQL*Loader. Using LogMiner. Summary.
Importance of Backups. Backup Types. Incurring Damage on the Database. Performing Backups and Recoveries. Comprehensive Planning and Testing. Summary.
Responding to Problems. File and Space Management. Locking. "Snapshot Too Old" Rollback Errors. Summary.
Database Tuning Approach. Diagnostic Utilities: UTLBSTAT/UTLESTAT and STATSPACK. Tuning Memory Structures. Tuning Rollback Segments. Avoiding File Contention. Wait Events. Locally Managed Tablespaces. Tuning Tables. Indexes. Summary.
Imperative Concepts. Understanding the Kernel. Startup/Shutdown Processes in Unix. Understanding the Hardware Architecture. Summary.
Need for Monitoring the Server. Overview of Monitoring the Server. Monitoring Memory Issues. Monitoring Disk I/O. Monitoring the CPU. Monitoring the Network. Summary.
What Are Patches and Upgrades? When and How to Apply Patches. When and How to Upgrade. Additional Considerations. Summary.
What Is a Migration. Reasons to Migrate Your Database. Preparation. Migration Methods. Using ODMA. Summary.
Understanding the Role and Future of Java Inside Oracle. Java Overview. Supporting Java with Oracle. Managing Java Inside the Database. Summary.
What Are WebDB and Oracle Portal? WebDB/Oracle Portal Architecture. Installation. Basic WebDB Maintenance. Log into the Site. Key Differences between Oracle Portal and WebDB. Summary.
Web Environment. Understanding and Using iAS. Installation. Configuration File Location and Apache Control. Summary.
Installing the 9i Server. Setting Up Security and Logging In. Creating a Server Parameter File (SPFILE). Using Oracle-Managed Files. Using Dynamic Memory Parameters and Multiple Block Sizes. Using Undo Tablespaces. Comprehensive Sample Schemas. Miscellaneous Features and Changes. Summary.
Growth of the DBA. Motivation. Continuing Your Education. Getting Certified. Networking with Other DBAs. Learning Systems Administration and Architecture. Learning Java. Summary.
Cursor-Movement Commands. Entering Text. Editing Text. Saving and Exiting. Miscellaneous Commands.
Hot Backup Script.