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
Numerics
- 64-bit feature, B-1
A
- account
- creating the oracle account, 3-17
- account privileges
- setting, 3-8
- account quotas
- minimum values, 3-9
- ADA, version, 1-12
- Administrator
- disk space requirements, 1-10
- response file, 1-19
- administrators
- , 5-12
- authentication methods
- Kerberos, 1-15
- Secure Socket Layer, 1-15
- AUTHORIZE utility, 3-5, 3-6
- AUTOGEN, 3-15
- AUTOGEN utility, 3-15
- automating startup and shutdown, 5-13
B
- Big Oracle Blocks, B-3
- BOB, B-3
C
- CATNSNMP.SQL file, capabilities, 5-20
- changes and enhancements, 2-2
- character mode
- issues and restrictions, 3-2
- clientadmin.rsp file, 1-19
- clientcustom.rsp file, 1-19
- clientprogmr.rsp file, 1-19
- commands
- lsnrctl, 3-20
- runInstaller
- starting, 4-3, 4-6
- umask, 3-18
- compatibility issues, 1-13
- configuration
- restrictions, 1-15
- control files
- CONTROL01.CTL, 5-26
- CONTROL02.CTL, 5-26
- CONTROL03.CTL, 5-26
- CTXSYS user name
- database roles, 5-20
- described, 5-20
- password, 5-20
D
- data dictionary, described, 5-26
- data files
- defined, 5-23
- DR01.DBF, 5-23
- INDX01.DBF, 5-23
- SYSTEM01.DBF, 5-24
- TEMP01.DBF, 5-24
- TOOLS01.DBF, 5-24
- USERS01.DBF, 5-24
- database
- creation methods
- selecting, 1-5
- data dictionary
- defined, 5-26
- data files, 5-23
- database passwords, 5-19
- database user names, 5-19
- initialization parameter file, 5-25
- redo log files, 5-25
- rollback segments, 5-26
- tablespaces, 5-23
- tablespaces and, 5-23
- database environments
- and Oracle Database Configuration Assistant, 1-6
- general purpose, 1-4
- database roles
- of CTXSYS user name, 5-20
- of DBSNMP user name, 5-20
- of MDSYS user name, 5-20
- of ORDPLUGINS user name, 5-20
- of ORDSYS user name, 5-20
- of OUTLN user name, 5-20
- of SCOTT user name, 5-21
- of SYS user name, 5-21
- of SYSTEM user name, 5-21
- DB_BLOCK_BUFFERS, B-4
- DB_DOMAIN parameter, 5-22
- DB_NAME parameter, 5-22
- DBAs
- See administrators
- dbca.rsp file, 1-19
- DBSNMP user name
- database roles, 5-20
- described, 5-20
- dropping with CATNSNMP.SQL file, 5-20
- password, 5-20
- DCL command, to check disk format, 2-4
- DEC
- compilers, 1-12
- DEC ADA 3.4.2, 1-12
- default control files
- CONTROL01.CTL, 5-26
- CONTROL02.CTL, 5-26
- CONTROL03.CTL, 5-26
- default data files
- DR01.DBF, 5-23
- INDX01.DBF, 5-23
- SYSTEM01.DBF, 5-24
- TEMP01.DBF, 5-24
- TOOLS.DBF, 5-24
- USERS01.DBF, 5-24
- default initialization parameter file
- init.ora, 5-25
- default redo log files
- REDO01.LOG, 5-25
- REDO02.LOG, 5-25
- REDO03.LOG, 5-25
- default tablespaces
- DRSYS, 5-23
- INDX, 5-23
- SYSTEM, 5-24
- TEMP, 5-24
- TOOLS, 5-24
- USERS, 5-24
- dependencies, product, 1-13
- documentation
- related, xiv
- DR01.DBF
- data file, 5-23
- tablespace contained in, 5-23
- DRSYS tablespace, described, 5-23
- DSS, B-2
E
- enterprise.rsp files, 1-19
- environment
- requirements, 3-19
F
- file systems
- requirements, 3-3
- files
- installActions.log, 4-8
- Oracle Universal Installer log files, 4-8
- oraInst.loc, 3-2
- permissions for creation, 3-16
- response files, 4-11
- setting permissions for creation, 3-18
- supported file systems, 3-3
G
- general purpose database. See database environments, 1-4
- GENPARAMS parameter, 3-15
- global database name
- defined, 5-22
- groups
- OSDBA and OSOPER, 5-12
H
- hardware
- memory, 1-8
- requirements, 1-8
- home directory, 3-17
I
- identifiers, process rights, 3-10
- images
- described, 1-10
- removing, 5-29
- INDX tablespace, described, 5-23
- INDX01.DBF
- data file, 5-23
- tablespace contained in, 5-23
- initialization parameter file
- description, 5-25
- in database, 5-25
- init.ora, 5-25
- initialization parameters
- desupported, 2-5
- obsolescent, 2-5
- Initialize command, formatting a new disk to ODS-5, 2-4
- installActions.log file, 4-8
- installation
- aborted, 4-11
- character mode, 3-2
- cleaning up, 4-11
- non-interactive, 3-2, 4-11
- described, 4-11
- response files, 4-11
- oracle software owner, 3-16
- post-installation tasks, 5-1
- pre-installation tasks, 3-1
- requirements
- environment, 3-19
- Optimal Flexible Architecture, 3-3
- installation types
- with Oracle9i, A-2
- with Oracle9i Client, A-8
- with Oracle9i Enterprise Edition, A-2
- with Oracle9i server, A-2
- installing
- procedure requirements, 3-4
- instances
- account required to start, 3-12
- interMedia
- requirements, 1-14
- SYSTEM tablespace, 5-15
- interMedia Text
- data dictionary space requirements, 1-14, 5-15
- issues and restrictions, port-specific, 3-2
J
- Java Runtime Environment
- modifying, cautions about, 3-20
- requirements, 1-14, 3-2
- requirements for, 3-20
- JRE. See Java Runtime Environment
K
- Kerberos authentication
- requirements, 1-15
L
- linking Oracle Net, 1-16
- LRS
- See Log roll-forward server (LRS), B-1
- lsnrctl command, 3-20
M
- MAXSYSGROUP, 3-6
- MDSYS user name
- database roles, 5-20
- password, 5-20
- migrating existing Oracle databases, 1-7
- migration
- Oracle Data Migration Assistant, 3-3
- modifying system parameters, 3-13
- MRU, B-4
- multiple databases, 3-12
- multiple Oracle homes
- system identifier, 5-23
N
- Net8 Configuration Assistant, 5-14
- non-interactive installation, 3-2
- noninteractive installation. See installation, non-interactive
O
- OEM_MONITOR, 5-22
- OEMAGENT
- process rights, 3-12
- OLTP. See transaction processing
- OLTP transactions, B-2
- OpenVMS
- system parameters, 3-13
- operating system
- configuration, 3-16
- requirements, 1-11
- Optimal Flexible Architecture
- installation issues and restrictions, 3-3
- Oracle
- Server DBA account, 3-5
- tools, adding or upgrading, 5-27
- oracle account
- home directory, 3-17
- how to create
- how to create, 3-17
- post-installation tasks, 5-13
- pre-installation tasks, 3-18
- requirements, 3-17
- Oracle Advanced Security
- Oracle Wallet Manager, 1-15
- requirements, 1-15
- Wallet Manager, defined, A-22
- Oracle Application Server Listener. See Oracle HTTP Server
- Oracle Data Migration Assistant, 3-3
- and Oracle7, 3-3
- Oracle Database Configuration Assistant
- and Oracle interMedia, 1-6
- database creation methods
- selecting, 1-5
- database environments configured by, 1-5, 1-6
- response file, 1-19
- Oracle Enterprise Manager Quick Tours
- defined, A-15
- Oracle HTTP Server
- defined, A-15
- Oracle Integration Server
- defined, A-16
- Oracle Intelligent Agent
- defined, A-16
- Oracle interMedia
- Locator
- described, A-17
- Oracle interMedia Image
- defined, A-16
- Oracle inventory
- JRE locations, 3-2
- log files, 4-8
- Oracle Java Database. See Oracle JDBC Drivers
- Oracle Java Tools
- defined, A-17
- Oracle JDBC Drivers
- defined, A-17
- Oracle Locale Builder
- defined, A-17
- Oracle Locator
- described, A-17
- Oracle Management Server
- defined, A-17
- Oracle Names
- defined, A-18
- Oracle Net
- and Oracle Advanced Security, 1-15
- defined, A-18
- linking options, 1-16
- Oracle Protocol Support
- installation types available with, A-4, A-6
- pre-installation tasks
- shutting down listeners, 3-20
- Oracle Net Server
- defined, A-18
- Oracle Options
- requirements, 1-14
- Oracle Parallel Server
- re-installing, 4-11
- Oracle Partitioning
- defined, A-19
- Oracle PL/SQL Gateway
- defined, A-19
- Oracle Precompilers
- post-installation tasks, 5-16
- Oracle Real Application Clusters
- defined, A-19
- Oracle Real Application Clusters Guard
- defined, A-20
- Oracle Server
- automating startup and shutdown, 5-13
- oracle software owner
- See oracle account
- Oracle Spatial
- defined, A-20
- Oracle Spatial Data Cartridge. See Oracle Spatial
- Oracle Spatial Index Advisor, defined, A-20
- Oracle Text
- defined, A-21
- Oracle Text Manager
- defined, A-21
- Oracle Transparent Gateway
- Informix
- hardware requirements for, C-3
- Ingres
- installation prompts for, C-9
- installation prompts for, C-8
- installation worksheets for, C-6
- RDB
- installation worksheet for, C-7
- rdb
- installation prompts for, C-9
- removing, C-9
- rms
- installation worksheet for, C-7
- Oracle Universal Installer
- and migrating data, 1-7
- and upgrading software, 1-7
- database creation methods, 1-5
- defined, A-21
- inventory, 3-2, 4-8
- log files, 4-8
- response files
- list of, 1-19
- Oracle Utilities
- defined, A-22
- Oracle Visual Information Retrieval
- requirements, 1-14
- Oracle Wallet Manager
- and Secure Socket Layer, 1-15
- defined, A-22
- Oracle XML Developer's Kit
- defined, A-22
- ORACLE_HOME logical
- oracle account home directory, 3-17
- requirements, 3-2
- Oracle7
- migration, 3-3
- Oracle8
- creating account, 3-6
- MAXSYSGROUP requirement, 3-6
- quotas required, 3-9
- relinking, 5-29
- setting system parameters, 3-15
- Oracle9i
- 64-bit feature, B-1
- Oracle9i Client
- disk space requirements, 1-10
- memory requirements, 1-8
- response file, 1-19
- Oracle9i Client top-level component, installation types available with, A-8
- Oracle9i Enterprise Edition
- disk space requirements, 1-10
- Oracle9i Enterprise Edition top-level component
- installation types available with, A-2
- Oracle9i JVM
- enterprise edition defined, A-23
- requirements, 1-14
- Oracle9i Server
- defined, A-23
- Oracle9i, installation types available with, A-2
- oraInst.loc file, 3-2
- oraInventory directory, 4-8
- ORDPLUGIN user name
- database roles, 5-20
- ORDPLUGINS, user name and password, 5-20
- ORDSYS
- database roles, 5-20
- user name and password, 5-20
- OSDBA and OSOPER groups, 5-12
- OUTLN user name
- database roles of, 5-20
- described, 5-20
- password of, 5-20
P
- parameters
- GENPARAMS, 3-15
- initialization, 5-13
- init.ora file, 5-13
- SAVPARAMS, 3-15
- SYSGEN, 3-13
- passwords
- changing, 5-12
- for CTXSYS user name, 5-20
- for DBSNMP user name, 5-20
- for MDSYS user name, 5-20
- for ORDPLUGINS user name, 5-20
- for ORDSYS user name, 5-20
- for OUTLN user name, 5-20
- for SCOTT user name, 5-21
- for SYS user name, 5-21
- for SYSTEM user name, 5-21
- performance, B-2
- permissions
- file creation, 3-16
- setting with umask, 3-18
- PGA, B-3
- post-installation tasks
- Oracle Precompilers, 5-16
- product-specific, 5-14
- Secure Socket Layer, 5-17
- Shared Server, 5-15
- precompilers
- requirements, 1-14
- pre-installation tasks
- as the System user, 3-16
- Oracle Net, 3-20
- shutting down listeners, 3-20
- Pro*C, 1-12
- Pro*C/C++
- described, A-23
- requirements, 1-14
- Pro*COBOL, 1-12
- described, A-24
- requirements, 1-14
- Pro*FORTRAN, 1-12
- described, A-24
- requirements, 1-14
- process rights identifier, 3-10
- product dependencies, 1-13
- Program Global Area, B-3
- programmatic interfaces, 1-12
- Programmer
- disk space requirements, 1-10
- response file, 1-19
- protocol support
- post-installation tasks, 5-17
- Secure Socket Layer, 5-17
- TCP/IP, defined, A-25
Q
- query-intensive transactions, B-2
- quotas
- account, 3-9
R
- redo log files
- in starter database, 5-25
- REDO01.LOG, 5-25
- REDO02.LOG, 5-25
- REDO03.LOG, 5-25
- related documentation, xiv
- relinking
- Oracle code, 5-29
- Oracle products, 5-29
- requirements
- CD-ROM, 1-9
- file permissions, 3-16
- file systems, 3-3
- hardware, 1-8
- interMedia, 1-14
- Java Runtime Environment, 1-14, 3-2, 3-20
- Kerberos authentication, 1-15
- memory, 1-8
- operating system, 1-11
- oracle account, 3-17
- Oracle Advanced Security, 1-15
- Oracle Options, 1-14
- Oracle Visual Information Retrieval, 1-14
- ORACLE_HOME, 3-2
- Oracle9i JVM, 1-14
- precompilers, 1-14
- Pro*C/C++, 1-14
- Pro*COBOL, 1-14
- Pro*FORTRAN, 1-14
- Secure Socket Layer, 1-15
- swap space, 1-9
- system configuration, 3-16
- system installation, 1-8
- tools, 1-14
- window manager, 1-11
- Reserved Memory Registry, 3-13
- response files
- clientadmin.rsp, 1-19
- clientcustom.rsp, 1-19
- clientprogmr.rsp, 1-19
- custom.rsp, 1-19
- dbca.rsp, 1-19
- enterprise.rsp, 1-19
- standard.rsp, 1-19
- restrictions, configuration, 1-15
- Roles
- OEM_MONITOR, 5-22
- roles
- of CTXSYS user name, 5-20
- of DBSNMP user name, 5-20
- of MDSYS user name, 5-20
- of ORDPLUGINS user name, 5-20
- of ORDSYS user name, 5-20
- of OUTLN user name, 5-20
- of SCOTT user name, 5-21
- of SYS user name, 5-21
- of SYSTEM user name, 5-21
- rollback segments, starter database, 5-26
- root user
- post-installation tasks, 5-12
- runInstaller, command, 4-3, 4-6
S
- SAVPARAMS parameter, 3-15
- scalability, B-2
- SCOTT user name
- database roles, 5-21
- described, 5-21
- password, 5-21
- Secure Socket Layer
- post-installation tasks, 5-17
- requirements, 1-15
- security issues, 3-12
- See AlsoApache
- seed database. See database environments, 1-5
- SERVICE_NAMES parameter, 5-22
- Set Volume command, changing a disk to ODS-5, 2-4
- setting
- account
- quotas, 3-9
- account privileges, 3-8
- SGA
- protection, 3-11
- shared
- CORE, 1-10
- images, 1-10
- UPISHR, 1-10
- Shared Server
- post-installation tasks, 5-15
- shutdown and startup, 5-13
- silent install. See installation, non-interactive
- SQL*Module, 1-12
- SQL*Module Ada
- described, A-24
- SQL*Plus
- described, A-25
- SQL*Plus Worksheet
- described, A-25
- SQLJ
- described, A-21
- SQLJ Runtime
- described, A-21
- standard.rsp files, 1-19
- starting instances, 3-12
- startup and shutdown, 5-13
- svrcustom.rsp file, 1-19
- SYS account, 3-6
- SYS user name
- database roles of, 5-21
- described, 5-21
- password of, 5-21
- SYSGEN parameters, 3-13
- SYSMAN, 3-13
- SYSTEM
- account, 3-6
- system
- parameters, 3-13
- summary of requirements, 3-16
- System Global Area
- init.ora file, 5-13
- system identifier
- multiple Oracle homes, 5-23
- system requirements, 1-8
- SYSTEM tablespace
- description, 5-24
- interMedia Option database objects, 5-15
- System user
- pre-installation tasks, 3-16
- SYSTEM user name
- database roles of, 5-21
- described, 5-21
- password of, 5-21
- SYSTEM01.DBF
- data file, 5-24
- tablespace contained in, 5-24
T
- tablespaces
- containing DR01.DBF, 5-23
- containing INDX01.DBF, 5-23
- containing SYSTEM01.DBF, 5-24
- containing TEMP01.DBF, 5-24
- containing TOOLS.DBF, 5-24
- containing USERS01.DBF, 5-24
- defined, 5-23
- DRSYS, 5-23
- expanding for large sorts, 5-24
- in database, 5-23
- INDX, 5-23
- SYSTEM, 5-24
- TEMP, 5-24
- TOOLS, 5-24
- USERS, 5-24
- TCP/IP protocol support
- and Secure Socket Layer, 1-15
- defined, A-25
- TEMP tablespace, described, 5-24
- TEMP01.DBF
- data file, 5-24
- tablespace contained in, 5-24
- TOOLS tablespace, described, 5-24
- tools, adding or upgrading, 5-27
- tools, requirements, 1-14
- TOOLS01.DBF, data file, 5-24
- TOOLS.DBF, tablespace contained in, 5-24
- transaction processing. See database environments database environments
- transaction processing database
- troubleshooting
- oraInventory log files, 4-8
U
- UAF, 3-5
- UIC GROUP number, 3-6
- umask command
- setting, 3-18
- uname command, 1-11
- upgrading, 3-3
- Oracle products, 5-27
- to Oracle8 from Oracle7, 1-13
- upgrading existing Oracle databases, 1-7
- user and group numbers, 3-5
- user names
- CTXSYS, 5-20
- DBSNMP, 5-20
- MDSYS, 5-20
- ORDPLUGINS, 5-20
- ORDSYS, 5-20
- OUTLN, 5-20
- SCOTT, 5-21
- SYS, 5-21
- SYSTEM, 5-21
- USERS tablespace, described, 5-24
- USERS01.DBF
- data file, 5-24
- tablespace contained in, 5-24
V
- Very Large Memory, B-1
- VLM, reserving memory, 3-13
- VMS mailbox driver, 1-12
W
- window manager
- requirements, 1-11
X
- XML
- Development Kit, A-25
- Oracle XML Developer's Kit, A-22
- X-windows
- configuring, 1-11