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

unauthenticated access to, 6.7.2

ACFS, 1.8.2

requirements, 3.2

ADVM

requirements, 3.2

aliases, multiple on computers, 2.6.3

ANONYMOUS user

unauthenticated account access with, 6.7.2

APPC-enabled databases, H.4

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

ASM

checking disk availability on Oracle Solaris, 3.6.4

asm groups

creating, 2.7.2.4

ASM See Oracle Automatic Storage Management

asmcmd utility, 3.11

asmdba groups

creating, 2.7.2.5, 2.7.2.5

Automatic Storage Management

block and character device names

on Oracle Solaris, 3.6.4

changing owner and permissions of disks

on Oracle Solaris, 3.6.4

identifying available disks on Oracle Solaris, 3.6.4

identifying disks on Oracle Solaris, 3.6.4

B

backups of database

Oracle Database Recovery Manager, H.2

base directory

See Oracle base directory

block device

device name on Oracle Solaris, 3.6.4

C

certification, hardware and software, 1.3.1

character device

device name on Oracle Solaris, 3.6.4

chmod command, 2.11.2, 2.13.2, 3.6.4

chown command, 2.11.2, 2.13.2, 3.6.4

CLASSPATH environment variable, 5.3.4.3

client static library, generating, 5.2.5

cloning

Configuring Oracle Configuration Manager in a Cloned Oracle Home, B.2

Oracle home, B.1

Cluster Manager

ports, ranges and protocol, E.3

Cluster Ready Services (CRS). See Oracle Clusterware

Cluster Synchronization Services (CSS)

Oracle Automatic Storage Management, 1.8.2

ports, ranges and protocol, E.3

clusters

installation guidelines, 4.2

See also Oracle Clusterware, Oracle Real Application Clusters

Clusterware

installed before Oracle Database, 4.2

Clusterware. See Oracle Clusterware

commands

runcluvfy.sh, 3.7.1

setup.exe, 3.7.1

useradd, 2.7.2.7.2

usermod, 2.7.2.7.3

computers with multiple aliases, 2.6.3

computers, non-networked, 2.6.4

configuration assistants

failure, G.7.1

troubleshooting, G.7, G.7

configuring

accounts of Oracle users, 5.2.3.1

configuring disks for Oracle Automatic Storage Management, 3.6.1, 4.2.2

Configuring Oracle Configuration Manager in a Cloned Oracle Home, B.2

Connection Manager

ports, ranges and protocol, E.3

control files

locating, 6.10.3

naming, D.2.3

reviewing, 6.10

using Oracle Enterprise Manager Database Control with, 6.10.3

CONTROL_FILES initialization parameter, 6.10.3

create inventory, 4.5.1

CSD

download location for WebSphere MQ, 2.3.4.2

custom database

failure groups for Oracle Automatic Storage Management, 3.6.2

requirements when using Oracle Automatic Storage Management, 3.6.2, 3.6.2

custom install option, 4.5.1

D

DAS (direct attached storage) disks, 3.6.3

data files

creating separate directories for, 2.13.2

defined, 6.10.1

managing with Oracle ASM, 1.8.2

minimum disk space for, 2.13.1

naming, D.2.3

options for placing on file system, 2.13

recommendations for file system, 2.13.1

reviewing, 6.10

setting permissions on data file directories, 2.13.2

setting up, 6.10.1

data loss

minimizing with Oracle Automatic Storage Management, 3.6.2

data mining tools

Oracle Data Mining, H.2

data warehousing tool

Oracle OLAP, H.2

Database Configuration Assistant

running in silent mode, A.6

troubleshooting, G.7

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.6.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.2

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 on Oracle Solaris, 3.6.4

creating, 2.7.2.2, 2.7.2.2

description, 2.7.1.2, 2.7.1.3

SYSDBA privilege, 2.7.1.2

dba groups

creating, 2.7.2.4, 2.7.2.6

dbca.rsp file, A.3.1

default data files, 6.10.1

default file mode creation mask

setting, 2.15

default tablespaces, 6.10.1

Deinstallation Tool, 7.1

description

database restart, 3

Oracle Restart, 3

device names

on Oracle Solaris, 3.6.4

