Skip Headers
Oracle® Database Installation Guide
10g Release 2 (10.2) for Linux x86

Part Number B15660-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

Index

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

A

Access Manager for AS/400, G.4
accounts
reviewing, 5.4
unauthenticated access to, 5.5.2
Advantage family of databases, G.4
aliases, multiple on computers, 2.4.4
ANONYMOUS user
unauthenticated account access with, 5.5.2
APPC-enabled databases, G.4
APPC-enabled systems, G.4
applications, migrating non-Oracle applications to Oracle, G.3
applications-based workflows, G.3
architecture
checking system architecture, 2.2
AS/400 applications, accessing Oracle database, G.4
ASM See Automatic Storage Management
asmcmd utility, 3.5.4
ASMLib add-on support library, 3.5.1
Automatic Storage Management
asmcmd utility, 3.5.4
ASMLib add-on support library, 3.5.1
Automatic Storage Management disk group templates, 1.5.1.2
block device names, 2.11.5.1, 2.11.5.2
block devices, 3.5.1
changing owner and permissions of raw devices, 2.11.5.2, 2.11.5.2, 2.12.4
characteristics of failure groups, 2.11.2
checking disk availability, 2.11.5.1, 2.11.5.2, 2.12.3
configuring disks, 2.11.1, 2.11.3
configuring disks for Automatic Storage Management, 2.11.5
considerations before installing, 3.5.1
DAS disks, 2.11.4
database creation for, 3.5.3
disk devices, 1.5.1.2
disk groups, 2.11.2
disks, supported, 2.11.4
displaying attached disks, 2.11.5.1, 2.11.5.2, 2.12.3
Enterprise Manager Migrate Database wizard, 3.5.2
failure groups
examples, 2.11.2, 2.11.2
identifying, 2.11.2
identifying available disks, 2.11.5.1, 2.11.5.2
identifying disks, 2.11.5.1, 2.11.5.2, 2.12.3
installation, testing, 3.5.4
installing, 3.5
managing, 5.3.2
migrating existing databases to, 3.5.2
mirroring, 2.11.2
Optimal Flexible Architecture file naming conventions, C.3.3
Oracle Clusterware, 1.5.1.2
Oracle home location for new installation, 3.5.1
partition creation, 2.11.4
password file, 3.5.1
recommendations for disk groups, 2.11.2
redundancy levels, 2.11.2
removing, 6.4
running multiple databases on a single server, 3.5.1
SAN disks, 2.11.4
space required for preconfigured database, 2.11.2
SPFILE server parameter file, 3.5.1
starting and stopping, 5.3.1
storage option for data files, 2.9
templates, 1.5.1.2
upgrade advantages with separate Oracle homes, 3.5.1
Automatic Storage Management disk groups
about, 1.5.1.2
creating, 3.5.2
managing, 5.3.2
Automatic Storage Management failure groups
about, 1.5.1.2
Automatic Storage Management instance
about, 1.5.1.2
creating, 3.5.2

B

backups of database
Oracle Database Recovery Manager, G.2
base directory
See Oracle base directory
Bash shell
default user startup file, 2.14
.bash_profile file, 2.14
Basic installation type
noninteractive installations, A.3.2
block device
device name, 2.11.5.1, 2.11.5.2
block device discovery on Automatic Storage Management, 3.5.1
Bourne shell
default user startup file, 2.14

C

C shell
default user startup file, 2.14
certification, hardware and software, 1.6.1
Character Set Scanner, 1.7.1
checking distribution of the operating system, 2.3
checking version of the operating system, 2.3
chmod command, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4
chown command, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4
CLASSPATH environment variable, 4.3.5.3
Cluster Ready Services (CRS). See Oracle Clusterware
Cluster Synchronization Services (CSS)
Automatic Storage Management, 1.5.1.2
clusters
installation guidelines, 3.2
See also Oracle Clusterware, Oracle Real Application Clusters
Clusterware
installed before Oracle Database, 3.2
Clusterware. See Oracle Clusterware
compilers
GNU Compiler Collection (GCC), 4.3.8
primary, 4.3.8
computers with multiple aliases, 2.4.4
computers, non-networked, 2.4.5
configuration assistants
failure, F.5.1
troubleshooting, F.5, F.5
configuring
kernel parameters, 2.6
configuring disks for Automatic Storage Management, 2.11.1, 2.11.3
Connection Manager
ports, ranges and protocol, D.3
connectivity tools
Oracle Procedural Gateway, G.4
Oracle Transparent Gateway, G.4
See also databases, non-Oracle
control files
locating, 5.8.3
naming, C.3.3
raw devices for, 2.12.2
reviewing, 5.8
using Oracle Enterprise Manager Database Control with, 5.8.3
CONTROL_FILES initialization parameter, 5.8.3
CSD
download location for WebSphere MQ, 2.3
csscan utility
See Character Set Scanner
custom database
failure groups for Automatic Storage Management, 2.11.2
requirements when using Automatic Storage Management, 2.11.2, 2.11.2
Custom installation type
reasons for choosing, 2.5
custom.rsp file, A.3.1

D

