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, 6.6

aliases, multiple on computers, 2.8.3

APPC-enabled databases, H.4

applications, migrating non-Oracle applications to Oracle, H.3

asm groups

creating, 2.9.2.4

ASM See Oracle Automatic Storage Management

asmcmd utility, 3.10

asmdba groups

creating, 2.9.2.5, 2.9.2.5

authorized problem analysis report

See APAR

Automatic Storage Management

block and character device names, 3.5.4

changing owner and permissions of disks, 3.5.4

checking disk availability, 3.5.4

identifying available disks, 3.5.4

identifying disks, 3.5.4

B

backups of database

Oracle Database Recovery Manager, H.2

base directory

See Oracle base directory

block and character device names, 3.5.4

block device

device name, 3.5.4

C

C compiler

requirement, 2.3.2

D

DAS (direct attached storage) disks, 3.5.3

data files

creating separate directories for, 2.14.2

defined, 6.10.1

managing with Oracle ASM, 1.8.2

minimum disk space for, 2.14.1

naming, D.2.3

options for placing on file system, 2.14

recommendations for file system, 2.14.1

reviewing, 6.10

setting permissions on data file directories, 2.14.2

setting up, 6.10.1

data loss

minimizing with Oracle Automatic Storage Management, 3.5.2

data mining tools

Oracle Data Mining, H.2

data warehousing tool

Oracle OLAP, H.2

Database Configuration Assistant

running in silent mode, A.5

troubleshooting, G.8

database install

customize, 4.5.1

databases

files, 6.10.1

identifying, 6.8

initialization parameter file, 6.9

naming, 4.5.1

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

Oracle Automatic Storage Management requirements, 3.5.2

recovery with Oracle Backup and Recovery, H.2

redo log files, 6.10.2

security management, H.2

tablespaces, 6.10.1

Daylight Savings Time, 1.13.3

DB_DOMAIN initialization parameter, 6.8

DB_NAME initialization parameter, 6.8, 6.8

DB2 database, H.4

DB2 z/OS database, H.4

DB2/400 database, H.4

dba group

and Automatic Storage Management disks, 3.5.4

creating, 2.9.2.2, 2.9.2.2

description, 2.9.1.2, 2.9.1.3

SYSDBA privilege, 2.9.1.2

dba groups

creating, 2.9.2.4, 2.9.2.6

dbca.rsp file, A.2.1

Deconfiguring

Oracle Restart, G.6

default data files, 6.10.1

default file mode creation mask

setting, 2.16

default tablespaces, 6.10.1

Deinstallation tool, 7

about, 7.1

example, 7.3

failed installations, 7.2

previous grid home, 7.1

roothas.pl, 7.1

deinstalling previous grid home, 7.1

deprecated features, Preface

description

database restart, 3

Oracle Restart, 3

desupported features, Preface

E

Enterprise Manager Database Control Agent

ports

ranges and protocol, E.3

enterprise.rsp file, A.2.1

environment

configuring for oracle user, 2.16

environment variables

DISPLAY, 2.10, 2.16

NLS_LANG, F.1.1.2

ORACLE_BASE, 2.12.2, 2.16

ORACLE_HOME, 2.15, 2.16, 2.16

ORACLE_HOSTNAME, 2.8.2

ORACLE_SID, 2.16

PATH, 2.16

SHELL, 2.16

TMP and TMPDIR, 2.2.2, 2.16, 3.1.2

TNS_ADMIN, 2.16

errors

configuration assistants, G.8

display errors, G.3

installation, G.4, G.5, G.8.2

remote terminal installation, G.3

response file installation, G.11

silent mode, G.11

su command, G.3

/usr/X11R6/bin/xdpyinfo, G.3

X Window, G.1

X Window display errors, G.2

EXAMPLE tablespace

description, 6.10.1

example01.DBF data file, 6.10.1

examples

Oracle Automatic Storage Management failure groups, 3.5.2, 3.5.2

Oracle base directories, 2.11.1

executable_stack parameter

recommended value, 2.10

external redundancy

Oracle Automatic Storage Management redundancy level, 3.5.2

extjob user

creating, 2.9.2.8

F

failure group