DHCP computers, installing on, 2.6.1

E

Enterprise Manager Database Control Agent

ports

ranges and protocol, E.3

enterprise.rsp file, A.3.1

environment

configuring for oracle user, 2.15

environment variables

DISPLAY, 2.15

NLS_LANG, F.1.1.2

ORACLE_BASE, 2.11.2, 2.15

ORACLE_HOME, 2.14, 2.15, 2.15

ORACLE_HOSTNAME, 2.6.2

ORACLE_SID, 2.15

PATH, 2.15

SHELL, 2.15

TMP and TMPDIR, 2.2.3, 2.15, 3.1.2

TNS_ADMIN, 2.15

errors

configuration assistants, G.7

display errors, G.3

installation, G.4, G.5, G.7.2

remote terminal installation, G.3

response file installation, G.10

silent mode, G.10

su command, G.3

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

X Window, G.1

X Window display errors, G.2

/etc/system file, 2.9

EXAMPLE tablespace

description, 6.10.1

example01.DBF data file, 6.10.1

examples

Oracle Automatic Storage Management failure groups, 3.6.2, 3.6.2

Oracle base directories, 2.10.1

external redundancy

Oracle Automatic Storage Management redundancy level, 3.6.2

F

failure group

examples of Oracle Automatic Storage Management failure groups, 3.6.2

failure groups

characteristics of Oracle Automatic Storage Management failure group, 3.6.2

examples in Oracle Automatic Storage Management, 3.6.2

in Oracle ASM, 1.8.2

Fast Recovery Area, 5.2.7

fatal errors, G.7.2

file mode creation mask

setting, 2.15

file sets, 2.3

file system

appropriate for Oracle base directory, 2.11.2

data file and recovery file placement options, 2.13

identifying formatted devices on Oracle Solaris, 3.6.4

requirements for Oracle base directory, 2.11.2

using for data files, 2.13.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.3.1

enterprise.rsp, A.3.1

/etc/group, D.2.2.3

/etc/passwd, D.2.2.3

/etc/system, 2.9

listener.ora, 5.3.1

mgw.ora, 5.3.4.3

oraInst.loc, 2.7.2.1

oraInst.loc file, A.2

oratab, 2.11.1, 2.11.1

redo log, 6.10.2

response files, A.3

tnsnames.ora, 5.3.1

Flash Recovery Area

See Fast Recovery Area

format command, 3.6.4

G

Gateways products FAQ, H.4

Global Database Name

about, 4.5.1

global database name, 6.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.7.2.1

creating the asm group, 2.7.2.4, 2.7.2.4

creating the asmdba group, 2.7.2.5

creating the dba group, 2.7.2.2, 2.7.2.2

creating the oinstall group, 2.7.2.1

creating the oper group, 2.7.2.3, 2.7.2.3

UNIX OSDBA group (dba), 2.7.1.2

UNIX OSDBA group for Oracle Restart (dba), 2.7.1.3

UNIX OSOPER group (oper), 2.7.1.2

H

hardware certification, 1.3.1

hardware requirements, 2.2, 3.1

disk space, 2.2.3

display, 2.2.4

memory, 2.2.1

run level, 2.2.5

system architecture, 2.2.2

high redundancy

Oracle Automatic Storage Management redundancy level, 3.6.2

home directory

See Oracle home directory

host name, setting before installation, 2.6.2

I

IBM DB2 database, H.4

IBM DB2 z/OS database, H.4

IBM DB2/400 database, H.4

IBM WebSphere MQ Series databases, H.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.6.3

considerations, 1.3

database editions, 1.6

errors, G.5, G.7.2

silent mode, G.10

laptops, 2.6.4

log files, G.4, G.4

Oracle Automatic Storage Management requirements, 3.6.2

overview, 1

response file

oraInst.loc file, A.2

response files, A, A.3

preparing, A.3, A.3.2

silent mode, G.10

templates, A.3

responsefile

error handling, G.10

silent mode, A.4

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

instance

instance identifier (SID), 2.15

IP addresses, multiple, 2.6.2

IPC protocol address

Oracle Messaging Gateway setting, 5.3.4.1

J

JDK

internationalization class, 5.3.4.3

