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

Part Number B25147-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
Contact Us

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, F.4
accounts
reviewing, 5.4
unauthenticated access to, 5.5.2
Advantage family of databases, F.4
aliases, multiple on computers, 2.4.4
ANONYMOUS user
unauthenticated account access with, 5.5.2
APPC-enabled databases, F.4
APPC-enabled systems, F.4
applications, migrating non-Oracle applications to Oracle, F.3
applications-based workflows, F.3
architecture
checking system architecture, 2.2
AS/400 applications, accessing Oracle database, F.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
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, B.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
response files, A.1.2
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, 2.9
upgrade advantages with separate Oracle homes, 3.5.1
Automatic Storage Management (ASM)
ASM disk group templates, 1.5.1.2
templates, 1.5.1.2
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, F.2
base directory
See Oracle base directory
Bash shell
default user startup file, 2.14
setting shell limits on Linux x86, 2.6
.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
setting shell limits on Linux x86, 2.6

C

C compiler
requirement on Linux, 2.3, 2.3
C shell
default user startup file, 2.14
setting shell limits on Linux x86, 2.6
certification, hardware and software, 1.6.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
client static library, generating, 4.2.5
Cluster Manager
ports, ranges and protocol, C.3
Cluster Ready Services (CSS). See Oracle Clusterware
Cluster Synchronization Services (CSS)
Automatic Storage Management, 1.5.1.2
ports, ranges and protocol, C.3
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.7
primary, 4.3.7
computers with multiple aliases, 2.4.4
computers, non-networked, 2.4.5
configuration assistants
failure, E.5.1
troubleshooting, E.5, E.5
configuring
kernel parameters, 2.6
configuring disks for Automatic Storage Management, 2.11.1, 2.11.3
Connection Manager
ports, ranges and protocol, C.3
connectivity tools
Oracle Procedural Gateway
about, F.4
Oracle Transparent Gateway
about, F.4
See also databases, non-Oracle
control files
locating, 5.8.3
naming, B.3.3
raw devices for
on Linux, 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
requirements
on Linux, 2.3
csh.login file, 2.6
csh.login.local file, 2.6
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, B.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, C.3
data loss
minimizing with Automatic Storage Management, 2.11.2
Data Mining Scoring Engine
about, F.2
installing, F.2
Data Mining Scoring Engine, installation guidelines, 3.2
data mining tools
Data Mining Scoring Engine, F.2
Oracle Data Mining, F.2
data warehousing tool
Oracle OLAP, F.2
Database Configuration Assistant
running in silent mode, A.6
troubleshooting, E.5
databases
administrative information, B.1.1
Automatic Storage Management requirements, 2.11.2
files, 5.8.1
identifying, 5.6
initialization parameter file, 5.7
non-Oracle
APPC-enabled, F.4
iWay, F.4
non-Oracle, listed, F.4
OLAP support (Oracle OLAP), F.2
Optimal Flexible Architecture file naming conventions, B.3.3
recovery with Oracle Backup and Recovery, F.2
redo log files, 5.8.2
removing, 6.3
security management, F.2
tablespaces, 5.8.1
DB_DOMAIN initialization parameter, 5.6
DB_NAME initialization parameter, 5.6, 5.6
DB2 database, F.4
DB2 z/OS database, F.4
DB2/400 database, F.4
dba group
and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2
and Automatic Storage Management disks on Linux, 2.12.4
and SYSDBA privilege, 2.5
creating, 2.5.2, 2.5.2, 2.5.3
description, 2.5
raw device group
on Linux, 2.12.4
DBCA_RAW_CONFIG environment variable, 2.12.5, 2.14
dbca.rsp file, A.3.1
DBSNMP user password, 3.4.1
default file mode creation mask
setting, 2.14
device names
IDE disks, 2.11.5.1, 2.11.5.2
IDE disks on Linux, 2.12.3
RAID, 2.11.5.1, 2.11.5.2
RAID on Linux, 2.12.3
raw devices, 2.11.5.2, 2.11.5.2
SCSI disks, 2.11.5.1, 2.11.5.2
SCSI disks on Linux, 2.12.3
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, 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
disc
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, B.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, B.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
DOMAIN_NAME initialization parameter, 5.6
drive failure safeguards, B.1.1
Dynamic Host Configuration Protocol. See DHCP