DAS (direct attached storage) disks, 2.11.4
data files
creating separate directories for, 2.10.3
defined, 5.8.1
managing with Automatic Storage Management, 1.5.1.2
minimum disk space for, 2.10.1
naming, C.3.3
options for placing on file system, 2.10
recommendations for file system, 2.10.1
reviewing, 5.8
setting permissions on data file directories, 2.10.3
setting up, 5.8.1
Data Guard
ports, ranges and protocol, D.3
data loss
minimizing with Automatic Storage Management, 2.11.2
Data Mining Scoring Engine
about, G.2
installing, G.2
Data Mining Scoring Engine, installation guidelines, 3.2
data mining tools
Data Mining Scoring Engine, G.2
Oracle Data Mining, G.2
data warehousing tool
Oracle OLAP, G.2
Database Configuration Assistant
running in silent mode, A.6
troubleshooting, F.5
databases
administrative information, C.1.1
Automatic Storage Management requirements, 2.11.2
files, 5.8.1
identifying, 5.6
initialization parameter file, 5.7
migrating non-Oracle databases to Oracle, G.1
non-Oracle
APPC-enabled, G.4
iWay, G.4
non-Oracle, listed, G.4
OLAP support (Oracle OLAP), G.2
Optimal Flexible Architecture file naming conventions, C.3.3
recovery with Oracle Backup and Recovery, G.2
redo log files, 5.8.2
removing, 6.3
security management, G.2
tablespaces, 5.8.1
DB_DOMAIN initialization parameter, 5.6
DB_NAME initialization parameter, 5.6, 5.6
DB2 database, G.4
DB2 z/OS database, G.4
DB2/400 database, G.4
dba group
and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4
and SYSDBA privilege, 2.5
creating, 2.5.2
description, 2.5
raw device group, 2.12.4
DBCA_RAW_CONFIG environment variable, 2.12.5, 2.14
dbca.rsp file, A.3.1
DBSNMP user password, 3.4.2
default file mode creation mask
setting, 2.14
deprecated and desupported components, 1.8
device names
IDE disks, 2.11.5.1, 2.11.5.2
RAID, 2.11.5.1, 2.11.5.2
raw devices, 2.11.5.2, 2.11.5.2
SCSI disks, 2.11.5.1, 2.11.5.2
DHCP computers, installing on, 2.4.2
directory
creating separate data file directories, 2.10.3
database file directory, 2.10.1
Oracle base directory, 2.7.1
Oracle home directory, 2.7.3, 2.7.3
Oracle Inventory directory, 2.7.2
oraInventory, 2.7.2
permission for data file directories, 2.10.3
discs
mounting, 3.3.2.1
disk devices
in Automatic Storage Management, 1.5.1.2
managing with Automatic Storage Management, 1.5.1.2
disk mirroring, C.4.1
disk space
checking, 2.2
requirement for Oracle base directory, 2.8.1, 2.8.2
requirements for preconfigured database in Automatic Storage Management, 2.11.2, 2.11.2
disk striping, C.4.2
disks
checking availability for Automatic Storage Management, 2.11.5.1, 2.11.5.2, 2.12.3
configuring for Automatic Storage Management, 2.11.1, 2.11.3
displaying attached disks, 2.11.5.1, 2.11.5.2, 2.12.3
identifying for Automatic Storage Management, 2.12.3
supported for Automatic Storage Management, 2.11.4
DISPLAY environment variable
setting, 2.14, 2.14
Distributed Computing Environment (DCE), 1.8
DOMAIN_NAME initialization parameter, 5.6
drive failure safeguards, C.1.1
Dynamic Host Configuration Protocol. See DHCP

E

e-business integration workflows, G.3
enterprise.rsp file, A.3.1
env command, 2.14
environment
checking settings, 2.14
configuring for oracle user, 2.14
environment variables
DBCA_RAW_CONFIG, 2.12.5
DISPLAY, 2.14, 2.14
NLS_LANG, 4.2.4, E.1
ORACLE_BASE, 2.7.1, 2.8.2, 2.14
ORACLE_HOME, 2.13, 2.14, 2.14
ORACLE_HOSTNAME, 2.4.3
ORACLE_SID, 2.14
PATH, 2.14
removing from shell startup file, 2.14
SHELL, 2.14
TEMP and TMPDIR, 2.2, 2.14
TNS_ADMIN, 2.14
errata
Linux kernel errata, 2.3
errors
configuration assistants, F.5
fatal, F.5.2
installation, F.3, F.4
noninteractive installation, F.6
silent mode, F.6
X Window display errors, F.2
/etc/oraInst.loc file, F.4
EXAMPLE tablespace
raw device for, 2.12.2
examples
Automatic Storage Management failure groups, 2.11.2, 2.11.2
Oracle base directories, 2.7.1
external jobs
operating system user required for, 2.5
external redundancy
Automatic Storage Management redundancy level, 2.11.2
extjob executable
operating system user required for, 2.5

F

