Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Administering Oracle Database 10g

• 1.1 Overview
  • 1.1.1 Oracle Database 10g Code
    • 1.1.1.1 ORACLE.EXE File
  • 1.1.2 Oracle Database 10g Instances
    • 1.1.2.1 System Global Area
    • 1.1.2.2 Storing Data
    • 1.1.2.3 Storing Changes to the Database
    • 1.1.2.4 Using Redo Log Files
    • 1.1.2.5 Using Logical Names
  • 1.1.3 Logical Names Data Files: Locations and Identifying
• 1.2 Initialization Parameters
  • 1.2.1 Maximum Value of DB_BLOCK_SIZE Initialization Parameter
  • 1.2.2 CLUSTER_INTERCONNECTS Initialization Parameter
• 1.3 Database Limits
• 1.4 Operating System Accounts and Groups
• 1.5 Security
  • 1.5.1 Security for SQL*Plus Command
  • 1.5.2 Security for Database Files
  • 1.5.3 Customizing the Initialization File
  • 1.5.4 Running the orapwd Utility
  • 1.5.5 Password Management
  • 1.5.6 Security for External Jobs
• 1.6 Using Trace and Alert Files
  • 1.6.1 Trace Files
  • 1.6.2 Alert Files
• 1.7 PL/SQL Gateway
• 1.8 Oracle HTTP Server Powered by Apache
• 1.9 Granting Access to Oracle Database 10g Users

2 Starting and Stopping Oracle Software

• 2.1 Starting Up Oracle Database 10g
  • 2.1.1 Before Starting Up
  • 2.1.2 Starting Oracle Database 10g by Using SQL*Plus
    • 2.1.2.1 Identifying the Current Instance
    • 2.1.2.2 Specifying Startup Parameters
    • 2.1.2.3 Starting the Server Using SQL*Plus
  • 2.1.3 Starting Oracle Database 10g Remotely by Using SQL*Plus from an OpenVMS Client
    • 2.1.3.1 Steps to Perform on a Remote System Database
    • 2.1.3.2 Steps to Perform on a OpenVMS Client System
  • 2.1.4 Starting Oracle Database 10g Remotely by Using SQL*Plus from a Microsoft Windows PC Client
    • 2.1.4.1 Steps to Perform on Remote System Database
    • 2.1.4.2 Steps to Perform on a Microsoft Windows Client System
• 2.2 Shutting Down Oracle Database 10g
  • 2.2.1 Shutting Down Oracle Database 10g by Using SQL*Plus
  • 2.2.2 Stopping Oracle User Processes Before Database Shutdown
  • 2.2.3 Removing Sharable Images
• 2.3 Oracle Net Listener
  • 2.3.1 Oracle Management Agent

3 Configuring Oracle Products

• 3.1 Configuring the Database for Additional Oracle Products
• 3.2 Using Configuration Assistants as Standalone Tools
  • 3.2.1 Using Oracle Net Configuration Assistant
  • 3.2.2 Using Database Configuration Assistant
  • 3.2.3 Configuring New or Upgraded Databases
• 3.3 Relinking Executables
  • 3.3.1 Support for Shared Libraries in RMAN

4 Administering SQL*Plus

• 4.1 Administering Command-Line SQL*Plus
  • 4.1.1 Using Setup Files
    • 4.1.1.1 Using the Site Profile File
    • 4.1.1.2 Using the User Profile File
  • 4.1.2 Using the PRODUCT_USER_PROFILE Table
  • 4.1.3 Using Demonstration Tables
    • 4.1.3.1 Performing a Typical Installation
    • 4.1.3.2 Creating Demonstration Tables Manually
    • 4.1.3.3 Deleting Demonstration Tables
• 4.2 SQL*Plus Command Line Help
  • 4.2.1 Installing the SQL*Plus Command Line Help
  • 4.2.2 Removing SQL*Plus Command Line Help
• 4.3 Using Command-Line SQL*Plus
  • 4.3.1 Using a System Editor from SQL*Plus
  • 4.3.2 Running Operating System Commands from SQL*Plus
  • 4.3.3 Interrupting SQL*Plus
  • 4.3.4 Using the SPOOL Command
• 4.4 SQL*Plus Restrictions
  • 4.4.1 Resizing Windows
  • 4.4.2 Return Codes

5 Configuring Oracle Net Services

• 5.1 Oracle Net Services Configuration Overview
  • 5.1.1 Centralized Configuration
  • 5.1.2 Client/Server Configuration
  • 5.1.3 Distributed Database Configuration
