Skip Headers
Oracle® Database Installation Guide
11g Release 1 (11.1) for AIX Based Systems

B32076-07
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
PDF · Mobi · ePub

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

accounts
reviewing, 5.6
unauthenticated access to, 5.7.2
ADMIN account
changing password for Oracle HTTP Server 9.0.3, 4.4.5.1
AIX
character raw device names, 2.12.7
checking disk availability for ASM, 2.12.7
configuring disks for ASM, 2.12.7
identifying disks for ASM, 2.12.7
identifying LVM disks, 2.12.7
initializing disks for LVM, 2.12.7
aliases, multiple on computers, 2.5.4
ANONYMOUS user
unauthenticated account access with, 5.7.2
APPC-enabled databases, H.4
Application Express
getting started, 4.4.10
logging in to, 4.4.10
setting up, 4.4.10.2
user roles, 4.4.10.1
Application Express Administration Services, 4.4.10.2
Application Express administrator, 4.4.10.1
Application Express user roles
Application Express administrator, 4.4.10.1
developer, 4.4.10.1
end user, 4.4.10.1
workspace administrator, 4.4.10.1
applications, migrating non-Oracle applications to Oracle, H.3
ASM
changing owner and permissions of disks
on AIX, 2.12.7
character raw device names on AIX, 2.12.7
checking disk availability on AIX, 2.12.7
configuring disks
on AIX, 2.12.7
identifying available disks on AIX, 2.12.7
identifying disks on AIX, 2.12.7
ASM See Automatic Storage Management
asmcmd utility, 3.6.4
authorized problem analysis report
See APAR
Automatic Storage Management
asmcmd utility, 3.6.4
changing owner and permissions of disks, 2.12.5
character raw device names, 2.12.5
characteristics of failure groups, 2.12.2
checking disk availability, 2.12.5
configuring disks, 2.12.1, 2.12.3, 2.12.5
considerations before installing, 3.6.1
DAS disks, 2.12.4
database creation for, 3.6.3
disk devices, 1.7.2
disk groups, 2.12.2
disks, supported, 2.12.4
Enterprise Manager Migrate Database wizard, 3.6.2
failure groups
examples, 2.12.2, 2.12.2
identifying, 2.12.2
identifying available disks, 2.12.5
identifying disks, 2.12.5
installation, testing, 3.6.4
installing, 3.6
managing, 5.3.2
migrating existing databases to, 3.6.2
mirroring, 2.12.2
Optimal Flexible Architecture file naming conventions, D.2.3
Oracle Clusterware, 1.7.2
Oracle home location for new installation, 3.6.1
partition creation, 2.12.4
password file, 3.6.1
recommendations for disk groups, 2.12.2
redundancy levels, 2.12.2
removing, 6.6
response files, A.1.2
running multiple databases on a single server, 3.6.1
SAN disks, 2.12.4
space required for preconfigured database, 2.12.2
SPFILE server parameter file, 3.6.1
starting and stopping, 5.3.1
upgrade advantages with separate Oracle homes, 3.6.1
Automatic Storage Management (ASM)
ASM disk group templates, 1.7.2
templates, 1.7.2
upgrading, 3.5.1
Automatic Storage Management disk groups
about, 1.7.2
creating, 3.6.2
managing, 5.3.2
Automatic Storage Management failure groups
about, 1.7.2
Automatic Storage Management instance
about, 1.7.2
creating, 3.6.2

B

backups of database
Oracle Database Recovery Manager, H.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
Bourne shell
default user startup file, 2.14

C

C compiler
requirement, 2.3.2
See also Pro*C/C++
C shell
default user startup file, 2.14
certification, hardware and software, 1.3.1
cfgmgr command, 2.12.5
character raw device
device name, 2.12.5
device name on AIX, 2.12.7
character raw device names, 2.12.5
chdev command, 2.12.7
checking disk availability for Automatic Storage Management, 2.12.5
checking distribution of the operating system, 2.3.1
checking version of the operating system, 2.3.1
chmod command, 2.9.2, 2.11.2, 2.12.5, 2.12.7
chown command, 2.9.2, 2.11.2, 2.12.5, 2.12.7
CLASSPATH environment variable, 4.3.4.3
client static library, generating, 4.2.5
cloning
Oracle home, B
Cluster Manager
ports, ranges and protocol, E.3
Cluster Ready Services (CSS). See Oracle Clusterware
Cluster Synchronization Services (CSS)
Automatic Storage Management, 1.7.2
ports, ranges and protocol, E.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
computers with multiple aliases, 2.5.4
computers, non-networked, 2.5.5
configuration assistants
failure, G.7.1
troubleshooting, G.7, G.7
configuring
Oracle Application Server 11g (new), 4.4.5.2
Oracle HTTP Server (new), 4.4.5
Oracle HTTP Server 11g (new), 4.4.5.2
configuring disks for Automatic Storage Management, 2.12.1, 2.12.3, 2.12.5
configuring new disks, 2.12.5
Connection Manager
ports, ranges and protocol, E.3
control files
locating, 5.10.3
naming, D.2.3
reviewing, 5.10
using Oracle Enterprise Manager Database Control with, 5.10.3
CONTROL_FILES initialization parameter, 5.10.3
country codes, I
CSD
download location for WebSphere MQ, 2.3.4.3
requirements
on AIX, 2.3.4.3
custom database
failure groups for Automatic Storage Management, 2.12.2
requirements when using Automatic Storage Management, 2.12.2, 2.12.2
custom.rsp file, A.3.1

