Oracle9i Administrator's Reference
Release 1 (9.0.1) for Alpha OpenVMS

Part Number A90868-01


Contents

Go to previous page

Index

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


A

Ada, 9-5
ADDRESS specification protocols, 11-3
administering SQL, 8-2
AGENT_START.COM, 10-25
ALTER DATABASE command, 6-4, 7-2
ALTER SYSTEM command, 3-5
ALTER TABLESPACE command, 6-3
ANO, 10-30
de-installation, 10-35
requirements, 10-31
with Oracle Names, 10-34
Appendices, 9
ARCH process, 7-4
ARCHIVELOG mode, 1-5
authentication, 10-31
usage notes, 10-37
authorization, 1-9
AUTHORIZE utility, 3-3

B

BACKGROUND_DUMP_DEST, 10-20
Backup procedures, 1-5
BEQ protocol, 11-4
Bequeath Adapter, 10-11
Bequeath Listener, 10-12
privileges, 10-15
problem resolution, 10-13
shutting down, 10-13
starting, 10-12
Binary integers, 9-15
block size
tuning, 2-4
Blocksize, 6-3
buffer manager, 2-3
Buffers
database buffer pool, 1-4
redo log buffers, 1-4

C

C Language
precompiling, 9-5
Centralized configuration, 10-3
checksumming, 10-30
Client-server configuration, 10-4
COBOL, 9-5, 9-16
Commands
ALTER DATABASE, 6-4
CONNECT INTERNAL, B-2
CREATE TABLE, 6-4
DROP TABLESPACE, 6-4
Communities
protocol-dependent groups, 10-8
Compiling with programmatic interfaces, 9-7
Configuration, 10-2
centralized, 10-3
client-server, 10-4
distributed, 10-4
configuration
encapsulator, 11-7
master agent, 11-6
configuration files
Net8, 11-2
Oracle Net, 11-2
precompiler, 9-2
CONNECT INTERNAL, B-2
CONTINUE command, C-2
Control files
creating, 6-3
identifying, 6-3
CPU usage
priority level of processes, 2-5
tuning, 2-4
CREATE CONTROLFILE parameters, 1-7
CREATE DATABASE parameters, 1-7

D

Database
automatic recovery, 7-12
granting access to, 3-3
opening in exclusive mode, 4-4
Database files
defined, 1-4
database files, 1-9
Database links
creating, 6-2
Database verification utility, 6-8
database verification utility, 6-8
Datafiles, 1-6
Datatypes, 9-15
DB_BLOCK_BUFFERS parameter, 1-4
DB_dbname directory, 6-3
DBSNMPJ.COM, 10-25
DEBUG qualifier, 9-6
Demo files
programmatic interfaces, 9-9
demonstration
the procedural option, PL/SQL, 1-16
demonstration tables
creating manually, 8-3
deleting, 8-3
SQL*Plus, 8-3
Detached processes, 7-12
identification, A-6
Discovery option, 10-25
disk
monitoring performance, 2-4
disk I/O
tuning, 2-4
distributed database, 10-4
Distributed database configuration, 10-4
documentation
accessing, xv
navigation files, xv
on administration and tuning, xvi
on migrating and upgrading from previous release, xvi
related, xvi
where installed, xv
DROP TABLESPACE command, 6-4

E

editor SQL*Plus, 8-5
encapsulator configuration, 11-7
encryption, 10-30
Errors
ORA-00921, 6-4
Ethernet, 10-2
event flags
restrictions, 9-6
Exclusive mode, 4-4
Export utility, 7-8

F

files
trace files, 2-5
FORTRAN, 9-5, 9-15

G

glogin.sql file, 8-2

H

help facility, 8-4
HOST
, 9-6

I

