Oracle8 Administrator's Reference for Sun SPARC Solaris 2.x
Release 8.0.4
A56101-01

Library
Product
Contents

Prev

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  Y  Z 

Symbols

$
using, 2-25
,, 5-6
?
example of use, 2-10
@
to denote $ORACLE_SID, 2-10
_editor
setting, 4-6

A

Ada compiler, 2-11
ADA_PATH, 2-11
adapters utility, 6-3
ADDRESS specification
protocol adapters, 6-5
administering
SQL, 4-2
advanced networking option, 6-19
.bak files, 6-19
DCE integration, 6-19
security and single sign-on, 6-19
afiedt.buf, 4-7
APPC/LU6.2 protocol adapter, 6-16
ADDRESS, 6-17
solaris 2.x-specific listener, 6-16
asynchronous I/O, 3-8
using, 3-8
automatic login
listener.ora file, 2-25
non-UNIX systems, 2-25
remote_os_roles, 2-29

B

BEQ protocol adapter, 6-6
ADDRESS, 6-6
overview, 6-6
syntax for connection parameters, 6-7
binding processes, 3-10
block and file size
specifying, 3-12
BSD, 2-12
BSD-UNIX file system type, 3-9
buffer cache size
tuning, 3-12
buffer manager, 3-6

C

C
Pro*C/C++, 5-4
SQL Module for, 5-13
cache
size
tuning, 3-12
cartridge demos
Image Cartridge, 7-3
installing for Time Series, 7-2
Visual Information Retrieval Cartridge, 7-3
catching routine
example, 5-21
CATPROC.SQL, 1-15
CDE tools, 2-9
changing databases, 2-6
chmod command
example, 2-24
cluster
estimating size, 2-14
COBOL
Pro*COBOL, 5-6
command interpreter, 2-12
commands
expst, 3-11
impst, 3-11
ipcs, 3-7
orapwd, 2-27
sar, 3-6
vmstat, 3-6
common environment
oraenv file, 2-5
setting, 2-5
configuration files
Net8, 6-3
precompiler, 5-3
CONNECT INTERNAL
security, 2-24
control remote DBA access
REMOTE_DBA_OPS_ALLOWED, 2-26
REMOTE_DBA_OPS_DENIED, 2-26
control remote login, 2-26
OPS_DOLLAR_LOGIN_DENIED, 2-26
COPY command
SQL*Plus, 4-8
coraenv, 2-9
CPU usage
priority level of processes, 3-10
processor binding, 3-10
single-task architecture, 3-11
tuning, 3-10

D

daemon user
security, 2-26
data cartridges
running demos for, 7-1
database
administrator
permissions for executables, 2-21
files
authorization, 2-24
security, 2-24
database I/O
DBWR tuning, 3-7
database writer
tuning, 3-7
dba group
members, 2-21
relinking, 2-22
DBA group ID
keywords, 2-26
non-default name, 2-26
DBA_GROUP
/etc/listener.ora file, 2-26
DBA_GROUP_sid
/etc/listener.ora file, 2-26
DBWR
tuning, 3-7
debugger programs, 5-3
default
directory, 2-11, 2-12
linker option, 2-11
printer, 2-11
default printer, 2-12
default settings
system editor, 4-7
demonstration
precompiler, 2-32
the procedural option, PL/SQL, 2-31
demonstration programs
oracle call interface, 5-15
Pro*C/C++, 5-4
Pro*COBOL, 5-8
SQL*Module for Ada, 5-13
demonstration tables
creating manually, 4-4
deleting, 4-4
SQL*Plus, 4-3
demos
creating for Image Cartridge, 7-3
creating for Visual Information Retrieval Cartridge, 7-3
installing for Time Series Cartridge, 7-2
disk
monitoring performance, 3-9
quotas, 2-14
Disk I/O
tuning, 3-7
disk I/O
asynchronous I/O, 3-8
file system type, 3-9
I/O slaves, 3-8
request queues, 3-9
tuning the database writer, 3-7
disk performance
issues, 3-10
DISPLAY
environment variable, 2-11
dynamic and static linking
oracle libraries, 5-19

E