• 5.2 Oracle Net Services Installation
• 5.3 Oracle Net Services and TNS
• 5.4 Protocol Adapters
  • 5.4.1 IPC-Mailbox Protocol
  • 5.4.2 TCP/IP Protocol
  • 5.4.3 BEQ-Bequeath Protocol
  • 5.4.4 Bequeath Listener
    • 5.4.4.1 Starting Up the Bequeath Listener
    • 5.4.4.2 Determining the Status of the Bequeath Listener
    • 5.4.4.3 Shutting Down the Bequeath Listener
    • 5.4.4.4 Problem Resolution
    • 5.4.4.5 Bequeath Listener Privileges
• 5.5 TNS Listener
  • 5.5.1 LSNRCTL
  • 5.5.2 TNS Listener Privileges
  • 5.5.3 Process Quotas
  • 5.5.4 ORASRV_NETV2_SID Command File
  • 5.5.5 General Connections
  • 5.5.6 Trace Information for TCPIP connection
• 5.6 Advanced Security Option
  • 5.6.1 Manual Steps for Authentication Adapters
  • 5.6.2 Usage Notes for Authentication Adapters
• 5.7 Oracle Net Services Configuration Files
• 5.8 Configuring Oracle Net Services Protocol Support
  • 5.8.1 ADDRESS Specification
• 5.9 BEQ Protocol Support
• 5.10 IPC Protocol Support
• 5.11 TCP/IP Protocol Support
  • 5.11.1 Specifying a TCP/IP ADDRESS

6 Using Oracle Precompilers and the Oracle Call Interface

• 6.1 Overview of Oracle Precompilers
  • 6.1.1 Precompiler Configuration Files
  • 6.1.2 Precompiler Executables
    • 6.1.2.1 Precompiler README files
  • 6.1.3 Precompiler README Files
  • 6.1.4 Issues Common to All Precompilers
  • 6.1.5 Static and Dynamic Linking
  • 6.1.6 Client Shared and Static Libraries
• 6.2 Precompiling
  • 6.2.1 Syntax
  • 6.2.2 Guidelines and Restrictions
• 6.3 Compiling
  • 6.3.1 Compiler Options Used to Compile Oracle Database 10g
  • 6.3.2 Floating Point Format
    • 6.3.2.1 Application Compatibility for Floating Point Format
  • 6.3.3 Pro*COBOL
• 6.4 Linking
  • 6.4.1 Syntax
  • 6.4.2 Linking Precautions
  • 6.4.3 Guidelines for Linking
• 6.5 Pro*C/C++ Precompiler
  • 6.5.1 Pro*C/C++ Demonstrations
  • 6.5.2 Pro*C/C++ User Programs
  • 6.5.3 Operating System (OpenVMS) Header Files
• 6.6 Pro*COBOL Precompiler
  • 6.6.1 Pro*COBOL Oracle Runtime System
  • 6.6.2 Pro*COBOL Demonstrations
  • 6.6.3 Pro*COBOL User Programs
  • 6.6.4 FORMAT Precompiler Option
  • 6.6.5 Pro*COBOL Restriction
• 6.7 Pro*FORTRAN Precompiler
  • 6.7.1 Pro*FORTRAN Demonstrations
  • 6.7.2 Pro*FORTRAN User Programs
• 6.8 Using the Oracle Call Interface Routines
  • 6.8.1 Guidelines
  • 6.8.2 CDA/LDA Structure Information
    • 6.8.2.1 Size and Offsets of Structure Elements
  • 6.8.3 Linking Oracle Call Interface Programs Written in the C Programming Language
  • 6.8.4 Linking Oracle Call Interface Programs Written in Other Languages
• 6.9 Data Areas and Data Types
• 6.10 Using Literals as Call Arguments
• 6.11 Optional or Missing Parameters
• 6.12 Using Event Flags
• 6.13 Custom Link Files
• 6.14 Multithreaded Applications

7 Building and Running Demonstrations

• 7.1 PL/SQL Demonstrations
  • 7.1.1 PL/SQL Kernel Demonstrations
  • 7.1.2 PL/SQL Precompiler Demonstrations
• 7.2 RDBMS Demonstrations
  • 7.2.1 Extensible Indexing Demonstrations
• 7.3 RDBMS C++ File Demonstrations
• 7.4 RDBMS Java File Demonstrations
  • 7.4.1 aqjms Demonstrations
  • 7.4.2 rmanpipe.sql Demonstrations
  • 7.4.3 JavaVM Demonstrations
• 7.5 XDK Demonstrations
  • 7.5.1 Java Demonstrations
  • 7.5.2 C Programming Language Demonstrations