Import utility
for recovery, 7-14
INCLUDE option, 9-6
initialization parameters
BACKGROUND_DUMP_DEST, 2-6
BITMAP_MERGE_AREA_SIZE, 1-10
COMMIT_POINT_STRENGTH, 1-10
CONTROL_FILES, 1-10
CREATE_BITMAP_AREA_SIZE, 1-10
DB_BLOCK_BUFFERS, 1-10
DB_BLOCK_SIZE, 1-10
DB_FILE_DIRECT_IO_COUNT, 1-10
DB_FILE_MULTIBLOCK_READ_COUNT, 1-10
DISTRIBUTED_TRANSACTIONS, 1-10
HASH_AREA_SIZE, 1-10
HASH_MULTIBLOCK_IO_COUNT, 1-10
JAVA_POOL_SIZE, 1-10
LOG_BUFFER, 1-11
LOG_CHECKPOINT_INTERVAL, 1-11
MAX_DISPATCHERS, 1-11
MAX_DUMP_FILE, 2-6
MAX_SERVERS, 1-11
NLS_LANGUAGE, 1-11
NLS_TERRITORY, 1-11
OBJECT_CACHE_MAX_SIZE_PERCENT, 1-11
OBJECT_CACHE_OPTIMAL_SIZE, 1-11
OPEN_CURSORS, 1-11
OS_AUTHENT_PREFIX, 1-11
PROCESSES, 1-11
SHARED_POOL_SIZE, 1-11
SHARED_SERVERS, 1-11
SORT_AREA_SIZE, 1-11
USER_DUMP_DEST, 2-5
INIT.ORA file
location, A-5
INIT.ORA files
at start-up, 1-3
setting SGA size, 1-3
initsid.ora file, 1-9
INSORACLE.COM file
run as a batch job, 4-10
installation
Oracle Internet Directory, xvi
Oracle Workflow, xvi
Intelligent Agent
configuration on SNMP, 11-6
interrupting SQL*Plus, 8-6
I/O
improving, 1-3
tuning, 2-4
IPC protocol, 11-4

K

Kerberos5, 10-31

L

linker directives
with Oracle programming interfaces, 9-9
Linking
, 9-8
LOUTL.COM, 9-10
OCI routines, 9-12, 9-14
LISTENER.ORA, 10-9
LNOCIC.COM, 9-13
LNOCI.COM, 9-14
log writer process (LGWR), 2-5
LOG_BUFFER parameter, 1-4
LOG_CHECKPOINT_INTERVAL parameter, 1-5, 7-2
Logical names
alphabetical listing, A-3
command files that define, A-2
Logicals
identification, 1-6
using to specify files, 1-6
LOGIN.COM file
of ORACLE users, 3-2
LOGINOUT, C-3
login.sql file, 8-2
LRS
See Log roll-forward server (LRS), A-1, B-1, C-1

M

Mailbox Adapter, 10-9
Mailbox protocol adapter, 10-9
Managing Instances, 5-1
master agent configuration, 11-6
MAXDATAFILES parameter, 1-7
MAXINSTANCES parameter, 1-7
MAXLOGFILES parameter, 1-7
MAXLOGHISTORY parameter, 1-7
MAXLOGMEMBERS parameter, 1-7
memory
tuning, 2-3
memory management, 2-3
control paging, 2-3
swap space, 2-3
Multiple protocols
on single machine, 10-8
multithreaded servers, 10-3

N

Names Server
Oracle Names
introduction, 10-20
privileges, 10-21
namesctl, 10-20
NAMES.ORA, 10-23
Net8
ADDRESS specification, 11-3
BEQ protocol, 11-4
files and utilities, 11-2
IPC protocol, 11-4
oracle enterprise manager intelligent agent, 11-6
protocol support, 11-3
protocols, 11-3
TCP/IP protocol, 11-5
Net8 configuration files, 11-2
NMICONF.TCL, 10-25
NOARCHIVELOG mode, 1-5

O

OCI routines, 9-12, 9-14
options file
using for linker directives, 9-9
ORA_DUMP directory, 7-4
ORA_INSTALL logical name, A-4
ORA_LSNR, 10-18
ORA_SID logical, 4-5
default value, 1-2
ORA_USER.COM file, A-6
ORA-00921 error, 6-4
ORACLE call interface
OCI routines, 9-12
Oracle Enterprise Manager (OEM), 10-23
oracle enterprise manager intelligent agent, 11-6
Oracle Intelligent Agent, 10-24
maintenance, 10-29
shutdown, 10-28, 10-29
startup, 10-28
Oracle Names
with ANO, 10-34
Oracle Net
products and features, 11-2
Oracle Net configuration files, 11-2
ORACLE programmatic interfaces
compiling, 9-7
datatypes, 9-15
FORTRAN %REF directive, 9-15
HOST option, 9-6
linking, 9-8
LNOCIC.COM, 9-13
LNOCI.COM, 9-14
, 9-8
OCI routines, 9-12, 9-14
optional call parameters, 9-15
precompiling, 9-5
, 9-6
Oracle Protocol Adapters, 10-7
role in TNS network, 10-7
oracle software owner, 1-8
special accounts, 1-8
Oracle Text, D-1
Oracle7
granting access privileges, 3-3
linked as shared image, 1-2
logical names, A-2
relinking, 1-2
Spatial, D-1
ORACLE.EXE file
defined, 1-2
ORACLEINS
to shut down Oracle7, 4-13
ORACLEINS.COM file
logical assignments made, A-2
ORAMBX, 6-9
orapwd command, 1-11
orapwd utility, 1-11
ORAUSER_instance.COM file, 3-2
running for ORACLE users, 3-2

P