echo command, 2-5
editor
setting the order of, 4-6
SQL*Plus, 4-6
environment variables, 5-7
ADA_PATH, 2-11
DISPLAY, 2-11
HOME, 2-11
LANG, 2-11
LANGUAGE, 2-11
LD_LIBRARY_PATH, 2-11
LDOPTS, 2-11
LDPATH, 2-11
LPDEST, 2-11
MicroFocus COBOL compiler, 5-7
NLS_LANG, 2-8
ORA_NLS, 2-8
ORACLE_HELP, 2-8
ORACLE_HOME, 2-8
ORACLE_SID, 2-9
ORACLE_TERM, 2-9
ORACLE_TERMINAL, 2-9
ORACLE_TRACE, 2-9
ORAENV_ASK, 2-9
PATH, 2-11
PRINTER, 2-12
Pro*COBOL, 5-7
setting for SQL*Plus, 4-7
SHELL, 2-12
Sun Nihongo COBOL compiler, 5-8
TERM, 2-12
TMPDIR, 2-12
TNS_ADMIN, 2-10, 6-3
TWO_TASK, 2-10
TZ, 2-12
XENVIRONMENT, 2-12
exclamation point
SQL*Plus prompt, 4-7
executable program, 2-11
exports
tuning, 3-11
expst command, 3-11

F

file names
default extensions in SQL*Plus, 4-8
files
trace files, 3-13
FORMAT precompiler
Pro*COBOL, 5-10

G

getname command, 6-13
glogin.sql, 4-2
groups
sample script, 2-31

H

help facility
SQL*Plus, 4-4
help file, 2-8
HOME, 2-11
home directory, 2-11

I

I/O
DBWR tuning, 3-7
disk request queues, 3-9
tuning, 3-7
I/O slaves, 3-8
Image Cartridge, 7-3
creating the demo for, 7-3
imports
tuning, 3-11
impst command, 3-11
index size
calculating, 2-14
initialization parameter
remote_os_authent, 2-25
initialization parameters
BACKGROUND_DUMP_DEST, 2-15
BITMAP_MERGE_AREA_SIZE, 2-15
COMMIT_POINT_STRENGTH, 2-15
CONTROL_FILES, 2-15
CREATE_BITMAP_AREA_SIZE, 2-15
DB_BLOCK_BUFFERS, 2-15
DB_BLOCK_SIZE, 2-15
DB_FILE_DIRECT_IO_COUNT, 2-15
DB_FILE_MULTIBLOCK_READ_COUNT, 2-15
DB_FILES, 2-15
defaults, 2-15
DISTRIBUTED_TRANSACTIONS, 2-15
HASH_AREA_SIZE, 2-15
HASH_MULTIBLOCK_IO_COUNT, 2-16
LOCK_SGA, 2-16
LOCK_SGA_AREAS, 2-16
LOG_ARCHIVE_BUFFER_SIZE, 2-16
LOG_ARCHIVE_BUFFERS, 2-16
LOG_ARCHIVE_DEST, 2-16
LOG_ARCHIVE_FORMAT, 2-16
LOG_BUFFER, 2-16
LOG_CHECKPOINT_INTERVAL, 2-16
LOG_SMALL_ENTRY_MAX_SIZE, 2-16
MTS_LISTENER_ADDRESS, 2-16
MTS_MAX_DISPATCHERS, 2-16
MTS_MAX_SERVERS, 2-16
MTS_SERVERS, 2-16
NLS_LANGUAGE, 2-16
NLS_TERRITORY, 2-16
OBJECT_CACHE_MAX_SIZE_PERCENT, 2-16
OBJECT_CACHE_OPTIMAL_SIZE, 2-16
OPEN_CURSORS, 2-16
OS_AUTHENT_PREFIX, 2-16
PROCESSES, 2-16
SHARED_POOL_SIZE, 2-16
SHOW PARAMETERS command, 2-15
SORT_AREA_SIZE, 2-16
SORT_READ_FAC, 2-16
SORT_SPACEMAP_SIZE, 2-16
USER_DUMP_DEST, 2-16
input and output, 2-11
interrupting SQL*Plus, 4-7
iostat, 3-4
IPC protocol adapter, 6-8
ADDRESS, 6-8
overview, 6-8
ipcs command, 3-7
ireclen, 5-3

K

kernel
tuning UNIX parameters, 3-11
keywords
DBA group ID, 2-26

L