D

dadTool.pl utility, 4.4.9
DAS (direct attached storage) disks, 2.12.4
data files
creating separate directories for, 2.11.2
defined, 5.10.1
managing with Automatic Storage Management, 1.7.2
minimum disk space for, 2.11.1
naming, D.2.3
options for placing on file system, 2.11
recommendations for file system, 2.11.1
reviewing, 5.10
setting permissions on data file directories, 2.11.2
setting up, 5.10.1
Data Guard
ports, ranges and protocol, E.3
data loss
minimizing with Automatic Storage Management, 2.12.2
data mining tools
Oracle Data Mining, H.2
Data Vault, 1.2.4
data warehousing tool
Oracle OLAP, H.2
Database Configuration Assistant
running in silent mode, A.6
troubleshooting, G.7
database configuration collections, 4.5
databases
Automatic Storage Management requirements, 2.12.2
files, 5.10.1
identifying, 5.8
initialization parameter file, 5.9
naming, 3.5.1, 3.6.3
non-Oracle
APPC-enabled, H.4
non-Oracle, listed, H.4
OLAP support (Oracle OLAP), H.2
Optimal Flexible Architecture file naming conventions, D.2.3
recovery with Oracle Backup and Recovery, H.2
redo log files, 5.10.2
removing, 6.5
removing Oracle HTML DB, 6.4
security management, H.2
tablespaces, 5.10.1
upgrading, 3.5.1
DB_DOMAIN initialization parameter, 5.8
DB_NAME initialization parameter, 5.8, 5.8
DB2 database, H.4
DB2 z/OS database, H.4
DB2/400 database, H.4
dba group
and ASM disks on AIX, 2.12.7
and Automatic Storage Management disks, 2.12.5
and SYSDBA privilege, 2.6
creating, 2.6.2, 2.6.2, 2.6.3, 2.6.4
description, 2.6
dbca.rsp file, A.3.1
default data files, 5.10.1
default file mode creation mask
setting, 2.14
default tablespaces, 5.10.1
deprecated and desupported components, Preface
developer, 4.4.10.1
device names, 2.12.5
on AIX, 2.12.7
DHCP computers, installing on, 2.5.2
directory
creating separate data file directories, 2.11.2
database file directory, 2.11.1
Oracle base directory, 2.8.1, 2.8.1
Oracle home directory, 2.8.3, 2.8.3
Oracle Inventory directory, 2.8.2
oraInventory, 2.8.2
permission for data file directories, 2.11.2
disc
mounting, 3.3.2.1
disk devices
in Automatic Storage Management, 1.7.2
managing with Automatic Storage Management, 1.7.2
disk space
checking, 2.2.3
requirements for preconfigured database in Automatic Storage Management, 2.12.2, 2.12.2
disks
changing permissions and owner for ASM
on AIX, 2.12.7
changing permissions and owner for Automatic Storage Management, 2.12.5
checking availability for ASM on AIX, 2.12.7
checking availability for Automatic Storage Management, 2.12.5
configuring for ASM on AIX, 2.12.7
configuring for Automatic Storage Management, 2.12.1, 2.12.3, 2.12.5
configuring new disks, 2.12.5
identifying LVM disks, 2.12.5
identifying LVM disks on AIX, 2.12.7
supported for Automatic Storage Management, 2.12.4
DISPLAY environment variable
setting, 2.14
DOMAIN_NAME initialization parameter, 5.8
Dynamic Host Configuration Protocol. See DHCP

E