examples of Oracle Automatic Storage Management failure groups, 3.5.2

failure groups

characteristics of Oracle Automatic Storage Management failure group, 3.5.2

examples in Oracle Automatic Storage Management, 3.5.2

in Oracle ASM, 1.8.2

Fast Recovery Area, 5.2.7

fatal errors, G.8.2

file mode creation mask

setting, 2.16

file sets, 2.3

file system

appropriate for Oracle base directory, 2.12.2

data file and recovery file placement options, 2.14

requirements for Oracle base directory, 2.12.2

using for data files, 2.14.1

files, D.2.3

$ORACLE_HOME/dbs/initsid.ora, 6.9

$ORACLE_HOME/install/portlist.ini, 6.2, 6.2

control, 6.10.3, D.2.3

data files, D.2.3

dbca.rsp, A.2.1

enterprise.rsp, A.2.1

/etc/group, D.2.2.3

/etc/passwd, D.2.2.3

listener.ora, 5.3.1

oraInst.loc, 2.9.2.1

oratab, 2.12.1, 2.12.1

redo log, 6.10.2

response files, A.2

tnsnames.ora, 5.3.1

Flash Recovery Area

See Fast Recovery Area

G

Gateways products FAQ, H.4

global database name, 6.8

Global Database Name

about, 4.5.1

globalization support, F

Grid Control. See Oracle Enterprise Manager Grid Control

group file, D.2.2.3

groups

checking for existing oinstall group, 2.9.2.1

creating the asm group, 2.9.2.4, 2.9.2.4

creating the asmdba group, 2.9.2.5

creating the dba group, 2.9.2.2, 2.9.2.2

creating the oinstall group, 2.9.2.1

creating the oper group, 2.9.2.3, 2.9.2.3

UNIX OSDBA group (dba), 2.9.1.2

UNIX OSDBA group for Oracle Restart (dba), 2.9.1.3

UNIX OSOPER group (oper), 2.9.1.2

H

hardware certification, 1.3.1

hardware requirements, 2.2, 3.1

disk space, 2.2.2

display, 2.2.3

memory, 2.2.1

run level, 2.2.4

high redundancy

Oracle Automatic Storage Management redundancy level, 3.5.2

home directory

See Oracle home directory

host name resolution, 2.7, 2.8.1

host name, setting before installation, 2.8.2

I

IBM DB2 database, H.4

IBM DB2 z/OS database, H.4

IBM DB2/400 database, H.4

IBM WebSphere MQ

requirements, 2.3.3.3

IBM WebSphere MQ Series databases, H.4

identifying disks for Automatic Storage Management, 3.5.4

identifying LVM disks, 3.5.4

Informix Server database, H.4

initialization parameter file

description, 6.9

in databases, 6.9

initsid.ora, 6.9

initialization parameters

DB_NAME, 6.8

DOMAIN_NAME, 6.8

SERVICE_NAMES, 6.8

initsid.ora file, 6.9

initsid.ora initialization parameter file, 6.9

in-place Oracle Database Client upgrade, Preface

installation

accessing installation software, 4.3

available products, 1.6, 1.6

cleaning up after a failed installation, G.12

clusters, installation guidelines, 4.2

component-specific guidelines, 4.2

computer aliases, multiple, 2.8.3

considerations, 1.3

database editions, 1.6

errors, G.5, G.8.2

silent mode, G.11

laptops, 2.8.4

log files, G.4, G.4

Oracle Automatic Storage Management requirements, 3.5.2

overview, 1

response files, A, A.2

preparing, A.2, A.2.2

silent mode, G.11

templates, A.2

silent mode, A.3

upgrading, H.1

installation errors

steps to resolve, G.4

installation guidelines, 4.5.1, 4.5.1

installation overview, 1.2

installation software

copying to a hard disk, 4.3.2.2

extracting, 4.3.1.3

installation software, accessing, 4.3

Installing

Oracle restart, 3.7.1

instance

instance identifier (SID), 2.16

ioscan command, 3.5.4

IP addresses, multiple, 2.8.2

J

JDK requirements, 2.3

K

kernel parameters

setting, 2.10

ksi_alloc_max parameter

recommended value, 2.10

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.8.4

