Index

A B C D E F G H I J K L M N O P Q R S T U V W X

A

accounts and groups, 1.4

ADDRESS specification protocols, 5.8.1

administering command-line SQL*Plus, 4.1

Advanced Security Option for Security and Single Sign-On

see ASO

ALTER DATABASE command, C.1

ALTER TABLESPACE command, B.3

/ANSI option, 6.3.3

ANSI standard compilers

compatibility with, 6.4.3

aqjms demonstrations, 7.4.1

ARCH process, C.1.2

archive logs

file naming, G.4

ARCHIVELOG mode, 1.1.2.4

archiving

redo files

automatically, C.1.2

manually, C.1.3

redo logs, C.1

ASO

authentication adapters

usage notes, 5.6.2

description, 5.6

authentication adapters

manual steps for ASO installation, 5.6.1

usage notes, 5.6.2

authorization

database file security, 1.5.2

AUTHORIZE utility, 1.9

B

BACKGROUND_DUMP_DEST parameter, 1.6.1, 1.6.2, 5.5.5, D.2.1

backing up, C.2.3

closed database, C.2.1

open database, C.2.2

the database, C.2

procedures and tools, C

redo log files, 1.1.2.4

warning message, C.2.2

BACKUP utility, C.2, C.2.1, C.4.3.1

Bequeath listener, 5.4.4

determining the status, 5.4.4.2

error message ORA-12203, 5.4.4.4

getting trace information, 5.4.4.4

privileges, 5.4.4.5, 5.4.4.5

problem ORA-12203, 5.4.4.4

problem resolution, 5.4.4.4

shutting down, 5.4.4.3

starting up, 5.4.4.1

Bequeath protocol adapter, 5.1.1, 5.4.3, 5.4.3

description, 5.4.3

on startup of SQL*Plus, B.1

support, 5.9

binary integers, 6.9, 6.9

block size

tuning, 8.4.3

buffer manager, 8.4, 8.4

buffers

database buffer pool, 1.1.2.1

redo log buffers, 1.1.2.1

C

C programming language

precompiling, 6.2.1

Pro*C/C++, 6.5

C++ file demonstrations, 7.3

call arguments

using literals as, 6.10

canceling operations, F.1.1

methods, F.1.1, F.1.2

with option to continue, F.1.2

centralized configuration, 5.1.1, 5.1.1

client problem

ORA-12203, 5.4.4.4

client shared library, 6.1.6

client static library, 6.1.6

client/server

configuration, 5.1.2, 5.1.2

client/server network, 5.1.2

closed database

backing up, C.2.1

Cluster Ready Services, G.3

CLUSTER_INTERCONNECTS initialization parameter, 1.2.2, 1.2.2

COBOL, 6.2.1, 6.11

command-line SQL*Plus, 4.2

commands

CONNECT INTERNAL, E

DROP TABLESPACE, B.3.1

for managing database files, B.3.1

compatibility

with ANSI standard compilers, 6.4.3

compiler options, 6.3.1

compiling with programmatic interfaces, 6.3

configuration (Oracle Net Services)

centralized, 5.1.1

client/server, 5.1.2

distributed database, 5.1.3

configuration files

precompiler, 6.1.1

configuring

additional Oracle products, 3.1

CONNECT INTERNAL, E

CONTINUE command, F.1.2

control files

creating, B.2

identifying, B.2

control keys

disabling, F.1.3

CPU contention, 8.1

CPU usage

tuning, 8.7

CREATE CONTROLFILE parameter, A.1

CREATE DATABASE parameter, A.1

custom link files, 6.13

D

daabase instances

assigning IDs, 1.1.2

data areas, 6.9

data file locations, 1.1.3

data structures and definitions

backing up, C.2.3

data types, 6.9

database

automatic recovery, C.4.1

backing up, C.2

backing up structures and data definitions, C.2.3

creation methods

Oracle Database Configuration Assistant, 3.2.2

granting access to, 1.9

import and export messages, C.2.3

Database Configuration Assistant

described, 3.2.2

security management, 1.5.5

using, 3.2.2

using to install SQL*Plus online Help, 4.2.1

database files, 1.5.2

defined, 1.1.2.2

managing, B.3

database limits, 1.3