embedded PL/SQL gateway
about, 4.4.2.1
disabling, 4.4.3.2
enabling, 4.4.3.2
end user, 4.4.10.1
enterprise.rsp file, A.3.1
env command, 2.14
environment
checking settings, 2.14
configuring for oracle user, 2.14
environment variables
DISPLAY, 2.14
NLS_LANG, F.1.1.2
ORACLE_BASE, 2.9.2, 2.14
ORACLE_HOME, 2.13, 2.14, 2.14
ORACLE_HOSTNAME, 2.5.3
ORACLE_SID, 2.14
PATH, 2.14
removing from shell startup file, 2.14
SHELL, 2.14
TMP and TMPDIR, 2.2.3, 2.14
TNS_ADMIN, 2.14
errors
configuration assistants, G.7
installation, G.3, G.4, G.7.2
noninteractive installation, G.8
silent mode, G.8
X Window, G.1
X Window display errors, G.2
EXAMPLE tablespace
description, 5.10.1
example01.DBF data file, 5.10.1
example01.DBF data file, 5.10.1
examples
Automatic Storage Management failure groups, 2.12.2, 2.12.2
Oracle base directories, 2.8.1
external redundancy
Automatic Storage Management redundancy level, 2.12.2

F

failure group
examples of Automatic Storage Management failure groups, 2.12.2
failure groups
characteristics of Automatic Storage Management failure group, 2.12.2
examples in Automatic Storage Management, 2.12.2
in Automatic Storage Management, 1.7.2
fatal errors, G.7.2
features
deprecated, Preface
file mode creation mask
setting, 2.14
file sets, 2.3
file system
appropriate for Oracle base directory, 2.9.2
data file and recovery file placement options, 2.11
NFS, 1.3.4
requirements for Oracle base directory, 2.9.2
using for data files, 2.11.1
writing to, 1.3.4
files, D.2.3
$ORACLE_HOME/dbs/initsid.ora, 5.9
$ORACLE_HOME/install/portlist.ini, 5.2, 5.2
.bash_profile, 2.14
contol, D.2.3
control, 5.10.3
custom.rsp, A.3.1
data files, D.2.3
dbca.rsp, A.3.1
editing shell startup file, 2.14
enterprise.rsp, A.3.1
/etc/group, D.2.2.3
/etc/passwd, D.2.2.3
listener.ora, 4.3.1
.login, 2.14
mgw.ora, 4.3.4.3
oraInst.loc, 2.6.1, 2.6.1
oraInst.loc file, A.2
oratab, 2.9.1, 2.9.1
.profile, 2.14
redo log, 5.10.2
response files, A.3
standard.rsp, A.3.1
tnsnames.ora, 4.3.1

G

Gateways products FAQ, H.4
getting started
Application Express, 4.4.10
Global Database Name
about, 3.5.1, 3.6.3
global database name, 5.8
globalization support, F
Grid Control. See Oracle Enterprise Manager Grid Control
group file, D.2.2.3
groups
checking for existing oinstall group, 2.6.1
creating the dba group, 2.6.2, 2.6.3, 2.6.4
creating the oinstall group, 2.6.1

H

hardware certification, 1.3.1
hardware requirements, 2.2
high redundancy
Automatic Storage Management redundancy level, 2.12.2
home directory
See Oracle home directory
host name, setting before installation, 2.5.3
HTTP Server
choosing, 4.4.2
httpd.conf
modifications if running Oracle9i, 4.4.5.1

I

IBM DB2 database, H.4
IBM DB2 z/OS database, H.4
IBM DB2/400 database, H.4
IBM WebSphere MQ
requirement on AIX, 2.3.4.3
IBM WebSphere MQ Series databases, H.4
identifying disks for Automatic Storage Management, 2.12.5
identifying LVM disks, 2.12.5
Informix Server database, H.4
initialization parameter
job_queue_process, 4.5
initialization parameter file
description, 5.9
in databases, 5.9
initsid.ora, 5.9
initialization parameters
DB_NAME, 5.8
DOMAIN_NAME, 5.8
SERVICE_NAMES, 5.8
initsid.ora file, 5.9
initsid.ora initialization parameter file, 5.9
installation
accessing installation software, 3.3
Automatic Storage Management requirements, 2.12.2
available products, 1.5, 1.5
cleaning up after a failed installation, G.9
clusters, installation guidelines, 3.2
component-specific guidelines, 3.2
computer aliases, multiple, 2.5.4
considerations, 1.3
errors, G.4, G.7.2
silent mode, G.8
laptops, 2.5.5
log files, G.3, G.3
noninteractive
error handling, G.8
oraInst.loc file, A.2
overview, 1
reinstalling Oracle software, 3.2
response files, A, A.3
preparing, A.3, A.3.2
silent mode, G.8
templates, A.3
silent mode, A.3.2, A.4
upgrading, H.1
installation errors
steps to resolve, G.3
installation guidelines, 3.5.1, 3.5.1
Oracle Label Security, 3.2
installation overview, 1.1
installation software
copying to a hard disk, 3.3.2.2
extracting, 3.3.1.2
installation software, accessing, 3.3
installCCRSQL.sh, 4.5.1, G.6
installing
other languages, 4.4.7
instance
instance identifier (SID), 2.14
IP addresses, multiple, 2.5.3
IPC protocol address
Oracle Messaging Gateway setting, 4.3.4.1

