Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose

Audience

Oracle9i and Oracle9i Enterprise Edition

Typographic Conventions

Command Syntax

Accessing Installed Documentation

Related Documentation

Oracle Services and Support

Documentation Accessibility

Part I Administering Oracle9i on OpenVMS

1 Administering Oracle9i on HP OpenVMS Alpha

1.1 Overview

1.1.1 Oracle9i Code

1.1.1.1 ORACLE.EXE File

1.1.2 Oracle9i 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 Datafiles: Locations and Identifying by

1.2 Relinking Executables

1.3 Database Limits

1.4 Operating System Accounts and Groups

1.5 Security

1.5.1 Security for SQL*Plus Command "CONNECT AS SYSDBA"

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 PL/SQL Gateway

1.6.1 Installing the PL/SQL Gateway

1.7 Oracle HTTP Server powered by Apache

1.8 Demonstration Files

1.8.1 SQL*Loader Demonstrations

1.8.2 Administering SQL*Loader

1.8.2.1 Newline Characters in Fixed Length Records

1.8.2.2 Removing Newline Characters

1.8.3 PL/SQL Demonstrations

1.8.3.1 PL/SQL Kernel Demonstrations

1.8.3.2 PL/SQL Precompiler Demonstrations

2 Tuning Oracle9i on HP OpenVMS Alpha

2.1 Importance of Tuning

2.1.1 Types of Performance Bottlenecks

2.2 Oracle SQL Tuning Tools

2.3 Tuning Memory Management

2.3.1 Allocate Sufficient Swap Space

2.3.2 Control Paging

2.3.3 Adjust Oracle Block Size

2.4 Tuning Disk I/O

2.5 Monitoring Disk Performance

2.6 Tuning CPU Usage

2.6.1 Keep All Oracle Users/Processes at the Same Priority

2.7 Using Trace and Alert Files

2.7.1 Trace Files

2.7.2 Alert Files

3 Setting Up Oracle9i Users

3.1 Granting Access to Oracle9i Users

3.2 Ending a User's Session

4 Starting Up and Shutting Down Oracle9i

4.1 Starting Up Oracle9i

4.1.1 Before Start Up

4.1.2 Starting Oracle9i via SQL*Plus

4.1.2.1 Identifying the Current Instance

4.1.2.2 Specifying Startup Parameters

4.1.2.3 Starting the Server using SQL*Plus

4.1.3 Starting Oracle9i Remotely via SQL*Plus from an OpenVMS Client

4.1.4 Steps to Perform on Remote System Database

4.1.5 Steps to Perform on Client System

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

4.1.7 Steps to Perform on Remote System Database

4.2 Shutting Down Oracle9i

4.2.1 Shutting Down Oracle9i using SQL*Plus

4.2.2 Stopping Oracle Users Before Database Shutdown

4.2.3 De-installing Shareable Images

5 Managing the Database

5.1 SQL*Plus and Oracle Net

5.2 Creating Multiple Control Files

5.3 Managing Database Files

5.3.1 Using Commands to Manage Database Files

5.3.1.1 ALTER DATABASE

5.3.1.2 DROP TABLESPACE

5.3.2 Adding Files

5.3.3 Renaming Files

5.3.4 Moving Tablespace Files

5.3.5 Moving Redo Log Files

5.4 Database Verification Utility and Other Useful Utilities

5.4.1 Database Verification Utility

5.5 Debugging Database Processes with ORAMBX

6 Backing Up and Archiving Your Database

6.1 Archiving Redo Log Files

6.1.1 Specifying Archive Destinations

6.1.2 Archiving Automatically

6.1.3 Archiving Manually

6.2 Backing Up the Database

6.2.1 Backing Up a Closed Database

6.2.2 Backing Up an Open Database

6.2.3 Backing Up Data Structures and Definitions

6.2.3.1 Exporting to Other OpenVMS Machines

6.2.3.2 Exporting to Non-OpenVMS Machines

6.3 Exporting to and Importing from Multiple Tapes

6.3.0.3 Exporting with Multi-Reel Files

6.3.1 Exporting to Multiple Tapes

6.3.2 Importing from Multiple Tapes

6.4 Recovering Your Data

6.4.1 Overview

6.4.2 Recovering from Instance Failure

6.4.3 Recovering from Media Failure

6.4.3.1 Media Recovery

6.4.3.2 Restoring from an Export File

Part II Using and Administering the Oracle Tools

7 Administering SQL*Plus

7.1 Administering SQL*Plus

7.1.1 Using Setup Files

7.1.1.1 Using the Site Profile File

7.1.1.2 Using the User Profile File

7.1.2 Using the PRODUCT_USER_PROFILE Table

7.1.3 Using Demonstration Tables

7.1.3.1 Performing a Typical Installation

7.1.3.2 Creating Demonstration Tables Manually

7.1.3.3 Deleting Demonstration Tables

7.1.4 SQL*Plus Online Help

7.1.5 Installing the SQL*Plus Online Help

7.1.6 Removing the SQL*Plus Online Help

7.2 Using SQL*Plus

7.2.1 Using a System Editor from SQL*Plus

7.2.2 Running Operating System Commands from SQL*Plus

7.2.3 Interrupting SQL*Plus

7.2.4 Using the SPOOL Command

7.3 SQL*Plus Restrictions

7.3.1 Resizing Windows

7.3.2 Return Codes

8 Using Oracle Precompilers and the Oracle Call Interface

8.1 Overview of Oracle Precompilers

8.1.1 Precompiler Configuration Files

8.1.2 SQL*Module

8.1.3 Precompiler Executables

