Skip Headers
Oracle® Database Administrator's Reference
10g Release 1 (10.1) for hp OpenVMS Alpha
Part No. B13738-01
  Go To Index



Title and Copyright Information

Send Us Your Comments


Intended Audience
Documentation Accessibility
Oracle Database 10g and Oracle Database 10g Enterprise Edition
For the Latest Information
Install Only Licensed Products
Typographical Conventions
Command Syntax
Accessing Installed Documentation
Related Documentation
Third-Party Software Notices

1 Administering Oracle Database 10g

1.1 Overview
1.1.1 Oracle Database 10g Code
1.1.2 Oracle Database 10g Instances
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.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.3 Starting Oracle Database 10g Remotely by Using SQL*Plus from an OpenVMS Client
2.1.4 Starting Oracle Database 10g Remotely by Using SQL*Plus from a Microsoft Windows PC Client
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.2 Using the PRODUCT_USER_PROFILE Table
4.1.3 Using 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.5 TNS Listener
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.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.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.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.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.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.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.8.5 Unexpected Link Errors
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.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

8 Tuning Oracle Database 10g

8.1 Introduction to Tuning
8.2 Oracle SQL Tuning Tools
8.3 Tuning Memory Management
8.3.1 Allocate Sufficient Swap Space
8.3.2 Control Paging
8.3.3 Adjust Oracle Block Size
8.4 Tuning Disk I/O
8.5 Monitoring Disk Performance
8.6 Tuning CPU Usage
8.7 System Global Area
8.7.1 Determine the Size of the SGA

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.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

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

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 RAC

G.1 Introduction to RAC Administration
G.2 Changes from Oracle9i Database
G.3 Administering the Oracle Cluster Registry in RAC
G.4 Managing Archived Redo Logs Using RMAN in RAC
G.5 RMAN Archiving Configuration
G.5.1 Cluster File System Archiving and Naming Scheme