J

JDK
internationalization class, 4.3.4.3
run-time class, 4.3.4.3
JDK requirements, 2.3

K

Korn shell
default user startup file, 2.14

L

languages
installing Oracle components in different languages, F.2
using Oracle components in different languages, F.1.2
laptops, installing Oracle Database on, 2.5.5
License
Custom installation, 1.1, 3.5.1
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.4.1
local device
using for data files, 2.11.1
log files, G.3, G.3
troubleshooting, G.4
logical volume manager
See LVM
.login file, 2.14
loopback adapters
non-networked computers, 2.5.5
lsdev command, 2.12.5, 2.12.7
lsnrctl command, 2.13
lspv command, 2.12.5, 2.12.7
LVM
identifying volume group devices, 2.12.5
identifying volume group devices on AIX, 2.12.7
initializing disks on AIX, 2.12.7
recommendations for Automatic Storage Management, 2.12.2

M

mask
setting default file mode creation mask, 2.14
memory requirements, 2.2
MGW_AGENT service name, 4.3.4.2
mgwextproc service
adding static service information, 4.3.4.1
mgw.ora file
modifying, 4.3.4.3
Microsoft SQL Server database, H.4
migrating applications to Oracle, H.3
migrating non-Oracle databases to Oracle, H.1
mirroring Automatic Storage Management disk groups, 2.12.2
mkdir command, 2.9.2, 2.11.2
Mode
Connected, 4.5
Disconnected, 4.5
mode
setting default file mode creation mask, 2.14
mount point
for Oracle base directory, 2.8.1
mount point directories, 3.3.2.2
mount point directory
choosing, C.3
mount points
Optimal Flexible Architecture conventions for creating, D.2
MQSeries
class, 4.3.4.3
multihomed computers, installing on, 2.5.3
multiple aliases, computers with, 2.5.4
multiple Oracle homes, 1.3.2

N

naming subdirectories, D.2.2.5
NAS devices
creating files on for use with Automatic Storage Management, C.4
guidelines for configuration, C.1
Net Configuration Assistant
troubleshooting, G.7
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.5.4
non-networked computers, 2.5.5
primary, on computers with multiple aliases, 2.5.4
See also loopback adapters, primary network adapters
network cards, multiple, 2.5.3
Network File System See NFS
network setup
about, 2.5
computers with multiple aliases, 2.5.4
network topics
DHCP computers, 2.5.2
laptops, 2.5.5
multiple network cards, 2.5.3
non-networked computers, 2.5.5
new installation
adding entry for Application Express, 4.4.5.1
adding new MIME types, 4.4.5.1
configuring Oracle Application Server 10g, 4.4.5.2, 4.4.5.2
configuring Oracle HTTP Server, 4.4.5
configuring Oracle HTTP Server 9.0.3, 4.4.5.1
modifications to support SQL Workshop, 4.4.5.1
modifying httpd.conf, 4.4.5.1
modifying marvel.conf, 4.4.5.2
modifying wdbsvr.app, 4.4.5.1
NFS
mount options, C.5
using for installation, 1.3.4
NLS_LANG environment variable, F.1.1.2
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, G.8
noninteractive mode
about, A.1
reasons for using, A.1.1
See also response files, silent mode, A.1
non-networked computers, 2.5.5
non-Oracle databases, listed, H.4
normal redundancy, Automatic Storage Management redundancy level, 2.12.2

O

