Index

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

A

accounts

reviewing, 5.2

unauthenticated access to, 5.3

ANONYMOUS user

unauthenticated account access with, 5.3

ASM

characteristics of failure groups, 2.10.1

configuring disks

on Mac OS X, 2.10.3

disk groups, 2.10.1

displaying attached disks

on Mac OS X, 2.10.3

failure groups, 2.10.1

examples, 2.10.1

identifying, 2.10.1

identifying available disks on Mac OS X, 2.10.3

identifying disks on Mac OS X, 2.10.3

OFA file naming conventions, B.3.3

overview, 1.5.1

recommendations for disk groups, 2.10.1

redundancy levels, 1.5.1

space required for preconfigured database, 2.10.1

storage option for datafiles, 2.8

B

base directory

See Oracle base directory

Bash shell

default user startup file, 2.13

Bourne shell

default user startup file, 2.13

C

C compiler

requirement on Mac OS X, 2.3, 2.3

C shell

default user startup file, 2.13

CD-ROMs

copying software from, 3.3

certification, hardware and software, 1.6.1

chmod command, 2.7, 2.9

chown command, 2.7, 2.9

compiler

checking on Mac OS X, 2.3

configuration assistants

troubleshooting, D.4

control files

locating, 5.6.3

naming, B.3.3

reviewing, 5.6

using Oracle Enterprise Manager Database Control with, 5.6.3

CONTROL_FILES initialization parameter, 5.6.3

custom database

failure groups for ASM, 2.10.1

requirements when using ASM, 2.10.1

Custom installation type

reasons for choosing, 2.4

custom.rsp file, A.3

D

data loss

minimizing with ASM, 2.10.1

Database Configuration Assistant

troubleshooting, D.4

Database Control

default ports, C.1

databases

administrative information, B.2.1

ASM requirements, 2.10.1

files, 5.6.1

identifying, 5.4

initialization parameter file, 5.5

OFA file naming conventions, B.3.3

redo log files, 5.6.2

removing, 6.3

tablespaces, 5.6.1

datafiles

creating separate directories for, 2.9

defined, 5.6.1

managing with ASM, 1.5.1

minimum disk space for, 2.9

naming, B.3.3

options for placing on file system, 2.9

recommendations for file system, 2.9

reviewing, 5.6

setting permissions on datafile directories, 2.9

setting up, 5.6.1

storage options, 2.8

DB_DOMAIN initialization parameter, 5.4

DB_NAME initialization parameter, 5.4, 5.4

dba group

and SYSDBA privilege, 2.4

creating, 2.4.2

description, 2.4

DBSNMP user password, 3.4.2

default file mode creation mask

setting, 2.13

E

Enterprise Manager

default ports, C.1

enterprise.rsp file, A.3

env command, 2.13

environment

checking settings, 2.13

configuring for oracle user, 2.13

environment variables

ORACLE_BASE, 2.6, 2.7, 2.13

ORACLE_HOME, 2.12, 2.13, 2.13

ORACLE_SID, 2.13

PATH, 2.13

removing from shell startup file, 2.13

SHELL, 2.13

TEMP and TMPDIR, 2.2, 2.13

TNS_ADMIN, 2.13

errors

configuration assistants, D.4

installation, D.3, D.4.2

non-interactive installation, D.5

silent mode, D.5

/etc/sysctl.conf file, 2.5

EXAMPLE tablespace, 5.6.1

examples

ASM failure groups, 2.10.1

Oracle base directories, 2.6

external jobs

UNIX user required for, 2.4

external redundancy

ASM redundancy level, 1.5.1

extjob executable

UNIX user required for, 2.4

F

failure group

ASM, 2.10.1

characteristics of ASM failure group, 2.10.1

examples of ASM failure groups, 2.10.1

fatal errors, D.4.2

file mode creation mask

setting, 2.13

file naming, B.2.1

file system

appropriate for Oracle base directory, 2.7