database verification utility, B.4, B.4

DB_BLOCK_SIZE, D.2.2

maximum value of, 1.2.1

DB_BLOCK_SIZE initialization parameter, 8.8, 8.8, 8.8

DB_CACHE_SIZE initialization parameter, 8.8

DB_CACHE_SIZE parameter, 1.1.2.1

DB_dbname directory, B.3

DB_nnK_CACHE_SIZE parameter, 1.1.2.1, 1.5.3, 1.5.3

DEBUG qualifier, 6.2.2

debugger, 6.2.2

debugger programs, 6.1.4

definitions and structures

backing up, C.2.3

demonstration

the procedural option, PL/SQL, 7.1

demonstration files

creating and running, 7.8

programmatic interfaces, 6.4.1

demonstration tables

creating manually, 4.1.3.2

deleting, 4.1.3.3

SQL*Plus, 4.1.3

demonstrations

aqjms, 7.4.1

C++ files, 7.3

extensible indexing, 7.2.1

Java file, 7.4

JavaVM, 7.4.3

JDBC, 7.6

Network Editor, 7.7.3

Oracle Spatial, 7.7

Oracle Text, 7.7

PL/SQL, 7.7.3, 7.7.3, 7.7.3, 7.7.3

PL/SQL kernel, 7.1.1

PL/SQL precompilers, 7.1.2

Pro*C/C++, 6.5.1

Pro*COBOL, 6.6.1, 6.6.2

Pro*FORTRAN, 6.7.1

proc demonstrations, 6.4.3

RDBMS, 7.2

rmanpipe.sql, 7.4.2

Spatial Network, 7.7.3

SQL*Loader, 7.8

XDK, 7.5

desupported initialization parameters

DB_FILE_DIRECT_IO_COUNT, 1.5.3

HASH_MULTIBLOCK_IO_COUNT, 1.5.3

detached processes, C.4.2

running Oracle programs as, F.2

disabling control keys, F.1.3

disk

monitoring performance, 8.6

disk I/O

contention, 8.1

tuning, 8.5

distributed database, 5.1.3

configuration, 5.1.3, 5.1.3

DROP TABLESPACE command, B.3.1

E

editor SQL*Plus, 4.3.1

error

ORA_12203, 5.4.4.4

ORA-12203, 5.4.4.4, 5.4.4.4

event flags

restrictions, 6.2.2

using, 6.12

export files

recovering data from, C.4.3.2

export messages, C.2.3

export utility, C.2.3, C.2.3

exporting files

to a non-OpenVMS system, C.2.3.2

to and from multiple tapes, C.3

to multiple tapes, C.3.2

to OpenVMS system, C.2.3.1

extensible indexing demonstrations, 7.2.1

extproc demonstration

running, 7.1.1

F

failure types, C.4.1

files

trace files, 1.6.1

fixed-length records, 7.8.1.1

FORMAT precompiler, 6.6.3

Pro*COBOL, 6.6.4

FORTRAN, 6.2.1, 6.11

G

glogin.sql file, 4.1.1.1

H

Help facility, 4.2.1

HOST

option for PRO<language> command, 6.2.1

HOST command, 4.3.2

I

import messages, C.2.3

import utility

for recovery, C.4.3.2

importing files

from multiple tapes, C.3.3

INCLUDE option, 6.2.1

initialization file

customizing, 1.5.3

initialization parameters, 1.2

BACKGROUND_DUMP_DEST, 1.6.2

BITMAP_MERGE_AREA_SIZE, 1.5.3

CLUSTER_INTERCONNECTS, 1.2.2

COMMIT_POINT_STRENGTH, 1.5.3

CONTROL_FILES, 1.5.3

CREATE_BITMAP_AREA_SIZE, 1.5.3

DB_BLOCK_BUFFERS, 1.5.3

DB_BLOCK_SIZE, 1.5.3, 8.8, 8.8, 8.8

DB_CACHE_SIZE, 8.8

DB_FILE_MULTIBLOCK_READ_COUNT, 1.5.3

DISTRIBUTED_TRANSACTIONS, 1.5.3

for System Global Area, 8.8

HASH_AREA_SIZE, 1.5.3

JAVA_POOL_SIZE, 1.5.3, 8.8

