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

@

• $, using
• .cshrc file, setting variables
• .login file, setting variables
• .profile file, setting variables
• ?, example of use
• @, to denote $ORACLE_SID

  A

• accounting_node parameter, Oracle DECnet Protocol Adapter specification
• Ada compiler
• ADA_PATH
• ADDRESS keyword
  • SPX/IPX protocol adapter
  • TCP/IP protocol adapter
• admin directory
  • file naming conventions
    • catparr.sql.script
    • catproc.sql.script
    • dbms*.sql
    • utl*.sql
  • located in rdbms directory
  • SQL scripts
• admin/* directory, in Oracle product subdirectory
• admin/resource resource files, in Oracle product subdirectory
• admin/terminal runtime files, in Oracle product subdirectory
• admin, script in product subdirectory
• alert file
  • background process
  • checkpoint
  • location
  • log switch
• APPC/LU6.2 Protocol Adapter, overview
• archmon process, stopping
• automatic login
  • listener.ora file
  • non-UNIX systems
  • os_authent_prefix
  • remote_os_roles

  B

• background process, alert file
• backup restore utility
  • archive to tape
  • archmon program
  • backing up a database
  • destination direction
  • parameters
• binary executable, function
• bin, ORACLE_HOME directory structure
• block sizes
• BSD

  C

• cat.sql
  • catalog tables
  • data dictionary tables
• catalog.sql, SQL script in admin directory
• catching routine, example
• catparr.sql, Parallel Server SQL script in admin directory
• catproc.sql, SQL script in admin directory
• CDE tools
• CDS Native Naming Adapter
  • connecting to Oracle servers
  • service names
  • tnsnames.ora file
• changing databases
• chmod command, example
• Client Status Monitor
• command interpreter
• commands
  • iostat
  • sar
  • vmstat
• common environment, setting
• community_name parameter
  • Oracle DECnet Protocol Adapter specification
  • Oracle SPX/IPX Protocol Adapter specification
• CONNECT INTERNAL, security
• connection manager, interchange
• control remote DBA access
  • REMOTE_DBA_OPS_ALLOWED
  • REMOTE_DBA_OPS_DENIED
• control remote login
  • OPS_DOLLAR_LOGIN_DENIED
• conventions used
• COPY command, SQL*Plus
• coraenv
• customizing, installation

  D

• daemon user, security
• database
  • adminstrator
  • backup strategy
  • buffers
    • using
  • files
    • security
  • hardware
  • locking
  • planning
  • planning tools
  • recovery
  • requirements
  • tuning tools
  • utilities
• DBA group ID
  • keywords
  • non-default name
• dba group
  • members
  • relinking
• DBA_GROUP, /etc/listener.ora file
• DBA_GROUP_sid, /etc/listener.ora file
• dbms.sql, database packages in product subdirectory
• dbs, ORACLE_HOME directory structure
• de-fragmentation
• DECnet protocol adapter
  • ADDRESS keyword
  • ADDRESS keyword for connect descriptor
  • sample ADDRESS
• default printer
• default, directory [2]
  • linker option
  • printer
• demo demonstration scripts and datafiles, Oracle product subdirectory
• demonstration
  • examp9
  • precompiler
• demonstrations, SQL*Plus
• demonstration, the procedural option, PL/SQL
• determining SGA size
• directory structure, Oracle Server
• disk activity, monitoring, iostat utility
• disk request queues
• DISPLAY, environment variable
• dntpa, Oracle product subdirectory
• doc, readme files in product subdirectory

  E

• echo command
• environment variable
  • how to:
    • export
    • set
• environment variables
  • ADA_PATH
  • DISPLAY
  • HOME
  • LANG
  • LANGUAGE
  • LD_LIBRARY_PATH
  • LDOPTS
  • LDPATH
  • LPDEST
  • NLS_LANG
  • ORA_NLS
  • ORACLE_HELP
  • ORACLE_HOME
  • ORACLE_LPSTAT
  • ORACLE_PAGER
  • ORACLE_SID
  • ORACLE_TERM [2]
  • ORACLE_TERMINAL
  • ORACLE_TRACE
  • ORAENV_ASK
  • PATH
  • PRINTER
  • SDD_BIN
  • SHELL
  • SQLPATH
  • TERM
  • TMPDIR
  • TNS_ADMIN [2]
  • TWO_TASK
  • TZ
  • XENVIRONMENT
• estimating SGA size
• examp9.pc, executable
• examp9, demonstration
• exclamation point, SQL*Plus prompt
• executable program
• executable, examp9.pc

  F

• file names, default extensions in SQL*Plus
• file naming conventions, in admin directory
• filename extensions, in ORACLE_HOME directory
• files, trace files
• FORMAT option
  • Pro*COBOL
  • Pro*FORTRAN
• fragmentation, tablespaces

  G

• generic listener
• groups, sample script
• guicommon, Oracle product subdirectory

  H

• help file
• HOME
• home directory

  I

• init.ora file, sample
• init.ora parameter
  • background_dump_dest
  • db_block_buffers
  • db_block_size
  • log_buffer
  • os_authent_prefix
  • remote_os_authent
  • remote_os_roles
• init.ora parameters, alert file
• init.ora parameter
  • shared_pool_size
  • sort_area_size
• initialization parameter, remote_os_authent
• input and output
• install, installation scripts in product subdirectory
• instance startup, alert file
• interchange
  • connection manager
  • connection manager process name
  • data pump process name
  • definition
  • navigator description
  • navigator process name
  • trace and log configuration files
• iostat utility
  • sample

  J

  K

• kernel
  • identifying problems
  • parameters
• keywords, DBA group ID

  L

• language
  • environment variable
• ld
• LD_LIBRARY_PATH, environment variable
• LDOPTS, environment variable
• LDPATH, environment variable
• lib
  • libraries and makefiles in product subdirectory
  • ORACLE_HOME directory structure
• libraries, in Oracle product subdirectory
• library cache, allocating space
• listener log files
• listener.log file
• listener_alias
  • listener process
  • UNIX name for TNS listener
• lock contention
• log files, destination direction
• log output files
  • Interchange Connection Manager
  • Interchange Navigator
  • SQL*Net V2 clients and servers
  • SQL*Net V2 listener
• log_archive_start, set to true
• log_buffer, estimating SGA size
• Logical Volume Manager, using
• login home directories
  • administering
  • sample script
• login.sql setup file
• log, trace and log files in product subdirectory
• LPDEST, environment variable
• lu62pa, Oracle product subdirectory
• LVM

  M

• makefiles, in Oracle product subdirectory
• mesg, files in product subdirectory
• messages, displaying online
• mirror resilvering
• mount points, naming
• Multi-Threaded Server
• Multilingual Option, message text and binary files
• multiple DBWRs, using list I/O
• multiple signal handlers

  N

• naming conventions
• National Language Support
• National Language Support (NLS)
  • option
  • variable
• native naming adapters
• Navigator
  • control program
  • process name
• Network Manager, on Microsoft Windows
• network passwords
• network security
• network
  • dba privileges
  • Oracle product subdirectory
• NIS Native Naming adapter
  • configuring servers
  • tnsnames map
• NLS
• NLS_LANG, environment variable
• nodes, and Oracle DECnet Protocol Adapter

  O

• object_id parameter, Oracle DECnet Protocol Adapter specification [2] [3]
• ocommon, Oracle product subdirectory
• oerr
  • messages
  • sample facility codes
  • syntax
  • utility
• OFA
• operating system authorized login, SQL*Net Version 2
• Optimal Flexible Architecture
  • file mapping
  • list of rules [2]
  • mount points
  • naming conventions
  • naming tablespaces
  • planning
  • requirements
  • segments
• ORA_NLS, environment variable
• oracle account, set authorization
• Oracle APPC/LU6.2 Protocol Adapter, using
• Oracle DECnet Protocol Adapter, nodes
• Oracle Enterprise Backup Utility
  • initsid.ora parameters
  • starting redo log archiving
• Oracle environment variables
  • ORACLE_BASE
  • ORACLE_HELP
  • ORACLE_HOME
  • ORACLE_LPSTAT
  • ORACLE_PAGER
  • ORACLE_PATH
  • ORACLE_SID
  • ORACLE_TERM
  • ORACLE_TERMINAL
  • ORACLE_TRACE
• oracle group
  • group
• Oracle product subdirectory
  • admin script in
  • admin/* special directory
  • admin/resource resource files
  • admin/terminal runtime files
  • contents of
    • proc
    • rdbms
    • sqlplus
    • tcp
  • demo demonstration scripts and datafiles
  • dntpa
  • guicommon
  • install script in
  • libraries and makefiles
  • lu62pa
  • mesg files in
  • network
  • ocommon
  • plsql
  • proada
  • procob
  • profor
  • propas
  • pso
  • readme files
  • spxpa
  • sqlplus
  • tcppa
  • tk2
  • trace and log files
• Oracle Protocol Adapter, MTS configuration, IPC example
• Oracle Server
  • accounts
  • directory structure
  • product subdirectories
  • roles
  • roles and /etc/group file
• oracle software owner
  • special accounts
• Oracle System Identifier
• Oracle Worldwide Technical Support
  • Europe, customer support
  • USA, customer support
• Oracle*XA, restrictions
• ORACLE_BASE directory
• ORACLE_HELP, environment variable
• ORACLE_HOME directory
• ORACLE_HOME
  • environment variable
  • using ? for
• ORACLE_SID
  • environment variable
  • suppressing prompt
• ORACLE_TERM, environment variable
• oraenv file
  • description
  • moving between databases
• ORAENV_ASK
  • setting
• orainst
  • ORACLE_HOME directory structure
• orapwd utility
  • description
  • running
• OS_password parameter, Oracle DECnet Protocol Adapter specification
• OS_username parameter, Oracle DECnet Protocol Adapter specification

  P

• paging
• parallel
  • query
  • server
    • planning
    • tuning contention
• PATH
• PATH variable
• performance bottlenecks
  • CPU
  • I/O
  • memory
• permissions
  • dba group
  • granting
• PL/SQL, demonstrations, loading
• planning
  • database
  • hardware
  • OFA database structure
• plsql, Oracle product subdirectory
• precompiler, running demonstration
• precompilers
  • building demonstrations
  • linking problems
  • overview
  • signals
  • values
• PRINTER
• printer queue
• Pro*Ada
  • building programs
  • sample program
  • using
• Pro*C signals
• Pro*C, building programs
• Pro*COBOL
  • administration
  • building programs
  • FORMAT option
  • sample program
  • using
• Pro*C
  • sample program
  • using
• Pro*FORTRAN
  • building programs
  • FORMAT option
  • sample program
  • using
• Pro*Pascal
  • building programs
  • sample program
  • using
• proada, Oracle product subdirectory
• proc, contents of, Oracle product subdirectory
• Process Global Area dump
• procob, Oracle product subdirectory
• product subdirectories
• profor, Oracle product subdirectory
• propas, Oracle product subdirectory
• protocol parameter
  • Oracle DECnet Protocol Adapter specification
  • SPX/IPX Protocol Adapter specification
• pso, Oracle product subdirectory
• pstat utility

  Q

• question mark, example of use

  R

• raw devices
  • advantages
  • disadvantages
  • setting up
• raw partitions
• raw redo logs
• rdbms, contents of, Oracle product subdirectory
• rdbms/admin
• rdbms, ORACLE_HOME directory structure
• redo buffers, optimizing
• redo log
  • archiving
  • buffer latch
  • own disk device
  • raw devices
  • stopping archive
• remote
  • connect
    • as OPERATOR
  • login
  • parameter
    • REMOTE_OS_AUTHENT [2]
• requirements, database, planning
• resilvering, mirror
• resource definition
• roles, mapping to groups
• rollback
  • segment
  • segments
• root group, oracle software owner
• root, user

  S

• sar command
• script
  • admin
  • product installation
• SDD_BIN, environment variable
• security
  • assigning permissions
  • CONNECT INTERNAL
  • default group names
  • file ownership
  • group accounts
  • network dba privileges
  • remote connection
  • Server Manager access
  • SHUTDOWN command
  • STARTUP command
  • two-task architecture
• segments, temporary
• Server Manager
  • commands
  • security
• session cache cursors, optimizing
• setuid root, for tnslsnr
• SGA, estimating size
• shadow process
  • security
  • spawned by tnslsnr
  • syntax
• shared libraries
  • creating executables
  • generating
  • LD_LIBRARY_PATH environment variable
  • LD_RUN_PATH environment variable
  • Oracle static libraries
  • Pro C and XA clients
  • support
• shared object library
• shared_pool_size, estimating SGA size
• shared
  • library loader
  • memory
  • object library
  • object
  • pool size
• SHELL
• shell script, pupbld
• SHUTDOWN command
  • security
• signal
  • handlers
  • routine
• single-task architecture
• software distribution
• special accounts
• special groups
  • root
• SPOOL command, SQL*Plus
• SPX/IPC protocol adapter, ADDRESS
• SPX/IPX protocol adapter [2]
  • ADDRESS keyword for connect descriptor
  • commands
  • MTS configuration
  • ntspxctl utility
  • parameters
  • sample ADDRESS
  • service parameters
  • using
• spxpa, Oracle product subdirectory
• SQL scripts in admin directory
  • cat*.sql
  • catalog.sql
  • catparr.sql
  • catproc.sql
  • dbms.sql
  • utl.sql
• SQL*DBA
• SQL*Module
  • compiling
  • linking
• SQL*Net V1
• SQL*Net V2 [2]
• SQL*Net V2 DECnet Protocol Adapter, ADDRESS
• SQL*Net V2 SPX/IPX Protocol Adapter, summary of help commands
• SQL*Net V2
  • /etc/oratab file
  • adapters utility
  • APPC/LU6.2 Protocol Adapter overview
  • CDS Native Naming Adapter
  • configuration files
  • configuration tasks
  • DECnet Protocol Adapter [2]
  • default directory
  • installing in network environment
  • listener [2]
  • listener control program
  • MTS configuration, IPC example [2]
  • Multi-Threaded Server
  • Names Server
  • NIS Native Naming adapter
  • operating system software
  • starting the listener process
  • trace output files
  • using APPC/LU6.2 Protocol Adapter
• SQL*Net Version 2, operating system authorized login
• SQL*Plus setup files
  • glogin.sql
  • login.sql
• SQL*Plus
  • COPY command
  • default editor
  • installing help tables manually
  • installing the demos
  • interrupting
  • running demonstrations
  • sample setup files
  • UNIX commands
• sqlnet.log file
• sqlplus, contents of, Oracle product subdirectory
• sqlplus, Oracle product subdirectory
• STARTUP command, security
• startup files, in oraenv
• static libraries
• storage parameters
• stripe size
• sub-shell, creating in SQL*Plus
• superuser
• swap space, allocation
• swap utility
• SYS account, description
• SYSDATE, and TZ
• SYSTEM account
  • database maintenance
  • description
  • monitoring databases
• System Global Area dump
• system time, setting
• System V

  T

• tcp, contents of, Oracle product subdirectory
• TCP/IP protocol adapter
  • ADDRESS
  • configuring the listener
  • connect descriptor
  • hostname parameter
  • listener.ora file
  • nodes
  • overview
  • parameters
  • port_number parameter
  • protocol parameters
  • sample ADDRESS
  • using
• tcppa, Oracle product subdirectory
• temporary disk file
• temporary segments
  • initializing
• TERM variable
• TERM, environment variable
• thread safety
• time zone, setting with TZ
• tk2, Oracle product subdirectory
• TMPDIR
• TNS listener
  • configuring for Oracle TCP/IP Protocol Adapter
  • control program
  • default process name
  • description
  • names of spawned shadow processes
• TNS_ADMIN, environment variable
• Toolkit II resource file
• trace file
  • contents
  • initialization parameter
    • CORE_DUMP_DEST
    • USER_DUMP_DEST
  • Oracle Server detached process
  • types
  • user process
• trace output files
  • Interchange Connection Manager
  • Interchange Navigator
  • Interchange pump
  • SQL*Net V2 listener
  • sqlnet.trc
• tracing Bourne shell scripts
• tuning
  • application design
  • asynchronous I/O
  • avoiding index contention
  • balancing CPU loads
  • client/server configuration
  • CPU percentages
  • Distributed Lock Manager
  • distributing hot files
  • I/O bottlenecks
  • identifying contention
  • isolating contention
  • kernal parameters
  • localizing disk I/O
  • multi-processor systems
  • multiple DBWRs
  • Oracle resources
  • parallel server
  • post-wait driver
  • raw partitions
  • redistribute applications
  • reducing contention
  • spin count
  • usage patterns
• two-task signal
  • SIGCLD
  • SIGCONT
  • SIGINT
  • SIGIO
  • SIGPIPE
  • SIGTERM
  • SIGURG
• two-task
  • architecture
  • communication
• TWO_TASK, environment variable
• TZ
  • and SYSDATE
  • environment variable

  U

• UNIX pager
• UNIX
  • running commands from SQL*Plus
  • security
• user interrupt handler
• users, sample script
• utility
  • oerr
  • orapwd
• utl.sql, tables and views for database utilities

  V

• vmstat utility, sample
• vmstat, command
• volume, tape archiving

  W

  X

• X Windows
• X Windows system
• XENVIRONMENT, environment variable

  Y

  Z