page-out activity, 2-4
paging, 2-3
paging space, 2-3
tuning, 2-3
Parallel Query, 5-4
Parameters
optional with programmatic interfaces, 9-15
Pascal, 9-5
password utility, 3-3
PEER master agent, 10-29
PL/I, 9-5
PL/SQL demonstrations
loading, 1-16
precompiler configuration files, 9-2
precompilers
overview, 9-2
Precompiling
guidelines and restrictions, 9-6
options, 9-6
syntax and example, 9-5
preferred credentials, 10-27
Privileges
and Process Rights Identifier, B-1
Process Rights Identifier, B-1
PRODUCT_USER_PROFILE Table, 8-3
Programmatic Interfaces
ORACLE programmatic interfaces, 9-4
Protocol Adapters, 10-7
Bequeath Adapter, 10-11
Mailbox Adapter, 10-9
TCP/IP Adapter, 10-10
Protocol API differences
TNS implementation, 10-8
Protocol implementations, 10-8
protocols, 11-3
ADDRESS specification, 11-3

R

Redo log file
mode of use, 7-2
Redo log files
default names for, 1-5
defining, 1-5
modes of, 1-5
moving, 6-6
reusing, 1-5
size of, 1-6
related documentation, xvi
relinking, 1-7
Relinking Oracle7, 1-2
remote connections parameters
OS_AUTHENT_PREFIX, 1-11
restrictions (SQL*Plus), 8-6
resizing windows, 8-6
return codes, 8-6
Rolling backward, 7-12
Rolling forward, 7-12
root user, 1-8
running operating system commands, 8-5

S

scripts
start_peer, 11-7
SDNS.ORA, 10-22
SecurID, 10-31
security, 1-8, 1-9
CONNECT INTERNAL, 1-9
file ownership, 1-8
group accounts, 1-8
Server Manager access, 1-9
SHUTDOWN command, 1-9
STARTUP command, 1-9
two-task architecture, 1-8
Server Manager, 4-5
commands, 1-9
security, 1-9
setup files
SQL*Plus, 8-2
shadow process, 1-8
Shared ORACLE7 image, A-5
Shared Pool, 1-3
SHUTDOWN command, 1-9, 7-13
security, 1-9
SHUTDOWN file
to stop ORACLE7, 4-14
SID
and instances, 5-2
ORA_SID, A-5
Simple Network Management Protocol (SNMP), 11-6
site profile SQL*Plus, 8-2
SNMP
and Intelligent Agent, 11-6
SNMP and Intelligent Agent, 11-6
SNMP support, 10-29
snmpd executable, 11-7
Spatial demonstrations, D-1
special accounts, 1-8
SPOOL command
SQL*Plus, 8-6
using, 8-6
SQL scripts, 2-2
SQL*Net
architecture, 10-7
SQL*Plus
default editor, 8-5
demonstration tables, 8-3
editor, 8-5
help facility, 8-4
interrupting, 8-6
PRODUCT_USER_PROFILE Table, 8-3
restrictions, 8-6
running operating system commands, 8-5
setup files, 8-2
site profile, 8-2
SPOOL command, 8-6
system editor, 8-5
user profile, 8-2
using, 8-5
start_peer script, 11-7
STARTUP command, 1-9, 4-5, 7-13
superuser, 1-8
swap space, 2-3
tuning, 2-3
system editor
SQL*Plus, 8-5
System Global Area
components, 1-3
defined, 1-3
identification, A-6
size, 1-3
SYSTEM tablespace, 7-14
removing, 6-3

T

Tablespace files
moving, 6-5
TCP/IP Adapter, 10-10
TCP/IP protocol, 11-5
ADDRESS, 11-5
TNS
Oracle network layer, 10-7
TNS client
community member
common cases, 10-8
TNS Listener
general connections, 10-20
introduction, 10-15
privileges, 10-17
process quotas, 10-18
TNS, Adapters, and Protocols
Protocol Adapters, 10-8
trace and alert files
alert files, 2-6
trace file names, 2-5
using, 2-5
Trace files, A-4
trace information, writing, 10-13
Transparent Network Substrate, 10-8
Transparent Network Substrate (TNS), 10-5
tuning, 2-3
CPU usage, 2-4
disk I/O, 2-4
I/O bottlenecks, 2-4
memory management, 2-3
trace and alert files, 2-5
two-task, 1-8

U

user profile
SQL*Plus, 8-2
USER_DUMP_DEST, 10-20
using SQL*Plus, 8-5
Utility
database verification, 6-8
useful, 6-8

V

VMS Mailbox adapter, 10-4
VMS Mailbox driver
creating database links for the, 6-2

W

Windows, 10-23

Go to previous page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.


Contents