obfuscate
password, 4.4.9
OEM
See Oracle Enterprise Manager
oinstall group
checking for existing, 2.6.1
creating, 2.6.1
description, 2.6
OLAP tools
about, H.2
Oracle OLAP, H.2
OLS
See Oracle Label Security
OMF
See Oracle Managed Files
online help
not working, G.12
oper group
and SYSOPER privilege, 2.6
creating, 2.6.3, 2.6.4
description, 2.6
operating system
checking distribution and version, 2.3.1
operating system groups
creating the dba group, 2.6.3, 2.6.4
creating the oinstall group, 2.6.1
oinstall, 2.6
OSDBA, 2.6
OSOPER, 2.6
osoper, 2.6
requirements, 2.6
operating system requirements, 2.3
operating system users
creating the oracle user, 2.6.5
oracle, 2.6
requirements, 2.6
root user, 3.5.1
Optimal Flexible Architecture
Automatic Storage Management, D.2.3
conventions for creating mount points, D.2
file identification, D.2.5
file mapping, D.2.6
files systems, D.2.1.1
naming, D.2.1
database files, D.2.3
Oracle base directory, D.2.2
subdirectories, D.2.2.5
very large databases, D.2.2.2
Oracle Managed Files, D.2.3
pathnames, D.2.2.3
recommendations for Oracle base directory, 2.8.1
recommended path for Oracle base directory, 2.8.1
recommended path for Oracle home directory, 2.8.3
recommended path for Oracle Inventory directory, 2.8.2
special tablespaces, D.2.4
standard, D
using seperate segments, D.2.4
Oracle Application Server, H.2
Oracle applications
installing with Oracle Database, H.3
Oracle base directory
creating, 2.9.2
creating new, 2.9.2
description, 2.8.1
determining disk space on, 2.9.1
equivalent directory on Microsoft Windows, 2.8.1
examples, 2.8.1
identifying appropriate file system, 2.9.2
identifying existing, 2.9.1
mount point for, 2.8.1
naming conventions, D.2.2
recommended path, 2.8.1
relationship with Oracle software owner user, 2.8.1
requirement for, 2.8.1
requirements for existing directory, 2.9.1
requirements on file system, 2.9.2
Oracle Cluster Registry
See OCR
Oracle Cluster Registry port, E.3
Oracle Clusterware
about, H.1
ports, E.3
ports, ranges and protocol, E.3
used with Automatic Storage Management, 1.7.2
used with Oracle Real Application Clusters, H.1
Oracle components
using in different languages, F.1.2
Oracle CSS Daemon
configuration, deleting, 6.7.3
Oracle Data Mining
about, H.2
installing, H.2
Oracle Database
administering and monitoring, H.2
creating data file directories, 2.11.2
Custom installation, 1.5
Enterprise Edition installation, 1.5
getting started using
accessing, 5.4, 5.5
starting and stopping database, 5.4, 5.5
installing with Oracle applications, H.3
minimum disk space requirements, 2.11.1
multiple databases on a single server with Automatic Storage Management, 3.6.1
naming, 3.5.1, 3.6.3
privileged groups, 2.6
requirements with Automatic Storage Management, 2.12.2
security management, H.2
setting ORACLE_SID environment variable, 2.14
Standard Edition installation, 1.5
upgrading, H.1
Web servers, H.3
Oracle Database Client
configuring connections, H.1
Oracle Database components
administering and monitoring, H.2
connectivity FAQ, H.4
FAQ on installing, H.1
installing with Oracle applications, H.3
installing with Oracle Database tools, H.2
Oracle Database Configuration Assistant
response file, A.3.1
Oracle Database Recovery Manager (RMAN)
about, H.2
Automatic Storage Management, 1.7.2, 3.6.2
Oracle Database SID
about, 3.5.1
naming rules, 3.5.1
Oracle Database Vault
postinstallation task, 4.3.3
Oracle E-Business Suite, 4.5.3, 6.3
Oracle Enterprise Management Agent
HTTP port, changing, E.4
ports
ranges and protocol, E.3
Oracle Enterprise Manager, 1.8
Database Control
logging into, 5.2
port number, 5.2
using to modify control files, 5.10.3
using to modify redo log files, 5.10.2
using to view control files, 5.10.3
using to view redo log files, 5.10.2
database migration to Automatic Storage Management, 3.6.2
login privileges, 5.2
Migrate Wizard, 3.6.2
Oracle Enterprise Manager Database Console
ports, ranges and protocol, E.3
Oracle Enterprise Manager Database Control
ports, changing, E.5
Oracle Enterprise Manager Migrate Database wizard, 3.6.2
Oracle Event Manager
ports, ranges and protocol, E.3
Oracle home
cloning, B
Oracle home directory
Automatic Storage Management considerations, 3.6.1
description, 2.8.3
identifying for listener, 2.13
multiple homes, network considerations, 2.5.3
recommended path, 2.8.3
requirement for, 2.8.3
requirements, 2.8.3
using to identify Oracle base directory, 2.9.1
Oracle home name, 2.8.3
Oracle host name, setting before installation, 2.5.3
Oracle HTML DB
removing from the database, 6.4
Oracle HTTP Server
about, 4.4.2.2
Oracle HTTP Server 9.0.3
changing ADMIN password, 4.4.5.1
configuring (new), 4.4.5.1
Oracle internationalization class, 4.3.4.3
Oracle Internet Directory, H.2
Oracle Inventory
description, 2.8.2
pointer file, 2.6.1, 2.6.1
Oracle Inventory directory
description, 2.8.2
recommended path, 2.8.2
Oracle Inventory group
checking for existing, 2.6.1
creating, 2.6.1, 2.6.1
description, 2.6
Oracle JDBC class, 4.3.4.3
Oracle Label Security
installation guidelines, 3.2
post-installation tasks, 4.3.2
Oracle Managed Files
Optimal Flexible Architecture naming conventions, D.2.3
Oracle Messaging Gateway
CSD requirements
on AIX, 2.3.4.3
postinstallation tasks, 4.3.4
requirements on AIX, 2.3.4.3
Oracle Messaging Gateway class, 4.3.4.3
Oracle Migration Workbench
migrating non-Oracle applications to Oracle, H.3
migrating non-Oracle databases to Oracle, H.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, H.2
Oracle Precompilers
postinstallation tasks, 4.3.5
Oracle Procedural Gateway
listed products, H.4
Oracle Real Application Clusters (RAC)
installed before Oracle Database, 3.2
installing with Oracle Enterprise Manager, H.2
Oracle Clusterware
about, H.1
Oracle Schemas, Preface
Oracle software
removing, 6.8
Oracle Software Owner user
and ASM disks, 2.12.7
and Automatic Storage Management disks, 2.12.5
creating, 2.6.5.1
Oracle software owner user
configuring environment for, 2.14
creating, 2.6.5
description, 2.6
determining default shell, 2.14
relationship with Oracle base directory, 2.8.1
Oracle SQL Developer
accessing, 5.5
Oracle SQL*Net Listener
ports, ranges and protocol, E.3
Oracle Technology Network (OTN)
downloading documentation from, Preface
Oracle Text knowledge base, 4.3.7
Oracle Transparent Gateway
listed products, H.4
Oracle Ultra Search
ports, changing, E.6
ports, ranges and protocol, E.3
Oracle Universal Installer
Automatic Storage Management behavior, 3.6.1
guidelines for using, 3.2
installation guidelines, 3.2
response files, A
list of, A.3.1, A.3.1, A.3.1
running, 3.5.1
running in different languages, F.2
oracle user
and ASM disks, 2.12.7
and Automatic Storage Management disks, 2.12.5
configuring environment for, 2.14
creating, 2.6.5, 2.6.5.1, 2.6.5.2
description, 2.6
determining default shell, 2.14
relationship with Oracle base directory, 2.8.1
Oracle XML DB
about, H.2
ports, E.7
ports, changing, E.7
ports, ranges and protocol, E.3
ORACLE_BASE environment variable, 2.9.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.5.3
computers with multiple aliases, 2.5.4
multihomed computers, 2.5.3
setting before installation, 2.5.3
ORACLE_SID environment variable
removing from shell startup file, 2.14
setting, 2.14
Oracle9i
modifying wdbsvr.app, 4.4.5.1
oraInst.loc file
location, 2.6.1, 2.6.1
location of, 2.6.1, 2.6.1
oraInventory directory
See Oracle Inventory directory
oratab file, 2.9.1
formats, 2.9.1
location of, 2.9.1
OSDBA group
and ASM disks on AIX, 2.12.7
and Automatic Storage Management disks, 2.12.5
and SYSDBA privilege, 2.6
creating, 2.6.2, 2.6.3, 2.6.4
description, 2.6
OSOPER group
and SYSOPER privilege, 2.6
description, 2.6
OTN Web site
downloading installation software from, 3.3.1
OUI
See Oracle Universal Installer