listener

identifying Oracle home for, 2.15

lsnrctl command, 2.15

stopping, 2.15, 2.15

listener.ora file, 5.3.1

local device

using for data files, 2.14.1

log files, G.4, G.4

troubleshooting, G.5

log files locations in OFA, D.2.6

logical volume manager

See LVM

loopback adapters

non-networked computers, 2.8.4

lsnrctl command, 2.15

LVM

identifying volume group devices, 3.5.4

recommendations for Oracle Automatic Storage Management, 3.5.2

M

mask

setting default file mode creation mask, 2.16

max_thread_proc parameter

recommended value, 2.10

maxdsiz parameter

recommended value, 2.10

maxdsiz_64bit parameter

recommended value, 2.10

maxssiz parameter

recommended value, 2.10

maxssiz_64bit parameter

recommended value, 2.10

maxuprc parameter

recommended value, 2.10

memory requirements, 2.2, 3.1

Microsoft SQL Server database, H.4

migrating

See upgrading

migrating applications to Oracle, H.3

migrating non-Oracle databases to Oracle, H.1

mirroring Oracle Automatic Storage Management disk groups, 3.5.2

mkdir command, 2.12.2, 2.14.2

mode

setting default file mode creation mask, 2.16

mount point

for Oracle base directory, 2.11.1

mount point directories, 4.3.2.2

mount point directory

choosing, C.3

mount points

Optimal Flexible Architecture conventions for creating, D.2

msgmap parameter

recommended value, 2.10

msgmni parameter

recommended value, 2.10

msgseg parameter

recommended value, 2.10

msgtql parameter

recommended value, 2.10

multihomed computers, installing on, 2.8.2

multiple aliases, computers with, 2.8.3

multiple databases and Oracle ASM, 2.9.1.3

multiple Oracle homes, 1.3.2

N

naming subdirectories, D.2.2.5

NAS devices

creating files on for use with Oracle Automatic Storage Management, C.4

guidelines for configuration, C.1

ncsize parameter

recommended value, 2.10

Net Configuration Assistant

troubleshooting, G.8

Net Configuration Assistant (NetCA)

response files, A.4

running at command prompt, A.4

netca.rsp file, A.2.1

network adapters

computers with multiple aliases, 2.8.3

non-networked computers, 2.8.4

primary, on computers with multiple aliases, 2.8.3

See also loopback adapters, primary network adapters

network cards, multiple, 2.8.2

Network Information Services

alternative to local users and groups, 2.9.2

Network Information Services.See NIS

network setup

about, 2.8

computers with multiple aliases, 2.8.3

host name resolution, 2.7, 2.8.1

network topics

laptops, 2.8.4

multiple network cards, 2.8.2

non-networked computers, 2.8.4

nfile parameter

recommended value, 2.10

nflocks parameter

recommended value, 2.10

NFS

mount options, C.5

ninode parameter

recommended value, 2.10

nkthread parameter

recommended value, 2.10

NLS_LANG environment variable, F.1.1.2

noninteractive mode

See also response files, response file mode, A.1

non-networked computers, 2.8.4

non-Oracle databases, listed, H.4

normal redundancy, Oracle Automatic Storage Management redundancy level, 3.5.2

nproc parameter

recommended value, 2.10

O

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 2.9.2.1

oinstall groups

creating, 2.9.2.1

OLAP tools

about, H.2

Oracle OLAP, H.2

OMF

See Oracle Managed Files

oper group

creating, 2.9.2.3

description, 2.9.1.2

oper groups

creating, 2.9.2.3

operating system

checking distribution and version, 2.3.1

reviewing common practices, 2.4

operating system accounts

creating and configuring, 5.2.3

operating system groups

creating the oinstall group, 2.9.2.1

operating system requirements, 2.3

operating system users

root user, 4.5.1

Optimal Flexible Architecture

advantages, D.1.1

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 Automatic Storage Management, D.2.3

Oracle Managed Files, D.2.3

overview, D.1

pathnames, D.2.2.3

recommendations for Oracle base directory, 2.11.1

recommended path for Oracle base directory, 2.11.1

recommended path for Oracle home directory, 2.11.3

