Skip Headers
Oracle® Database Administrator's Reference
10
g
Release 2 (10.2) for hp OpenVMS
Part Number B25416-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Intended Audience
Documentation Accessibility
Related Documentation
Conventions
Third-Party Software Notices
1
Administering Oracle Database 10
g
1.1
Overview
1.1.1
Oracle Database 10
g
Code
1.1.2
Oracle Database 10
g
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.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 10
g
Users
2
Starting and Stopping Oracle Software
2.1
Starting Up Oracle Database 10
g
2.1.1
Before Starting Up
2.1.2
Starting Oracle Database 10
g
by Using SQL*Plus
2.1.3
Starting Oracle Database 10
g
Remotely by Using SQL*Plus from an OpenVMS Client
2.1.4
Starting Oracle Database 10
g
Remotely by Using SQL*Plus from a Microsoft Windows PC Client
2.2
Shutting Down Oracle Database 10
g
2.2.1
Shutting Down Oracle Database 10
g
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.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.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 10
g
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.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.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.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 10
g
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.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 10
g
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 Oracle9
i
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
Index