Oracle9<i>i</i> Administrator's Reference -- Contents

Overview

Oracle9i Code

Oracle9i Instances

Logical Names Datafiles: Locations and Identifying by

Relinking Executables

Database Limits

Operating System Accounts and Groups

Security

Security for SQL*Plus Commands

Security for Database Files

Customizing the Initialization File

Running the orapwd Utility

Password Management

PL/SQL Gateway

Installing the PL/SQL Gateway

Oracle HTTP Server powered by Apache

Demonstration Files

SQL*Loader Demonstrations

Administering SQL*Loader

PL/SQL Demonstrations

Importance of Tuning

Types of Performance Bottlenecks

Oracle SQL Tuning Tools

Tuning Memory Management

Allocate Sufficient Swap Space

Control Paging

Adjust Oracle Block Size

Tuning Disk I/O

Monitoring Disk Performance

Tuning CPU Usage

Keep All Oracle Users/Processes at the Same Priority

Using Trace and Alert Files

Trace Files

Alert Files

Granting Access to Oracle9i Users

Using the Oracle9i Password Utility

Ending a User's Session

Starting Up the Oracle9i

Before Start Up

Starting Oracle9i via ORACLEINS

Starting Oracle9i via STARTUP Files

Starting Oracle9i via SQL*Plus

Starting Oracle9i Remotely via SQL*Plus from an OpenVMS Client

Starting Oracle9i Remotely via SQL*Plus from a Windows PC Client

Starting Oracle9i Automatically

Shutting Down the Oracle9i

Stopping Oracle Users Before Database Shutdown

Shutting Down Oracle9i using ORACLEINS

Shutting Down Oracle9i using the SHUTDOWN File

Shutting Down Oracle9i using SQL*Plus

De-installing Shareable Images

Managing Single Instances

Components of Instances

Controlling Instances

Deleting Instances

Adding and Enabling Instance Threads

Preparing an Instance for Parallel Query

Creating Database Links

Creating Multiple Control Files

Managing Database Files

Using Commands to Manage Database Files

Adding Files

Renaming Files

Moving Tablespace Files

Moving Redo Log Files

Database Verification Utility and Other Useful Utilities

Database Verification Utility

Other Useful Utilities

Debugging Database Processes with ORAMBX

Archiving Redo Log Files

Specifying Archive Destinations

Archiving Automatically

Archiving Manually

Backing Up the Database

Backing Up a Closed Database

Backing Up an Open Database

Backing Up Data Structures and Definitions

Exporting to and Importing from Multiple Tapes

Exporting to Multiple Tapes

Importing from Multiple Tapes

Recovering Your Data

Overview

Recovering from Instance Failure

Recovering from Media Failure

Administering SQL*Plus

Using Setup Files

Using the PRODUCT_USER_PROFILE Table

Using Demonstration Tables

SQL*Plus Online Help

Installing the SQL*Plus Online Help

Removing the SQL*Plus Online Help

Using SQL*Plus

Using a System Editor from SQL*Plus

Running Operating System Commands from SQL*Plus

Interrupting SQL*Plus

Using the SPOOL Command

SQL*Plus Restrictions

Resizing Windows

Return Codes

Overview of Oracle Precompilers

Precompiler Configuration Files

Relinking Precompiler Executables

Programmatic Interfaces

SQL*Module

Directory Structure

PROGINT Branch of the ORA_ROOT Directory Structure

Precompiler README Files

Precompiling

Syntax

Example

Guidelines and Restrictions

Using the Alpha OpenVMS Debugger

Using Event Flags

Migrating Applications Developed with Pro*C Compilers

Compiling

Compiler Options Used to Compile Oracle9i

Floating Point Formats

Pro*COBOL

Linking

Syntax

Example

Including Option Files

Guidelines

Using the Oracle Call Interface (OCI) Routines

Guidelines

CDA/LDA Structure Information

Linking OCI Programs Written in C

Linking OCI Programs Written in Other Languages

Unexpected Link Errors

Data Areas and Datatypes

Binary Integers

Using Literals as Call Arguments

Optional or Missing Parameters

Using Event Flags

Configuration Overview

Centralized

Client/Server

Distributed Database

Oracle Net Installations

Oracle Net and the Transparent Network Substrate (TNS)

Using Oracle Net

Oracle Net Architecture

The Protocol Adapters

TNS Listener

ORASRV_NETV2_<SID> Command File

General Connections

Oracle Names

NAMESCTL

Names Server Privileges

Requirements

Oracle Intelligent Agent and SNMP Support

Installing the Oracle Intelligent Agent

Oracle Intelligent Agent Setup and Discovery Option

Oracle Intelligent Agent Startup, Shutdown, and Status Query

Oracle Intelligent Agent Maintenance

SNMP Support

Advanced Security Option

Usage Notes for the Authentication Adapters

Core Oracle Net Services Products and Features

Oracle Net Services and Utilities

Oracle Net Services Protocol Support

ADDRESS Specification

Bequeath (BEQ) Protocol Support

IPC Protocol Support

Specifying a IPC ADDRESS

TCP/IP Protocol Support

Specifying a TCP/IP ADDRESS

Oracle Enterprise Manager

Configuring Oracle Intelligent Agent for Oracle SNMP

Oracle9i Logical Names

Where Logical Names Are Defined

Alphabetical Listing

Process Quota Logical Names

System-Dependent Initialization Parameters

BACKGROUND_ DUMP_DEST

VLM_BACKING_STORAGE_FILE

Interrupting and Terminating Oracle Operations

Cancelling without Aborting the Oracle Image

Cancelling with the Option to Continue

Disabling Control Keys

Running Oracle Programs as Detached Processes

Oracle Text

Oracle9i Spatial

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Administering Oracle9i

2 Tuning for Oracle9i on Alpha OpenVMS

3 Setting Up Oracle9i Users

4 Starting Up and Shutting Down Oracle9i

5 Managing Instances

6 Managing the Database

7 Backing Up and Archiving Your Database

8 Administering SQL*Plus

9 Using Oracle Precompilers and the Oracle Call Interface

10 Oracle Net on Alpha OpenVMS

11 Configuring Oracle Net Services

A Logical Names and Parameters

B Messages and Codes

C Alpha OpenVMS Process Control

D Running Oracle Text, and Oracle Spatial Demonstrations

Index