E

e-business integration workflows, F.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, D.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, E.5
installation, E.3, E.4, E.5.2
noninteractive installation, E.6
silent mode, E.6
X Window, E.1
X Window display errors, E.2
/etc/csh.login file, 2.6
/etc/csh.login.local file, 2.6
/etc/oraInst.loc file, E.4
/etc/pam.d/login file, 2.6
/etc/profile file, 2.6
/etc/profile.local file, 2.6
/etc/raw file, 2.12.4
/etc/security/limits.so file, 2.6
/etc/sysconfig/rawdevices file, 2.11.5.2, 2.11.5.2, 2.12.4
/etc/sysctl.conf file, 2.6
EXAMPLE tablespace
raw device for
on Linux, 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, F
fatal errors, E.5.2
fdisk command, 2.11.5.1, 2.11.5.2, 2.12.3, 2.12.3
file mode creation mask
setting, 2.14
file naming, B.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
organization, B.1.1
requirements for Oracle base directory, 2.8.2
using for data files, 2.10.1
file-max file, 2.6
file-max parameter
recommended value on Linux x86, 2.6
files, B.3.3
$ORACLE_HOME/dbs/initsid.ora, 5.7
$ORACLE_HOME/install/portlist.ini, 5.2, 5.2
.bash_profile, 2.14
contol, B.3.3
control, 5.8.3
control files
raw devices for on Linux, 2.12.2
custom.rsp, A.3.1
data files, B.3.3
dbca.rsp, A.3.1
default shell startup file, 2.6
editing shell startup file, 2.14
enterprise.rsp, A.3.1
/etc/csh.login, 2.6
/etc/csh.login.local, 2.6
/etc/group, B.3.2.2
/etc/oraInst.loc, E.4
/etc/pam.d/login, 2.6
/etc/passwd, B.3.2.2
/etc/profile, 2.6
/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
listener.ora, 4.3.1
.login, 2.14
mgw.ora, 4.3.5.3
oraInst.loc, 2.5.1, 2.8.1
oraInst.loc file, A.2
oratab, 2.8.1, 2.8.1
password file
raw device for on Linux, 2.12.2
/proc/sys/fs/file-max, 2.6
/proc/sys/kernel/sem, 2.6, 2.6
/proc/sys/kernel/shmall, 2.6, 2.6
/proc/sys/kernel/shmmax, 2.6
shmmax file, 2.6
/proc/sys/kernel/shmmni, 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 on Linux, 2.12.2
response files, A.3
server parameter file
raw devices for on Linux, 2.12.2
SPFILE
raw devices for on Linux, 2.12.2
spnc_commands, 4.3.7
standard.rsp, A.3.1
tnsnames.ora, 4.3.1
for raw devices, 2.12.4
FORTRAN
requirement on Linux, 2.3
free
UNIX command, 2.2
frequently asked installation questions, F

G

Gateways products FAQ, F.4
GCC
postinstallation tasks, 4.3.7
GCC See GNU Compiler Collection (GCC)
global database name, 5.6
globalization support, D
GNU Compiler Collection (GCC) configuration, 4.3.7
Grid Control. See Oracle Enterprise Manager Grid Control
group file, B.3.2.2
groups
checking for existing oinstall group, 2.5.1
creating the dba group, 2.5.2, 2.5.3
creating the oinstall group, 2.5.1

H

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

I