LARGE_POOL_SIZE, 8.8

LOG_BUFFER, 1.5.3

LOG_BUFFERS, 8.8

LOG_CHECKPOINT_INTERVAL, 1.5.3

MAX_DISPATCHERS, 1.5.3

MAX_DUMP_FILE, 1.6.1

MAX_SERVERS, 1.5.3

NLS_LANGUAGE, 1.5.3

NLS_TERRITORY, 1.5.3

not to be modified, 1.5.3

OBJECT_CACHE_MAX_SIZE_PERCENT, 1.5.3

OBJECT_CACHE_OPTIMAL_SIZE, 1.5.3

OPEN_CURSORS, 1.5.3

OS_AUTHENT_PREFIX, 1.5.3

SHARED_POOL_SIZE, 8.8

SHARED_SERVERS, 1.5.3

system dependent, D.2

USER_DUMP_DEST, 1.6.1

init.ora

initialization parameters, D.2

INIT.ORA file, C.1.2

at startup, 1.1.2.1

INIT.ORA parameters, 5.5.5

initsid.ora file, 1.5.3, 1.5.3

installing

PL/SQL gateway, 1.7

instance failure, C.4.1

recovering from, C.4.2

restarting after, C.4.2

instance recovery, C.4.1

instances, 1.1.2

interrupting

and terminating Oracle operations, F.1

SQL*Plus, 4.3.3

I/O

improving, 1.1.2.1

tuning, 8.5

IPC address, 5.10

IPC protocol, 5.10

IPC protocol support, 5.10

connection parameters, 5.10

IRECLEN parameter, 6.1.4

J

Java file demonstrations, 7.4

JAVA_POOL_SIZE initialization parameters, 8.8

JavaVM demonstrations, 7.4.3

JDBC demonstrations, 7.6

K

Kerberos5

authentication adapter usage notes, 5.6.2

during ASO installation, 5.6.1

kernel demonstrations

PL/SQL, 7.1.1

L

LARGE_POOL_SIZE initialization parameters, 8.8

library

client shared and static libraries, 6.1.6

link files

custom, 6.13

linking

LNPRO<language> symbol, 6.4

OCI routines, 6.8.1

LISTENER.ORA, 5.5.4

LISTENER.ORA file, 5.4.1, 5.5

and authentication adapters, 5.6.2

literals

using as call arguments, 6.10

LNK$LIBRARY, 6.4.3

LNOCIC.COM, 6.8.3

LNOCI.COM, 6.8.4

locked accounts

unlocking, 1.5.5

log writer process (LGWR), 8.7

LOG_ARCHIVE_ FORMAT parameter, D.2.4

LOG_ARCHIVE_DEST parameter, C.1.1, C.1.2, C.1.3, D.2.3

LOG_ARCHIVE_START parameter, C.1.2

LOG_BUFFER parameter, 1.1.2.1

LOG_BUFFERS initialization parameters, 8.8

LOG_CHECKPOINT_INTERVAL parameter, 1.1.2.3, C.1

logical name definitions

for MTS Dispatcher, D.1.2

logical names

identification, 1.1.3

quotas, D.1.1

using to specify files, 1.1.2.5

LOGINOUT, F.2

LOUTL, 6.4.3

LOUTL.COM

linking sharable images with, 6.4.3

LRS

See Log roll-forward server (LRS), A, B, D, E, F

LSNRCTL mode

cautions with TNS listener, 5.5.1

LSNRCTL START, 5.5.1

LSNRCTL utility

starting TNS listener, 5.5.1

LSNRCTL.COM, 5.5.3

M

mailbox protocol adapter, 5.4.1, 5.4.1

managing

database files, B.3

memory, 8.4

special accounts and groups, 1.4

MAXDATAFILES parameter, A.1

MAXINSTANCES parameter, A.1, A.1

MAXLOGFILES parameter, A.1

MAXLOGHISTORY parameter, A.1

MAXLOGMEMBERS parameter, A.1

media failure, C.4.1

recovering from, C.4.3

media recovery, C.4.1

after failure, C.4.3.1

memory

contention, 8.1

tuning, 8.4

memory management, 8.4

control paging, 8.4.2

swap space, 8.4.1

messages

import and export, C.2.3