P

partition
using with Automatic Storage Management, 2.12.2
partitions
creation for Automatic Storage Management disks, 2.12.4
passwd command, 2.6.5.2
passwd file, D.2.2.3
password
obfuscating, 4.4.9
password file for Automatic Storage Management, 3.6.1
passwords
resetting, 5.7
with Database Control, 5.7.1
with SQL*Plus, 5.7.2
reviewing, 5.6
specifying for response files, A.1
unlocking, 5.7
with Database Control, 5.7.1
with SQL*Plus, 5.7.2
See alsosecurity
PATH environment variable
setting, 2.14
pathnames
Optimal Flexible Architecture, D.2.2.3
permissions
for data file directories, 2.11.2
for Oracle base directory, 2.9.2
port numbers
managing, E
portlist.ini file, 5.2, E.2
ports
access URLs, E.2
Cluster Manager, ranges and protocol, E.3
Cluster Synchronization Services, ranges and protocol, E.3
configured for applications, E.2
Connection Manager, ranges and protocol, E.3
Data Guard, ranges and protocol, E.3
default ranges, E
Oracle Cluster Registry, E.3
Oracle Clusterware, E.3
Oracle Clusterware, ranges and protocol, E.3
Oracle Enterprise Management Agent HTTP, changing, E.4
Oracle Enterprise Management Agent, ranges and protocol, E.3
Oracle Enterprise Manager Database Console, ranges and protocol, E.3
Oracle Enterprise Manager Database Control, changing, E.5
Oracle Event Manager, ranges and protocol, E.3
Oracle SQL*Net Listener, ranges and protocol, E.3
Oracle Ultra Search, changing, E.6
Oracle Ultra Search, ranges and protocol, E.3
Oracle XML DB, E.7
Oracle XML DB, changing, E.7
Oracle XML DB, ranges and protocol, E.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 Oracle Messaging Gateway, 4.3.4
Oracle Label Security, configuring, 4.3.2
Oracle Net Services, configuring, 4.3.1
Oracle Precompilers, 4.3.5
patches, installing and downloading, 4.1.1
postinstallation tasks
configuring embedded PL/SQL gateway, 4.4.3
configuring Oracle Application Server 11g, 4.4.5.2
configuring Oracle HTTP Server (new), 4.4.5
configuring Oracle HTTP Server 9.0.3, 4.4.5.1
installing other languages, 4.4.7
logging in to Application Express, 4.4.10
obfuscating passwords, 4.4.9
Oracle Text knowledge base, 4.3.7
Precompilers
requirements, 2.3.2
preconfigured database
Automatic Storage Management disk space requirements, 2.12.2
requirements when using Automatic Storage Management, 2.12.2, 2.12.2
privilege, 2.6
privileged groups
for Oracle Database, 2.6
Pro*C/C++
configuring, 4.3.5.1
requirements, 2.3.2
See also C compiler
process
stopping existing, 2.13
stopping existing listener process, 2.13
stopping listener process, 2.13
.profile file, 2.14
program technical fix
See PTF
ps command, 2.13
PVID
clearing from disk device, 2.12.7

