Contents

Title and Copyright Information

Send Us Your Comments

About this Guide

Part I Administering the Oracle8i Enterprise Edition

1 Introduction to Oracle8i on Alpha OpenVMS

New Features on Alpha OpenVMS

DBJAVA (JDBC, Java Database Connectivity)

Oracle Parallel Server

JServer

SQLJ

Oracle8i on Alpha OpenVMS

Oracle8i Code

Oracle8i Instances

Logical NamesDatafiles: Locations and Identifying by

2 Setting Up Oracle8i Users

Granting Access to Oracle8i Users

Using the Oracle8i Password Utility

Ending a User's Session

3 Starting Up and Shutting Down Oracle8i

Starting Up the Oracle8i Enterprise Edition

Before Start Up

Starting Oracle8i via ORACLEINS

Starting Oracle8i via STARTUP Files

Starting Oracle8i via Server Manager

Starting Oracle8i Remotely via Server Manager from an OpenVMS Client

Starting Oracle8i Remotely via Server Manager from a Windows PC Client

Starting Oracle8i Automatically

Shutting Down the Oracle8i Enterprise Edition

Stopping Oracle Users Before Database Shutdown

Shutting Down Oracle8i using ORACLEINS

Shutting Down Oracle8i using the SHUTDOWN File

Shutting Down Oracle8i using Server Manager

De-installing Shareable Images

4 Managing Instances

Managing Single Instances

Components of Instances

Controlling Instances

Deleting Instances

Adding and Enabling Instance Threads

Preparing an Instance for Parallel Query

5 Managing the Database

Server Manager and SQL*Net

Starting Server Manager

SET ECHO and SET TERMOUT Functionality in SVRMGR

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

6 Backing Up and Archiving Your Database

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

7 Recovering Your Data

Overview

Recovering from Instance Failure

Recovering from Media Failure

Media Recovery

Restoring from an Export File

8 Optimizing Oracle8i

Tuning Memory Usage for the Oracle8i Enterprise Edition

Adjusting INIT.ORA Parameters

Modifying Alpha OpenVMS Process Quotas

Adjusting the SGA

Installing Products in Shared Memory

Installing Oracle Products

Running ORA_INSUTL

Reducing Database Fragmentation

9 Trace Files

Using Trace Files

Specifying Trace File Directories

Identifying Trace Files

No Need to Format

INIT.ORA Parameter for Creating World-readable Trace Files

Part II Using and Administering the Oracle Tools

10 Oracle Programmatic Interfaces

Programmatic Interfaces

SQL*Module

Directory Structure

PROGINT Branch of the ORA_ROOT Directory Structure

Precompiler Executable Files

Precompiler Include Files

Precompiler Oracle Call Interface (OCI) Files

Precompiler Demo 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 Oracle8i

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

11 SQL*Plus

Warning Message When Invoking SQL*Plus

Interrupting SQL*Plus

Installing Help Tables

Running System Commands

Passing Parameters to SQL*Plus

Passing Parameters to SQL*Plus from OpenVMS

Passing Parameters to SQL*Plus Interactively from a User

Passing Parameters to SQL*Plus from an Input File

Passing Values from SQL*Plus

Passing a Numeric Value

Passing Multiple Values

Using Profile Files

Types of Files

Order of Execution

Creating the Files

Using the OpenVMS Editor from SQL*Plus

Converting SQL*Plus Output Files

Interpreting Output from the SQL*Plus TIMING Command

Exit Status within DCL

Part III Appendices

A Logical Names and Parameters

Oracle8i Logical Names

Where Logical Names Are Defined

Alphabetical Listing

Process Quota Logical Names

System-Dependent Initialization Parameters

BACKGROUND_ DUMP_DEST

CONTROL_FILES

DB_BLOCK_SIZE

LOG_ARCHIVE_DEST

LOG_ARCHIVE_ FORMAT

PRE_PAGE_SGA

SHARED_POOL_SIZE

SORT_AREA_SIZE

USER_DUMP_DEST

VLM_BACKING_STORAGE_FILE

B Messages and Codes

C Alpha OpenVMS Process Control

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

D Alpha OpenVMS Supplement to the Generic Documentation Set

Server Guides

Utilities Guide

Index