datafile and recovery file placement options, 2.9

organization, B.2.1

requirements for Oracle base directory, 2.7

storage option for datafiles, 2.8

using for datafiles, 2.9

files, B.3.3

$ORACLE_HOME/dbs/initsid.ora, 5.5

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

control, 5.6.3, B.3.3

custom.rsp, A.3

datafiles, B.3.3

editing shell startup file, 2.13

enterprise.rsp, A.3

/etc/group, B.3.2.2

/etc/passwd, B.3.2.2

/etc/sysctl.conf, 2.5

.login, 2.13

oraInst.loc, 2.7, A.2

oratab, 2.7

.profile, 2.13

redo log, 5.6.2

response files, A.3

standard.rsp, A.3

/var/opt/oracle/oraInst.loc, D.3, D.3

G

global database name, 5.4

groups

checking for existing oinstall group, 2.4.1

creating the dba group, 2.4.2

creating the oinstall group, 2.4.1

creating the oper group, 2.4.3

UNIX OSDBA group (dba), 2.4

UNIX OSOPER group (oper), 2.4

H

hardware certification, 1.6.1

hardware requirements, 2.2

high redundancy

ASM redundancy level, 1.5.1

home directory

distribution, B.2.1

See Oracle home directory

I

id command, 2.4.5

initialization parameter file

description, 5.5

in databases, 5.5

initsid.ora, 5.5

initialization parameters

DB_NAME, 5.4

DOMAIN_NAME, 5.4

SERVICE_NAMES, 5.4

initsid.ora initialization parameter file, 5.5

installation

overview, 3.1

available products, 1.3, 1.3

completing, 3.4.2

considerations, 1.6

errors, D.3, D.4.2

silent mode, D.5

guidelines, 3.4.1

log files, D.2, D.2

non-interactive

error handling, D.5

oraInst.loc file, A.2

response files, A.3

preparing, A.3

silent mode, D.5

templates, A.3

silent mode, A.3, A.4

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 software

copying to a hard disk, 3.3, 3.3

extracting, 3.2

re-installing, 3.4.1

installation types

and ASM requirements, 2.10.1

instance

instance identifier (SID), 2.13

I/O loads, B.2.1

OFA, B.2.1

iSQL*Plus

default ports, C.1

K

kernel parameters

configuring on Mac OS X, 2.5

Korn shell

default user startup file, 2.13

ksh

See Korn shell

L

licensing information, 1.3

listener

identifying Oracle home for, 2.12

lsnrctl command, 2.12

stopping, 2.12

stopping existing listener process, 2.12

log files, D.2, D.2

troubleshooting, D.3

logical volume manager

See LVM

.login file, 2.13

lsnrctl command, 2.12

LVM

recommendations for ASM, 2.10.1

M

Mac OS X

checking operating system version, 2.3

checking software requirements, 2.3

configuring disks for ASM, 2.10.3

configuring kernel parameters, 2.5

displaying attached disks, 2.10.3, 2.11

identifying disks for ASM, 2.10.3

operating system requirements, 2.3

software requirements, 2.3

mask

setting default file mode creation mask, 2.13

memory requirements, 2.2

MGMT_ECM_DEPOT_TS tablespace, 5.6.1

MGMT_TABLESPACE tablespace, 5.6.1

mkdir command, 2.7, 2.9

mode

setting default file mode creation mask, 2.13

mount point

for Oracle base directory, 2.6

multiple Oracle homes, 1.6.2

N

naming subdirectories, B.3.2.4

Net Configuration Assistant

troubleshooting, D.4

Network Information Services

See NIS

NIS

alternative to local users and groups, 2.4

nobody user

checking existence of, 2.4.5

description, 2.4

non-interactive installation

oraInst.loc file, A.2

response files

preparing, A.3

templates, A.3

silent mode, A.3, A.4

errors, D.5

non-interactive installations

running

Oracle Universal Installer, A.4

normal redundancy