recommended path for Oracle Inventory directory, 2.11.2

special tablespaces, D.2.4

standard, D

using separate segments, D.2.4

Oracle Application Server, H.2

Oracle applications

installing with Oracle Database, H.3

Oracle ASM, 1.8.2

Oracle ASM disk groups

about, 1.8.2

Oracle ASM failure groups

about, 1.8.2

Oracle ASM instance

about, 1.8.2

Oracle ASMCA, 6.3.2

Oracle Automatic Storage Management, 1.8.2

asmcmd utility, 3.10

characteristics of failure groups, 3.5.2

configuring disks, 3.5.1, 4.2.2

configuring disks for Automatic Storage Management, 3.5.4

considerations before installing, 3.4

DAS disks, 3.5.3

disk devices, 1.8.2

disk groups, 3.5.2

disks, supported, 3.5.3

failure groups

examples, 3.5.2, 3.5.2

identifying, 3.5.2

installation, testing, 3.10

managing, 6.3.2

mirroring, 3.5.2

multiple databases, 2.9.1.3

Optimal Flexible Architecture file naming conventions, D.2.3

Oracle ASM disk group templates, 1.8.2

partition creation, 3.5.3

password file, 3.4

recommendations for disk groups, 3.5.2

redundancy levels, 3.5.2

response files, A.1.2

SAN disks, 3.5.3

space required for preconfigured database, 3.5.2

SPFILE server parameter file, 3.4

starting and stopping, 6.3.1

templates, 1.8.2

Oracle Automatic Storage Management Configuration Assistant, 6.3.2

Oracle Automatic Storage Management disk groups

managing, 6.3.2

Oracle base directory

creating, 2.12.2

creating new, 2.12.2

description, 2.11.1

examples, 2.11.1

identifying appropriate file system, 2.12.2

identifying existing, 2.12.1

mount point for, 2.11.1

naming conventions, D.2.2

recommended path, 2.11.1

relationship with Oracle software owner user, 2.11.1

requirement for, 2.11.1

requirements for existing directory, 2.12.1

requirements on file system, 2.12.2

Oracle Cluster Registry

See OCR

Oracle Cluster Registry port, E.3

Oracle Clusterware

about, H.1

used with Oracle Real Application Clusters, H.1

Oracle components

using in different languages, F.1.2

Oracle Data Mining

about, H.2

installing, H.2

Oracle Database

administering and monitoring, H.2

creating data file directories, 2.14.2

Enterprise Edition installation, 1.6

getting started using

accessing, 6.4, 6.5

starting and stopping database, 6.4, 6.5

installing with Oracle applications, H.3

minimum disk space requirements, 2.14.1

naming, 4.5.1

requirements with Oracle Automatic Storage Management, 3.5.2

security management, H.2

setting ORACLE_SID environment variable, 2.16

Standard Edition installation, 1.6

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.2.1

Oracle Database Recovery Manager (RMAN)

about, H.2

Oracle Database Vault

audit policy, 1.3.6

postinstallation task, 5.3.3

preinstallation requirement, 2.3.3.6

Oracle Enterprise Management Agent

HTTP port, changing, E.4

Oracle Enterprise Manager, 1.9

Database Control

logging into, 6.2

port number, 6.2

using to modify control files, 6.10.3

using to modify redo log files, 6.10.2

using to view control files, 6.10.3

using to view redo log files, 6.10.2

Oracle Enterprise Manager Database Control

ports, changing, E.5

ports, ranges and protocol, E.3

Oracle home

cloning, B.1

Oracle home directory

description, 2.11.3

identifying for listener, 2.15

multiple homes, network considerations, 2.8.2

recommended path, 2.11.3

requirement for, 2.11.3

requirements, 2.11.3

using to identify Oracle base directory, 2.12.1

Oracle host name, setting before installation, 2.8.2

Oracle Internet Directory, H.2

Oracle Inventory

description, 2.11.2

pointer file, 2.9.2.1

Oracle Inventory directory

description, 2.11.2

recommended path, 2.11.2

Oracle Inventory group

creating, 2.9.2.1

Oracle Inventory groups

checking for existing, 2.9.2.1

creating, 2.9.2.1