Microsoft Windows PC client

starting Oracle Database 10g, 2.1.4

moving

tablespace files, B.3.4

MTS Dispatcher

logical names for, D.1.2

multiple tapes

exporting to, C.3.2

exporting to and from, C.3

importing files from, C.3.3

multi-reel export files, C.3.1

N

Network Editor demonstration, 7.7.3

newline characters, 7.8.1.1

removing, 7.8.1.2

NOARCHIVELOG mode, 1.1.2.4

non-OpenVMS system

exporting files to, C.2.3.2

O

open database

backing up, C.2.2

OpenVMS

BACKUP utility, C.2, C.2.1

debugger, 6.2.2

event flags, 6.2.2

exporting files to, C.2.3.1

protocol adapters, 5.4

OpenVMS Client

starting Oracle Database 10g remotely by using, 2.1.3

operating system

accounts and groups, 1.4

ORA_LSNR, 5.5.3

ORA_ROOT directory, 1.1.2.2, C.1.2

ORA-12203, 5.4.4.4, 5.4.4.4, 5.4.4.4

oracle

accounts and groups, 1.4

Oracle Call Interface

linking programs in other languages, 6.8.4

programs in the C programming language, 6.8.3

routines, 6.8, 6.8

Oracle Cluster Registry (OCR), G.3

administering, G.3

managing, G.3

Oracle Database 10g

compiler options, 6.3.1

granting access privileges, 1.9

logical names, D.1

recovery, C.4.1

remote starting, 2.1.3

shutting down, 2.2

by using SQL*Plus, 2.2.1

SQL*Loader demonstration files included, 7.8

starting, 2.1

starting remotely, 2.1.4

tuning, 8.1

Oracle Management Agent

starting, 2.3.1

stopping, 2.3.1

Oracle Net listener

restarting, 2.3

stopping, 2.3

Oracle Net Services, 5.1.3

ADDRESS specification, 5.8.1

and mailbox protocol adapter, 5.4.1

and Transparent Network Substrate (TNS), 5.3

BEQ protocol, 5.9

Bequeath adapter, 5.1.1

configuration

overview, 5.1

types, 5.1

files and utilities, 5.7

IPC protocol, 5.10

protocol adapters automatically installed, 5.2

protocol support, 5.8

support for TCP/IP, 5.4.2

TCP/IP protocol, 5.11

using, 5.3

Oracle Network Configuration Assistant

described, 3.2.1

Oracle operations

interrupting and terminating, F.1

Oracle products

configuring the database for additional, 3.1

Oracle programmatic interfaces

compiling, 6.3

FORTRAN %REF directive, 6.10

HOST option, 6.2.1

linking, 6.4

LNOCIC.COM, 6.8.3

LNOCI.COM, 6.8.4

LNPRO<language> symbol, 6.4

OCI routines, 6.8.1

optional call parameters, 6.11

precompiling, 6.2

PRO<language> symbol, 6.2.2

Oracle programs

running as detached processes, F.2

Oracle Real Application Clusters

CLUSTER_INTERCONNECTS initialization parameter, 1.2.2

system tuning, 8.1

Oracle Real Application Clusters mode, C.1, C.1.2, C.1.2, C.4.3.1

Oracle resources contention, 8.1

Oracle run-time system

Pro*COBOL, 6.6.1

Oracle Shared Server, 5.1.1, 5.5, 5.5

Oracle software owner

special accounts, 1.4

Oracle Spatial demonstrations, 7.7, 7.7.2

Oracle Spatial Network demonstrations, 7.7.3

Oracle Text, 7.7.1

Oracle Text demonstrations, 7.7

oracle user account, 1.4

ORACLE_SID logical, 2.1.2.1

default value, 1.1.2

ORACLE.EXE file, 1.1.1.1

orapwd utility, 1.5.4, 1.5.4, 1.5.4

ORASRV_NETV2_SID.COM command, 5.5.4

ORAUSER.COM

restarting Oracle Net listener, 2.3

to start server using SQL*Plus, 2.1.2.3

to stop Oracle Net listener, 2.3

using to start up Oracle, 2.1.1

ORECLEN parameter, 6.1.4

P

page-out solutions, 8.4.2

paging, 8.4.2

paging space, 8.4