ASM redundancy level, 1.5.1

O

OEM

See Oracle Enterprise Manager

OFA

administrative information, B.2.1

ASM, B.3.3

concurrent execution of application software, B.2.1

distributed I/O loads, B.2.1

drive failure safeguards, B.2.1

file identification, B.3.6

file mapping, B.2.1, B.3.7

file naming, B.2.1

file system organization, B.2.1

files systems, B.3.1.1

hardware support, B.2.1

home directory distribution, B.2.1

I/O loads, B.2.1

naming, B.3.1

database files, B.3.3

Oracle base directory, B.3.2

subdirectories, B.3.2.4

tablespaces, B.3.5

very large databases, B.3.1.3

on UNIX, B.3

Oracle Managed Files, B.3.3

pathnames, B.3.2.2

recommendations for Oracle base directory, 2.6

recommended path for Oracle base directory, 2.6

recommended path for Oracle home directory, 2.6

recommended path for Oracle Inventory directory, 2.6

special tablespaces, B.3.4

standard, B

tablespace contents, B.2.1

UNIX directory subtrees, B.2.1

using separate segments, B.3.4

oinstall group

checking for existing, 2.4.1

creating, 2.4.1

description, 2.4

OLS

See Oracle Label Security

OMF

See Oracle Managed Files

oper group

and SYSOPER privilege, 2.4

creating, 2.4.3

description, 2.4

operating system requirements

Mac OS X, 2.3

Optimal Flexible Architecture

See OFA

Oracle base directory

and ORACLE_BASE environment variable, 2.6

creating, 2.7

creating new, 2.7

description, 2.6

determining disk space on, 2.7

disk space requirements, 2.7, 2.7

equivalent directory on Windows, 2.6

examples, 2.6

identifying appropriate file system, 2.7

identifying existing, 2.7

mount point for, 2.6

naming conventions, B.3.2

recommended path, 2.6

relationship with Oracle Software Owner user, 2.6

requirement for, 2.6

requirements for existing directory, 2.7

requirements on file system, 2.7

Oracle Cluster Registry

See OCR

Oracle Database

creating datafile directories, 2.9

Custom installation, 1.3

datafile storage options, 2.8

Enterprise Edition installation, 1.3

minimum disk space requirements, 2.9

privileged groups, 2.4

requirements with ASM, 2.10.1

setting ORACLE_SID environment variable, 2.13

Standard Edition installation, 1.3

Oracle Enterprise Manager, 1.5.2

Database Control

logging into, 5.1

port number, 5.1

using to modify control files, 5.6.3

using to modify redo log files, 5.6.2

using to view control files, 5.6.3

using to view redo log files, 5.6.2

Oracle home directory

description, 2.6

identifying for listener, 2.12

recommended path, 2.6

requirement for, 2.6

using to identify Oracle base directory, 2.7

Oracle home name, 2.6

Oracle Inventory

description, 2.6

Oracle Inventory directory

description, 2.6

recommended path, 2.6

Oracle Inventory group

checking for existing, 2.4.1

creating, 2.4.1

description, 2.4

Oracle Label Security

installation guidelines, 3.4.1

post-installation tasks, 4.3.2

Oracle Managed Files

OFA naming conventions, B.3.3

Oracle Net

configuration file directory, 4.3.1

identifying Oracle home for listener, 2.12

lsnrctl command, 2.12

stopping existing listener, 2.12

stopping the listener, 2.12

Oracle Net Services

post-installation tasks, 4.3.1

Oracle Precompilers

post-installation tasks, 4.3.5

Oracle software

removing, 6.6

Oracle Software Owner user

configuring environment for, 2.13

creating, 2.4.4, 2.4.4

description, 2.4

determining default shell, 2.13

relationship with Oracle base directory, 2.6

required group membership, 2.4

Oracle Universal Installer

installation guidelines, 3.4.1

response files

list of, A.3, A.3, A.3

running, 3.4.2

oracle user