IBM DB2 database, F.4
IBM DB2 z/OS database, F.4
IBM DB2/400 database, F.4
IBM DRDA databases, connecting to, F.4
IBM mainframe data, connecting to, F.4
IBM WebSphere MQ
requirement on Linux, 2.3
IBM WebSphere MQ Series databases, F.4
ICC See Intel C++ compiler (ICC)
id command, 2.5.5
IDE disks
device names, 2.11.5.1, 2.11.5.2
device names on Linux, 2.12.3
Informix Server database, F.4
Ingres II database, F.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
available products, 1.3, 1.3
cleaning up after a failed installation, E.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, E.4, E.5.2
silent mode, E.6
FAQ for Oracle Database products, F
guidelines, 3.4.1
laptops, 2.4.5
log files, E.3, E.3
noninteractive
error handling, E.6
oraInst.loc file, A.2
quick installation, F.1
reinstalling Oracle software, 3.2
response files, A, A.3
preparing, A.3, A.3.2
silent mode, E.6
templates, A.3
silent mode, A.3.2, A.4
upgrading, F.1
with other components, F
installation errors
steps to resolve, E.3
installation guidelines, 3.4.1, 3.4.2, 3.4.2
Oracle Label Security, 3.4.1
Oracle Universal Installer, 3.4.1
re-installing 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
re-installing, 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.7
I/O loads, B.1.1
Optimal Flexible Architecture, B.1.1
IP addresses, multiple, 2.4.3
ip_local_port_range file, 2.6
ip_local_port_range parameter
recommended value on Linux x86, 2.6
IPC protocol address
Oracle Messaging Gateway setting, 4.3.5.1
iSQL*Plus
ports, changing, C.6
ports, ranges and protocol, C.3
iWay databases, F.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, F.3

K

kernel
Linux errata, 2.3
kernel parameters
changing, 2.6
configuring, 2.6
Korn shell
default user startup file, 2.14
setting shell limits on Linux x86, 2.6
ksh
See Korn shell

L

languages
installing Oracle components in different languages, D.2
laptops, installing Oracle Database on, 2.4.5
licensing information, 1.3
limit command, 2.6
limits.so file, 2.6
Linux
IDE disk device names, 2.12.3
kernel errata, 2.3
RAID device names, 2.12.3
SCSI disk device names, 2.12.3
setting shell limits, 2.6
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, E.3, E.3
troubleshooting, E.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
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, F.4
migrating applications to Oracle, F.3
migrating non-Oracle databases to Oracle, F.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 points
Optimal Flexible Architecture conventions for creating, B.3
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, B.3.2.4
Natively Compiled Java Libraries, F.3
Net Configuration Assistant
troubleshooting, E.5
Net Configuration Assistant (NetCA)
response files, A.5
running at command prompt, A.5
netca.rsp file, A.3.1
network adapters
computers with multiple aliases, 2.4.4
non-networked computers, 2.4.5
primary, on computers with multiple aliases, 2.4.4
See also loopback adapters, primary network adapters
network cards, multiple, 2.4.3
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
NLS_LANG environment variable, D.1
NLS_LANG parameter
about, D.1
nobody user
checking existence of, 2.5.5
description, 2.5
nofile
shell limit on Linux x86, 2.6
noninteractive installation
oraInst.loc file, A.2
response files
preparing, A.3, A.3.2
templates, A.3
silent mode, A.3.2, A.4
errors, E.6
noninteractive mode
about, A.1
reasons for using, A.1.1
See also response files, silent mode, A.1
non-networked computers, 2.4.5
non-Oracle databases, listed, F.4
normal redundancy, Automatic Storage Management redundancy level, 2.11.2
nproc
shell limit on Linux x86, 2.6

O

