+612 9045 4394
Oracle9i for Windows 2000 : Tips and Techniques - Scott Jesse

Oracle9i for Windows 2000

Tips and Techniques

Paperback Published: 1st December 2001
ISBN: 9780072194623
Number Of Pages: 676

Share This Book:


RRP $122.00
or 4 easy payments of $22.24 with Learn more
Ships in 7 to 10 business days

Windows as a platform for databases continues to grow and Oracle on Windows continues to become more important. Written by the team at Oracle, this book provides undocumented tips and techniques and covers issues central to database administration, features of 9i and highlights issues specific to Windows 2000. The core of the book is aimed at providing undocumented tips and techniques for maximizing the utility of the RDBMS. Coverage in this book includes: tuning, and backup and recovery; clustering and standby databases focusing on high availability; features in 9i-highlighting differences between 9i and 8i; centralizing and simplifying database administration using Enterprise Manager; and developing an upgrade and migration strategy.

Forewordp. xxi
Acknowledgementsp. xxiii
Introductionp. xxvii
Windows 2000p. 3
Oracle and Microsoftp. 4
Windows 2000p. 5
A Brief Look Inside Windows 2000p. 7
Securityp. 18
The Windows 2000 Interfacep. 21
The Registry and the Environmentp. 23
Summaryp. 27
Overview of Oracle9i RDBMSp. 29
Process Architecturep. 30
The Oracle Instancep. 34
The Database Filesp. 39
Internal Database Managementp. 44
Database Integrity Checksp. 53
Summaryp. 56
Implementing the Oracle RDBMS on Windows 2000
Configuring Windows 2000p. 61
Tuning Windows for Oraclep. 63
Microsoft Management Consolep. 70
Command-Line Managementp. 79
System Administrationp. 92
The Operating System Environmentp. 101
Remote Administrationp. 106
Resourcesp. 109
Looking Aheadp. 111
Summaryp. 113
Installing and Configuring the Oracle RDBMSp. 115
History of Oracle on Windows NTp. 117
The Oracle Universal Installerp. 120
Beginning the Installationp. 123
Creating the Databasep. 130
The Database Storage Pagep. 143
Deinstalling Oracle Productsp. 153
Summaryp. 155
Advanced Database Administration for Windows 2000p. 157
Advanced Database Creation and Managementp. 159
Oracle Memory Usage on Windows 2000p. 168
Using the Performance Monitorp. 183
Using the Oracle Administration Assistantp. 194
Additional 9i Featuresp. 199
Summaryp. 208
Backup and Recovery Considerationsp. 209
Base Your Backup Strategy on Your Business Needsp. 211
Align Backup Strategies with Business Needs Before Agreeing to a Service Level Agreementp. 213
Cold Backups Make Your Life Easierp. 214
Using Windows 2000 Backup Utilityp. 216
Third-Party Backup Productsp. 217
Understanding and Implementing Hot Backupsp. 217
Leveraging Server Managed Recoveryp. 220
Understanding the Oracle9i Recovery Manager Architecturep. 221
RMAN Configuration: A Primerp. 223
RMAN Integration with Media Management Softwarep. 226
Understanding the Benefits of an RMAN Implementationp. 227
RMAN Backups: Syntax and Usagep. 231
Establishing Persistent Backup Parametersp. 241
RMAN Restore and Recovery: A Primerp. 242
RMAN Recovery: Syntax and Usagep. 245
Understanding and Using Incomplete Recoveryp. 248
Using RMAN Backups to Create Clone Copies of Production Databasesp. 257
Test All Backups for Recoverabilityp. 262
Summaryp. 262
Windows 2000: The Premiere Enterprise Management Platform
Oracle Connectivityp. 265
The Oracle Net Architecturep. 267
Connectivity Configurationp. 295
General Network Tuning and Configurationp. 316
Resourcesp. 318
Summaryp. 321
Oracle Enterprise Managerp. 323
EM Functionalityp. 324
EM Frameworkp. 329
The Agentp. 342
Eventsp. 346
Jobsp. 355
Database Administrationp. 358
The Oracle Management Serverp. 363
EM Web Reportingp. 368
EM 3-Tier Infrastructure and Firewallsp. 375
EM Reference and Helpp. 376
Summaryp. 378
Advanced Management, Tools, and Analysisp. 379
Techniques with Toolsp. 380
Tools for Holistic Database Managementp. 398
Summaryp. 412
Change Managementp. 413
Upgrading the Operating Systemp. 414
Migrating or Upgrading the Oracle Databasep. 419
Upgrading in a Clustered or Standby Environmentp. 434
Summaryp. 438
Clustering and High Availability
Oracle Failsafep. 441
Oracle Failsafe Conceptsp. 443
Designing an Oracle Failsafe Solutionp. 447
Preparing to Install MSCSp. 450
Installing Microsoft Cluster Serverp. 453
Installing Oracle Failsafep. 458
Making the Database Failsafep. 462
Troubleshooting in a Failsafe/MSCS Environmentp. 472
Summaryp. 476
Oracle Real Application Clustersp. 477
The RAC Environmentp. 479
Preparing for the Cluster Installationp. 481
Installing the Cluster Software and Oracle9i RDBMSp. 493
Maintaining a RAC Instancep. 502
Summaryp. 507
The Standby Databasep. 509
Standby Database Architecturep. 510
Traditional Standby Configuration: A Test Casep. 518
Utilizing Oracle9i Log Transport Servicesp. 523
Using Oracle9i Data Guard for Standby Database Managementp. 525
Use RMAN to Configure the Standby Databasep. 528
Use the Standby Database for RMAN Backups of the Production Databasep. 529
Summaryp. 531
Oracle9i Advance Replicationp. 533
Replication: Load Balancing, Disaster Recovery, and Distributed Offline Transaction Processingp. 535
The Advanced Replication Architecturep. 536
Replication and Database Performancep. 539
Replication Manager vs. Replication APIp. 539
N-Way Setup and Configurationp. 540
Conflict Resolution Techniquesp. 553
Offline Instantiationp. 554
Administration of the Replication Environmentp. 556
Conclusions and Advice for the Replication DBAp. 558
Summaryp. 559
Maximizing Availabilityp. 561
Transparent Application Failoverp. 562
Real Application Clusters Guardp. 564
Backing Up a RAC Database Using RMANp. 581
Creating a Single Instance Standby Database from a Cluster Databasep. 587
Summaryp. 590
Media Management Configuration for RMAN Backups to Tapep. 593
VERITAS NetBackupp. 594
NetBackup Configuration for RMAN Backupsp. 594
Monitoring Backups from the NetBackup Serverp. 596
Generating and Finding Diagnostic Information for Oracle 9ip. 599
Oradebugp. 600
Dumping Information to Trace Filesp. 602
Tracing SQLp. 605
More to Explorep. 611
Indexp. 613
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9780072194623
ISBN-10: 0072194626
Series: Oracle Press Series
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 676
Published: 1st December 2001
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.5 x 19.1  x 3.4
Weight (kg): 1.14