LANGUAGE
environment variable, 2-11
language, 2-8
ld, 2-11
LD_LIBRARY_PATH
environment variable, 2-11
LDOPTS
environment variable, 2-11
LDPATH
environment variable, 2-11
limits
resource, 2-14
linking
single-task, 3-11
login home directories
administering, 2-29
sample script, 2-30
login.sql, 4-2
LPDEST
environment variable, 2-11

M

MAXDATAFILES parameter, 2-36
MAXINSTANCES parameter, 2-36
MAXLOGFILES parameter, 2-36
MAXLOGHISTORY parameter, 2-36
MAXLOGMEMBERS parameter, 2-36
memory
estimating usage, 2-13
SGA tuning, 3-7
shared, 2-16
tuning, 3-5
virtual, 2-13
memory management, 3-5
control paging, 3-6
single shared memory segment, 3-7
swap space, 3-6
UNIX kernel, 3-7
MicroFocus COBOL compiler, 5-7
mpstat, 3-5
multiple signal handlers, 5-21
multi-thread server, 6-4

N

naming adapters, 6-18
National Language Support (NLS)
variable, 2-8
Net8
adapters utility, 6-3
advanced networking option, 6-19
APPC/LU6.2 protocol adapter, 6-16
BEQ protocol adapter, 6-6
files and utilities, 6-3
IPC protocol adapter, 6-8
multi-thread server, 6-4
naming adapters, 6-18
Net8 assistant, 6-4
oracle connection manager, 6-4
oracle enterprise manager intelligent agent, 6-18
oracle names, 6-4
products and features, 6-3
protocol adapters, 6-5
RAW protocol adapter, 6-9
README files, 6-2
SPX/IPX protocol adapter, 6-11
TCP/IP protocol adapter, 6-9
Net8 assistant, 6-4
Net8 configuration files
location of, 6-3
network
dba privileges, 2-25
network passwords, 2-24
network security, 2-24
Nihongo COBOL, 5-11
NLS_LANG
environment variable, 2-8
ntisbsdm broadcast daemon, 6-11
ntspxctl utility, 6-11

O

operating system authorized login
SQL*Net Version 2, 2-25
operating system commands
running from SQL*Plus, 4-7
ORA_NLS
environment variable, 2-8
Oracle
memory usage, 2-14
oracle account
set authorization, 2-24
Oracle APPC/LU6.2 Protocol Adapter, 6-17
oracle call interface, 5-15
demonstration programs, 5-15
user programs, 5-16
using, 5-15
oracle connection manager, 6-4
oracle enterprise manager intelligent agent, 6-18
agent service discovery and auto-configuration, 6-18
debugging tcl scripts, 6-18
Oracle environment variables
EPC_DISABLED, 2-8
NLS_LANG, 2-8
ORA_NLS33, 2-8
ORACLE_BASE, 2-8
ORACLE_HELP, 2-8
ORACLE_HOME, 2-8
ORACLE_PATH, 2-8
ORACLE_SID, 2-9
ORACLE_TERM, 2-9
ORACLE_TERMINAL, 2-9
ORACLE_TRACE, 2-9
ORAENV_ASK, 2-9
TNS_ADMIN, 2-10
TWO_TASK, 2-10
oracle group
permissions and executables, 2-22
oracle libraries
oracle shared library, 5-19
static and dynamic linking, 5-19
oracle names, 6-4
oracle precompiler and OCI linking and makefiles, 5-17
custom makefiles, 5-17
undefined symbols, 5-18
oracle run time system
Pro*COBOL, 5-8
Oracle Server
accounts, 2-20
roles, 2-23
roles and /etc/group file, 2-23
oracle software owner, 2-20
special accounts, 2-20
Oracle System Identifier, 2-9
ORACLE_HELP
environment variable, 2-8
ORACLE_HOME
environment variable, 2-8
using ? for, 2-10
ORACLE_SID
environment variable, 2-9
suppressing prompt, 2-6
ORACLE_TERM
environment variable, 2-9
oraenv file
description, 2-5
moving between databases, 2-6
ORAENV_ASK, 2-9
setting, 2-6
orainst, 2-9
orapwd command, 2-27
oreclen, 5-3

P