Oracle Label Security

post-installation tasks, 5.3.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, D.2.3

Oracle Messaging Gateway

CSD requirements, 2.3.3.3

postinstallation tasks, 5.3.4

requirements, 2.3.3.3

Oracle Net

configuration file directory, 5.3.1

identifying Oracle home for listener, 2.15

lsnrctl command, 2.15

stopping listener, 2.15

stopping the listener, 2.15

Oracle Net Configuration Assistant

response file, A.2.1

Oracle Net Services

post-installation tasks, 5.3.1

Oracle Net Services Listener

ports, ranges and protocol, E.3

Oracle OLAP

about, H.2

Oracle Precompilers

postinstallation tasks, 5.3.5

Oracle Procedural Gateway

listed products, H.4

Oracle Real Application Clusters (RAC)

installed before Oracle Database, 4.2

installing with Oracle Enterprise Manager, H.2

Oracle Clusterware

about, H.1

Oracle Restart

description, 3

Installing, 3.7.1

modifying, 3.8

OSDBA group description, 2.9.1.3

relinking, 3.8

user, 2.9.1.3

Oracle Schemas, Preface

Oracle software owner user

configuring environment for, 2.16

determining default shell, 2.16

relationship with Oracle base directory, 2.11.1

Oracle Software Owner user

and Automatic Storage Management disks, 3.5.4

creating, 2.9.2.7, 2.9.2.7.1

oracle user, 2.9.2.7.2

Oracle SQL Developer

accessing, 6.5

migrating non-Oracle applications to Oracle, H.3

migrating non-Oracle databases to Oracle, H.1

Oracle Technology Network (OTN)

downloading documentation from, Preface

Oracle Text knowledge base, 5.3.7

Oracle Transparent Gateway

listed products, H.4

Oracle Universal Installer

guidelines for using, 4.2

installation guidelines, 4.2

response files, A

list of, A.2.1

running, 4.5.1

running in different languages, F.2

oracle user

and Automatic Storage Management disks, 3.5.4

configuring environment for, 2.16

creating, 2.9.2.7.1

determining default shell, 2.16

relationship with Oracle base directory, 2.11.1

Oracle user accounts

configuring, 5.2.3.1

Oracle XML DB

about, H.2

ports, ranges and protocol, E.3

ORACLE_BASE environment variable, 2.12.2

setting, 2.16

ORACLE_HOME environment variable

setting, 2.15

unsetting, 2.16

ORACLE_HOSTNAME, 2.8.2

ORACLE_HOSTNAME environment variable

computers with multiple aliases, 2.8.3

multihomed computers, 2.8.2

setting before installation, 2.8.2

ORACLE_SID environment variable

setting, 2.16

oraInst.loc file

location, 2.9.2.1

location of, 2.9.2.1

oraInventory directory

See Oracle Inventory directory

oratab file, 2.12.1

formats, 2.12.1

location of, 2.12.1

OSASM groups

creating, 2.9.2.4

multiple databases, 2.9.1.3

SYSASM, 2.9.1.3

OSDBA group

and Automatic Storage Management disks, 3.5.4

OSDBA groups

creating, 2.9.2.2

creating for Oracle Grid Infrastructure, 2.9.2.5

description for database, 2.9.1.2

SYSDBA privilege, 2.9.1.2

SYSDBA privilege for Oracle Restart, 2.9.1.3

OSOPER groups

creating, 2.9.2.3

description for database, 2.9.1.2

SYSOPER privilege, 2.9.1.2, 2.9.1.2

OTN website

downloading installation software from, 4.3.1

P

partition

using with Oracle Automatic Storage Management, 3.5.2

partitions

creation for Oracle Automatic Storage Management disks, 3.5.3

passwd file, D.2.2.3

password file for Oracle Automatic Storage Management, 3.4

passwords

resetting, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

reviewing, 6.6

unlocking, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

patch download location, 2.3.4

patches

download location, 2.3.4

PATH environment variable

setting, 2.16

pathnames

Optimal Flexible Architecture, D.2.2.3

permissions

for data file directories, 2.14.2

for Oracle base directory, 2.12.2

port numbers

managing, E

portlist.ini file, 6.2, E.2