tuning, 8.4, 8.4.2

parameters

CREATE CONTROLFILE, A.1

CREATE DATABASE, A.1

MAXDATAFILES, A.1

MAXLOGFILES, A.1

MAXLOGHISTORY, A.1

MAXLOGMEMBERS, A.1

optional with programmatic interfaces, 6.11

Pascal, 6.2.1

password

management, 1.5.5

performance bottlenecks

types, 8.1

PL/I, 6.2.1

PL/SQL

demonstration files

loading, 7.1

running, 7.8

kernel demonstrations, 7.1.1

precompiler demonstrations, 7.1.2

Pl/SQL demonstration, 7.7.3, 7.7.3, 7.7.3, 7.7.3

PL/SQL demonstrations, 7.1, 7.1

PL/SQL gateway

installing, 1.7, 1.7

postinstallation tasks

configuration assistants, 3.2

PRE_PAGE_SG, D.2.5

precompiler files

configuration files, 6.1.1

demonstrations, 7.1.2

overview, 6.1

precompiler README files, 6.1.3

precompilers

uppercase to lowercase conversion, 6.1.4

value of IRECLEN and RECLEN, 6.1.4

vendor debugger programs, 6.1.4

precompiling

guidelines and restrictions, 6.2.2, 6.2.2

options, 6.2.1

syntax and example, 6.2

privileges

and process rights identifier, E

Pro*C/C++

demonstrations, 6.5.1

user programs, 6.5.2

using, 6.5

Pro*COBOL, 6.3.3, 6.6, 6.6

demonstrations, 6.6.1, 6.6.2

FORMAT precompiler, 6.6.3, 6.6.4

naming differences, 6.6

Oracle run time system, 6.6.1

user programs, 6.6.3

proc demonstrations, 6.4.3

process quotas

TNS listener, 5.5.3

Process Rights Identifier, E

PRODUCT_USER_PROFILE Table, 4.1.2

protocol adapters

Bequeath adapter, 5.4.3

installed with Oracle Net Services, 5.2

mailbox protocol, 5.4.1

on OpenVMS, 5.4

TCP/IP protocol, 5.4.2

protocols

ADDRESS specification, 5.8.1

Oracle Net Services, 5.8

Q

quotas

logical names, D.1.1

R

RDBMS demonstrations, 7.2

recovering

data from export files, C.4.3.2

from media failure, C.4.3

the database, C, C.4

redo log files

archiving, 1.1.2.4, C.1

automatically, C.1.2

manually, C.1.3

default names for, 1.1.2.4

defining, 1.1.2.3

modes of use, 1.1.2.4, C.1

moving, B.3.5

reusing, 1.1.2.4, 1.1.2.4

size of, 1.1.2.4

relinking executables, 3.3

remote

starting Oracle Database 10g by using OpenVMS client, 2.1.3

remote connections parameters

OS_AUTHENT_PREFIX, 1.5.4

removing

sharable images, 2.2.3

removing online Help in SQL*Plus, 4.2.2

REPLY/ENABLE=TAPES command, C.3

restarting an instance after failure, C.4.2

restrictions (SQL*Plus), 4.4

resizing windows, 4.4.1

return codes, 4.4.2

RMAN

for backup, C.2.3

rmanpipe.sql demonstrations, 7.4.2

rolling transactions

backward, in data recovery, C.4.1

forward, in data recovery, C.4.1

root

accounts and groups, 1.4

user, 1.4

running operating system commands, 4.3.2

S

SDO Network Example demonstrations, 7.7.3

security, 1.5, 1.5, 1.5.1, 1.5.2

file ownership, 1.5

for database files, 1.5.2

group accounts, 1.5

Server Manager access, 1.5.1

SHUTDOWN command, 1.5.1

STARTUP command, 1.5.1

two-task architecture, 1.5

unlocking accounts, 1.5.5

Server Manager, 2.1.2.3

commands, 1.5.1

security, 1.5.1

setup files

SQL*Plus, 4.1.1

SGA, 8.8

determining, 8.8.1

see System Global Area

shadow process, 1.5

sharable images

linking with LOUTL.COM, 6.4.3

removing, 2.2.3

shared pool, 1.1.2.1

SHARED_POOL_SIZE, D.2.6