OEM
See Oracle Enterprise Manager
oinstall group
checking for existing, 2.5.1
creating, 2.5.1
description, 2.5
OLAP tools
about, F.2
Oracle OLAP, F.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.3
creating the oinstall group, 2.5.1
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, B.1.1
Automatic Storage Management, B.3.3
changes for Oracle Database 10g, B.2
characteristics of an installation compliant with, B.1.1
concurrent execution of application software, B.1.1
conventions for creating mount points, B.3
distributed I/O loads, B.1.1
drive failure safeguards, B.1.1
file identification, B.3.6
file mapping, B.1.1, B.3.7
file naming, B.1.1
file system organization, B.1.1
files systems, B.3.1.1
hardware support, B.1.1
home directory distribution, B.1.1
I/O loads, B.1.1
login home directories, B.1.1
naming, B.3.1
database files, B.3.3
Oracle base directory, B.3.2
subdirectories, B.3.2.4
tablespaces, B.3.5
very large databases, B.3.1.3
Oracle Managed Files, B.3.3
pathnames, B.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, B.3.4
standard, B
tablespace contents, B.1.1
UNIX directory subtrees, B.1.1
using seperate segments, B.3.4
Oracle Application Server, F.2
Oracle applications
APPC-enabled systems, connecting to, F.4
IBM DRDA databases, connecting to, F.4
installing with Oracle Database, F.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, B.3.2
recommended path, 2.7.1
relationship with Oracle software owner user, 2.7.1
requirement for, 2.7.1
requirements for existing directory, 2.8.1
requirements on file system, 2.8.2
Oracle Cluster Registry
See OCR
Oracle Cluster Registry port, C.3
Oracle Clusterware
about, F.1
ports, C.3
ports, ranges and protocol, C.3
used with Automatic Storage Management, 1.5.1.2
used with Oracle Real Application Clusters, F.1
Oracle Connection Manager, installation guidelines, 3.2
Oracle CSS Daemon
configuration, deleting, 6.5.3
Oracle Data Mining
about, F.2
installing, F.2
Oracle Database
administering and monitoring, F.2
AS/400 applications, F.4
creating data file directories, 2.10.3
Custom installation, 1.3
Enterprise Edition installation, 1.3
installing with Oracle applications, F.3
installing with other Oracle components, F
minimum disk space requirements, 2.10.1
multiple databases on a single server with Automatic Storage Management, 3.5.1
privileged groups, 2.5
quick installation, F.1
requirements with Automatic Storage Management, 2.11.2
security management, F.2
setting ORACLE_SID environment variable, 2.14
Standard Edition installation, 1.3
upgrading, F.1
Web application development tools (HTML DB), F.3
Web servers, F.3
workflows, F.3
Oracle Database Client
configuring connections, F.1
Oracle Database Companion CD
components, F.3
Oracle Database components
administering and monitoring, F.2
connectivity FAQ, F.4
FAQ on installing, F.1
installing with Oracle applications, F.3
installing with Oracle Database tools, F.2
Oracle Database Configuration Assistant
response file, A.3.1
Oracle Database Examples, F.3
Oracle Database Recovery Manager (RMAN)
about, F.2
Automatic Storage Management, 1.5.1.2, 3.5.2
Oracle Enterprise Management Agent
HTTP port, changing, C.4
ports
ranges and protocol, C.3
Oracle Enterprise Manager, 1.5.2
Database Control
logging into, 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 Console
ports, ranges and protocol, C.3
Oracle Enterprise Manager Database Control
ports, changing, C.5
Oracle Enterprise Manager Migrate Database wizard, 3.5.2
Oracle Event Manager
ports, ranges and protocol, C.3
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
installation FAQ, F.3
Oracle HTTP Server
installation FAQ, F.3
Oracle internationalization class, 4.3.5.3
Oracle Internet Directory, F.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
checking for existing, 2.5.1
creating, 2.5.1, 2.5.1
description, 2.5
Oracle JDBC class, 4.3.5.3
Oracle Label Security
installation guidelines, 3.2, 3.4.1
post-installation tasks, 4.3.2
Oracle Managed Files
Optimal Flexible Architecture naming conventions, B.3.3
Oracle Messaging Gateway
CSD requirements
on Linux, 2.3
postinstallation tasks, 4.3.5
requirements on Linux, 2.3
Oracle Messaging Gateway class, 4.3.5.3
Oracle Migration Workbench
migrating non-Oracle applications to Oracle, F.3
migrating non-Oracle databases to Oracle, F.1
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
response file, A.3.1
Oracle Net Services
post-installation tasks, 4.3.1
Oracle OLAP
about, F.2
Oracle Precompilers
postinstallation tasks, 4.3.6
Oracle Procedural Gateway
about, F.4
listed products, F.4
Oracle Real Application Clusters (RAC)
installed before Oracle Database, 3.2
installing with Oracle Enterprise Manager, F.2
Oracle Clusterware
about, F.1
ports, ranges and protocol, C.3
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
creating, 2.5.4.1
raw device owner
on Linux, 2.12.4
Oracle software owner user
configuring environment for, 2.14
creating, 2.5.4
description, 2.5
determining default shell, 2.14
relationship with Oracle base directory, 2.7.1
setting shell limits for, 2.6
Oracle SQL*Net Listener
ports, ranges and protocol, C.3
Oracle Text Supplied Knowledge Bases, F.3
Oracle Text supplied knowledge bases
postinstallation tasks, 4.3.4
Oracle Transparent Gateway
about, F.4
listed products, F.4
Oracle Ultra Search
ports, changing, C.7
ports, ranges and protocol, C.3
Oracle Universal Installer
Automatic Storage Management behavior, 3.5.1
guidelines for using, 3.2
installation guidelines, 3.2, 3.4.1
response files, A
list of, A.3.1, A.3.1, A.3.1
running, 3.4.2
running in different languages, D.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, 2.5.4.1, 2.5.4.2
description, 2.5
determining default shell, 2.14
raw device owner
on Linux, 2.12.4
relationship with Oracle base directory, 2.7.1
setting shell limits for, 2.6
Oracle Workflow
installation FAQ, F.3
Oracle XML DB
ports, C.8
ports, changing, C.8
ports, ranges and protocol, C.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.8.1, 2.8.1
location, 2.5.1
location of, 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
and Automatic Storage Management disks on Linux, 2.12.4
and SYSDBA privilege, 2.5
creating, 2.5.2, 2.5.3
description, 2.5
raw device group
on Linux, 2.12.4
OSOPER group
and SYSOPER privilege, 2.5
description, 2.5
OTN Web site
downloading installation software from, 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, B.3.2.2
password file
raw device for
on Linux, 2.12.2
password file for Automatic Storage Management, 3.5.1
passwords
DBSNMP, 3.4.1
guidelines, 3.4.1
resetting, 5.5
with Database Control, 5.5.1
with SQL*Plus, 5.5.2
reviewing, 5.4
specifying for response files, A.1
SYS, 3.4.1
SYSMAN, 3.4.1
SYSTEM, 3.4.1
unlocking, 5.5
with Database Control, 5.5.1
with SQL*Plus, 5.5.2
See alsosecurity
PATH environment variable
setting, 2.14
pathnames
Optimal Flexible Architecture, B.3.2.2
permissions
for data file directories, 2.10.3
for Oracle base directory, 2.8.2
PL/SQL native compilation, 4.3.7
PL/SQL native compilaton, 4.3.7
port numbers
managing, C
portlist.ini file, 5.2, C.2
ports
access URLs, C.2
Cluster Manager, ranges and protocol, C.3
Cluster Synchronization Services, ranges and protocol, C.3
configured for applications, C.2
Connection Manager, ranges and protocol, C.3
Data Guard, ranges and protocol, C.3
default ranges, C
iSQL*Plus, changing, C.6
iSQL*Plus, ranges and protocol, C.3
Oracle Cluster Registry, C.3
Oracle Clusterware, C.3
Oracle Clusterware, ranges and protocol, C.3
Oracle Enterprise Management Agent HTTP, changing, C.4
Oracle Enterprise Management Agent, ranges and protocol, C.3
Oracle Enterprise Manager Database Console, ranges and protocol, C.3
Oracle Enterprise Manager Database Control, changing, C.5
Oracle Event Manager, ranges and protocol, C.3
Oracle Real Application Clusters (RAC), ranges and protocol, C.3
Oracle SQL*Net Listener, ranges and protocol, C.3
Oracle Ultra Search, changing, C.7
Oracle Ultra Search, ranges and protocol, C.3
Oracle XML DB, C.8
Oracle XML DB, changing, C.8
Oracle XML DB, ranges and protocol, C.3
post-installation
recommended tasks
client static library, generating, 4.2.5
root.sh script, backing up, 4.2.1
user accounts, setting up, 4.2.3
required tasks, 4.1
configuring GCC as the primary compiler, 4.3.7
configuring Oracle Messaging Gateway, 4.3.5
installing natively compiled Java Libraries for Oracle JVM and Oracle interMedia, 4.3.3
installing Oracle Text supplied knowledge bases, 4.3.4
Oracle Label Security, configuring, 4.3.2
Oracle Net Services, configuring, 4.3.1
Oracle Precompilers, 4.3.6
patches, installing and downloading, 4.1.1
Precompilers
requirements on Linux, 2.3
preconfigured database
Automatic Storage Management disk space requirements, 2.11.2
requirements when using Automatic Storage Management, 2.11.2, 2.11.2
privilege, 2.5
privileged groups
for Oracle Database, 2.5
Pro*C/C++
configuring, 4.3.6.1
requirements on Linux, 2.3
See also C compiler
process
stopping existing, 2.13
stopping existing listener process, 2.13
stopping listener process, 2.13
processor
checking system architecture, 2.2
/proc/sys/fs/file-max file, 2.6
/proc/sys/kernel/sem file, 2.6
/proc/sys/kernel/shmall file, 2.6
/proc/sys/kernel/shmmni file, 2.6
/proc/sys/net/core/rmem_default file, 2.6
/proc/sys/net/core/rmem_max file, 2.6
/proc/sys/net/core/wmem_default file, 2.6
/proc/sys/net/core/wmem_max file, 2.6
/proc/sys/net/ipv4/ip_local_port_range file, 2.6
profile file, 2.6, 2.14
profile.local file, 2.6, 2.6
ps command, 2.13