failure group
examples of Automatic Storage Management failure groups, 2.11.2
failure groups
characteristics of Automatic Storage Management failure group, 2.11.2
examples in Automatic Storage Management, 2.11.2
in Automatic Storage Management, 1.5.1.2
FAQ for installation, G
fdisk command, 2.11.5.1, 2.11.5.2, 2.12.3, 2.12.3
features
deprecated, 1.8
desupported, 1.8
file mode creation mask
setting, 2.14
file naming, C.1.1
file sets, 2.3
file system
appropriate for Oracle base directory, 2.8.2
data file and recovery file placement options, 2.10
NFS, 1.6.4
organization, C.1.1
requirements for Oracle base directory, 2.8.2
using for data files, 2.10.1
writing to, 1.6.4
file-max file, 2.6
files, C.3.3
$ORACLE_HOME/dbs/initsid.ora, 5.7
$ORACLE_HOME/install/portlist.ini, 5.2
.bash_profile, 2.14
control, 5.8.3, C.3.3
control files
raw devices for, 2.12.2
custom.rsp, A.3.1
data files, C.3.3
dbca.rsp, A.3.1
editing shell startup file, 2.14
enterprise.rsp, A.3.1
/etc/group, C.3.2.2
/etc/oraInst.loc, F.4
/etc/pam.d/login, 2.6
/etc/passwd, C.3.2.2
/etc/profile.local, 2.6
/etc/raw, 2.12.4
/etc/security/limits.so, 2.6
/etc/sysconfig/rawdevices, 2.11.5.2, 2.11.5.2, 2.12.4
/etc/sysctl.conf, 2.6
limits.conf, 2.6
listener.ora, 4.3.1
.login, 2.14
mgw.ora, 4.3.5.3
oraInst.loc, 2.5.1, 2.5.1, 2.8.1, A.2
oratab, 2.8.1
password file
raw device for, 2.12.2
/proc/sys/fs/file-max, 2.6
/proc/sys/kernel/sem, 2.6
/proc/sys/kernel/shmall, 2.6
/proc/sys/kernel/shmmax
shmmax file, 2.6
/proc/sys/kernel/shmmni, 2.6
/proc/sys/net/core/rmem_default, 2.6
/proc/sys/net/core/rmem_max, 2.6
/proc/sys/net/core/wmem_default, 2.6
/proc/sys/net/core/wmem_max, 2.6
/proc/sys/net/ipv4/ip_local_port_range, 2.6
.profile, 2.14
profile.local, 2.6
raw device mapping file, 2.12.5, 2.14
redo log, 5.8.2
redo log files
raw devices for, 2.12.2
server parameter file
raw devices for, 2.12.2
SPFILE
raw devices for, 2.12.2
spnc_commands, 4.3.8
standard.rsp, A.3.1
tnsnames.ora, 4.3.1
for raw devices, 2.12.4
free
UNIX command, 2.2
frequently asked installation questions, G

G

Gateways products FAQ, G.4
GCC, 2.3
postinstallation tasks, 4.3.8
GCC See GNU Compiler Collection (GCC)
global database name, 5.6
globalization support, E
GNU Compiler Collection (GCC) configuration, 4.3.8
Grid Control. See Oracle Enterprise Manager Grid Control
group file, C.3.2.2
groupadd command, 2.5.2, 2.5.3
groups
creating the dba group, 2.5.2
creating the oinstall group, 2.5.1
creating the oper group, 2.5.3

H

hardware certification, 1.6.1
hardware requirements, 2.2
high redundancy
Automatic Storage Management redundancy level, 2.11.2
home directory
distribution, C.1.1
login, C.1.1
See Oracle home directory
host name, setting before installation, 2.4.3

I

IBM DB2 database, G.4
IBM DB2 z/OS database, G.4
IBM DB2/400 database, G.4
IBM DRDA databases, connecting to, G.4
IBM mainframe data, connecting to, G.4
IBM WebSphere MQ
Oracle Messaging Gateway requirement, 2.3
IBM WebSphere MQ Series databases, G.4
ICC See Intel C++ compiler (ICC)
id command, 2.5.5
IDE disks
device names, 2.11.5.1, 2.11.5.2, 2.12.3
Informix Server database, G.4
Ingres II database, G.4
initialization parameter file
description, 5.7
in databases, 5.7
initsid.ora, 5.7
initialization parameters
DB_NAME, 5.6
DOMAIN_NAME, 5.6
SERVICE_NAMES, 5.6
initsid.ora file, 5.7
initsid.ora initialization parameter file, 5.7
installation
accessing installation software, 3.3
Automatic Storage Management requirements, 2.11.2
cleaning up after a failed installation, F.7
clusters, installation guidelines, 3.2
completing, 3.4.2
component-specific guidelines, 3.2
computer aliases, multiple, 2.4.4
considerations, 1.6
errors, F.4
silent mode, F.6
FAQ for Oracle Database products, G
guidelines, 3.4.1
installation types, 1.3
laptops, 2.4.5
log files, F.3, F.3
noninteractive
error handling, F.6
oraInst.loc file, A.2
reinstalling Oracle software, 3.2
response files
preparing, A.3
silent mode, F.6
silent mode, A.4
upgrading, G.1
with other components, G
installation errors
steps to resolve, F.3
installation guidelines, 3.4.1, 3.4.2, 3.4.2
Oracle Label Security, 3.4.1
Oracle Universal Installer, 3.4.1
reinstalling Oracle software, 3.4.1
installation overview, 1.1
installation software
copying to a hard disk, 3.3.2.2
extracting, 3.3.1.2
reinstalling, 3.4.1
installation software, accessing, 3.3
installation types
disk space requirements, 2.2
instance
instance identifier (SID), 2.14
Intel C++ compiler (ICC), 4.3.8
I/O loads, C.1.1
Optimal Flexible Architecture, C.1.1
IP addresses, multiple, 2.4.3
ip_local_port_range file, 2.6
IPC protocol address
Oracle Messaging Gateway setting, 4.3.5.1
iSQL*Plus
ports, changing, D.6
ports, ranges and protocol, D.3
iWay databases, G.4