run-time class, 5.3.4.3

JDK requirements, 2.3

K

kernel parameters

checking on Oracle Solaris, 2.9

making changes persist on Oracle Solaris, 2.9

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

listener

identifying Oracle home for, 2.14

lsnrctl command, 2.14

stopping, 2.14, 2.14

listener.ora file, 5.3.1

modifying for external procedures, 5.3.4.1

local device

using for data files, 2.13.1

log files, G.4, G.4

troubleshooting, G.5

logical volume manager

See LVM

loopback adapters

non-networked computers, 2.6.4

lsnrctl command, 2.14

LVM

identifying volume group devices on Oracle Solaris, 3.6.4

recommendations for Oracle Automatic Storage Management, 3.6.2

Veritas Volume Manager on Oracle Solaris, 3.6.4

M

mask

setting default file mode creation mask, 2.15

memory requirements, 2.2, 3.1

MGW_AGENT service name, 5.3.4.2

mgwextproc service

adding static service information, 5.3.4.1

mgw.ora file

modifying, 5.3.4.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 Oracle Automatic Storage Management disk groups, 3.6.2

mkdir command, 2.11.2, 2.13.2

mode

setting default file mode creation mask, 2.15

mount point

for Oracle base directory, 2.10.1

mount point directories, 4.3.2.2

mount point directory

choosing, C.3

mount points

Optimal Flexible Architecture conventions for creating, D.2

MQSeries

class, 5.3.4.3

multihomed computers, installing on, 2.6.2

multiple aliases, computers with, 2.6.3

multiple databases and Oracle ASM, 2.7.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

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

non-networked computers, 2.6.4

primary, on computers with multiple aliases, 2.6.3

See also loopback adapters, primary network adapters

network cards, multiple, 2.6.2

Network Information Services

alternative to local users and groups, 2.7.2

Network Information Services.See NIS

network setup

about, 2.6

computers with multiple aliases, 2.6.3

network topics

DHCP computers, 2.6.1

laptops, 2.6.4

multiple network cards, 2.6.2

non-networked computers, 2.6.4

NFS

mount options, C.5

NLS_LANG environment variable, F.1.1.2

noninteractive mode

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

non-networked computers, 2.6.4

non-Oracle databases, listed, H.4

normal redundancy, Oracle Automatic Storage Management redundancy level, 3.6.2

O

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 2.7.2.1

oinstall groups

creating, 2.7.2.1

OLAP tools

about, H.2

Oracle OLAP, H.2

OMF

See Oracle Managed Files

oper group

creating, 2.7.2.3

description, 2.7.1.2

oper groups

creating, 2.7.2.3

operating system accounts

creating and configuring, 5.2.3

operating system groups

creating the oinstall group, 2.7.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.10.1

recommended path for Oracle base directory, 2.10.1

recommended path for Oracle home directory, 2.10.3

recommended path for Oracle Inventory directory, 2.10.2

special tablespaces, D.2.4

standard, D

using separate segments, D.2.4

Oracle ACFS, 1.8.2, 3.2, 3.2

requirements, 3.2

Oracle ADVM, 3.2, 3.2

requirements, 3.2

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

characteristics of failure groups, 3.6.2

configuring disks, 3.6.1, 4.2.2

configuring disks for Automatic Storage Management, 3.6.4

considerations before installing, 3.5

DAS disks, 3.6.3

disk devices, 1.8.2

disk groups, 3.6.2

disks, supported, 3.6.3

failure groups

examples, 3.6.2, 3.6.2

identifying, 3.6.2

installation, testing, 3.11

managing, 6.3.2

mirroring, 3.6.2

multiple databases, 2.7.1.3

Optimal Flexible Architecture file naming conventions, D.2.3

Oracle ASM disk group templates, 1.8.2

partition creation, 3.6.3

password file, 3.5

recommendations for disk groups, 3.6.2

redundancy levels, 3.6.2

response files, A.1.2

SAN disks, 3.6.3

space required for preconfigured database, 3.6.2

SPFILE server parameter file, 3.5

starting and stopping, 6.3.1

templates, 1.8.2

Oracle Automatic Storage Management Cluster File System, 1.8.2, 3.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.11.2

creating new, 2.11.2

description, 2.10.1

examples, 2.10.1

identifying appropriate file system, 2.11.2

identifying existing, 2.11.1

mount point for, 2.10.1

naming conventions, D.2.2

recommended path, 2.10.1

relationship with Oracle software owner user, 2.10.1

requirement for, 2.10.1

requirements for existing directory, 2.11.1

requirements on file system, 2.11.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 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.13.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.13.1

naming, 4.5.1

requirements with Oracle Automatic Storage Management, 3.6.2

security management, H.2

setting ORACLE_SID environment variable, 2.15

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.3.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.4.5

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 Event Manager

ports, ranges and protocol, E.3

Oracle home

cloning, B.1

Oracle home directory

description, 2.10.3

identifying for listener, 2.14

multiple homes, network considerations, 2.6.2

recommended path, 2.10.3

requirement for, 2.10.3

requirements, 2.10.3

using to identify Oracle base directory, 2.11.1

Oracle host name, setting before installation, 2.6.2

Oracle internationalization class, 5.3.4.3

Oracle Internet Directory, H.2

Oracle Inventory

description, 2.10.2

pointer file, 2.7.2.1

Oracle Inventory directory

description, 2.10.2

recommended path, 2.10.2

Oracle Inventory group

creating, 2.7.2.1

Oracle Inventory groups

checking for existing, 2.7.2.1

creating, 2.7.2.1

Oracle JDBC class, 5.3.4.3

Oracle Label Security

post-installation tasks, 5.3.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, D.2.3

Oracle Messaging Gateway

postinstallation tasks, 5.3.4

Oracle Messaging Gateway class, 5.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, 5.3.1

identifying Oracle home for listener, 2.14

lsnrctl command, 2.14

stopping listener, 2.14

stopping the listener, 2.14

Oracle Net Configuration Assistant

response file, A.3.1

Oracle Net Services

post-installation tasks, 5.3.1

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

OSDBA group description, 2.7.1.3

user, 2.7.1.3

Oracle Schemas, Preface

Oracle Software Owner user

and Automatic Storage Management disks, 3.6.4

creating, 2.7.2.7, 2.7.2.7.1

oracle user, 2.7.2.7.2

Oracle software owner user

configuring environment for, 2.15

determining default shell, 2.15

relationship with Oracle base directory, 2.10.1

Oracle Solaris

block and character device names, 3.6.4

checking disk availability for Automatic Storage Management, 3.6.4

checking kernel parameters, 2.9

identifying disks for Automatic Storage Management, 3.6.4

identifying file systems, 3.6.4

identifying LVM disks, 3.6.4

making kernel parameter changes persist, 2.9

patch download location, 2.3.5

Oracle SQL Developer

accessing, 6.5

Oracle SQL*Net Listener

ports, ranges and protocol, E.3

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

running, 4.5.1

running in different languages, F.2

oracle user

and Automatic Storage Management disks, 3.6.4

configuring environment for, 2.15

creating, 2.7.2.7.1

determining default shell, 2.15

relationship with Oracle base directory, 2.10.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.11.2

setting, 2.15

ORACLE_HOME environment variable

setting, 2.14

unsetting, 2.15

ORACLE_HOSTNAME, 2.6.2

ORACLE_HOSTNAME environment variable

computers with multiple aliases, 2.6.3

multihomed computers, 2.6.2

setting before installation, 2.6.2

ORACLE_SID environment variable

setting, 2.15

oraInst.loc file

location, 2.7.2.1

location of, 2.7.2.1

oraInventory directory

See Oracle Inventory directory

oratab file, 2.11.1

formats, 2.11.1

location of, 2.11.1

OSASM groups

creating, 2.7.2.4

multiple databases, 2.7.1.3

SYSASM, 2.7.1.3

OSDBA group

and Automatic Storage Management disks on Oracle Solaris, 3.6.4

OSDBA groups

creating, 2.7.2.2

creating for Oracle Grid Infrastructure, 2.7.2.5

description for database, 2.7.1.2

SYSDBA privilege, 2.7.1.2

SYSDBA privilege for Oracle Restart, 2.7.1.3

OSOPER groups

creating, 2.7.2.3

description for database, 2.7.1.2

SYSOPER privilege, 2.7.1.2, 2.7.1.2

OTN Web site

downloading installation software from, 4.3.1

P

packages, checking, 2.3.2

partition

using with Oracle Automatic Storage Management, 3.6.2

partitions

creation for Oracle Automatic Storage Management disks, 3.6.3

slices on Oracle Solaris, 3.6.4

passwd file, D.2.2.3

password file for Oracle Automatic Storage Management, 3.5

passwords

resetting, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

reviewing, 6.6

specifying for response files, A.1

unlocking, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

R

RAID

using for Oracle data files, 2.13.1

RAM requirements, 2.2, 3.1

readme.txt file, E.2

recommendations

on perfomring software-only installations, 3.7

recovery files

options for placing on file system, 2.13

recovery of databases

Oracle Backup and Recovery, H.2

Red Hat Package Manager

See RPM

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.6.2, 3.6.2

for Oracle Automatic Storage Management, 3.6.2

redundant array of independent disks

See RAID

requirements

hardware, 2.2, 3.1

response file installation

oraInst.loc file, A.2

response files

preparing, A.3, A.3.2

templates, A.3

silent mode, A.4

errors, G.10

response file mode

about, A.1

reasons for using, A.1.1

response files, A.1

about, A.1

creating with template, 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

Oracle Automatic Storage Management, A.1.2

passing values at command line, A.1

passwords, A.1

security, A.1

specifying with Oracle Universal Installer, A.4

response files installation

about, A

root user, 4.5.1, 4.5.1

logging in as, 2.1

root.sh script

backing up, 5.2.1

RPM

checking, 2.3.2

rpm command, 2.3.2

S

Sample Schemas

tablespaces and data files, 6.10.1

SAN (storage area network) disks, 3.6.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.7

management tools, H.2

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

TMP environment variable, 2.2.3, 3.1.2

setting, 2.15

TMPDIR environment variable, 2.2.3, 3.1.2

setting, 2.15

TNS_ADMIN environment variable

unsetting, 2.15

tnsnames.ora file, 5.3.1

adding a connect descriptor, 5.3.4.2

MGW_AGENT service name, 5.3.4.2

modifying for external procedures, 5.3.4.2

troubleshooting, G

display errors, G.3

fatal errors, G.7.2

remote terminal installation, G.3

su command, G.3

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

U

umask command, 2.15

UNDOTBS

tablespace (undotbs01.dbf), 6.10.1

UNIX commands

chmod, 2.11.2, 2.13.2, 3.6.4

chown, 2.11.2, 2.13.2, 3.6.4

format, 3.6.4

mkdir, 2.11.2, 2.13.2

patchadd, 2.3.5

ps, 2.14

rpm, 2.3.2

sysdef, 2.9

umask, 2.15

unset, 2.15

unsetenv, 2.15

vxdisk, 3.6.4

xhost, 2.1

xterm, 2.1

UNIX groups

checking for existing oinstall group, 2.7.2.1

OSDBA (dba), 2.7.1.2

OSDBA (dba) for Oracle Restart, 2.7.1.3

OSOPER (oper), 2.7.1.2

using NIS, 2.7.2

UNIX users

using NIS, 2.7.2

UNIX workstation

installing from, 2.1

unset command, 2.15

unsetenv command, 2.15

upgraded databases

configuring, 5.2.2

upgrading, 1.13

ASM, 1.13.1

Daylight Savings Time, 1.13.2

useradd command, 2.7.2.7.2

USERS

tablespace (users01.dbf), 6.10.1

users

creating the oracle user, 2.7.2.7, 2.7.2.7.1

Oracle Restart, 2.7.1.3

users and groups, 2.7

UTLRP.SQL

recompiling invalid SQL modules, 5.2.2

V

Veritas Volume Manager, 3.6.4

very large databases

Optimal Flexible Architecture naming mount points, D.2.2.2

vxdisk command, 3.6.4

VxVM, 3.6.4

W

Web servers (Oracle HTTP Server), H.3

WebSphere MQ

CSD download location, 2.3.4.2

WebSphere MQ class, 5.3.4.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