SHARED_POOL_SIZE initialization parameters, 8.8

SHOW_LINK_COMMAND, 6.4.3

SHUTDOWN command, 1.5.1, C.4.2

security, 1.5.1

SHUTDOWN NORMAL command, C.2.1

shutting down

Oracle Database 10g, 2.2

by using SQL*Plus, 2.2.1

SID

system ID, setting, 1.1.2

site profile SQL*Plus, 4.1.1.1

SORT_AREA_SIZE, D.2.7

Spatial demonstrations, 7.7.2

Spatial Network demonstrations, 7.7.3

special operating system accounts, 1.4

SPOOL command

using in SQL*Plus, 4.3.4

SQL scripts, 8.3

SQL*Loader

administering, 7.8.1

demonstration files, 7.8, 7.8

newline characters in fixed-length records, 7.8.1.1

SQL*Plus, 2.1.2.3

administering command-line, 4.1

default editor, 4.3.1

demonstration tables, 4.1.3

editor, 4.3.1

Help facility, 4.2.1

installing command-line Help, 4.2

interrupting, 4.3.3, 4.3.3

PRODUCT_USER_PROFILE Table, 4.1.2

removing online Help, 4.2.2

restrictions, 4.4

running operating system commands, 4.3.2

setup files, 4.1.1

site profile, 4.1.1.1

SPOOL command, 4.3.4

starting

Oracle Database 10g remotely by using, 2.1.3

starting Oracle Database 10g, 2.1.2

system editor, 4.3.1

to shut down Oracle Database 10g, 2.2.1

user profile, 4.1.1.2

using, 4.3

to start Oracle Database 10g from Microsoft Windows client, 2.1.4

using to start Oracle Database 10g, 2.1.2.3

starting Oracle Database 10g, 2.1

by using SQL*Plus, 2.1.2.3

remotely

by using a Microsoft Windows PC client, 2.1.4

with SQL*Plus, 2.1.2

startup

parameters, 2.1.2.2

STARTUP command, 1.5.1, 2.1.2.3, C.4.2

static and dynamically linking

Oracle libraries and precompilers, 6.1.5

structures and definitions

backing up, C.2.3

superuser, 1.4

swap space, 8.4

tuning, 8.4

system editor

SQL*Plus, 4.3.1

System Global Area

components, 1.1.2.1

defined, 1.1.2.1

initialization parameters, 8.8

SYSTEM tablespace

removing, B.3

T

tablespace files

moving, B.3.4

TCP/IP, 5.4.1

adapter, 5.4.2

protocol, 5.11

ADDRESS, 5.10, 5.11.1

protocol adapter version, 5.4.2

terminating and interrupting Oracle operations, F.1

thread support, 6.14

TNS

see transparent network substrate

TNS listener

and process quotas, 5.5.3

cautions, 5.5.1, 5.5.1

general connections, 5.5.5

introduction, 5.5

privileges, 5.4.4.5, 5.5.2

specific to OpenVMS Alpha, 5.5

starting, using LSNRCTL, 5.5.1

trace and alert files

alert files, 1.6.2

generate by instance failure, C.4.2

trace file names, 1.6.1

using, 1.6

trace information

for Bequeath listener, 5.4.4.4, 5.4.4.4

Transparent Network Substrate (TNS), 5.3

and Oracle Net Services, 5.3

tuning, 8.4, 8.4

CPU usage, 8.7

disk I/O, 8.5

I/O bottlenecks, 8.5

memory management, 8.4

Oracle Database 10g, 8.1

performance bottlenecks, 8.1

trace and alert files, 1.6

tuning tools

Oracle SQL, 8.3

two-task, 1.5

U

upgraded databases

configuring, 3.2.3

user profile

SQL*Plus, 4.1.1.2

user programs

for Pro*C/C++, 6.5.2

Pro*COBOL, 6.6.3

USER_DUMP_DEST, 1.6.1, 5.5.5, D.2.8

using command-line SQL*Plus on OpenVMS, 4.3

utilities

database verification, B.4

UTLRP.SQL

recompiling invalid SQL modules, 3.2.3

V

V$DBFILE, B.3.3

W

warning message, during backup, C.2.2

X

XDK demonstrations, 7.5