J

Java Libraries for Oracle JVM and Oracle interMedia
postinstallation tasks, 4.3.3
JDK
internationalization class, 4.3.5.3
run-time class, 4.3.5.3
JDK requirements, 2.3
JPublisher, G.3

K

kernel
Linux errata, 2.3
kernel parameters
changing, 2.6
configuring, 2.6
Korn shell
default user startup file, 2.14

L

languages
installing Oracle components in different languages, E.2
laptops, installing Oracle Database on, 2.4.5
Legato Single Server Version (LSSV), 1.8
licensing information, 1.3
limit command, 2.6
limits.conf file, 2.6
limits.so file, 2.6
Linux
kernel errata, 2.3
listener
identifying Oracle home for, 2.13
lsnrctl command, 2.13
stopping, 2.13, 2.13
stopping existing listener process, 2.13
listener.ora file, 4.3.1
modifying for external procedures, 4.3.5.1
local device
using for data files, 2.10.1
log files, F.3, F.3
installation, reviewing, F.4
logical volume manager
See LVM
login file, 2.6, 2.14
loopback adapters
non-networked computers, 2.4.5
lsdev command, 2.11.5.1, 2.11.5.2, 2.12.3
lsnrctl command, 2.13
LVM, 1.5.1.1
recommendations for Automatic Storage Management, 2.11.2

M

mapping file
for raw devices, 2.12.5, 2.14
mask
setting default file mode creation mask, 2.14
memory requirements, 2.2
MGW_AGENT service name, 4.3.5.2
mgwextproc service
adding static service information, 4.3.5.1
mgw.ora file
modifying, 4.3.5.3
Microsoft SQL Server database, G.4
migrating
See upgrading
migrating applications to Oracle, G.3
migrating databases to Oracle, G.1
mirroring Automatic Storage Management disk groups, 2.11.2
mkdir command, 2.8.2, 2.10.3
mode
setting default file mode creation mask, 2.14
mount point
for Oracle base directory, 2.7.1
mount point directories, 3.3.2.2
mount point directory
choosing, B.2
mount points
Optimal Flexible Architecture conventions for creating, C.3.1
MQSeries
class, 4.3.5.3
multihomed computers, installing on, 2.4.3
multiple aliases, computers with, 2.4.4
multiple Oracle homes, 1.6.2

N

naming subdirectories, C.3.2.4
NAS device, 2.8.2
NAS devices
creating files on for use with Automatic Storage Management, B.3
guidelines for configuration, B.1
natively compiled Java libraries, G.3
Net Configuration Assistant
response file, A.3.1, A.3.1
running in silent mode, A.5
troubleshooting, F.5
NetCA
See Net Configuration Assistant
netca.rsp file, A.3.1, A.3.1
network adapters
non-networked computers, 2.4.5
See also loopback adapters, primary network adapters
network attached storage devices
See NAS devices
network cards, multiple, 2.4.3
Network File System See NFS
network setup
about, 2.4
computers with multiple aliases, 2.4.4
network topics
DHCP computers, 2.4.2
laptops, 2.4.5
multiple network cards, 2.4.3
non-networked computers, 2.4.5
NFS
mount options, B.4
using for installation, 1.6.4
NFS file system, 2.8.2
NLS_LANG environment variable, 4.2.4, E.1
NLS_LANG parameter
about, E.1
nobody user
checking existence of, 2.5.5
description, 2.5
noninteractive installation
oraInst.loc file, A.2
response files
preparing, A.3
silent mode, A.4
errors, F.6
noninteractive installations
running
Oracle Universal Installer, A.4
non-networked computers, 2.4.5
non-Oracle databases, listed, G.4
normal redundancy, Automatic Storage Management redundancy level, 2.11.2

O