configuring environment for, 2.13

creating, 2.4.4, 2.4.4

description, 2.4

determining default shell, 2.13

relationship with Oracle base directory, 2.6

required group membership, 2.4

ORACLE_BASE environment variable, 2.6, 2.7

removing from shell startup file, 2.13

setting, 2.13

ORACLE_HOME environment variable

removing from shell startup file, 2.13

setting, 2.12

unsetting, 2.13

ORACLE_SID environment variable

removing from shell startup file, 2.13

setting, 2.13

oraInst.loc file, 2.7

oraInventory directory

See Oracle Inventory directory

oratab file

format, 2.7

OSDBA group

and SYSDBA privilege, 2.4

creating, 2.4.2

description, 2.4

OSOPER group

and SYSOPER privilege, 2.4

creating, 2.4.3

description, 2.4

OTN Web site

downloading installation software from, 3.2, 3.2

OUI

See Oracle Universal Installer

P

partition

using with ASM, 2.10.1

passwords

DBSNMP, 3.4.2

guidelines, 3.4.2

resetting, 5.3

with Database Control, 5.3

with SQL*Plus, 5.3

reviewing, 5.2

SYS, 3.4.2

SYSMAN, 3.4.2

SYSTEM, 3.4.2

unlocking, 5.3

with Database Control, 5.3

with SQL*Plus, 5.3

PATH environment variable

setting, 2.13

pathnames

OFA, B.3.2.2

pdisk command, 2.10.3, 2.11

permissions

for datafile directories, 2.9

for Oracle base directory, 2.7

physical RAM requirements, 2.2

ports

default port ranges, C

post-installation

recommended tasks

root.sh script, backing up, 4.2.1

user accounts, setting up, 4.2.3

required tasks, 4.1

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

Precompilers

requirements on Mac OS X, 2.3

preconfigured database

ASM disk space requirements, 2.10.1

requirements when using ASM, 2.10.1

privileged groups

for Oracle Database, 2.4

Pro*C/C++

configuring, 4.3.5.1

requirements on Mac OS X, 2.3

R

RAC

supported storage locations, 2.8

RAID

recommended ASM redundancy level, 2.10.1

using for Oracle datafiles, 2.9

RAM requirements, 2.2

raw devices

creating a raw device mapping file, 2.11

storage option for datafiles, 2.8

recovery files

options for placing on file system, 2.9

redo log, B.3.3

redo log files

in starter database, 5.6.2

locating, 5.6.2

naming, B.3.3

reviewing, 5.6

using Oracle Enterprise Manager Database Control with, 5.6.2

redundancy level

and space requirements for preconfigured database, 2.10.1

for ASM, 1.5.1

redundant array of independent disks

See RAID

requirements

hardware, 2.2

response files

custom.rsp, A.3

enterprise.rsp, A.3

standard.rsp, A.3

root user, 3.4.2, 3.4.2

logging in as, 2.1

root.sh script

backing up, 4.2.1

S

semume parameter

recommended value on Mac OS X, 2.5

SERVICE_NAMES initialization parameter, 5.4, 5.4

shared storage

requirement for RAC, 2.8

shell

determining default shell for oracle user, 2.13

SHELL environment variable

checking value of, 2.13

shell startup file

editing, 2.13

removing environment variables, 2.13

SID, 5.4

setting ORACLE_SID environment variable, 2.13

silent mode installation, A.3, A.4

software certification, 1.6.1

software requirements

Mac OS X, 2.3

standard.rsp files, A.3

startup file

for shell, 2.13

storage device

shared storage requirements, 2.8

swap space

requirements, 2.2

SYS user password, 3.4.2

SYSAUX tablespace, 5.6.1

sysctl command, 2.5

sysctl.conf file, 2.5

SYSDBA privilege

associated UNIX group, 2.4

SYSMAN user password, 3.4.2

SYSOPER privilege

associated UNIX group, 2.4

System Identifier, 5.4

See SID