• 7.6 JDBC Demonstrations
• 7.7 Running Oracle Text and Oracle Spatial Demonstrations
  • 7.7.1 Oracle Text
  • 7.7.2 Oracle Spatial
    • 7.7.2.1 Running the Spatial Demonstration
  • 7.7.3 Spatial Network Demonstrations
  • 7.7.4 Spatial Example Demonstrations
  • 7.7.5 Spatial Georaster Demonstrations
• 7.8 SQL*Loader Demonstrations
  • 7.8.1 Administering SQL*Loader
    • 7.8.1.1 Newline Characters in Fixed-Length Records
    • 7.8.1.2 Removing Newline Characters

8 Tuning Oracle Database 10g

• 8.1 Introduction to Tuning
• 8.2 Oracle Performance Tuning Tools
• 8.3 Oracle SQL Tuning Tools
• 8.4 Tuning Memory Management
  • 8.4.1 Allocate Sufficient Swap Space
  • 8.4.2 Control Paging
  • 8.4.3 Adjust Oracle Block Size
• 8.5 Tuning Disk I/O
• 8.6 Monitoring Disk Performance
• 8.7 Tuning CPU Usage
• 8.8 System Global Area
  • 8.8.1 Determine the Size of the SGA
• 8.9 Enhanced Oracle Performance
  • 8.9.1 System Changes

A Database Limits

• A.1 Database Limits

B Managing the Database

• B.1 SQL*Plus and Oracle Net Services
• B.2 Creating Multiple Control Files
• B.3 Managing Database Files
  • B.3.1 Using Commands to Manage Database Files
  • B.3.2 Adding Files
  • B.3.3 Renaming Files
  • B.3.4 Moving Tablespace Files
  • B.3.5 Moving Redo Log Files
• B.4 Database Verification Utility
• B.5 Important Note on Changes to Data File Formats for OpenVMS

C Backing Up and Archiving the Database

• C.1 Archiving Redo Log Files
  • C.1.1 Specifying Archive Destinations
  • C.1.2 Archiving Automatically
  • C.1.3 Archiving Manually
• C.2 Backing Up the Database
  • C.2.1 Backing Up a Closed Database
  • C.2.2 Backing Up an Open Database
  • C.2.3 Backing Up Data Structures and Definitions
    • C.2.3.1 Exporting to Other OpenVMS Systems
    • C.2.3.2 Exporting to Non-OpenVMS Systems
• C.3 Exporting to and Importing from Multiple Tapes
  • C.3.1 Exporting with Multi-Reel Files
  • C.3.2 Exporting to Multiple Tapes
  • C.3.3 Importing from Multiple Tapes
• C.4 Recovering Data
  • C.4.1 Overview of Data Recovery
  • C.4.2 Recovering from Instance Failure
  • C.4.3 Recovering from Media Failure
    • C.4.3.1 Media Recovery
    • C.4.3.2 Using an Export File for Media Recovery

D Logical Names and Parameters

• D.1 Oracle Database 10g Logical Names
  • D.1.1 Process Quota Logical Names
  • D.1.2 Logical Name Definitions for the MTS Dispatcher
• D.2 System-Dependent Initialization Parameters
  • D.2.1 BACKGROUND_ DUMP_DEST
  • D.2.2 DB_BLOCK_SIZE
  • D.2.3 LOG_ARCHIVE_DEST
  • D.2.4 LOG_ARCHIVE_ FORMAT
  • D.2.5 PRE_PAGE_SGA
  • D.2.6 SHARED_POOL_SIZE
  • D.2.7 SORT_AREA_SIZE
  • D.2.8 USER_DUMP_DEST

E Messages and Codes

F Process Control

• F.1 Interrupting and Terminating Oracle Operations
  • F.1.1 Canceling Without Terminating the Oracle Image
  • F.1.2 Canceling with the Option to Continue
  • F.1.3 Disabling Control Keys
• F.2 Running Oracle Programs as Detached Processes

G Administering Oracle RAC

• G.1 Introduction to Oracle RAC Administration
• G.2 Changes from Oracle9i Database
• G.3 Administering the Oracle Cluster Registry
• G.4 Managing Archived Redo Logs Using RMAN
• G.5 RMAN Archiving Configuration
  • G.5.1 Cluster File System Archiving and Naming Scheme
    • G.5.1.1 Advantages and Disadvantages of the Cluster File System Archiving Scheme
    • G.5.1.2 Initialization Parameter Settings for the Cluster File System Archiving Scheme
    • G.5.1.3 Location of Archived Logs for the Cluster File System Archiving Scheme

Index