R

RAC
configuring disks for raw devices on Linux, 2.12.2
RAID
device names, 2.11.5.1, 2.11.5.2
device names on Linux, 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
on Linux, 2.12.2
for server parameter file
on Linux, 2.12.2
for SPFILE
on Linux, 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
on Linux, 2.12.2
for EXAMPLE tablespace
on Linux, 2.12.2
for redo log files
on Linux, 2.12.2
for SYSAUX tablespace
on Linux, 2.12.2
for SYSTEM tablespace
on Linux, 2.12.2
for TEMP tablespace
on Linux, 2.12.2
for UNDOTBS tablespace
on Linux, 2.12.2
for USER tablespace
on Linux, 2.12.2
specifing location of mapping file, 2.14
specifying owner and permissions, 2.12.4
storage option for data files, 2.9, 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, F.4
readme.txt file, C.2
reconfiguring CSS, 6.5
recovery files
options for placing on file system, 2.10
recovery of databases
Oracle Backup and Recovery, F.2
Red Hat
binding partitions to raw devices, 2.12.4
operating system requirements, 2.3
Red Hat Package Manager
See RPM
redo log, B.3.3
redo log files
in starter database, 5.8.2
locating, 5.8.2
naming, B.3.3
raw devices for
on Linux, 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
about, A.1
Automatic Storage Management, A.1.2
creating with template, A.3.1
custom.rsp, A.3.1
dbca.rsp, A.3.1
enterprise.rsp, A.3.1
general procedure, A.1.3
Net Configuration Assistant, A.5
netca.rsp, A.3.1
passing values at command line, A.1
passwords, A.1
security, A.1
specifying with Oracle Universal Installer, A.4
standard.rsp, A.3.1
See also silent mode, noninteractive mode, A.1
response files installation
about, A
rmem_default file, 2.6
rmem_default parameter
recommended value on Linux, 2.6
rmem_max file, 2.6
rmem_max parameter
recommended value on Linux, 2.6
RMS database, F.4
roadmap for installing Oracle Database components, F
root user, 3.4.2, 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