paging space
tuning, 3-5, 3-6
PATH, 2-11
permissions
dba group, 2-21
granting, 2-22
PL/SQL
demonstrations
loading, 2-31
precompiler
relinking executables, 5-2
running demonstration, 2-32
value of ireclen and oreclen, 5-3
precompiler configuration files, 5-3
precompilers
overview, 5-2
signals, 5-21
uppercase to lowercase conversion, 5-3
values, 5-3
vendor debugger programs, 5-3
PRINTER, 2-12
Pro*C/C++
administering, 5-4
demonstration programs, 5-4
makefiles, 5-5, 5-6
signals, 5-21
system configuration file, 5-4
user programs, 5-6
using, 5-4
Pro*COBOL, 5-6
administering, 5-7
demonstration programs, 5-8, 5-9
environment variables, 5-7
FORMAT precompiler, 5-10
naming differences, 5-6
oracle run time system, 5-8
system configuration file, 5-7
user programs, 5-10
using, 5-8
PRODUCT_USER_PROFILE Table
SQL*Plus, 4-3
protocol adapters, 6-5
ADDRESS specification, 6-5
pupbld.sql, 4-3

Q

question mark
example of use, 2-10

R

raw devices, 3-14
buffer cache size, 3-12
criteria for using, 3-14
disadvantages, 3-14
guidelines for using, 3-15
oracle8 parallel server installation, 3-15
raw disk partition availability, 3-15
setting up, 3-15
RAW protocol adapter, 6-9
README files
Net8, 6-2
related documentation, xiv
relinking precompiler executables, 5-2
remote
connect
as INTERNAL, 2-29
as OPERATOR, 2-29
login
security, 2-26
parameter
REMOTE_OS_AUTHENT, 2-25
remote connections parameters
OS_AUTHENT_PREFIX, 2-29
REMOTE_OS_AUTHENT, 2-29
REMOTE_OS_ROLES, 2-29
resource contention
kernel parameters, 3-11
tuning, 3-11
resource definition, 2-12
resource limits, 2-14
restrictions (SQL*Plus), 4-8
COPY command, 4-8
resizing windows, 4-8
return codes, 4-9
roles
mapping to groups, 2-23
root
user, 2-20

S

s5 file system type, 3-9
sar, 3-3
sar command, 3-6, 3-13
security
assigning permissions, 2-21
CONNECT INTERNAL, 2-24
default group names, 2-22
file ownership, 2-21
group accounts, 2-21
network dba privileges, 2-25
Server Manager access, 2-23
SHUTDOWN command, 2-24
STARTUP command, 2-24
two-task architecture, 2-21
Send Us Your Comments
instructions, ix
Server Manager
commands, 2-23
security, 2-23
SHOW PARAMETERS, 2-15
setting up
war devices, 3-15
setup files
SQL*Plus, 4-2
SGA
estimating size, 3-7
relocating, 2-18
tuning, 3-7
shadow process
security, 2-21
shared
library loader, 2-11
object library, 2-11
shared memory
SGA, 2-16
SGA tuning, 3-7
shared object library, 2-11
SHELL, 2-12
SHUTDOWN command, 2-24
security, 2-24
SIGCLD two-task signal, 5-21
SIGINT two-task signal, 5-21
SIGIO two-task signal, 5-21
signal handlers
signals, 5-20
using, 5-20
signal routine
example, 5-21
signals
creating handlers, 5-20
two-task, 5-20
SIGPIPE two-task signal, 5-21
SIGTERM two-task signal, 5-21
SIGURG two-task signal, 5-21
single shared memory segment, 3-7
site profile
SQL*Plus, 4-2
software distribution, 2-8
solaris 2.x tools, 3-2
iostat, 3-4
mpstat, 3-5
sar, 3-3
swap, 3-4
vmstat, 3-2
special accounts, 2-20
special groups
root, 2-21
SPOOL command
SQL*Plus, 4-8
using, 4-8
SPX/IPX protocol adapter, 6-11
ADDRESS, 6-15
command summary, 6-13
getname command, 6-13
ntisbsdm broadcast daemon, 6-11
ntspxctl utility, 6-11
SQL
administering, 4-2
SQL scripts, 3-5
utlbstat and utlestat, 3-5
SQL*DBA, 2-9
SHOW PARAMETERS, 2-15
SQL*Module
for Ada, 5-13
for C, 5-13
SQL*Module for Ada, 5-13
administering, 5-13
demonstration programs, 5-13
system configuration file, 5-13
user programs, 5-15
using, 5-13
SQL*Net V1, 2-10
SQL*Net V2, 2-10
/etc/oratab file, 6-3
default directory, 6-3
using APPC/LU6.2 Protocol Adapter, 6-17
SQL*Net Version 2
operating system authorized login, 2-25
SQL*Plus
COPY command, 4-8
default editor, 4-6
demonstration tables, 4-3
editor, 4-6
environment variables, 4-7
help facility, 4-4
interrupting, 4-7, 4-8
PRODUCT_USER_PROFILE Table, 4-3
restrictions, 4-8
sample setup files, 4-3
setup files, 4-2
site profile, 4-2
SPOOL command, 4-8
system editor, 4-6
UNIX commands, 4-7
user profile, 4-2
using, 4-6
STARTUP command
security, 2-24
static and dynamic linking
oracle libraries, 5-19
sub-shell
creating in SQL*Plus, 4-7
Sun Nihongo COBOL, 5-11
Sun Nihongo COBOL compiler
environment variables, 5-8
superuser, 2-20
swap, 3-4
swap space
tuning, 3-5
SYS account
privileges, 2-20
SYSDATE
and TZ, 2-13
SYSTEM account
privileges, 2-20
system configuration file
Pro*C/C++, 5-4
Pro*COBOL, 5-7
SQL*Module for Ada, 5-13
system editor
default settings, 4-7
setting the order of, 4-6
SQL*Plus, 4-6
System Global Area (SGA)
relocating, 2-18
requirements, 2-16
system time
setting, 2-12
System V, 2-11