8.1.3.1 Precompiler README files

8.2 Precompiling

8.2.1 Syntax

8.2.2 Example

8.2.3 Guidelines and Restrictions

8.2.4 Using the HP OpenVMS Alpha Debugger

8.2.5 Using Event Flags

8.2.6 Migrating Applications Developed with Pro*C Compilers

8.3 Compiling

8.3.1 Compiler Options Used to Compile Oracle9i

8.3.2 Floating Point Formats

8.3.3 Pro*COBOL

8.4 Linking

8.4.1 Syntax

8.4.2 Including Option Files

8.4.3 Guidelines

8.4.3.1 Using the demos

8.4.3.2 Compatibility with ANSI Standard Compilers

8.4.3.3 Linking Shareable Images with LOUTL.COM

8.4.3.4 Watching the Link Command Passed to LOUTL

8.4.3.5 Using LNK$LIBRARY When Linking Against Oracle

8.5 Using the Oracle Call Interface Routines

8.5.1 Guidelines

8.5.2 CDA/LDA Structure Information

8.5.2.1 Alpha Size and Offsets of Structure Elements

8.5.3 Linking Oracle Call Interface Programs Written in C

8.5.4 Linking Oracle Call Interface Programs Written in Other Languages

8.5.5 Unexpected Link Errors

8.6 Data Areas and Datatypes

8.6.1 Binary Integers

8.7 Using Literals as Call Arguments

8.8 Optional or Missing Parameters

8.9 Using Event Flags

A Messages and Codes

9 Oracle Net on HP OpenVMS Alpha

9.1 Oracle Net Configuration Overview

9.1.1 Centralized Configuration

9.1.2 Client-Server Configuration

9.1.3 Distributed Database Configuration

9.2 Oracle Net Installations

9.3 Oracle Net and the Transparent Network Substrate (TNS)

9.3.1 Using Oracle Net

9.4 Oracle Net Architecture

9.4.0.1 Oracle Net Interface

9.4.0.2 Transparent Network Substrate

9.4.0.3 Oracle Protocol Adapters

9.5 The Protocol Adapters

9.5.1 IPC - Mailbox Protocol

9.5.1.1 Syntax

9.5.1.2 Example

9.5.2 TCP - TCP/IP Protocol

9.5.2.1 Syntax

9.5.2.2 QUEUESIZE

9.5.3 BEQ - Bequeath Protocol

9.5.4 Bequeath Listener

9.5.4.1 Starting up the Bequeath Listener

9.5.4.2 Bequeath Listener Status

9.5.4.3 Shutting Down the Bequeath Listener

9.5.4.4 Problem Resolution

9.5.4.5 Bequeath Listener Privileges

9.6 TNS Listener

9.6.1 LSNRCTL

9.6.2 TNS Listener Privileges

9.6.3 Process Quotas

9.6.4 ORASRV_NETV2_<SID> Command File

9.6.5 General Connections

9.7 Oracle Names

9.7.1 NAMESCTL

9.7.2 Names Server Privileges

9.8 Oracle Intelligent Agent

9.8.1 Installing the Oracle Intelligent Agent

9.8.2 Oracle Intelligent Agent Setup and Discovery Option

9.8.2.1 Creating the Startup Scripts

9.8.2.2 Oracle Intelligent Agent Parameter Files and Discovery Option

9.8.2.3 Setting the Preferred Credentials

9.8.3 Oracle Intelligent Agent Startup, Shutdown, and Status Query

9.8.3.1 Startup of the Oracle Intelligent Agent

9.8.3.2 Shutdown of the Oracle Intelligent Agent

9.8.4 Oracle Intelligent Agent Maintenance

9.9 Advanced Security Option

9.9.0.1 Task 3: Manual Steps for the Authentication Adapters

9.9.1 Usage Notes for the Authentication Adapters

9.9.1.1 General Information

9.9.1.2 Kerberos5

10 Configuring Oracle Net Services

10.1 Core Oracle Net Services Products and Features

10.1.1 Oracle Net Services and Utilities

10.1.1.1 Location of Oracle Net Services Configuration Files

10.2 Oracle Net Services Protocol Support

10.2.1 ADDRESS Specification

10.3 Bequeath (BEQ) Protocol Support

10.4 IPC Protocol Support

10.4.1 Specifying a IPC ADDRESS

10.5 TCP/IP Protocol Support

10.5.1 Specifying a TCP/IP ADDRESS

10.6 Oracle Enterprise Manager

Part III Appendixes

B Logical Names and Parameters

B.1 Oracle9i Logical Names

B.1.1 Process Quota Logical Names

B.2 System-Dependent Initialization Parameters

B.2.1 BACKGROUND_ DUMP_DEST

B.2.2 DB_BLOCK_SIZE

B.2.3 LOG_ARCHIVE_DEST

B.2.4 LOG_ARCHIVE_ FORMAT

B.2.5 PRE_PAGE_SGA

B.2.6 SHARED_POOL_SIZE

B.2.7 SORT_AREA_SIZE

B.2.8 USER_DUMP_DEST

B.2.9 VLM_BACKING_STORAGE_FILE

C HP OpenVMS Alpha Process Control

C.1 Interrupting and Terminating Oracle Operations

C.1.1 Cancelling without Aborting the Oracle Image

C.1.2 Cancelling with the Option to Continue

C.1.2.1 Known Limitations in Client-Server Connections

C.1.3 Disabling Control Keys

C.2 Running Oracle Programs as Detached Processes

D Running Oracle Text and Oracle Spatial Demonstrations

D.1 Oracle Text

D.2 Oracle Spatial

Index