ports

access URLs, E.2

Cluster Synchronization Services, ranges and protocol, E.3

configured for applications, E.2

Connection Manager, ranges and protocol, E.3

default ranges, E

Enterprise Manager Database Control Agent, ranges and protocol, E.3

Oracle Cluster Registry, E.3

Oracle Enterprise Management Agent HTTP, changing, E.4

Oracle Enterprise Manager Database Control, changing, E.5

Oracle Enterprise Manager Database Control, ranges and protocol, E.3

Oracle Net Services, E.3

Oracle Net Services Listener, ranges and protocol, E.3

Oracle XML DB, ranges and protocol, E.3

post-installation

recommended tasks

client static library, generating, 5.2.5

creating operating system accounts, 5.2.3

root.sh script, backing up, 5.2.1

required tasks, 5.1

configuring Oracle Messaging Gateway, 5.3.4

Oracle Label Security, configuring, 5.3.2

Oracle Net Services, configuring, 5.3.1

Oracle Precompilers, 5.3.5

patches, installing and downloading, 5.1.1

postinstallation tasks

Oracle Text knowledge base, 5.3.7

Precompilers

requirements, 2.3.2

preconfigured database

Oracle Automatic Storage Management disk space requirements, 3.5.2

requirements when using Oracle Automatic Storage Management, 3.5.2, 3.5.2

Pro*C/C++

configuring, 5.3.5.1

requirements, 2.3.2

R

RAC

configuring disks for ASM, 3.5.4

RACcheck audit tool, 5.2.9

RAID

using for Oracle data files, 2.14.1

RAM requirements, 2.2, 3.1

readme.txt file, E.2

recommendations

on perfomring software-only installations, 3.6

recovery files

options for placing on file system, 2.14

recovery of databases

Oracle Backup and Recovery, H.2

redo log, D.2.3

redo log files

in starter database, 6.10.2

locating, 6.10.2

naming, D.2.3

reviewing, 6.10

using Oracle Enterprise Manager Database Control with, 6.10.2

redundancy level

and space requirements for preconfigured database, 3.5.2, 3.5.2

for Oracle Automatic Storage Management, 3.5.2

redundant array of independent disks

See RAID

Removing Oracle Database Software, 7

Rendezvous

requirements, 2.3.3.3

requirements

hardware, 2.2, 3.1

response file installation

response files

preparing, A.2, A.2.2

templates, A.2

silent mode, A.3

errors, G.11

response file mode

about, A.1

reasons for using, A.1.1

response files, A.1

about, A.1

creating with template, A.2.1

dbca.rsp, A.2.1

enterprise.rsp, A.2.1

general procedure, A.1.3

Net Configuration Assistant, A.4

netca.rsp, A.2.1

Oracle Automatic Storage Management, A.1.2

passing values at command line, A.1

specifying with Oracle Universal Installer, A.3

response files installation

about, A

root user, 4.5.1, 4.5.1

logging in as, 2.1

roothas.pl, 3.6.2, 7.1, G.6

root.sh script

backing up, 5.2.1

S

SAM

starting, 2.10

sam command, 2.10

Sample Schemas

tablespaces and data files, 6.10.1

SAN (storage area network) disks, 3.5.3

schema passwords, 4.5.1

schemas

database schema passwords, 4.5.1

Oracle Schemas, about, Preface

Sample Schemas tablespaces and data files, 6.10.1

security

dividing ownership of Oracle software, 2.9

management tools, H.2

semmni parameter

recommended value, 2.10

semmns parameter

recommended value, 2.10

semmnu parameter

recommended value, 2.10

semvmx parameter

recommended value, 2.10

server parameter file (SPFILE), 3.4

SERVICE_NAMES initialization parameter, 6.8, 6.8

setting kernel parameters, 2.10

shell

determining default shell for oracle user, 2.16

SHELL environment variable

checking value of, 2.16

shmmax parameter

recommended value, 2.10

shmmni parameter

recommended value, 2.10

shmseg parameter

recommended value, 2.10

SID, 6.8

setting ORACLE_SID environment variable, 2.16

SID. See Oracle Database SID

silent mode

about, A.1

reasons for using, A.1.1

