Résumé
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.
1. Role of the DBA.
2. Architecture of the Oracle Server.
3. Planning a Database.
4. Machine Setup and Installation.
5. Creating a Database.
6. Daily Activities.
7. GUI Management Products.
8. DBA Utilities.
9. Backup and Recovery.
10. When Things Go Wrong.
11. Oracle Server Tuning.
12. Unix Operation System Architecture.
13. Unix Server Monitoring.
14. Patches and Upgrades.
15. Migrations.
16. Java Inside the Database Server.
17. WebDB/Oracle Portal.
18. Internet Application Server (iAS).
19. 9i Server New Features.
20. Growth of the DBA.
Appendix A. Basic Unix Commands.
Appendix B. vi Editor.
Appendix C. Scripts.
Glossary.
Index.
Table of Contents
Introduction.
Who Should Read This Book?
What Makes This Book Different?
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. Summary.
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. MaintenanceBenefits 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.
Summary.
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.
15. Migrations.
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 Database.
Summary.
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. Summary.
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.
Glossary.
Index.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Sams |
| Auteur(s) | Michael Wessler |
| Parution | 27/12/2001 |
| Nb. de pages | 584 |
| Format | 18,6 x 23,1 |
| Couverture | Broché |
| Poids | 1004g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780672321580 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