SYSTEM tablespace, 5.6.1

SYSTEM user password, 3.4.2

T

tablespaces

defined, 5.6.1

in databases, 5.6.1

reviewing, 5.6

setting up, 5.6.1

EXAMPLE, 5.6.1

MGMT_ECM_DEPOT_TS, 5.6.1

MGMT_TABLESPACE, 5.6.1

OFA

naming, B.3.5

special tablespaces, B.3.4

SYSAUX, 5.6.1

SYSTEM, 5.6.1

TEMP, 5.6.1

UNDOTBS, 5.6.1

USERS, 5.6.1

TEMP environment variable, 2.2

setting, 2.13

TEMP tablespace, 5.6.1

temporary directory, 2.2

temporary disk space

checking, 2.2

freeing, 2.2

requirements, 2.2

/tmp directory

checking space in, 2.2

freeing space in, 2.2

TMPDIR environment variable, 2.2

setting, 2.13

TNS_ADMIN environment variable

unsetting, 2.13

troubleshooting, D

fatal errors, D.4.2

U

Ultra Search

default ports, C.1

umask, 2.13

umask command, 2.13, 2.13

UNDOTBS tablespace, 5.6.1

UNIX commands, 2.13

chmod, 2.7, 2.9

chown, 2.7, 2.9

env, 2.13

id, 2.4.5

mkdir, 2.7, 2.9

pdisk, 2.10.3, 2.11

ps, 2.12

sysctl, 2.5

umask, 2.13

unset, 2.13

unsetenv, 2.13

UNIX directory subtrees, B.2.1

UNIX groups

checking for existing oinstall group, 2.4.1

creating the dba group, 2.4.2

creating the oinstall group, 2.4.1

creating the oper group, 2.4.3

oinstall, 2.4

OSDBA (dba), 2.4

OSOPER (oper), 2.4

required for oracle user, 2.4

requirements, 2.4

using NIS, 2.4

UNIX users

checking existence of the nobody user, 2.4.5

creating the oracle user, 2.4.4, 2.4.4

nobody, 2.4

oracle, 2.4

required for external jobs, 2.4

requirements, 2.4

unprivileged user, 2.4

using NIS, 2.4

unprivileged user

nobody user, 2.4

unset command, 2.13

unsetenv command, 2.13

upgraded databases

configuring, 4.2.2

user names

ANONYMOUS, 5.2

BI, 5.2

CTXSYS, 5.2

DBSNMP, 5.2

DIP, 5.2

DMSYS, 5.2

EXFSYS, 5.2

HR, 5.2

IX, 5.2

LBACSYS, 5.2, 5.2

MDDATA, 5.2, 5.2

MDSYS, 5.2, 5.2

MGMT_VIEW, 5.2, 5.2

ODM, 5.2, 5.2

ODM_MTR, 5.2, 5.2

OE, 5.2, 5.2

OLAPSYS, 5.2, 5.2

ORDPLUGINS, 5.2, 5.2

ORDSYS, 5.2, 5.2

OUTLN, 5.2, 5.2

PM, 5.2, 5.2

SCOTT, 5.2

SH, 5.2

SI_INFORMTN_SCHEMA, 5.2

SYS, 5.2

SYSMAN, 5.2

SYSTEM, 5.2

WK_TEST, 5.2

WKPROXY, 5.2

WKSYS, 5.2

WMSYS, 5.2

XDB, 5.2

users

checking existence of the nobody user, 2.4.5

creating the oracle user, 2.4.4, 2.4.4

Oracle Software Owner user (oracle), 2.4

UNIX nobody user, 2.4

USERS tablespace, 5.6.1

utlrep.sql

recompiling invalid SQL modules, 4.2.2

V

/var/opt/oracle/oraInst.loc file

reviewing log files, D.3

very large databases

OFA naming mount points, B.3.1.3

voting disk

raw device for, 2.11

W

Windows

analogy for Oracle base directory, 2.6