Go to main content
1/18
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
1
Administering Oracle Database 11
g
1.1
Overview
1.1.1
About Oracle Database 11
g
Code
1.1.1.1
ORACLE.EXE File
1.1.2
Oracle Database 11
g
Instances
1.1.2.1
About 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 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 11
g
Users
2
Starting and Stopping Oracle Software
2.1
Starting Up Oracle Database 11
g
2.1.1
Before Starting Up
2.1.2
Starting Oracle Database 11
g
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 11
g
Remotely by Using SQL*Plus from an HP OpenVMS Client
2.1.3.1
Steps to Perform on a Remote System Database
2.1.3.2
Steps to Perform on a HP OpenVMS Client System
2.1.4
Starting Oracle Database 11
g
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 11
g
2.2.1
Shutting Down Oracle Database 11
g
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 Oracle Database Configuration Assistant
3.2.3
Configuring New or Upgraded Databases
3.3
Relinking Executables
3.3.1
Support for Shared Libraries in Recovery Manager
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 11
g
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 (HP 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
Oracle RDBMS Demonstrations
7.2.1
Extensible Indexing Demonstrations
7.3
Oracle RDBMS C++ File Demonstrations
7.4
Oracle 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 11
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 HP 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 HP OpenVMS Systems
C.2.3.2
Exporting to Non-HP 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 11
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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.