R

RAID
recommended Automatic Storage Management redundancy level, 2.12.2
using for Oracle data files, 2.11.1
RAM requirements, 2.2
raw devices
initializing disks for LVM on AIX, 2.12.7
readme.txt file, E.2
reconfiguring CSS, 6.7
recovery files
options for placing on file system, 2.11
recovery of databases
Oracle Backup and Recovery, H.2
redo log, D.2.3
redo log files
in starter database, 5.10.2
locating, 5.10.2
naming, D.2.3
reviewing, 5.10
using Oracle Enterprise Manager Database Control with, 5.10.2
redundancy level
and space requirements for preconfigured database, 2.12.2, 2.12.2
for Automatic Storage Management, 2.12.2
redundant array of independent disks
See RAID
reinstalling Oracle software, 3.2
removing
Oracle HTML DB from the database, 6.4
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
root user, 3.5.1, 3.5.1
logging in as, 2.1
root.sh script
backing up, 4.2.1

S

Sample Schemas
tablespaces and data files, 5.10.1
SAN (storage area network) disks, 2.12.4
schemas
database schema passwords, 3.5.1
Oracle HTML DB schema removal, 6.4
Oracle Schemas, about, Preface
Sample Schemas tablespaces and data files, 5.10.1
security
management tools, H.2
See alsopasswords
server parameter file (SPFILE), 3.6.1
SERVICE_NAMES initialization parameter, 5.8, 5.8
shell
determining default shell for oracle user, 2.14
SHELL environment variable
checking value of, 2.14
shell startup file
editing, 2.14
removing environment variables, 2.14
SID, 5.8
setting ORACLE_SID environment variable, 2.14
SID. See Oracle Database SID
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
smit command, 2.6.1, 2.6.2, 2.6.3, 2.6.4, 2.6.5.2
software certification, 1.3.1
software requirements, 2.3
SPFILE server parameter file, 3.6.1
SQL Developer
accessing, 5.5
SQL Server database, H.4
SQL*Plus
accessing, 5.4
SQLJ class, 4.3.4.3
standard.rsp files, A.3.1
startup file
for shell, 2.14
static service information
adding for mgwextproc service, 4.3.4.1
storage area network disks, 2.12.4
storage management See Automatic Storage Management
suppressed mode
reasons for using, A.1.1
suppressed mode. See noninteractive mode
swap space
checking, 2.2.1
requirements, 2.2
Sybase Adapter Server database, H.4
SYS, 4.5.2
SYSDBA, 4.5.2
SYSDBA privilege
associated operating system group, 2.6
SYSOPER privilege
associated operating system group, 2.6
SYSTEM
tablespace, description, 5.10.1
System Identifier, 5.8
See SID
system01.dbf data file, 5.10.1, 5.10.1

