Go to main content
18/18
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,
H.4
accounts
reviewing,
5.4
unauthenticated access to,
5.5.2
Advantage family of databases,
H.4
aliases, multiple on computers,
2.4.4
ANONYMOUS user
unauthenticated account access with,
5.5.2
APPC-enabled databases,
H.4
APPC-enabled systems,
H.4
applications, migrating non-Oracle applications to Oracle,
H.3
applications-based workflows,
H.3
architecture
checking system architecture,
2.2
AS/400 applications, accessing Oracle database,
H.4
ASM
See
Automatic Storage Management
asmcmd utility,
3.5.4
authorized problem analysis report
See
APAR
Automatic Storage Management
asmcmd utility,
3.5.4
block and character device names
on Solaris,
2.11.5
,
2.12
changing owner and permissions of disks
on Solaris,
2.11.5
characteristics of failure groups,
2.11.2
checking disk availability on Solaris,
2.11.5
,
2.12
configuring disks,
2.11.1
,
2.11.3
on Solaris,
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
Enterprise Manager Migrate Database wizard,
3.5.2
failure groups
examples,
2.11.2
,
2.11.2
identifying,
2.11.2
identifying available disks on Solaris,
2.11.5
,
2.12
identifying disks on Solaris,
2.11.5
,
2.12
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,
D.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,
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
block device
device name on Solaris,
2.11.5
,
2.12
,
2.12
Bourne shell
default user startup file,
2.14
C
C shell
default user startup file,
2.14
CD-ROMs
mounting,
3.3.2.1
certification, hardware and software,
1.6.1
character device
device name on Solaris,
2.11.5
,
2.12
,
2.12
Character Set Scanner,
1.7.1
chmod command,
2.8.2
,
2.10.3
,
2.11.5
chown command,
2.8.2
,
2.10.3
,
2.11.5
CLASSPATH environment variable,
4.3.5.3
client static library, generating,
4.2.5
cloning
Oracle home,
B
Cluster Ready Services (CSS).
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.7
primary,
4.3.7
computers with multiple aliases,
2.4.4
computers, non-networked,
2.4.5
configuration assistants
failure,
G.5.1
troubleshooting,
G.5
,
G.5
configuring disks for Automatic Storage Management,
2.11.1
,
2.11.3
Connection Manager
ports, ranges and protocol,
E.3
connectivity tools
Oracle Procedural Gateway
about,
H.4
Oracle Transparent Gateway
about,
H.4
See also
databases, non-Oracle
control files
locating,
5.8.3
naming,
D.3.3
raw devices for
on Solaris,
2.12
,
2.12
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
on Solaris,
2.3
requirements
on Solaris,
2.3
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,
D.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,
E.3
data loss
minimizing with Automatic Storage Management,
2.11.2
Data Mining Scoring Engine
about,
H.2
installing,
H.2
Data Mining Scoring Engine, installation guidelines,
3.2
data mining tools
Data Mining Scoring Engine,
H.2
Oracle Data Mining,
H.2
data warehousing tool
Oracle OLAP,
H.2
Database Configuration Assistant
running in silent mode,
A.6
troubleshooting,
G.5
databases
administrative information,
D.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,
H.4
iWay,
H.4
non-Oracle, listed,
H.4
OLAP support (Oracle OLAP),
H.2
Optimal Flexible Architecture file naming conventions,
D.3.3
recovery with Oracle Backup and Recovery,
H.2
redo log files,
5.8.2
removing,
6.3
security management,
H.2
tablespaces,
5.8.1
DB_DOMAIN initialization parameter,
5.6
DB_NAME initialization parameter,
5.6
,
5.6
DB2 database,
H.4
DB2 z/OS database,
H.4
DB2/400 database,
H.4
dba group
and Automatic Storage Management disks on Solaris,
2.11.5
and SYSDBA privilege,
2.5
creating,
2.5.2
,
2.5.2
,
2.5.3
description,
2.5
raw device group
on Solaris,
2.12
DBCA_RAW_CONFIG environment variable,
2.14
on Solaris,
2.12
on SPARC,
2.12
dbca.rsp file,
A.3.1
DBSNMP user password,
3.4.1
default file mode creation mask
setting,
2.14
deprecated and desupported components,
1.8
device names
on Solaris,
2.11.5
,
2.12
,
2.12
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
disk devices
in Automatic Storage Management,
1.5.1.2
managing with Automatic Storage Management,
1.5.1.2
disk mirroring,
D.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,
D.4.2
disks
changing permissions and owner for Automatic Storage Management
on Solaris,
2.11.5
checking availability for Automatic Storage Management on Solaris,
2.11.5
,
2.12
checking availability for raw devices on Solaris,
2.12
configuring for Automatic Storage Management,
2.11.1
,
2.11.3
configuring for Automatic Storage Management on Solaris,
2.11.5
configuring raw devices on Solaris,
2.12
device names on Solaris,
2.12
identifying file systems on Solaris,
2.11.5
,
2.12
,
2.12
identifying LVM disks on Solaris,
2.12
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,
D.1.1
Dynamic Host Configuration Protocol.
See
DHCP
E
e-business integration workflows,
H.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
,
2.12
DISPLAY,
2.14
,
2.14
NLS_LANG,
F.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
TMP and TMPDIR,
2.2
,
2.14
TNS_ADMIN,
2.14
errors
configuration assistants,
G.5
installation,
G.3
,
G.4
,
G.5.2
noninteractive installation,
G.6
silent mode,
G.6
X Window,
G.1
X Window display errors,
G.2
/etc/system file,
2.6
EXAMPLE tablespace
raw device for
on Solaris,
2.12
,
2.12
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,
H
fatal errors,
G.5.2
features
deprecated,
1.8
file mode creation mask
setting,
2.14
file naming,
D.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
identifying formatted devices on Solaris,
2.11.5
,
2.12
,
2.12
NFS,
1.6.4
organization,
D.1.1
using for data files,
2.10.1
writing to,
1.6.4
files,
D.3.3
$ORACLE_HOME/dbs/initsid.ora,
5.7
$ORACLE_HOME/install/portlist.ini,
5.2
,
5.2
.bash_profile,
2.14
contol,
D.3.3
control,
5.8.3
control files
raw devices for on Solaris,
2.12
,
2.12
custom.rsp,
A.3.1
data files,
D.3.3
dbca.rsp,
A.3.1
editing shell startup file,
2.14
enterprise.rsp,
A.3.1
/etc/group,
D.3.2.2
/etc/passwd,
D.3.2.2
/etc/system,
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 Solaris,
2.12
,
2.12
.profile,
2.14
raw device mapping file,
2.14
on Solaris,
2.12
redo log,
5.8.2
redo log files
raw devices for on Solaris,
2.12
,
2.12
response files,
A.3
server parameter file
raw devices for on Solaris,
2.12
,
2.12
SPFILE
raw device for on Solaris,
2.12
raw devices for on Solaris,
2.12
spnc_commands,
4.3.7
standard.rsp,
A.3.1
tnsnames.ora,
4.3.1
/var/opt/oracle/oraInst.loc,
G.4
,
G.4
format command,
2.11.5
,
2.12
,
2.12
frequently asked installation questions,
H
G
Gateways products FAQ,
H.4
GCC
postinstallation tasks,
4.3.7
GCC
See
GNU Compiler Collection (GCC)
global database name,
5.6
globalization support,
F
GNU Compiler Collection (GCC) configuration,
4.3.7
Grid Control.
See
Oracle Enterprise Manager Grid Control
group file,
D.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,
D.1.1
login,
D.1.1
See
Oracle home directory
host name, setting before installation,
2.4.3
I
IBM DB2 database,
H.4
IBM DB2 z/OS database,
H.4
IBM DB2/400 database,
H.4
IBM DRDA databases, connecting to,
H.4
IBM mainframe data, connecting to,
H.4
IBM WebSphere MQ Series databases,
H.4
id command,
2.5.5
Informix Server database,
H.4
Ingres II database,
H.4
initialization parameter file
description,
5.7
in databases,
5.7
init
sid
.ora,
5.7
initialization parameters
DB_NAME,
5.6
DOMAIN_NAME,
5.6
SERVICE_NAMES,
5.6
init
sid
.ora file,
5.7
init
sid
.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,
G.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,
G.4
,
G.5.2
silent mode,
G.6
FAQ for Oracle Database products,
H
guidelines,
3.4.1
laptops,
2.4.5
log files,
G.3
,
G.3
noninteractive
error handling,
G.6
oraInst.loc file,
A.2
quick installation,
H.1
reinstalling Oracle software,
3.2
response files,
A
,
A.3
preparing,
A.3
,
A.3.2
silent mode,
G.6
templates,
A.3
silent mode,
A.3.2
,
A.4
upgrading,
H.1
with other components,
H
installation errors
steps to resolve,
G.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
instfix command,
2.3
I/O loads,
D.1.1
Optimal Flexible Architecture,
D.1.1
IP addresses, multiple,
2.4.3
IPC protocol address
Oracle Messaging Gateway setting,
4.3.5.1
i
SQL*Plus
ports, changing,
E.6
ports, ranges and protocol,
E.3
iWay databases,
H.4
J
Java
font package requirements for Solaris,
2.3
Java Libraries for Oracle JVM and Oracle interMedia
postinstallation tasks,
4.3.3
JDK
font packages required on Solaris,
2.3
internationalization class,
4.3.5.3
run-time class,
4.3.5.3
JDK requirements,
2.3
JPublisher,
H.3
K
kernel parameters
checking on Solaris,
2.6
configuring on Solaris,
2.6
making changes persist on Solaris,
2.6
Korn shell
default user startup file,
2.14
L
languages
installing Oracle components in different languages,
F.2
laptops, installing Oracle Database on,
2.4.5
Legato Single Server Version (LSSV),
1.8
licensing information,
1.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,
G.3
,
G.3
troubleshooting,
G.4
logical volume manager
See
LVM
logical volumes
creating on Solaris,
2.12
.login file,
2.14
loopback adapters
non-networked computers,
2.4.5
lsnrctl command,
2.13
LVM
configuring raw devices on Solaris,
2.12
creating a volume group on Solaris,
2.12
creating raw logical volumes on Solaris,
2.12
creating volume groups on Solaris,
2.12
identifying available disks on Solaris,
2.12
identifying volume group devices on Solaris,
2.12
initializing disks on Solaris,
2.12
recommendations for Automatic Storage Management,
2.11.2
Veritas Volume Manager on Solaris,
2.12
M
mapping file
for raw devices,
2.14
on Solaris,
2.12
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,
H.4
migrating
See
upgrading
migrating applications to Oracle,
H.3
migrating non-Oracle databases to Oracle,
H.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,
C.2
mount points
Optimal Flexible Architecture conventions for creating,
D.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
NAS devices
creating files on for use with Automatic Storage Management,
C.3
guidelines for configuration,
C.1
Natively Compiled Java Libraries,
H.3
Net Configuration Assistant
troubleshooting,
G.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 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,
C.4
using for installation,
1.6.4
NLS_LANG environment variable,
F.1
NLS_LANG parameter
about,
F.1
nobody user
checking existence of,
2.5.5
description,
2.5
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.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,
H.4
normal redundancy, Automatic Storage Management redundancy level,
2.11.2
O
OEM
See
Oracle Enterprise Manager
oinstall group
checking for existing,
2.5.1
creating,
2.5.1
description,
2.5
OLAP tools
about,
H.2
Oracle OLAP,
H.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 version of Solaris,
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,
D.1.1
Automatic Storage Management,
D.3.3
changes for Oracle Database 10g,
D.2
characteristics of an installation compliant with,
D.1.1
concurrent execution of application software,
D.1.1
conventions for creating mount points,
D.3
distributed I/O loads,
D.1.1
drive failure safeguards,
D.1.1
file identification,
D.3.6
file mapping,
D.1.1
,
D.3.7
file naming,
D.1.1
file system organization,
D.1.1
files systems,
D.3.1.1
hardware support,
D.1.1
home directory distribution,
D.1.1
I/O loads,
D.1.1
login home directories,
D.1.1
naming,
D.3.1
database files,
D.3.3
Oracle base directory,
D.3.2
tablespaces,
D.3.5
very large databases,
D.3.1.3
Oracle Managed Files,
D.3.3
pathnames,
D.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,
D.3.4
standard,
D
tablespace contents,
D.1.1
UNIX directory subtrees,
D.1.1
using seperate segments,
D.3.4
Oracle Advanced Security
deprecated component,
1.8
Oracle Application Server,
H.2
Oracle applications
APPC-enabled systems, connecting to,
H.4
IBM DRDA databases, connecting to,
H.4
installing with Oracle Database,
H.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,
D.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
Oracle Cluster Registry
See
OCR
Oracle Clusterware
about,
H.1
ports,
E.3
ports, ranges and protocol,
E.3
used with Automatic Storage Management,
1.5.1.2
used with Oracle Real Application Clusters,
H.1
Oracle Connection Manager, installation guidelines,
3.2
Oracle CSS Daemon
configuration, deleting,
6.5.3
Oracle Data Mining
about,
H.2
installing,
H.2
Oracle Database
administering and monitoring,
H.2
AS/400 applications,
H.4
creating data file directories,
2.10.3
Custom installation,
1.3
Enterprise Edition installation,
1.3
installing with Oracle applications,
H.3
installing with other Oracle components,
H
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,
H.1
requirements with Automatic Storage Management,
2.11.2
security management,
H.2
setting ORACLE_SID environment variable,
2.14
Standard Edition installation,
1.3
upgrading,
H.1
Web application development tools (HTML DB),
H.3
Web servers,
H.3
workflows,
H.3
Oracle Database Client
configuring connections,
H.1
Oracle Database Companion CD
components,
H.3
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 Examples,
H.3
Oracle Database Recovery Manager (RMAN)
about,
H.2
Automatic Storage Management,
1.5.1.2
,
3.5.2
Oracle Enterprise Management Agent
HTTP port, changing,
E.4
ports
ranges and protocol,
E.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,
E.3
Oracle Enterprise Manager Database Control
ports, changing,
E.5
Oracle Enterprise Manager Migrate Database wizard,
3.5.2
Oracle home
cloning,
B
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,
H.3
Oracle HTTP Server
installation FAQ,
H.3
Oracle internationalization class,
4.3.5.3
Oracle Internet Directory,
H.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 JDBC development drivers,
H.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,
D.3.3
Oracle Messaging Gateway
CSD requirements
on Solaris,
2.3
postinstallation tasks,
4.3.5
Oracle Messaging Gateway class,
4.3.5.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.6
Oracle Procedural Gateway
about,
H.4
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 software
removing,
6.6
Oracle Software Owner user
and Automatic Storage Management disks,
2.11.5
creating,
2.5.4.1
raw device owner
on Solaris,
2.12
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
Oracle SQL*Net Listener
ports, ranges and protocol,
E.3
Oracle SQLJ,
H.3
Oracle Storage Compatibility Program (OSCP)
certification of NAS devices,
C
Oracle Text Supplied Knowledge Bases,
H.3
Oracle Text supplied knowledge bases
postinstallation tasks,
4.3.4
Oracle Transparent Gateway
about,
H.4
listed products,
H.4
Oracle Ultra Search,
H.3
ports, changing,
E.7
ports, ranges and protocol,
E.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,
F.2
oracle user
and Automatic Storage Management disks,
2.11.5
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
relationship with Oracle base directory,
2.7.1
Oracle Workflow
installation FAQ,
H.3
Oracle XML DB
ports,
E.8
ports, changing,
E.8
ports, ranges and protocol,
E.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 on Solaris,
2.11.5
and SYSDBA privilege,
2.5
creating,
2.5.2
,
2.5.3
description,
2.5
raw device group
on Solaris,
2.12
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 on Solaris,
2.3
partition
using with Automatic Storage Management,
2.11.2
partitions
creation for Automatic Storage Management disks,
2.11.4
slices on Solaris,
2.11.5
,
2.12
,
2.12
passwd command,
2.5.4.2
passwd file,
D.3.2.2
password file
raw device for
on Solaris,
2.12
,
2.12
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 also
security
patchadd command,
2.3
patches
download location for Solaris,
2.3
PATH environment variable
setting,
2.14
pathnames
Optimal Flexible Architecture,
D.3.2.2
permissions
for data file directories,
2.10.3
for Oracle base directory,
2.8.2
pkginfo command,
2.3
PL/SQL native compilaton,
4.3.7
port numbers
managing,
E
portlist.ini file,
5.2
,
E.2
ports
access URLs,
E.2
configured for applications,
E.2
Connection Manager, ranges and protocol,
E.3
Data Guard, ranges and protocol,
E.3
default ranges,
E
i
SQL*Plus, changing,
E.6
i
SQL*Plus, ranges and protocol,
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 SQL*Net Listener, ranges and protocol,
E.3
Oracle Ultra Search, changing,
E.7
Oracle Ultra Search, ranges and protocol,
E.3
Oracle XML DB,
E.8
Oracle XML DB, changing,
E.8
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 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
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
patches required on Solaris,
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
.profile file,
2.14
program technical fix
See
PTF
ps command,
2.13
R
RAC
configuring disks for Automatic Storage Management on Solaris,
2.12
RAID
recommended Automatic Storage Management redundancy level,
2.11.2
using for Oracle data files,
2.10.1
RAM requirements,
2.2
raw device
for password file
on Solaris,
2.12
,
2.12
for server parameter file
on Solaris,
2.12
,
2.12
for SPFILE
on Solaris,
2.12
,
2.12
raw devices
block and character device names on Solaris,
2.12
checking disk availability on Solaris,
2.12
configuring on Solaris,
2.12
creating a raw device mapping file
on Solaris,
2.12
creating logical volumes on Solaris,
2.12
creating raw logical volumes on Solaris,
2.12
DBCA_RAW_CONFIG environment variable,
2.14
for control files
on Solaris,
2.12
,
2.12
for EXAMPLE tablespace
on Solaris,
2.12
,
2.12
for redo log files
on Solaris,
2.12
,
2.12
for SYSAUX tablespace
on Solaris,
2.12
,
2.12
for SYSTEM tablespace
on Solaris,
2.12
,
2.12
for TEMP tablespace
on Solaris,
2.12
,
2.12
for UNDOTBS tablespace
on Solaris,
2.12
,
2.12
for USER tablespace
on Solaris,
2.12
,
2.12
identifying disks on Solaris,
2.12
initializing disks for LVM on Solaris,
2.12
required sizes
on Solaris,
2.12
specifing location of mapping file,
2.14
specifying owner and permissions on Solaris,
2.12
storage option for data files,
2.9
,
2.9
value for DBCA_RAW_CONFIG environment variable
on Solaris,
2.12
on SPARC,
2.12
raw partitions
configuring on Solaris,
2.12
Rdb database,
H.4
readme.txt file,
E.2
reconfiguring CSS,
6.5
recovery files
options for placing on file system,
2.10
recovery of databases
Oracle Backup and Recovery,
H.2
redo log,
D.3.3
redo log files
in starter database,
5.8.2
locating,
5.8.2
naming,
D.3.3
raw devices for
on Solaris,
2.12
,
2.12
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
RMS database,
H.4
roadmap for installing Oracle Database components,
H
root user,
3.4.2
,
3.4.2
logging in as,
2.1
root.sh script
backing up,
4.2.1
S
SAN (storage area network) disks,
2.11.4
security
management tools,
H.2
See also
passwords
seminfo_semmni parameter
recommended value on Solaris,
2.6
seminfo_semmns parameter
recommended value on Solaris,
2.6
seminfo_semmsl parameter
recommended value on Solaris,
2.6
seminfo_semvmx parameter
recommended value on Solaris,
2.6
semmni parameter
recommended value on Solaris,
2.6
semmns parameter
recommended value on Solaris,
2.6
semmsl parameter
recommended value on Solaris,
2.6
semvmx parameter
recommended value on Solaris,
2.6
server parameter file
raw device for
on Solaris,
2.12
,
2.12
server parameter file (SPFILE),
3.5.1
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 startup file
editing,
2.14
removing environment variables,
2.14
shminfo_shmmax parameter
recommended value on Solaris,
2.6
shminfo_shmmin parameter
recommended value on Solaris,
2.6
shminfo_shmmni parameter
recommended value on Solaris,
2.6
shminfo_shmseg parameter
recommended value on Solaris,
2.6
shmmax parameter
recommended value on Solaris,
2.6
shmmin parameter
recommended value on Solaris,
2.6
shmmni parameter
recommended value on Solaris,
2.6
shmseg parameter
recommended value on Solaris,
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
Solaris
block and character device names,
2.11.5
,
2.12
,
2.12
checking disk availability for Automatic Storage Management,
2.11.5
,
2.12
checking disk availability for raw devices,
2.12
checking kernel parameters,
2.6
checking version,
2.3
configuring disks for Automatic Storage Management,
2.11.5
configuring kernel parameters,
2.6
configuring raw devices,
2.12
configuring raw partitions,
2.12
creating a raw device mapping file,
2.12
creating a volume group,
2.12
creating logical volumes,
2.12
creating raw logical volumes,
2.12
creating volume groups,
2.12
font packages for Java,
2.3
identifying disks for Automatic Storage Management,
2.11.5
,
2.12
identifying disks for LVM,
2.12
identifying file systems,
2.11.5
,
2.12
,
2.12
identifying LVM disks,
2.12
initializing disks for LVM,
2.12
making kernel parameter changes persist,
2.6
patch download location,
2.3
raw device sizes,
2.12
specifying owner and permissions on raw devices,
2.12
Veritas Volume Manager,
2.12
SPFILE
raw device for
on Solaris,
2.12
,
2.12
SPFILE server parameter file,
3.5.1
spnc_commands configuration file,
4.3.7
SQL Server database,
H.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
suppressed mode
reasons for using,
A.1.1
suppressed mode.
See
noninteractive mode
swap space
checking,
2.2
requirements,
2.2
Sybase Adapter Server database,
H.4
SYS user password,
3.4.1
SYSAUX tablespace
raw device for
on Solaris,
2.12
,
2.12
SYSDBA privilege
associated operating system group,
2.5
sysdef command,
2.6
SYSMAN user password,
3.4.1
SYSOPER privilege
associated operating system group,
2.5
system architecture
checking,
2.2
system file,
2.6
System Identifier,
5.6
See
SID
SYSTEM tablespace
raw device for
on Solaris,
2.12
,
2.12
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,
D.3.5
special tablespaces,
D.3.4
TEMP tablespace
raw device for
on Solaris,
2.12
,
2.12
temporary disk space
requirements,
2.2
Teradata database,
H.4
TMP environment variable,
2.2
setting,
2.14
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,
G
fatal errors,
G.5.2
U
umask,
2.14
umask command,
2.14
,
2.14
uname command,
2.3
UNDOTBS tablespace
raw device for
on Solaris,
2.12
,
2.12
UNIX commands,
2.14
chmod,
2.8.2
,
2.10.3
,
2.11.5
chown,
2.8.2
,
2.10.3
,
2.11.5
env,
2.14
format,
2.11.5
,
2.12
,
2.12
id,
2.5.5
instfix,
2.3
mkdir,
2.8.2
,
2.10.3
passwd,
2.5.4.2
patchadd,
2.3
pkginfo,
2.3
ps,
2.13
sysdef,
2.6
umask,
2.14
uname,
2.3
unset,
2.14
unsetenv,
2.14
useradd,
2.5.4.2
vxassist,
2.12
vxdg,
2.12
vxdisk,
2.12
vxdiskadd,
2.12
vxdiskconfig,
2.12
xhost,
2.1
xterm,
2.1
UNIX directory subtrees,
D.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
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,
1.7
advantages with separate Oracle homes,
3.5.1
USER tablespace
raw device for
on Solaris,
2.12
,
2.12
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
UTLRP.SQL
recompiling invalid SQL modules,
4.2.2
V
/var/opt/oracle/oraInst.loc file
reviewing log files,
G.4
Veritas Volume Manager,
2.12
very large databases
Optimal Flexible Architecture naming mount points,
D.3.1.3
volume group
creating on Solaris,
2.12
volume groups
creating on Solaris,
2.12
volumes
creating logical volumes on Solaris,
2.12
vxassist command,
2.12
vxdg command,
2.12
vxdisk command,
2.12
vxdiskadd command,
2.12
vxdiskconfig command,
2.12
VxVM,
2.12
creating raw logical volumes on Solaris,
2.12
W
Web applications, Oracle HTML DB,
H.3
Web servers (Oracle HTTP Server),
H.3
WebSphere MQ
CSD download location
for Solaris,
2.3
CSDs required
on Solaris,
2.3
WebSphere MQ class,
4.3.5.3
WebSphere MQ Series database,
H.4
Windows
analogy for Oracle base directory,
2.7.1
workflows
applications based,
H.3
e-business integration,
H.3
X
X Window
display errors,
G.1
X Window system
enabling remote hosts,
2.1
,
2.1
xhost command,
2.1
xterm command,
2.1
Scripting on this page enhances content navigation, but does not change the content in any way.