SAN (storage area network) disks, 2.11.4
SCSI disks
device names, 2.11.5.1, 2.11.5.2
device names on Linux, 2.12.3
security
management tools, F.2
See alsopasswords
sem file, 2.6
semmni parameter
recommended value on Linux x86, 2.6
semmns parameter
recommended value on Linux x86, 2.6
semmsl parameter
recommended value on Linux x86, 2.6
semopm parameter
recommended value on Linux x86, 2.6
server parameter file
raw device for
on Linux, 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
default shell startup file, 2.6
determining default shell for oracle user, 2.14
SHELL environment variable
checking value of, 2.14
shell limits
setting, 2.6
setting on Linux x86, 2.6
shell startup file
editing, 2.14
removing environment variables, 2.14
shmall file, 2.6
shmall parameter
recommended value on Linux x86, 2.6
shmmax parameter
recommended value on Linux x86, 2.6
shmmni file, 2.6
shmmni parameter
recommended value on Linux x86, 2.6
SID, 5.6
setting ORACLE_SID environment variable, 2.14
silent mode
about, A.1
reasons for using, A.1.1
See also noninteractive mode, response files, A.1
silent mode installation, A.3.2, A.4
software certification, 1.6.1
software requirements, 2.3
checking software requirements, 2.3
SPFILE
raw device for
on Linux, 2.12.2
SPFILE server parameter file, 3.5.1
spnc_commands configuration file, 4.3.7
SQL Server database, F.4
SQLJ class, 4.3.5.3
standard.rsp files, A.3.1
startup file
default shell startup file, 2.6
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
suppressed mode
reasons for using, A.1.1
suppressed mode. See noninteractive mode
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, F.4
SYS user password, 3.4.1
SYSAUX tablespace
raw device for
on Linux, 2.12.2
sysctl command, 2.6, 2.6
sysctl.conf file, 2.6
SYSDBA privilege
associated operating system group, 2.5
SYSMAN user password, 3.4.1
SYSOPER privilege
associated operating system group, 2.5
system architecture
checking, 2.2
System Identifier, 5.6
See SID
SYSTEM tablespace
raw device for
on Linux, 2.12.2
SYSTEM user password, 3.4.1

