SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Register your product to gain access to bonus material or receive a coupon.
Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tuning. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.
WARNING
Almost all of the code files have to modified to suit your particular application and/or situation. Neither the author nor the publisher assumes responsibility for use or misuse of the code.
Customizing Installation Options
Customizing Oracle 10g Installation Options
Introduction.
Who Should Read This Book
What You Need to Use This Book
How This Book Is Organized
About the Book's Sample Code
Conventions Used in This Book
I. GETTING STARTED WITH ORACLE DATABASE 10G.
1. Exploring Oracle Database 10g Architecture.
Overview of New Features
SYSAUX Tablespace
Rename Tablespace Option
Automatic Storage Management
Temporary Tablespace Group
BigFile Tablespace
Cross-Platform Transportable Tablespaces
Performance Management Using AWR
Automatic Database Diagnostic Monitor (ADDM)
DROP DATABASE Command
Data Pump Utilities
Processes Beneath the Hood
Classification of Database Processes
Memory Architecture
System Global Area (SGA)
Program Global Area (PGA)
Memory Manager (MMAN)
Automatic Undo Management
SQL Advisors
Oracle's Suite of Other Advisors
Flash Recovery Area
Flashback Operations
Flashback Database
Improved Oracle Enterprise Manager
Grid Technology Unveiled
Summary
2. Installing Oracle Database 10g.
Installation Decisions
Prerequisites
Overview of Silent Installation
Installing 10g on UNIX/Linux
Installation Steps
Platform-Independent Database Installation Questions
Optimal Flexible Architecture (OFA)
Common Steps for Installation
Components to Access Other Databases and Applications
Oracle Database 10g DBCA Overview
Tracing the Database Configuration Assistant (DBCA)
Installing 10g on Windows
Companion CD Installation and Patches (All Platforms)
Manual Database Installation Steps
Installation Checklists
Database and Binary Cloning
Using Enterprise Manager for Cloning
Migrating a Database from 8i or 9i
Overview of Database Upgrade Assistant
Upgrade Path for Standby Environments
Database Upgrade Assistant in Silent Mode
Using DBUA with Oracle 9i Physical Standby Configuration
Using DBUA with Oracle 9i Logical Standby Configuration
Applying Patches to Database Installations
Uninstalling from a Failed Install
Step 1: Identify All Database Instances
Step 2: Remove the Database(s)
Step 3: Remove the Oracle Software