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
Table of Contents
Who Should Read This Book? What Makes This Book
1. Role of the DBA.
What Is a DBA? Types of DBAs. Database
Administration Principles. Database Administration Responsibilities. Roles
Within the IT Organization. DBA Mindset. Summary.
2. Architecture of the Oracle Server.
Oracle Products Relating to Database Servers.
Database Versus Instance. Oracle File Types. Memory Structures. Oracle
Processes. Transaction Control. Miscellaneous Database Files. Summary.
3. Planning a Database.
System Architecture. Capacity Planning/Sizing.
Optimal Flexible Architecture. Application and Database Considerations. Summary.
4. Machine Setup and Installation.
Pre-Installation Setup. Installing Oracle.
5. Creating a Database.
Generating Creation Scripts. Creating the
Database. Post-Creation Activities. Configuring Net8 for the New Database.
Customizing Your .profile File. Summary.
6. Daily Activities.
Database Views. Oracle Startup/Shutdown. User
Management. Space Management. Monitoring. Summary.
7. GUI Management Products.
Oracle Enterprise Manager. TOAD. Summary.
8. DBA Utilities.
Export and Import. Common Export/Import Uses.
Maintenance Benefits of Export/Import. Advanced Export and Import Techniques.
Using SQL*Loader. Using LogMiner. Summary.
9. Backup and Recovery.
Importance of Backups. Backup Types. Incurring
Damage on the Database. Performing Backups and Recoveries. Comprehensive
Planning and Testing. Summary.
10. When Things Go Wrong.
Responding to Problems. File and Space
Management. Locking. "Snapshot Too Old" Rollback Errors. Summary.
11. Oracle Server Tuning.
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.
12. Unix Operation System Architecture.
Imperative Concepts. Understanding the Kernel.
Startup/Shutdown Processes in Unix. Understanding the Hardware Architecture.
13. Unix Server Monitoring.
Need for Monitoring the Server. Overview of
Monitoring the Server. Monitoring Memory Issues. Monitoring Disk I/O. Monitoring
the CPU. Monitoring the Network. Summary.
14. Patches and Upgrades.
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.
16. Java Inside the Database Server.
Understanding the Role and Future of Java Inside
Oracle. Java Overview. Supporting Java with Oracle. Managing Java Inside the
17. WebDB/Oracle Portal.
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.
18. Internet Application Server (iAS).
Web Environment. Understanding and Using iAS.
Installation. Configuration File Location and Apache Control. Summary.
19. 9i Server New Features.
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.
20. Growth of the DBA.
Growth of the DBA. Motivation. Continuing Your
Education. Getting Certified. Networking with Other DBAs. Learning Systems
Administration and Architecture. Learning Java. Summary.
Appendix A. Basic Unix Commands.
Appendix B. vi Editor.
Cursor-Movement Commands. Entering Text. Editing
Text. Saving and Exiting. Miscellaneous Commands.
Appendix C. Scripts.
Hot Backup Script.