See also response file mode, response files, A.1

silent mode installation, A.3

software certification, 1.3.1

software requirements, 2.3

software updates option, Preface, 1.5, 3.7.1, 4.5.1

downloading before installation, 3.7.1, 4.5.1

SPFILE server parameter file, 3.4

SQL Developer

accessing, 6.5

SQL Server database, H.4

SQL*Plus

accessing, 6.4

storage area network disks, 3.5.3

storage management See Oracle Automatic Storage Management

suppressed mode. See response file mode

swap space

checking, 2.2.1, 3.1.1

requirements, 2.2, 3.1

swlist command, 2.3.4

Sybase Adapter Server database, H.4

SYSASM

OSASM, 2.9.1.3

SYSDBA privilege

associated UNIX group, 2.9.1.2, 2.9.1.3

SYSOPER privilege

associated UNIX group, 2.9.1.2

SYSTEM

tablespace, description, 6.10.1

System Administration Manager

See SAM

System Administration Manager (SAM), 2.10

System Identifier, 6.8

See SID

system01.dbf data file, 6.10.1, 6.10.1

T

tablespaces, 6.10.1

defined, 6.10.1

in databases, 6.10.1

reviewing, 6.10

setting up, 6.10.1

expanding for large sorts, 6.10.1

Optimal Flexible Architecture

special tablespaces, D.2.4

SYSTEM, 6.10.1

TEMP, 6.10.1

UNDOTBS, 6.10.1

USERS, 6.10.1

TEMP

tablespace (temp01.dbf), 6.10.1

temp01.dbf data file, 6.10.1

temporary disk space

requirements, 2.2, 3.1

Teradata database, H.4

TIBCO Rendezvous

requirements, 2.3.3.3

TMP environment variable, 2.2.2, 3.1.2

setting, 2.16

TMPDIR environment variable, 2.2.2, 3.1.2

setting, 2.16

TNS_ADMIN environment variable

unsetting, 2.16

tnsnames.ora file, 5.3.1

troubleshooting, G

display errors, G.3

fatal errors, G.8.2

Oracle Restart, G.6

remote terminal installation, G.3

su command, G.3

/usr/X11R6/bin/xdpyinfo, G.3

U

umask command, 2.16

UNDOTBS

tablespace (undotbs01.dbf), 6.10.1

UNIX commands

chmod, 2.12.2, 2.14.2, 3.5.4

chown, 2.12.2, 2.14.2, 3.5.4

ioscan, 3.5.4

mkdir, 2.12.2, 2.14.2

ps, 2.15

pvdisplay, 3.5.4

sam, 2.10

swlist, 2.3.4

umask, 2.16

unset, 2.16

unsetenv, 2.16

xhost, 2.1

xterm, 2.1

UNIX groups

checking for existing oinstall group, 2.9.2.1

OSDBA (dba), 2.9.1.2

OSDBA (dba) for Oracle Restart, 2.9.1.3

OSOPER (oper), 2.9.1.2

using NIS, 2.9.2

UNIX users

creating an unprivileged user, 2.9.2.8

using NIS, 2.9.2

UNIX workstation

installing from, 2.1

unprivileged user

creating, 2.9.2.8

unset command, 2.16

unsetenv command, 2.16

upgraded databases

configuring, 5.2.2

upgrading, 1.13

ASM, 1.13.2

Daylight Savings Time, 1.13.3

operating sytem, 1.13.1

Oracle Database, 1.13.1

useradd command, 2.9.2.7.2

users

creating an unprivileged user, 2.9.2.8

creating the oracle user, 2.9.2.7, 2.9.2.7.1

Oracle Restart, 2.9.1.3

USERS

tablespace (users01.dbf), 6.10.1

users and groups, 2.9

UTLRP.SQL

recompiling invalid SQL modules, 5.2.2

V

very large databases

Optimal Flexible Architecture naming mount points, D.2.2.2

vps_ceiling parameter

recommended value, 2.10

W

Web servers (Oracle HTTP Server), H.3

WebSphere MQ

CSDs requirements, 2.3.3.3

requirements, 2.3.3.3

WebSphere MQ Series database, H.4

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

xterm command, 2.1