T

tablespaces, 5.10.1
defined, 5.10.1
in databases, 5.10.1
reviewing, 5.10
setting up, 5.10.1
expanding for large sorts, 5.10.1
Optimal Flexible Architecture
special tablespaces, D.2.4
SYSTEM, 5.10.1
TEMP, 5.10.1
UNDOTBS, 5.10.1
USERS, 5.10.1
TEMP
tablespace (temp01.dbf), 5.10.1
temp01.dbf data file, 5.10.1
temporary disk space
requirements, 2.2
Teradata database, H.4
TMP environment variable, 2.2.3
setting, 2.14
TMPDIR environment variable, 2.2.3
setting, 2.14
TNS_ADMIN environment variable
unsetting, 2.14
tnsnames.ora file, 4.3.1
adding a connect descriptor, 4.3.4.2
MGW_AGENT service name, 4.3.4.2
modifying for external procedures, 4.3.4.2
translated version
installing, 4.4.7
troubleshooting, G
ASM failure to mount disk group, 2.12.7
fatal errors, G.7.2
images, G.11
online help not working, G.12

U

umask, 2.14
umask command, 2.14, 2.14
UNDOTBS
tablespace (undotbs01.dbf), 5.10.1
Uninstall, 6.3, 6.4, 6.5, 6.6
uninstall, 6.3, 6.4, 6.5, 6.6
UNIX commands, 2.14
cfgmgr, 2.12.5
chdev, 2.12.7
chmod, 2.9.2, 2.11.2, 2.12.5, 2.12.7
chown, 2.9.2, 2.11.2, 2.12.5, 2.12.7
env, 2.14
lsdev, 2.12.5, 2.12.7
lspv, 2.12.5, 2.12.7
mkdir, 2.9.2, 2.11.2
passwd, 2.6.5.2
ps, 2.13
smit, 2.6.1, 2.6.2, 2.6.3, 2.6.4, 2.6.5.2
umask, 2.14
unset, 2.14
unsetenv, 2.14
xhost, 2.1
xterm, 2.1
UNIX groups
checking for existing oinstall group, 2.6.1
creating the dba group, 2.6.2
UNIX users
creating the oracle user, 2.6.5.1
UNIX workstation
installing from, 2.1
unset command, 2.14
unsetenv command, 2.14
upgraded databases
configuring, 4.2.2
upgrading
advantages with separate Oracle homes, 3.6.1
Automatic Storage Management, 3.5.1
databases, 3.5.1
obfuscating password, 4.4.9.1
user roles
Application Express administrator, 4.4.10.1
developer, 4.4.10.1
end user, 4.4.10.1
workspace administrator, 4.4.10.1
USERS
tablespace (users01.dbf), 5.10.1
users
creating the oracle user, 2.6.5, 2.6.5.1
Oracle software owner user, 2.6
UTLRP.SQL
recompiling invalid SQL modules, 4.2.2

V

very large databases
Optimal Flexible Architecture naming mount points, D.2.2.2

W

wdbsvr.app
modifications if running Oracle9i, 4.4.5.1
Web servers (Oracle HTTP Server), H.3
WebSphere MQ
CSD download location, 2.3.4.3
CSDs required
on AIX, 2.3.4.3
requirement on AIX, 2.3.4.3
WebSphere MQ class, 4.3.4.3
WebSphere MQ Series database, H.4
Windows
analogy for Oracle base directory, 2.8.1
workspace administrator, 4.4.10.1

X

X Window
display errors, G.1
X Window system
enabling remote hosts, 2.1, 2.1
xhost command, 2.1
XML data, H.2
XML DB HTTP server
disabling, 4.4.3.2
enabling, 4.4.3.2
xterm command, 2.1