T

tablespaces
defined, 5.8.1
in databases, 5.8.1
reviewing, 5.8
setting up, 5.8.1
Optimal Flexible Architecture
naming, B.3.5
special tablespaces, B.3.4
tcsh shell
setting shell limits on Linux x86, 2.6
TEMP environment variable, 2.2
setting, 2.14
TEMP tablespace
raw device for
on Linux, 2.12.2
temporary disk space
requirements, 2.2
Teradata database, F.4
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, E
fatal errors, E.5.2

U

ulimit command, 2.6
umask, 2.14
umask command, 2.14, 2.14
UNDOTBS tablespace
raw device for
on Linux, 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
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, 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, B.1.1
UNIX groups
checking for existing oinstall group, 2.5.1
creating the dba group, 2.5.2
UNIX users
creating the oracle user, 2.5.4.1
setting shell limits for on Linux x86, 2.6
UNIX workstation
installing from, 2.1
unprivileged user
checking existence of, 2.5.5
nobody user, 2.5
unset command, 2.14
unsetenv command, 2.14
upgraded databases
configuring, 4.2.2
upgrading
advantages with separate Oracle homes, 3.5.1
USER tablespace
raw device for
on Linux, 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, 2.5.4.1
operating system nobody user, 2.5
Oracle software owner user, 2.5
setting shell limits for UNIX users on Linux x86, 2.6
UTLRP.SQL
recompiling invalid SQL modules, 4.2.2

V

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

W

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

X

X Window
display errors, E.1
X Window system
enabling remote hosts, 2.1, 2.1
xhost command, 2.1
xterm command, 2.1