OCCI
postinstallation tasks, 4.3.7
OEM
See Oracle Enterprise Manager
oinstall group
creating, 2.5.1
description, 2.5
OLAP tools
Oracle OLAP, G.1, G.2
OLS
See Oracle Label Security
OMF
See Oracle Managed Files
oper group
and SYSOPER privilege, 2.5
creating, 2.5.3
description, 2.5
operating system
checking distribution and version, 2.3
operating system groups
creating the dba group, 2.5.2
creating the oinstall group, 2.5.1
creating the oper group, 2.5.3
oinstall, 2.5
OSDBA, 2.5
OSOPER, 2.5
osoper, 2.5
requirements, 2.5
operating system requirements, 2.3
operating system users
checking existence of the nobody user, 2.5.5
creating the oracle user, 2.5.4
nobody, 2.5
oracle, 2.5
requirements, 2.5
root user, 3.4.2
unprivileged user, 2.5
Optimal Flexible Architecture
administrative information, C.1.1
Automatic Storage Management, C.3.3
changes for Oracle Database 10g, C.2
characteristics of an installation compliant with, C.1.1
concurrent execution of application software, C.1.1
conventions for creating mount points, C.3.1
distributed I/O loads, C.1.1
drive failure safeguards, C.1.1
file mapping, C.1.1, C.3.7
file naming, C.1.1
file system organization, C.1.1
hardware support, C.1.1
home directory distribution, C.1.1
identifying file, C.3.6
implementing, C.3
I/O loads, C.1.1
login home directories, C.1.1
naming
database files, C.3.3
Oracle base directory, C.3.2
subdirectories, C.3.2.4
tablespaces, C.3.5
very large databases, C.3.1.3
Oracle Managed Files, C.3.3
pathnames, C.3.2.2
recommendations for Oracle base directory, 2.7.1
recommended path for Oracle base directory, 2.7.1
recommended path for Oracle home directory, 2.7.3
recommended path for Oracle Inventory directory, 2.7.2
special tablespaces, C.3.4
standard, C
tablespace contents, C.1.1
UNIX directory subtrees, C.1.1
using seperate segments, C.3.4
Oracle Advanced Security
deprecated component, 1.8
Oracle Application Server, G.2
Oracle applications
APPC-enabled systems, connecting to, G.4
IBM DRDA databases, connecting to, G.4
Oracle applications, installing with Oracle Database, G.3
Oracle base directory
and ORACLE_BASE environment variable, 2.7.1
creating, 2.8.2
creating new, 2.8.2
description, 2.7.1
determining disk space on, 2.8.1
disk space requirements, 2.8.1, 2.8.2
equivalent directory on Microsoft Windows, 2.7.1
examples, 2.7.1
identifying appropriate file system, 2.8.2
identifying existing, 2.8.1
mount point for, 2.7.1
naming conventions, C.3.2
recommended path, 2.7.1
relationship with Oracle software owner user, 2.7.1
requirements on file system, 2.8.2
Oracle C++ Call Interface requirements, 2.3
Oracle Call Interface requirements, 2.3
Oracle Cluster Registry
See OCR
Oracle Clusterware
about, G.1
ports, D.3
ports, ranges and protocol, D.3
used with Automatic Storage Management, 1.5.1.2
used with Oracle Real Application Clusters, G.1
Oracle Connection Manager, installation guidelines, 3.2
Oracle CSS Daemon
configuration, deleting, 6.5.3
Oracle Data Mining
about, G.2
installing, G.2
Oracle Database
administering and monitoring, G.2
AS/400 applications, G.4
creating data file directories, 2.10.3
Custom installation, 1.3
Enterprise Edition installation, 1.3
installing with Oracle applications, G.3
installing with other Oracle components, G
minimum disk space requirements, 2.10.1
multiple databases on a single server with Automatic Storage Management, 3.5.1
requirements with Automatic Storage Management, 2.11.2
security management, G.2
setting ORACLE_SID environment variable, 2.14
Standard Edition installation, 1.3
upgrading, G.1
Web application development tools (Oracle HTML DB), G.3
Web servers, G.3
workflows, G.3
Oracle Database Client, G.1
Oracle Database Companion CD
components, G.3
Oracle Database components
administering and monitoring, G.2
connectivity FAQ, G.4
FAQ for installing, G
FAQ on installing, G.1
installing with Oracle applications, G.3
installing with Oracle Database tools, G.2
Oracle Database Configuration Assistant
response file, A.3.1
Oracle Database Examples, G.3
Oracle Database Recovery Manager (RMAN)
Automatic Storage Management, 1.5.1.2, 3.5.2
Oracle Enterprise Management Agent
HTTP port, changing, D.4
Oracle Enterprise Manager, 1.5.2
Database Control
logging in to, 5.2
port number, 5.2
using to modify control files, 5.8.3
using to modify redo log files, 5.8.2
using to view control files, 5.8.3
using to view redo log files, 5.8.2
database migration to Automatic Storage Management, 3.5.2
login privileges, 5.2
Migrate Wizard, 3.5.2
Oracle Enterprise Manager Database Agent
ports, ranges and protocol, D.3
Oracle Enterprise Manager Database Console
ports, ranges and protocol, D.3
Oracle Enterprise Manager Database Control
ports, changing, D.5
Oracle Enterprise Manager Migrate Database wizard, 3.5.2
Oracle home directory
Automatic Storage Management considerations, 3.5.1
description, 2.7.3
identifying for listener, 2.13
multiple homes, network considerations, 2.4.3
recommended path, 2.7.3
requirement for, 2.7.3
requirements, 2.7.3
using to identify Oracle base directory, 2.8.1
Oracle home name, 2.7.3
Oracle host name, setting before installation, 2.4.3
Oracle HTML DB, G.3, G.3
Oracle HTTP Server, G.3, G.3, G.3
Oracle internationalization class, 4.3.5.3
Oracle Internet Directory, G.2
Oracle Inventory
description, 2.7.2
pointer file, 2.5.1
Oracle Inventory directory
description, 2.7.2
recommended path, 2.7.2
Oracle Inventory group
creating, 2.5.1
description, 2.5
Oracle JDBC class, 4.3.5.3
Oracle JDBC development drivers, G.3
Oracle JDBC/OCI driver requirements, 2.3
Oracle Label Security
installation guidelines, 3.2, 3.4.1
postinstallation tasks, 4.3.2
Oracle Managed Files
Optimal Flexible Architecture naming conventions, C.3.3
Oracle Messaging Gateway
postinstallation tasks, 4.3.5
Oracle Messaging Gateway class, 4.3.5.3
Oracle Messaging Gateway requirements
IBM WebSphere MQ, 2.3
TIBCO Rendezvous, 2.3
Oracle Migration Workbench, G.1, G.3
Oracle Net
configuration file directory, 4.3.1
identifying Oracle home for listener, 2.13
lsnrctl command, 2.13
stopping existing listener, 2.13
stopping listener, 2.13
stopping the listener, 2.13
Oracle Net Configuration Assistant
See Net Configuration Assistant
Oracle Net Services
postinstallation tasks, 4.3.1
Oracle OLAP, G.1, G.2
Oracle precompilers
postinstallation tasks, 4.3.6
Oracle Procedural Gateway
about, G.4
listed products, G.4
Oracle Real Application Clusters (RAC)
installed before Oracle Database, 3.2
installing with Oracle Enterprise Manager, G.2
Oracle Clusterware
about, G.1
Oracle software
removing, 6.6
Oracle software owner user
and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4
configuring environment for, 2.14
creating, 2.5.4
description, 2.5
determining default shell, 2.14
raw device owner, 2.12.4
relationship with Oracle base directory, 2.7.1
setting shell limits for, 2.6
Oracle Spatial requirements
X Window, 2.3
Oracle SQL*Net Listener
ports, ranges and protocol, D.3
Oracle SQLJ, G.3
Oracle Storage Compatibility Program (OSCP)
certification of NAS devices, B
Oracle Text supplied knowledge bases, G.3
postinstallation tasks, 4.3.4
Oracle Transparent Gateway
about, G.4
listed products, G.4
Oracle Ultra Search, G.3
ports, changing, D.7
ports, ranges and protocol, D.3
Oracle Universal Installer
Automatic Storage Management behavior, 3.5.1
installation guidelines, 3.2, 3.4.1
response files
list of, A.3.1, A.3.1, A.3.1
running, 3.4.2
running in different languages, E.2
oracle user
and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4
configuring environment for, 2.14
creating, 2.5.4
description, 2.5
determining default shell, 2.14
raw device owner, 2.12.4
relationship with Oracle base directory, 2.7.1
setting shell limits for, 2.6
Oracle Workflow, G.3, G.3
Oracle XDB
ports, D.8
ports, changing, D.8
ports, ranges and protocol, D.3
Oracle XML Developer's Kit (XDK) requirements, 2.3
ORACLE_BASE environment variable, 2.7.1, 2.8.2
removing from shell startup file, 2.14
setting, 2.14
ORACLE_HOME environment variable
removing from shell startup file, 2.14
setting, 2.13
unsetting, 2.14
ORACLE_HOSTNAME environment variable
about, 2.4.3
computers with multiple aliases, 2.4.4
multihomed computers, 2.4.3
setting before installation, 2.4.3
ORACLE_SID environment variable
removing from shell startup file, 2.14
setting, 2.14
oraInst.loc file, 2.5.1, 2.8.1
location, 2.5.1
oraInventory directory
See Oracle Inventory directory
oratab file, 2.8.1
formats, 2.8.1
location of, 2.8.1
OSDBA group
and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4
and SYSDBA privilege, 2.5
creating, 2.5.2
description, 2.5
raw device group, 2.12.4
OSOPER group
and SYSOPER privilege, 2.5
creating, 2.5.3
description, 2.5
OTN Web site
downloading installation software from, 3.3.1, 3.3.1
OUI
See Oracle Universal Installer

P

packages, checking, 2.3
partition
using with Automatic Storage Management, 2.11.2
partitions
binding to raw devices, 2.12.4
creating, 2.12.3
creating raw partitions, 2.12.2
creation for Automatic Storage Management disks, 2.11.4
passwd command, 2.5.4.2
passwd file, C.3.2.2
password file
raw device for, 2.12.2
password file for Automatic Storage Management, 3.5.1
passwords
DBSNMP, 3.4.2
guidelines, 3.4.2
resetting, 5.5
with Database Control, 5.5.1
with SQL*Plus, 5.5.2
reviewing, 5.4
SYS, 3.4.2
SYSMAN, 3.4.2
SYSTEM, 3.4.2
unlocking, 5.5
with Database Control, 5.5.1
with SQL*Plus, 5.5.2
patches
installing and downloading, 4.1.1
PATH environment variable
setting, 2.14
pathnames
Optimal Flexible Architecture, C.3.2.2
permissions
for data file directories, 2.10.3
for Oracle base directory, 2.8.2
PL/SQL native compilation, 4.3.8
PL/SQL native compilation requirements, 2.3
PL/SQL native compilaton, 4.3.8
port numbers
managing, D
portlist.ini file, 5.2, D.2
ports
access URLs, D.2
configured for applications, D.2
Connection Manager, ranges and protocol, D.3
Data Guard, ranges and protocol, D.3
default ranges, D
iSQL*Plus, changing, D.6
iSQL*Plus, ranges and protocol, D.3
Oracle Clusterware, D.3
Oracle Clusterware, ranges and protocol, D.3
Oracle Enterprise Management Agent HTTP, changing, D.4
Oracle Enterprise Manager Database Agent, ranges and protocol, D.3
Oracle Enterprise Manager Database Console, ranges and protocol, D.3
Oracle Enterprise Manager Database Control, changing, D.5
Oracle SQL*Net Listener, ranges and protocol, D.3
Oracle Ultra Search, changing, D.7
Oracle Ultra Search, ranges and protocol, D.3
Oracle XDB, D.8
Oracle XDB, changing, D.8
Oracle XDB, ranges and protocol, D.3
postinstallation
configuring required tasks
Oracle Net Services, 4.3.1
recommended tasks
root.sh script, backing up, 4.2.1
setting the NLS_LANG environment variable, 4.2.4
setting up user accounts, 4.2.3
required tasks, 4.1
configuring GCC as the primary compiler, 4.3.8
configuring OCCI, 4.3.7
configuring Oracle Label Security, 4.3.2
configuring Oracle Messaging Gateway, 4.3.5
configuring Oracle precompilers, 4.3.6
installing natively compiled Java Libraries for Oracle JVM and Oracle interMedia, 4.3.3
installing Oracle Text supplied knowledge bases, 4.3.4
patches, installing and downloading, 4.1.1
preconfigured database
Automatic Storage Management disk space requirements, 2.11.2
requirements when using Automatic Storage Management, 2.11.2, 2.11.2
Pro*C/C++
configuring, 4.3.6.1
See also C compiler
Pro*C/C++ requirements, 2.3
process
stopping existing, 2.13
stopping existing listener process, 2.13
stopping listener process, 2.13
processor
checking system architecture, 2.2
.profile file, 2.14
profile.local file, 2.6, 2.6
ps command, 2.13

R

RAC
configuring disks for raw devices, 2.12.2
RAID
device names, 2.11.5.1, 2.11.5.2, 2.12.3
recommended Automatic Storage Management redundancy level, 2.11.2
using for Oracle data files, 2.10.1
RAM requirements, 2.2
raw command, 2.11.5.2, 2.11.5.2, 2.12.4, 2.12.4
raw device
for password file, 2.12.2
for server parameter file, 2.12.2
for SPFILE, 2.12.2
raw devices
binding, 2.11.5.2, 2.11.5.2
binding to partitions, 2.12.4
changing permissions and owner for Automatic Storage Management, 2.11.5.2, 2.11.5.2, 2.12.4
creating a raw device mapping file, 2.12.5
creating partitions, 2.12.3
creating raw partitions, 2.12.2
DBCA_RAW_CONFIG environment variable, 2.14
device names, 2.11.5.2, 2.11.5.2, 2.12.4
device names, 2.12.4
for control files, 2.12.2
for EXAMPLE tablespace, 2.12.2
for redo log files, 2.12.2
for SYSAUX tablespace, 2.12.2
for SYSTEM tablespace, 2.12.2
for TEMP tablespace, 2.12.2
for UNDOTBS tablespace, 2.12.2
for USER tablespace, 2.12.2
specifing location of mapping file, 2.14
specifying owner and permissions, 2.12.4
storage option for data files, 2.9
value for DBCA_RAW_CONFIG environment variable, 2.12.5
raw file, 2.12.4
rawdevices file, 2.11.5.2, 2.11.5.2, 2.12.4
Rdb database, G.4
readme.txt file, D.2
reconfiguring CSS, 6.5
recovery files
options for placing on file system, 2.10
recovery of databases
Oracle Backup and Recovery, G.2
Red Hat
operating system requirements, 2.3
Red Hat Package Manager
See RPM
redo log, C.3.3
redo log files
in starter database, 5.8.2
locating, 5.8.2
naming, C.3.3
raw devices for, 2.12.2
reviewing, 5.8
using Oracle Enterprise Manager Database Control with, 5.8.2
redundancy level
and space requirements for preconfigured database, 2.11.2, 2.11.2
for Automatic Storage Management, 2.11.2
redundant array of independent disks
See RAID
reinstalling Oracle software, 3.2
requirements
hardware, 2.2
response files
custom.rsp, A.3.1
dbca.rsp, A.3.1
enterprise.rsp, A.3.1
netca.rsp, A.3.1, A.3.1
recording, A.3.2
standard.rsp, A.3.1
rmem_default file, 2.6
rmem_max file, 2.6
RMS database, G.4
roadmap for installing Oracle Database components, G
root user, 3.4.2
logging in as, 2.1
root.sh script
backing up, 4.2.1
RPM
checking, 2.3
rpm command, 2.3

S

SAME methodology, 1.5.1.1
SAN (storage area network) disks, 2.11.4
SCSI disks
device names, 2.11.5.1, 2.11.5.2, 2.12.3
security
management tools, G.2
sem file, 2.6
server parameter file
raw device for, 2.12.2
server parameter file (SPFILE), 3.5.1
service command, 2.11.5.2, 2.12.4
SERVICE_NAMES initialization parameter, 5.6, 5.6
shell
determining default shell for oracle user, 2.14
SHELL environment variable
checking value of, 2.14
shell limits
setting, 2.6
shell startup file
editing, 2.14
removing environment variables, 2.14
shmall file, 2.6
shmmni file, 2.6
SID, 5.6
setting ORACLE_SID environment variable, 2.14
silent mode installation, A.4
software certification, 1.6.1
software requirements, 2.3
checking, 2.3
SPFILE
raw device for, 2.12.2
SPFILE server parameter file, 3.5.1
spnc_commands configuration file, 4.3.8
SQL Server database, G.4
SQLJ class, 4.3.5.3
standard.rsp files, A.3.1
startup file
for shell, 2.14
static service information
adding for mgwextproc service, 4.3.5.1
storage area network disks, 2.11.4
storage management See Automatic Storage Management
stripe and mirror everything methodology
See SAME methodology
SUSE
binding partitions to raw devices, 2.12.4
operating system requirements, 2.3
swap space
checking, 2.2
requirements, 2.2
Sybase Adapter Server database, G.4
SYS user password, 3.4.2
SYSAUX tablespace
raw device for, 2.12.2
sysctl command, 2.6
sysctl.conf file, 2.6
SYSDBA privilege
associated operating system group, 2.5
SYSMAN user password, 3.4.2
SYSOPER privilege
associated operating system group, 2.5
system architecture
checking, 2.2
System Identifier, 5.6
See SID
SYSTEM tablespace
raw device for, 2.12.2
SYSTEM user password, 3.4.2

T

tablespaces
defined, 5.8.1
in databases, 5.8.1
Optimal Flexible Architecture
naming, C.3.5
special tablespaces, C.3.4
reviewing, 5.8
setting up, 5.8.1
TEMP environment variable, 2.2
setting, 2.14
TEMP tablespace
raw device for, 2.12.2
temporary disk space
requirements, 2.2
Teradata database, G.4
TIBCO Rendezvous
Oracle Messaging Gateway requirement, 2.3
TMPDIR environment variable, 2.2
setting, 2.14
TNS_ADMIN environment variable
unsetting, 2.14
tnsnames.ora file, 4.3.1
adding a connect descriptor, 4.3.5.2
MGW_AGENT service name, 4.3.5.2
modifying for external procedures, 4.3.5.2
troubleshooting, F
fatal errors, F.5.2

U

ulimit command, 2.6
umask, 2.14
umask command, 2.14, 2.14
UNDOTBS tablespace
raw device for, 2.12.2
UNIX commands, 2.14
chmod, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4
chown, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4
env, 2.14
fdisk, 2.11.5.1, 2.11.5.2, 2.12.3, 2.12.3
free, 2.2
groupadd, 2.5.2, 2.5.3
id, 2.5.5
limit, 2.6
lsdev, 2.11.5.1, 2.11.5.2, 2.12.3
mkdir, 2.8.2, 2.10.3
passwd, 2.5.4.2
ps, 2.13
raw, 2.11.5.2, 2.11.5.2, 2.12.4, 2.12.4
rpm, 2.3
service, 2.11.5.2, 2.12.4
sysctl, 2.6
ulimit, 2.6
umask, 2.14
unset, 2.14
unsetenv, 2.14
useradd, 2.5.4.2
xhost, 2.1
xterm, 2.1
UNIX directory subtrees, C.1.1
UNIX workstation
installing from, 2.1
unprivileged user
checking existence of, 2.5.5
unset command, 2.14
unsetenv command, 2.14
upgraded databases
configuring, 4.2.2
upgrading, 1.7
advantages with separate Oracle homes, 3.5.1
USER tablespace
raw device for, 2.12.2
useradd command, 2.5.4.2
users
checking existence of the nobody user, 2.5.5
creating the oracle user, 2.5.4
operating system nobody user, 2.5
Oracle software owner user, 2.5
utlrp.sql script
recompiling invalid SQL modules, 4.2.2

V

very large databases
Optimal Flexible Architecture naming mount points, C.3.1.3

W

Web applications, Oracle HTML DB, G.3
Web servers (Oracle HTTP Server), G.3
WebSphere MQ
CSD download location, 2.3
WebSphere MQ class, 4.3.5.3
WebSphere MQ Series database, G.4
Windows
analogy for Oracle base directory, 2.7.1
wmem_default file, 2.6
wmem_max file, 2.6
workflows
applications based, G.3
e-business integration, G.3

X

X Window requirement
Oracle Spatial requirement, 2.3
X Window system
enabling remote hosts, 2.1, 2.1
xhost command, 2.1
xterm command, 2.1