T

TCP/IP protocol adapter, 6-9
ADDRESS, 6-10
overview, 6-9
temporary disk file, 2-12
TERM
environment variable, 2-12
thread support, 5-19
Time Series Cartridge, 7-2
dev2k demo, 7-2
extend demo, 7-2
oci demo, 7-2
proc demo, 7-2
usage demo, 7-2
Time Series Cartridge demos
installing, 7-2
time zone
setting with TZ, 2-12
TMPDIR, 2-12
TNS listener
configuring for Oracle TCP/IP Protocol Adapter, 6-9
TNS_ADMIN
environment variable, 2-10
Toolkit II resource file, 2-9
tools, 3-2
trace and alert files
alert files, 3-14
trace file names, 3-13
using, 3-12, 3-13
tracing Bourne shell scripts, 2-9
tuning
block and file size, 3-12
CPU usage, 3-10
disk I/O, 3-7
I/O bottlenecks, 3-7
memory management, 3-5
resource contention, 3-11
solaris 2.x buffer cache size, 3-12
trace and alert files, 3-12, 3-13
TWO_TASK
environment variable, 2-10
two-task
architecture
security, 2-21
signals, 5-20
TZ
and SYSDATE, 2-12
environment variable, 2-12

U

ufs file system type, 3-9
UNIX
security, 2-21
UNIX commands
running from SQL*Plus, 4-7
UNIX environment variables used with Oracle8
ADA_PATH, 2-11
DISPLAY, 2-11
HOME, 2-11
LANG, 2-11
LD_LIBRARY_PATH, 2-11
LDOPTS, 2-11
LDPATH, 2-11
LPDEST, 2-11
PATH, 2-11
PRINTER, 2-12
SHELL, 2-12
TERM, 2-12
TMPDIR, 2-12
XENVIRONMENT, 2-12
UNIX file system type, 3-9
UNIX kernel
tuning, 3-11
user interrupt handler, 5-21
user profile
SQL*Plus, 4-2
user programs
oracle call interface, 5-16
Pro*C/C++, 5-6
Pro*COBOL, 5-10
SQL*Module for Ada, 5-15
users
sample script, 2-31
using SQL*Plus, 4-6
utlbstat and utlestat SQL scripts, 3-5

V

Veritas file system type, 3-9
Visual Information Retrieval Cartridge, 7-2
creating the demo, 7-3
vmstat, 3-2
vmstat command, 3-6
vxfs file system type, 3-9

W

writer activity
tuning, 3-7

X

X Windows, 2-11, 2-12
XA functionality, 5-23
XENVIRONMENT
environment variable, 2-12

Prev
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents