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

unlocking

with Oracle Enterprise Manager Database Express, 8.7.1

ACFS, 2.8.2

requirements, 5.2, 5.2.2

ADVM

requirements, 5.2, 5.2.2

aliases, multiple on computers, E.2

AMM, 2.3.5

APPC-enabled databases, J.4

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

ASM

checking disk availability on Oracle Solaris, 5.3.3.3

asm groups

creating, 4.1.5.8

asmcmd utility, 5.3.5

asmdba groups

creating, 4.1.5.6, 4.1.5.6

Automatic Memory Management, 2.3.5

Automatic Storage Management

block and character device names

on Oracle Solaris, 5.3.3.3

changing owner and permissions of disks

on Oracle Solaris, 5.3.3.3

identifying available disks on Oracle Solaris, 5.3.3.3

identifying disks on Oracle Solaris, 5.3.3.3

B

backupdba, 4.1.4.3

backupdba group

creating, 4.1.5.3

backups of database

Oracle Database Recovery Manager, J.2

base directory

See Oracle base directory

block device

device name on Oracle Solaris, 5.3.3.3

C

CDBs, Preface, 6.4.1

database character set, 6.2.1

installation, 6.4.1

PDBADMIN password, 6.4.1

S_PDBADMINPASSWORD, A.6.2

certification, hardware and software, 2.3.1

character device

device name on Oracle Solaris, 5.3.3.3

chmod command, 3.15.2, 3.17.2, 5.3.3.3

chown command, 3.15.2, 3.17.2, 5.3.3.3

cloning

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

Oracle home, B.1

Cluster Synchronization Services (CSS)

Oracle Automatic Storage Management, 2.8.2

ports, ranges and protocol, G.3

clusters

installation guidelines, 6.2

See also Oracle Clusterware, Oracle Real Application Clusters

commands

runcluvfy.sh, 5.4.1

setup.exe, 5.4.1

useradd, 4.1.5.11

usermod, 4.1.5.12

computers with multiple aliases, E.2

computers, non-networked, E.3

configuration assistants

failure, I.8.1

troubleshooting, I.8, I.8

configuring

accounts of Oracle users, 7.3.2.1

configuring disks for Oracle Automatic Storage Management, 6.2.2

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

Connection Manager

ports, ranges and protocol, G.3

control files

locating, 8.10.3

naming, F.2.3

reviewing, 8.10

using Oracle Enterprise Manager Database Express with, 8.10.3

CONTROL_FILES initialization parameter, 8.10.3

create inventory, 6.4.1

cron jobs, 1.6

custom database

failure groups for Oracle Automatic Storage Management, 5.3.3.1

requirements when using Oracle Automatic Storage Management, 5.3.3.1, 5.3.3.1

customize the database, 6.4.1

D

DAS (direct attached storage) disks, 5.3.3.2

data files

creating separate directories for, 3.17.2

defined, 8.10.1

managing with Oracle ASM, 2.8.2

minimum disk space for, 3.17.1

naming, F.2.3

options for placing on file system, 3.17

recommendations for file system, 3.17.1

reviewing, 8.10

setting permissions on data file directories, 3.17.2

setting up, 8.10.1

data loss

minimizing with Oracle Automatic Storage Management, 5.3.3.1

data mining tools

Oracle Data Mining, J.2

data warehousing tool

Oracle OLAP, J.2

Database Configuration Assistant

response file, A.2.1

running in silent mode, A.5

troubleshooting, I.8

databases

files, 8.10.1

identifying, 8.8

initialization parameter file, 8.9

naming, 6.4.1

non-Oracle

APPC-enabled, J.4

non-Oracle, listed, J.4

OLAP support (Oracle OLAP), J.2

Optimal Flexible Architecture file naming conventions, F.2.3

Oracle Automatic Storage Management requirements, 5.3.3.1

recovery with Oracle Backup and Recovery, J.2

redo log files, 8.10.2

security management, J.2

tablespaces, 8.10.1

DB_DOMAIN initialization parameter, 8.8

DB_NAME initialization parameter, 8.8, 8.8

DB2 database, J.4

DB2 z/OS database, J.4

DB2/400 database, J.4

dba group

and Automatic Storage Management disks on Oracle Solaris, 5.3.3.3

creating, 4.1.5.1, 4.1.5.1

description, 4.1.4.2, 4.1.4.4

SYSDBA privilege, 4.1.4.2

dba groups

creating, 4.1.5.5, 4.1.5.7, 4.1.5.8

dbca.rsp file, A.2.1

Deconfiguring

Oracle Restart, I.6

default data files, 8.10.1

default file mode creation mask

setting, 4.4

default tablespaces, 8.10.1

Deinstallation tool, 9

about, 9.1

example, 9.2, 9.3

previous grid home, 9.1.1

roothas.sh, 9.1

deinstalling previous grid home, 9.1.1

deprecated features, Preface

description

database restart, 5

Oracle Restart, 5

desupported features, Preface

device names

on Oracle Solaris, 5.3.3.3

dgdba, 4.1.4.3

dgdba group

creating, 4.1.5.4

Direct NFS Client

about, 7.4.10.1

about oranfstab, 7.4.10.2

attributes, 7.4.10.7

checking NFS buffer size, 7.4.10.4

configuring, 7.4.10

disabling, 7.4.10.8

enabling, 7.4.10.7

Enabling HCC, 7.4.10.9

mounting NFS, 7.4.10.3

SNMP support, 7.4.10.9

specifying network path, 7.4.10.6

TCP bufferl TCP buffer error, 7.4.10.5

E

enterprise.rsp file, A.2.1

environment

configuring for oracle or grid user, 4.4

Environment Requirements for grid user, 5.1.4

environment variables

DISPLAY, 4.4

NLS_LANG, H.1.1.2

ORACLE_BASE, 3.15.2, 4.4

ORACLE_HOME, 4.3, 4.4, 4.4

ORACLE_HOSTNAME, E.1

ORACLE_SID, 4.4

PATH, 4.4

SHELL, 4.4

TMP and TMPDIR, 3.3.1, 3.3.3, 4.4, 5.1.3

TNS_ADMIN, 4.4

ephemeral ports, D.3

errors

configuration assistants, I.8

display errors, I.3

installation, I.4, I.5, I.8.2

remote terminal installation, I.3

response file installation, I.11

silent mode, I.11

su command, I.3

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

X Window, I.1

X Window display errors, I.2

X11 forwarding, 4.2

/etc/system file, D.1.4

EXAMPLE tablespace

description, 8.10.1

example01.DBF data file, 8.10.1

examples

Oracle Automatic Storage Management failure groups, 5.3.3.1, 5.3.3.1

Oracle base directories, 3.14.1

external redundancy

Oracle Automatic Storage Management redundancy level, 5.3.3.1

F

failure group

examples of Oracle Automatic Storage Management failure groups, 5.3.3.1

failure groups

characteristics of Oracle Automatic Storage Management failure group, 5.3.3.1

examples in Oracle Automatic Storage Management, 5.3.3.1

in Oracle ASM, 2.8.2.1

Fast Recovery Area, 7.3.5

fatal errors, I.8.2

file mode creation mask

setting, 4.4

file system

appropriate for Oracle base directory, 3.15.2

data file and recovery file placement options, 3.17

identifying formatted devices on Oracle Solaris, 5.3.3.3

requirements for Oracle base directory, 3.15.2

using for data files, 3.17.1

files, F.2.3

$ORACLE_HOME/dbs/initsid.ora, 8.9

control, 8.10.3, F.2.3

data files, F.2.3

dbca.rsp, A.2.1

enterprise.rsp, A.2.1

/etc/group, F.2.2.3

/etc/passwd, F.2.2.3

/etc/system, D.1.4

listener.ora, 7.4.1.1

oraInst.loc, 4.1.1

oratab, 3.15.1, 3.15.1

redo log, 8.10.2

response files, A.2

tnsnames.ora, 7.4.1

filesets, 3.7.1, 3.7.2, 3.8.1, 3.8.2

Flash Recovery Area

See Fast Recovery Area

format command, 5.3.3.3

G

Gateways products FAQ, J.4

global database name, 8.8

Global Database Name

about, 6.4.1

globalization

support for, 1.6

globalization support, H

grid user

configuring environment, 5.1.4

configuring environment for, 4.4

environment requirements, 5.1.4

group file, F.2.2.3

groups

checking for existing oinstall group, 4.1.1

creating the asm group, 4.1.5.8, 4.1.5.8

creating the asmdba group, 4.1.5.6

creating the backupdba group, 4.1.5.3, 4.1.5.3

creating the dba group, 4.1.5.1, 4.1.5.1

creating the dgdba group, 4.1.5.4, 4.1.5.4

creating the kmdba group, 4.1.5.5, 4.1.5.5

creating the oinstall group, 4.1.1

creating the oper group, 4.1.5.2, 4.1.5.2

UNIX OSDBA group (dba), 4.1.4.2

UNIX OSDBA group for Oracle Restart (dba), 4.1.4.4

UNIX OSOPER group (oper), 4.1.4.2

H

hardware certification, 2.3.1

hardware requirements, 3.3, 5.1

checking, 3.3.1

general, 3.3.2

high redundancy

Oracle Automatic Storage Management redundancy level, 5.3.3.1

home directory

See Oracle home directory

host name resolution, 3.13

host name, setting before installation, E.1.1

I

IBM DB2 database, J.4

IBM DB2 z/OS database, J.4

IBM DB2/400 database, J.4

IBM WebSphere MQ Series databases, J.4

Informix Server database, J.4

initialization parameter file

description, 8.9

in databases, 8.9

initsid.ora, 8.9

initialization parameters

DB_NAME, 8.8

DOMAIN_NAME, 8.8

SERVICE_NAMES, 8.8

initsid.ora file, 8.9

initsid.ora initialization parameter file, 8.9

installation

accessing installation software, 6.3

and cron jobs, 1.6

and globalization, 1.6

available products, 2.5, 2.5

cleaning up after a failed installation, I.12

clusters, installation guidelines, 6.2

component-specific guidelines, 6.2

computer aliases, multiple, E.2

considerations, 2.3

database editions, 2.5

errors, I.5, I.8.2

silent mode, I.11

laptops, E.3

log files, I.4, I.4

Oracle Automatic Storage Management requirements, 5.3.3.1

overview, 2

response files, A, A.2

preparing, A.2, A.2.2

silent mode, I.11

templates, A.2

silent mode, A.3

upgrading, J.1

installation errors

steps to resolve, I.4

installation guidelines, 6.4.1, 6.4.1

installation overview, 2.2

installation software

copying to a hard disk, 6.3.2.2

extracting, 6.3.1.3

installation software, accessing, 6.3

Installing

Oracle restart, 5.5.1

instance

instance identifier (SID), 4.4

instfix command, 3.12

IP addresses, multiple, E.1

J

Java

font package requirements for Solaris, 3.7.2, 3.8.2

JDK

font packages required on Solaris, 3.7.2, 3.8.2

K

kenel parameter

project.max-shm-memory checking, D.1.3

kernel parameter

shared memory resource, D.1.3

kernel parameters, 7.4.10.5

checking on Oracle Solaris, D.1.4

configuring, D.1

displaying and changing, D.1.4

ephemeral ports, D.3

making changes persist on Oracle Solaris, D.1.4

project.max-shm-memory requirement, D.1.2

setting manually, D.1, D.3

shared memory resources, D.1.2

UDP and TCP, D.3

kmdba, 4.1.4.3

kmdba group

creating, 4.1.5.5

L

languages

installing Oracle components in different languages, H.2

using Oracle components in different languages, H.1.2

laptops, installing Oracle Database on, E.3

listener

identifying Oracle home for, 4.3

lsnrctl command, 4.3

stopping, 4.3, 4.3

listener.ora file, 7.4.1.1

local device

using for data files, 3.17.1

log files, I.4, I.4

troubleshooting, I.5

log files locations in OFA, F.2.6

logical volume manager

See LVM

loopback adapters

non-networked computers, E.3

lsnrctl command, 4.3

LVM

identifying volume group devices on Oracle Solaris, 5.3.3.3

recommendations for Oracle Automatic Storage Management, 5.3.3.1

Veritas Volume Manager on Oracle Solaris, 5.3.3.3

M

mask

setting default file mode creation mask, 4.4

memory requirements, 3.3, 5.1

Microsoft SQL Server database, J.4

migrating

See upgrading

migrating applications to Oracle, J.3

migrating non-Oracle databases to Oracle, J.1

mirroring Oracle Automatic Storage Management disk groups, 5.3.3.1

mkdir command, 3.15.2, 3.17.2

mode

setting default file mode creation mask, 4.4

mount point

for Oracle base directory, 3.14.1

mount point directories, 6.3.2.2

mount point directory

choosing, C.2

mount points

Optimal Flexible Architecture conventions for creating, F.2

mounting NFS with DNFS, 7.4.10.3

multihomed computers, installing on, E.1

multiple aliases, computers with, E.2

multiple databases and Oracle ASM, 4.1.4.4

multiple Oracle homes, 2.3.2

N

naming subdirectories, F.2.2.5

NAS devices

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

guidelines for configuration, C.1

Net Configuration Assistant

troubleshooting, I.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, E.2

non-networked computers, E.3

primary, on computers with multiple aliases, E.2

See also loopback adapters, primary network adapters

network cards, multiple, E.1

Network protocol buffer

setting, 7.4.10.5

network setup

computers with multiple aliases, E.2

host name resolution, 3.13

network topics

laptops, E.3

multiple network cards, E.1

non-networked computers, E.3

NFS buffer size parameter, 7.4.10.4

NLS_LANG environment variable, H.1.1.2

noninteractive mode

See also response files, response file mode,

non-networked computers, E.3

non-Oracle databases, listed, J.4

normal redundancy, Oracle Automatic Storage Management redundancy level, 5.3.3.1

O

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 4.1.1

oinstall groups

creating, 4.1.1

OLAP tools

about, J.2

Oracle OLAP, J.2

OMF

See Oracle Managed Files

oper group

creating, 4.1.5.2

description, 4.1.4.2

oper groups

creating, 4.1.5.2

operating system

about requirements, 3.6

checking version of Solaris, 3.10

reviewing common practices, 3.4

operating system accounts

creating and configuring, 7.3.2

operating system groups

creating the oinstall group, 4.1.1

operating system requirements, 3.7.1, 3.7.2, 3.8.1, 3.8.2

operating system users

root user, 6.4.1

Optimal Flexible Architecture

advantages, F.1.1

conventions for creating mount points, F.2

file identification, F.2.5

file mapping, F.2.6

files systems, F.2.1.1

naming, F.2.1

database files, F.2.3

Oracle base directory, F.2.2

subdirectories, F.2.2.5

very large databases, F.2.2.2

Oracle Automatic Storage Management, F.2.3

Oracle Managed Files, F.2.3

overview, F.1

pathnames, F.2.2.3

recommendations for Oracle base directory, 3.14.1

recommended path for Oracle base directory, 3.14.1

recommended path for Oracle home directory, 3.14.3

recommended path for Oracle Inventory directory, 3.14.2

special tablespaces, F.2.4

standard, F

using separate segments, F.2.4

ORAchk audit tool, 7.3.7

Oracle ACFS, 2.8.2, 5.2, 5.2.2

enabling, 5.2.4

requirements, 5.2, 5.2.2

restrictions, 5.2.3

Oracle ADVM, 5.2, 5.2.2

requirements, 5.2, 5.2.2

restrictions, 5.2.3

Oracle Application Server, J.2

Oracle applications

installing with Oracle Database, J.3

Oracle ASM, 2.8.2

Oracle ASM disk groups

about, 2.8.2.1

Oracle ASM failure groups

about, 2.8.2.1

Oracle ASM instance

about, 2.8.2.2

Oracle ASMCA, 8.3.2

Oracle Automatic Storage Management Cluster File System, 2.8.2, 5.2, 5.2.2

Oracle Automatic Storage Management Configuration Assistant, 8.3.2

Oracle Automatic Storage Management disk groups

managing, 8.3.2

Oracle Automatic Storage Management Dynamic Volume Manager, 5.2, 5.2.2

Oracle Automatic Storage Management, 2.8.2

asmcmd utility, 5.3.5

characteristics of failure groups, 5.3.3.1

configuring disks, 6.2.2

configuring disks for Automatic Storage Management, 5.3.3.3

DAS disks, 5.3.3.2

disk devices, 2.8.2.1

disk groups, 5.3.3.1

disks, supported, 5.3.3.2

failure groups

examples, 5.3.3.1, 5.3.3.1

identifying, 5.3.3.1

installation, testing, 5.3.5

managing, 8.3.2

mirroring, 5.3.3.1

multiple databases, 4.1.4.4

Optimal Flexible Architecture file naming conventions, F.2.3

Oracle ASM disk group templates, 2.8.2.1

partition creation, 5.3.3.2

recommendations for disk groups, 5.3.3.1

redundancy levels, 5.3.3.1

response files, A.1.2

SAN disks, 5.3.3.2

space required for preconfigured database, 5.3.3.1

starting and stopping, 8.3.1

templates, 2.8.2.1

Oracle base directory

creating, 3.15.2

creating new, 3.15.2

description, 3.14.1

examples, 3.14.1

identifying appropriate file system, 3.15.2

identifying existing, 3.15.1

mount point for, 3.14.1

naming conventions, F.2.2

recommended path, 3.14.1

relationship with Oracle software owner user, 3.14.1

requirement for, 3.14.1

requirements for existing directory, 3.15.1

requirements on file system, 3.15.2

Oracle Cluster Registry port, G.3

Oracle Clusterware

about, J.1

used with Oracle Real Application Clusters, J.1

Oracle components

using in different languages, H.1.2

Oracle Data Mining

about, J.2

installing, J.2

Oracle Database

administering and monitoring, J.2

creating data file directories, 3.17.2

Enterprise Edition, 2.5

getting started using

accessing, 8.4, 8.5

starting and stopping database, 8.4, 8.5

installing with Oracle applications, J.3

minimum disk space requirements, 3.17.1

naming, 6.4.1

requirements with Oracle Automatic Storage Management, 5.3.3.1

security management, J.2

setting ORACLE_SID environment variable, 4.4

Standard Edition, 2.5

Standard Edition One, 2.5

Standard Edition Two, 2.5

upgrading, J.1

web servers, J.3

Oracle Database Client

configuring connections, J.1

Oracle Database components

administering and monitoring, J.2

connectivity FAQ, J.4

FAQ on installing, J.1

installing with Oracle applications, J.3

installing with Oracle Database tools, J.2

Oracle Database Recovery Manager (RMAN)

about, J.2

Oracle Database Vault

postinstallation task, 7.4.3

Oracle Enterprise Manager, 2.9

Database Express

using to modify control files, 8.10.3

using to modify redo log files, 8.10.2

using to view control files, 8.10.3

using to view redo log files, 8.10.2

Oracle Enterprise Manager Cloud Control, 2.9, 2.9.1

Oracle Enterprise Manager Database Express

identifying tablespaces and data files, 8.10.1

initialization parameters, 8.9

locating the server parameter file, 8.9

logging into, 8.2

port number, 8.2

unlocking accounts and resetting passwords, 8.7.1

Oracle home

ASCII path restriction for, 1.4

cloning, B.1

Oracle home directory

description, 3.14.3

identifying for listener, 4.3

multiple homes, network considerations, E.1

recommended path, 3.14.3

requirement for, 3.14.3

requirements, 3.14.3

using to identify Oracle base directory, 3.15.1

Oracle host name, setting before installation, E.1.1

Oracle Internet Directory, J.2

Oracle Inventory

description, 3.14.2

pointer file, 4.1.1

Oracle Inventory directory

description, 3.14.2

recommended path, 3.14.2

Oracle Inventory group

creating, 4.1.2

Oracle Inventory groups

checking for existing, 4.1.1

creating, 4.1.1

Oracle Label Security

post-installation tasks, 7.4.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, F.2.3

Oracle Messaging Gateway

postinstallation tasks, 7.4.4

Oracle Net

configuration file directory, 7.4.1

identifying Oracle home for listener, 4.3

lsnrctl command, 4.3

stopping listener, 4.3

stopping the listener, 4.3

Oracle Net Configuration Assistant

response file, A.2.1

Oracle Net Services

post-installation tasks, 7.4.1

Oracle Net Services Listener

ports, ranges and protocol, G.3

Oracle OLAP

about, J.2

Oracle Precompilers

postinstallation tasks, 7.4.5

Oracle Procedural Gateway

listed products, J.4

Oracle Real Application Clusters (RAC)

installing with Oracle Enterprise Manager, J.2

Oracle Clusterware

about, J.1

Oracle Restart

description, 5

Installing, 5.5.1

OSDBA group description, 4.1.4.4

relinking, 5.6

user, 4.1.4.4

Oracle Schemas, Preface

Oracle software owner user

configuring environment for, 4.4

determining default shell, 4.4

relationship with Oracle base directory, 3.14.1

Oracle Software Owner user

and Automatic Storage Management disks, 5.3.3.3

creating, 4.1.5.10

oracle user, 4.1.5.11

Oracle Solaris

block and character device names, 5.3.3.3

checking disk availability for Automatic Storage Management, 5.3.3.3

checking kernel parameters, D.1.4

identifying disks for Automatic Storage Management, 5.3.3.3

identifying file systems, 5.3.3.3

identifying LVM disks, 5.3.3.3

making kernel parameter changes persist, D.1.4

Oracle SQL Developer

accessing, 8.5

migrating non-Oracle applications to Oracle, J.3

migrating non-Oracle databases to Oracle, J.1

Oracle Technology Network (OTN)

downloading documentation from, Preface

Oracle Text knowledge base, 7.4.7

Oracle Transparent Gateway

listed products, J.4

Oracle Universal Installer

guidelines for using, 6.2

installation guidelines, 6.2

response files, A

list of, A.2.1

running, 6.4.1

running in different languages, H.2

oracle user

and Automatic Storage Management disks, 5.3.3.3

configuring environment for, 4.4

creating, 4.1.5.10

determining default shell, 4.4

relationship with Oracle base directory, 3.14.1

Oracle user accounts

configuring, 7.3.2.1

Oracle XML DB

about, J.2

configuring or reinstalling, 7.4.8

configuring the ports, 7.4.8

ports, ranges and protocol, G.3

ORACLE_BASE environment variable, 3.15.2

setting, 4.4

ORACLE_HOME environment variable

setting, 4.3

unsetting, 4.4

ORACLE_HOSTNAME, E.1

ORACLE_HOSTNAME environment variable

computers with multiple aliases, E.2

multihomed computers, E.1

setting before installation, E.1.1

ORACLE_SID environment variable

setting, 4.4

oraInst.loc file

location, 4.1.1

location of, 4.1.1

oraInventory directory

See Oracle Inventory directory

oratab file, 3.15.1

formats, 3.15.1

location of, 3.15.1

OSASM groups

creating, 4.1.5.8

multiple databases, 4.1.4.4

SYSASM, 4.1.4.4

OSBACKUPDBA, 6.4.1

OSBACKUPDBA group, 4.1.4.3

creating, 4.1.5.3

OSDBA group

and Automatic Storage Management disks on Oracle Solaris, 5.3.3.3

OSDBA groups

creating, 4.1.5.1

creating for Oracle Grid Infrastructure, 4.1.5.6

description for database, 4.1.4.2

SYSDBA privilege, 4.1.4.2

SYSDBA privilege for Oracle Restart, 4.1.4.4

OSDGDBA, 6.4.1

OSDGDBA group, 4.1.4.3

creating, 4.1.5.4

OSKMDBA, 6.4.1

OSKMDBA group, 4.1.4.3

creating, 4.1.5.5

OSOPER groups

creating, 4.1.5.2

description for database, 4.1.4.2

SYSOPER privilege, 4.1.4.2, 4.1.4.2

OTN website

downloading installation software from, 6.3.1

P

packages

checking on Oracle Solaris, 3.11

checking on Solaris, 3.10

partition

using with Oracle Automatic Storage Management, 5.3.3.1

partitions

creation for Oracle Automatic Storage Management disks, 5.3.3.2

slices on Oracle Solaris, 5.3.3.3

passwd file, F.2.2.3

passwords

resetting, 8.7

with Oracle Enterprise Manager Database Express, 8.7.1

with SQL*Plus, 8.7.2

reviewing, 8.6

unlocking, 8.7

with SQL*Plus, 8.7.2

patchadd command, 3.12

patches

download location for Solaris, 3.12

PATH environment variable

setting, 4.4

pathnames

Optimal Flexible Architecture, F.2.2.3

PDBs, Preface, 6.4.1

installation, 6.4.1

sample schema, 6.4.1

permissions

for data file directories, 3.17.2

for Oracle base directory, 3.15.2

pkginfo command, 3.10

port numbers

managing, G

portlist.ini file, G.2

ports

access URLs, G.2

Cluster Synchronization Services, ranges and protocol, G.3

configured for applications, G.2

Connection Manager, ranges and protocol, G.3

default ranges, G

Oracle Cluster Registry, G.3

Oracle Net, G.3

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

Oracle XML DB, ranges and protocol, G.3

post-installation

recommended tasks

creating operating system accounts, 7.3.2

root.sh script, backing up, 7.3.1

required tasks, 7.2

configuring Oracle Messaging Gateway, 7.4.4

Oracle Label Security, configuring, 7.4.2

Oracle Net Services, configuring, 7.4.1

Oracle Precompilers, 7.4.5

patches, installing and downloading, 7.2.1

postinstallation tasks

Oracle Text knowledge base, 7.4.7

preconfigured database

Oracle Automatic Storage Management disk space requirements, 5.3.3.1

requirements when using Oracle Automatic Storage Management, 5.3.3.1, 5.3.3.1

Pro*C/C++

configuring, 7.4.5.1

See also C compiler

process

stopping existing, 4.3

stopping listener process, 4.3

project.max-shm-memory checking, D.1.3

project.max-shm-memory requirement, D.1.2

ps command, 4.3

R

RAID

using for Oracle data files, 3.17.1

RAM requirements, 3.3, 5.1

readme.txt file, G.2

recommendations

on perfomring software-only installations, 5.4

recovery files

options for placing on file system, 3.17

recovery of databases

Oracle Backup and Recovery, J.2

redo log, F.2.3

redo log files

in starter database, 8.10.2

locating, 8.10.2

naming, F.2.3

reviewing, 8.10

using Oracle Enterprise Manager Database Express with, 8.10.2

redundancy level

and space requirements for preconfigured database, 5.3.3.1, 5.3.3.1

for Oracle Automatic Storage Management, 5.3.3.1

redundant array of independent disks

See RAID

Removing Oracle Database Software, 9

requirements

checking, 3.3

hardware, 3.3, 5.1

response file installation

response files

preparing, A.2, A.2.2

templates, A.2

silent mode, A.3

errors, I.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 script execution plan, 4.5

root scripts automation, 4.5

root user, 6.4.1, 6.4.1

logging in as, 3.2

roothas.sh, 5.4.2, 9.1, I.6

root.sh script

backing up, 7.3.1

S

Sample Schemas

tablespaces and data files, 8.10.1

SAN (storage area network) disks, 5.3.3.2

schema passwords, 6.4.1

schemas

database schema passwords, 6.4.1

Oracle Schemas, about, Preface

Sample Schemas tablespaces and data files, 8.10.1

security

dividing ownership of Oracle software, 4.1

management tools, J.2

separation of duty, 4.1

OSBACKUPDBA, 4.1.4.3, 6.4.1

OSDGDBA, 4.1.4.3, 6.4.1

OSKMDBA, 4.1.4.3, 6.4.1

SERVICE_NAMES initialization parameter, 8.8, 8.8

shell

determining default shell for oracle user, 4.4

SHELL environment variable

checking value of, 4.4

shell limits

configuring, D.2

setting manually, D.2

SID, 8.8

setting ORACLE_SID environment variable, 4.4

SID. See Oracle Database SID

silent mode

about, A.1

reasons for using, A.1.1

See also response file mode, response files,

silent mode installation, A.3

software certification, 2.3.1

software requirements

checking software requirements, 3.10

drivers and packages, 3.9

LDAP, 3.9.3

ODBC, 3.9.1

Oracle Messaging Gateway, 3.9.2

programming environments, 3.9.4

Solaris x86-64, 3.8

SPARC (64-bit), 3.7

web browsers, 3.9.5

software requirements for Solaris 10 on SPARC, 3.7.2

software requirements for Solaris 10 on x86-64, 3.8.2

software requirements for Solaris 11 on SPARC, 3.7.1

software requirements for Solaris 11 on x86-64, 3.8.1

Solaris

checking version, 3.10

font packages for Java, 3.7.2, 3.8.2

patch download location, 3.12

Veritas Volume Manager, 5.3.3.3

Solaris 10

verifying patches, 3.12

Solaris 11

verifying patches, 3.11

SQL Developer

accessing, 8.5

SQL Server database, J.4

SQL*Plus

accessing, 8.4

ssh

and X11 Forwarding, 4.2

storage area network disks, 5.3.3.2

swap space

checking, 5.1.1

requirements, 3.3, 5.1

Sybase Adapter Server database, J.4

SYSASM

OSASM, 4.1.4.4

SYSBACKUP privilege, 4.1.4.3

SYSDBA privilege

associated UNIX group, 4.1.4.2, 4.1.4.4

sysdef command, D.1.4

SYSDG privilege, 4.1.4.3

SYSKM privilege, 4.1.4.3

SYSOPER privilege

associated UNIX group, 4.1.4.2

SYSTEM

tablespace, description, 8.10.1

system file, D.1.4

System Identifier, 8.8

See SID

system01.dbf data file, 8.10.1, 8.10.1

T

tablespaces, 8.10.1

defined, 8.10.1

expanding for large sorts, 8.10.1

in databases, 8.10.1

Optimal Flexible Architecture

special tablespaces, F.2.4

reviewing, 8.10

setting up, 8.10.1

SYSTEM, 8.10.1

TEMP, 8.10.1

UNDOTBS, 8.10.1

USERS, 8.10.1

TEMP

tablespace (temp01.dbf), 8.10.1

temp01.dbf data file, 8.10.1

temporary disk space

requirements, 3.3, 5.1

Teradata database, J.4

TMP environment variable, 3.3.1, 3.3.3, 5.1.3

setting, 4.4

TMPDIR environment variable, 3.3.1, 3.3.3, 5.1.3

setting, 4.4

TNS_ADMIN environment variable

unsetting, 4.4

tnsnames.ora file, 7.4.1

troubleshooting, I

disk space errors, 1.4

display errors, I.3

DISPLAY errors, 4.2

environment path errors, 1.3

fatal errors, I.8.2

Oracle Restart, I.6

remote terminal installation, I.3

su command, I.3

unexplained installation errors, 1.6

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

X11 forwarding error, 4.2

U

UDP and TCP, 7.4.10.5, D.3

umask command, 4.4

uname command, 3.10

UNDOTBS

tablespace (undotbs01.dbf), 8.10.1

UNIX commands

chmod, 3.15.2, 3.17.2, 5.3.3.3

chown, 3.15.2, 3.17.2, 5.3.3.3

format, 5.3.3.3

instfix, 3.12

mkdir, 3.15.2, 3.17.2

patchadd, 3.12

pkginfo, 3.10

ps, 4.3

sysdef, D.1.4

umask, 4.4

uname, 3.10

unset, 4.4

unsetenv, 4.4

vxdisk, 5.3.3.3

xhost, 3.2

xterm, 3.2

UNIX groups

checking for existing oinstall group, 4.1.1

OSDBA (dba), 4.1.4.2

OSDBA (dba) for Oracle Restart, 4.1.4.4

OSOPER (oper), 4.1.4.2

UNIX workstation

installing from, 3.2

unset command, 4.4

unsetenv command, 4.4

upgraded databases

configuring, 7.4.9

upgrading, 2.11, 2.11

operating sytem, 2.11.1

Oracle ASM, 2.11.2

Oracle Database, 2.11.1

useradd command, 4.1.5.11

users

creating the oracle user, 4.1.5.10

Oracle Restart, 4.1.4.4

USERS

tablespace (users01.dbf), 8.10.1

users and groups, 4.1

UTLRP.SQL

recompiling invalid SQL modules, 7.4.9

V

verifying packages, 3.11

verifying patches, 3.12

Veritas Volume Manager, 5.3.3.3

very large databases

Optimal Flexible Architecture naming mount points, F.2.2.2

vxdisk command, 5.3.3.3

VxVM, 5.3.3.3

W

web servers (Oracle HTTP Server), J.3

WebSphere MQ Series database, J.4

X

X Window

display errors, I.1

X Window system

enabling remote hosts, 3.2

X Window System

enabling remote hosts, 3.2

X11 forwarding errors, 4.2

xhost command, 3.2

XML data, J.2

xterm command, 3.2