Index

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

A

accounts

reviewing, 9.6

unlocking

with Oracle Enterprise Manager Database Express, 9.7.1

accounts configured by, 4.1.4

ACFS, 2.8.2

requirements, 6.2, 6.2.2

ADVM

requirements, 6.2, 6.2.2

aio-max-nr file, D.1.1

aliases, multiple on computers, E.2

AMD 64

software requirements for, 4.8, 4.9

AMM, 2.3.5

APPC-enabled databases, J.4

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

asm groups

creating, 5.1.5.8

asmcmd utility, 6.3.6

asmdba groups

creating, 5.1.5.6, 5.1.5.6

Automatic Memory Management, 2.3.5

B

backupdba, 5.1.4.3

backupdba group

creating, 5.1.5.3

backups of database

Oracle Database Recovery Manager, J.2

base directory

See Oracle base directory

block devices

creating permissions file, D.3.2

browsers, 4.10.6

C

CDBs, Preface, 7.4.1

database character set, 7.2.1

installation, 7.4.1

PDBADMIN password, 7.4.1

S_PDBADMINPASSWORD, A.6.2

certification, hardware and software, 2.3.1

checking Linux distribution, 4.11

checking shared memory mount, 4.13

chmod command, 4.17.2, 4.20.2

chown command, 4.17.2, 4.20.2

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

See also Oracle Clusterware, Oracle Real Application Clusters

commands

cat, 4.11

fdisk, D.3.2

partprobe, D.3.2.2

rpm, 4.11

runcluvfy.sh, 6.4.1

setup.exe, 6.4.1

uname, 4.11

useradd, 5.1.5.11

usermod, 5.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, 8.3.2.1

configuring disks for Oracle Automatic Storage Management, 7.2.2

configuring kernel parameters, D.1

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

Connection Manager

ports, ranges and protocol, G.3

control files

locating, 9.10.3

naming, F.2.3

reviewing, 9.10

using Oracle Enterprise Manager Database Express with, 9.10.3

CONTROL_FILES initialization parameter, 9.10.3

create inventory, 7.4.1

cron jobs, 1.6

custom database

failure groups for Oracle Automatic Storage Management, 6.3.3.1

requirements when using Oracle Automatic Storage Management, 6.3.3.1, 6.3.3.1

customize the database, 7.4.1

D

DAS (direct attached storage) disks, 6.3.3.2

data files

creating separate directories for, 4.20.2

defined, 9.10.1

managing with Oracle ASM, 2.8.2

minimum disk space for, 4.20.1

naming, F.2.3

options for placing on file system, 4.20

recommendations for file system, 4.20.1

reviewing, 9.10

setting permissions on data file directories, 4.20.2

setting up, 9.10.1

data loss

minimizing with Oracle Automatic Storage Management, 6.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, 9.10.1

identifying, 9.8

initialization parameter file, 9.9

naming, 7.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, 6.3.3.1

recovery with Oracle Backup and Recovery, J.2

redo log files, 9.10.2

security management, J.2

tablespaces, 9.10.1

DB_DOMAIN initialization parameter, 9.8

DB_NAME initialization parameter, 9.8, 9.8

DB2 database, J.4

DB2 z/OS database, J.4

DB2/400 database, J.4

dba group

creating, 5.1.5.1, 5.1.5.1

description, 5.1.4.2, 5.1.4.4

SYSDBA privilege, 5.1.4.2

dba groups

creating, 5.1.5.5, 5.1.5.7, 5.1.5.8

dbca.rsp file, A.2.1

Deconfiguring

Oracle Restart, I.6

default data files, 9.10.1

default file mode creation mask

setting, 5.5

default Linux installation

recommendation for, 4.1.2

default tablespaces, 9.10.1

Deinstallation tool, 10

about, 10.1

example, 10.2, 10.3

previous grid home, 10.1.1

roothas.sh, 10.1

deinstalling previous grid home, 10.1.1

deprecated features, Preface

description

database restart, 6

Oracle Restart, 6

desupported features, Preface

device names

IDE disks, D.3.1.2.2

RAID, D.3.1.2.2

SCSI disks, D.3.1.2.2

device path persistence, D.3.1

dgdba, 5.1.4.3

dgdba group

creating, 5.1.5.4

Direct NFS Client

about, 8.4.10.1

about oranfstab, 8.4.10.2

attributes, 8.4.10.7

checking NFS buffer size, 8.4.10.4

configuring, 8.4.10

disabling, 8.4.10.8

enabling, 8.4.10.7

Enabling HCC, 8.4.10.9

mounting NFS, 8.4.10.3

SNMP support, 8.4.10.9

specifying network path, 8.4.10.6

TCP bufferl TCP buffer error, 8.4.10.5

E

enterprise.rsp file, A.2.1

environment

configuring for oracle or grid user, 5.5

Environment Requirements for grid user, 6.1.4

environment variables

DISPLAY, 5.5

NLS_LANG, H.1.1.2

ORACLE_BASE, 4.17.2, 5.5

ORACLE_HOME, 5.4, 5.5, 5.5

ORACLE_HOSTNAME, E.1

ORACLE_SID, 5.5

PATH, 5.5

SHELL, 5.5

TMP and TMPDIR, 4.3.3.3, 5.5, 6.1.3

TNS_ADMIN, 5.5

ephemeral ports, D.2

errors

configuration assistants, I.8

display errors, I.3

file descriptors error, I.12

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

Memory Size error, I.11

ORA-00845 error, I.11

ORA-27123 error, I.12

remote terminal installation, I.3

response file installation, I.13

silent mode, I.13

su command, I.3

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

X Window, I.1

X Window display errors, I.2

X11 forwarding, 5.3

/etc/sysctl.conf file, D.1.2

EXAMPLE tablespace

description, 9.10.1

example01.DBF data file, 9.10.1

examples

Oracle Automatic Storage Management failure groups, 6.3.3.1, 6.3.3.1

Oracle base directories, 4.16.1

external redundancy

Oracle Automatic Storage Management redundancy level, 6.3.3.1

F

failure group

examples of Oracle Automatic Storage Management failure groups, 6.3.3.1

failure groups

characteristics of Oracle Automatic Storage Management failure group, 6.3.3.1

examples in Oracle Automatic Storage Management, 6.3.3.1

in Oracle ASM, 2.8.2.1

Fast Recovery Area, 8.3.5

fatal errors, I.8.2

fdisk command, D.3.1.2.2

file mode creation mask

setting, 5.5

file system

appropriate for Oracle base directory, 4.17.2

data file and recovery file placement options, 4.20

requirements for Oracle base directory, 4.17.2

using for data files, 4.20.1

file-max file, D.1.1

file-max parameter

recommended value on Linux, D.1.1

files, F.2.3

$ORACLE_HOME/dbs/initsid.ora, 9.9

control, 9.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/sysctl.conf, D.1.2

listener.ora, 8.4.1.1

oraInst.loc, 5.1.1

oratab, 4.17.1, 4.17.1

/proc/sys/fs/file-max, D.1.1

/proc/sys/kernel/sem, D.1.1, D.1.1

/proc/sys/kernel/shmall, D.1.1, D.1.1

/proc/sys/kernel/shmmax, D.1.1

/proc/sys/kernel/shmmni, D.1.1

/proc/sys/net/ipv4/ip_local_port_range, D.1.1

redo log, 9.10.2

response files, A.2

tnsnames.ora, 8.4.1

Flash Recovery Area

See Fast Recovery Area

free

UNIX command, 6.1.1

G

Gateways products FAQ, J.4

global database name, 9.8

Global Database Name

about, 7.4.1

globalization

support for, 1.6

globalization support, H

grid user

configuring environment, 6.1.4

configuring environment for, 5.5

environment requirements, 6.1.4

group file, F.2.2.3

groups

checking for existing oinstall group, 5.1.1

creating the asm group, 5.1.5.8, 5.1.5.8

creating the asmdba group, 5.1.5.6

creating the backupdba group, 5.1.5.3, 5.1.5.3

creating the dba group, 5.1.5.1, 5.1.5.1

creating the dgdba group, 5.1.5.4, 5.1.5.4

creating the kmdba group, 5.1.5.5, 5.1.5.5

creating the oinstall group, 5.1.1

creating the oper group, 5.1.5.2, 5.1.5.2

UNIX OSDBA group (dba), 5.1.4.2

UNIX OSDBA group for Oracle Restart (dba), 5.1.4.4

UNIX OSOPER group (oper), 5.1.4.2

H

hardware certification, 2.3.1

hardware requirements, 4.3, 6.1

checking, 4.3.1

disk space, 4.3.3

general, 4.3.2

memory, 4.3.4

high redundancy

Oracle Automatic Storage Management redundancy level, 6.3.3.1

home directory

See Oracle home directory

host name resolution, 4.14

host name, setting before installation, E.1.1

HugePages, 2.3.6

restrictions, 2.3.6

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

IDE disks

device names, D.3.1.2.2

Informix Server database, J.4

initialization parameter file

description, 9.9

in databases, 9.9

initsid.ora, 9.9

initialization parameters

DB_NAME, 9.8

DOMAIN_NAME, 9.8

SERVICE_NAMES, 9.8

initsid.ora file, 9.9

initsid.ora initialization parameter file, 9.9

installation

accessing installation software, 7.3

and cron jobs, 1.6

and globalization, 1.6

available products, 2.5, 2.5

cleaning up after a failed installation, I.14

clusters, installation guidelines, 7.2

component-specific guidelines, 7.2

computer aliases, multiple, E.2

considerations, 2.3

database editions, 2.5

errors, I.5, I.8.2

silent mode, I.13

laptops, E.3

log files, I.4, I.4

Oracle Automatic Storage Management requirements, 6.3.3.1

overview, 2

response files, A, A.2

preparing, A.2, A.2.2

silent mode, I.13

templates, A.2

silent mode, A.3

upgrading, J.1

installation errors

steps to resolve, I.4

installation guidelines, 7.4.1, 7.4.1

installation overview, 2.2

installation software

copying to a hard disk, 7.3.2.2

extracting, 7.3.1.3

installation software, accessing, 7.3

Installing

Oracle restart, 6.5.1

instance

instance identifier (SID), 5.5

IP addresses, multiple, E.1

ip_local_port_range file, D.1.1

ip_local_port_range parameter

recommended value on Linux, D.1.1

K

kernel parameters, 8.4.10.5

changing, D.1.2

configuring, D.1

ephemeral ports, D.2

setting manually, D.1, D.2

UDP and TCP, D.2

kernel requirements

Linux x86-64, 4.8.1, 4.8.2, 4.8.3, 4.8.4, 4.9.1, 4.9.2, 4.9.3

kmdba, 5.1.4.3

kmdba group

creating, 5.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

LDAP, 4.10.4

Linux

checking version, 4.11

determining distribution of, 4.11

Linux x86-64

software requirements, 4.8.1, 4.8.2, 4.8.3, 4.8.4, 4.9.1, 4.9.2, 4.9.3

software requirements for, 4.8, 4.9

listener

identifying Oracle home for, 5.4

lsnrctl command, 5.4

stopping, 5.4, 5.4

listener.ora file, 8.4.1.1

local device

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

lsdev command, D.3.1.2.2

lsnrctl command, 5.4

LVM

recommendations for Oracle Automatic Storage Management, 6.3.3.1

M

mask

setting default file mode creation mask, 5.5

memory requirements, 4.3, 6.1

Microsoft SQL Server database, J.4

migrating

See upgrading

migrating applications to Oracle, J.3

migrating non-Oracle databases to Oracle, J.1

minimal Linux installation

recommendation for, 4.1.1

mirroring Oracle Automatic Storage Management disk groups, 6.3.3.1

mkdir command, 4.17.2, 4.20.2

mode

setting default file mode creation mask, 5.5

mount point

for Oracle base directory, 4.16.1

mount point directories, 7.3.2.2

mount point directory

choosing, C.2

mount points

Optimal Flexible Architecture conventions for creating, F.2

mounting NFS with DNFS, 8.4.10.3

multihomed computers, installing on, E.1

multiple aliases, computers with, E.2

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

network setup

computers with multiple aliases, E.2

host name resolution, 4.14

network topics

laptops, E.3

multiple network cards, E.1

non-networked computers, E.3

NFS buffer size parameter, 8.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, 6.3.3.1

O

ODBC requirements, 4.10.1

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 5.1.1

oinstall groups

creating, 5.1.1

OLAP tools

about, J.2

Oracle OLAP, J.2

OMF

See Oracle Managed Files

oper group

creating, 5.1.5.2

description, 5.1.4.2

oper groups

creating, 5.1.5.2

operating system

about requirements, 4.7

checking distribution and version of Linux, 4.11

reviewing common practices, 4.4

operating system accounts

creating and configuring, 8.3.2

operating system groups

creating the oinstall group, 5.1.1

operating system users

root user, 7.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, 4.16.1

recommended path for Oracle base directory, 4.16.1

recommended path for Oracle home directory, 4.16.3

recommended path for Oracle Inventory directory, 4.16.2

special tablespaces, F.2.4

standard, F

using separate segments, F.2.4

ORAchk audit tool, 8.3.7

Oracle ACFS, 2.8.2, 6.2, 6.2.2

enabling, 6.2.4

platforms, 6.2.2

requirements, 6.2, 6.2.2

restrictions, 6.2.3

Oracle ADVM, 6.2, 6.2.2

platforms, 6.2.2

requirements, 6.2, 6.2.2

restrictions, 6.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 filter driver

about, 6.3.4

Oracle ASM instance

about, 2.8.2.2

Oracle ASMCA, 9.3.2

Oracle ASMFD

about, Preface, 6.3.4

Oracle ASMLIB, D.3.1

about

configuring, D.3.1.2

deinstalling, D.3.1.3

Oracle Automatic Storage Management Cluster File System, 2.8.2, 6.2, 6.2.2

Oracle Automatic Storage Management Configuration Assistant, 9.3.2

Oracle Automatic Storage Management disk groups

managing, 9.3.2

Oracle Automatic Storage Management Dynamic Volume Manager, 6.2, 6.2.2

Oracle Automatic Storage Management library driver, D.3.1

Oracle Automatic Storage Management, 2.8.2

asmcmd utility, 6.3.6

characteristics of failure groups, 6.3.3.1

checking disk availability, D.3.1.2.2

configuring disks, 7.2.2

DAS disks, 6.3.3.2

disk devices, 2.8.2.1

disk groups, 6.3.3.1

disks, supported, 6.3.3.2

displaying attached disks, D.3.1.2.2

failure groups

examples, 6.3.3.1, 6.3.3.1

identifying, 6.3.3.1

identifying available disks, D.3.1.2.2

identifying disks, D.3.1.2.2

installation, testing, 6.3.6

managing, 9.3.2

mirroring, 6.3.3.1

multiple databases, 5.1.4.4

Optimal Flexible Architecture file naming conventions, F.2.3

Oracle ASM disk group templates, 2.8.2.1

partition creation, 6.3.3.2

recommendations for disk groups, 6.3.3.1

redundancy levels, 6.3.3.1

response files, A.1.2

SAN disks, 6.3.3.2

space required for preconfigured database, 6.3.3.1

starting and stopping, 9.3.1

templates, 2.8.2.1

Oracle base directory

creating, 4.17.2

creating new, 4.17.2

description, 4.16.1

determining disk space on, 4.17.1

disk space requirements, 4.17.1

examples, 4.16.1

identifying appropriate file system, 4.17.2

identifying existing, 4.17.1

mount point for, 4.16.1

naming conventions, F.2.2

recommended path, 4.16.1

relationship with Oracle software owner user, 4.16.1

requirement for, 4.16.1

requirements for existing directory, 4.17.1

requirements on file system, 4.17.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, 4.20.2

Enterprise Edition installation, 2.5

getting started using

accessing, 9.4, 9.5

starting and stopping database, 9.4, 9.5

installing with Oracle applications, J.3

minimum disk space requirements, 4.20.1

naming, 7.4.1

requirements with Oracle Automatic Storage Management, 6.3.3.1

security management, J.2

setting ORACLE_SID environment variable, 5.5

Standard Edition 2 installation, 2.5

Standard Edition installation, 2.5

Standard Edition One installation, 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, 8.4.3

Oracle Enterprise Manager, 2.9

Database Express

using to modify control files, 9.10.3

using to modify redo log files, 9.10.2

using to view control files, 9.10.3

using to view redo log files, 9.10.2

Oracle Enterprise Manager Cloud Control, 2.9, 2.9.1

Oracle Enterprise Manager Database Express

identifying tablespaces and data files, 9.10.1

initialization parameters, 9.9

locating the server parameter file, 9.9

logging into, 9.2

port number, 9.2

unlocking accounts and resetting passwords, 9.7.1

Oracle home

ASCII path restriction for, 1.4

cloning, B.1

Oracle home directory

description, 4.16.3

identifying for listener, 5.4

multiple homes, network considerations, E.1

recommended path, 4.16.3

requirement for, 4.16.3

requirements, 4.16.3

using to identify Oracle base directory, 4.17.1

Oracle host name, setting before installation, E.1.1

Oracle Internet Directory, J.2

Oracle Inventory

description, 4.16.2

pointer file, 5.1.1

Oracle Inventory directory

description, 4.16.2

recommended path, 4.16.2

Oracle Inventory group

creating, 5.1.2

Oracle Inventory groups

checking for existing, 5.1.1

creating, 5.1.1

Oracle Label Security

post-installation tasks, 8.4.2

Oracle Linux

and Oracle Preinstallation RPM, 4.1.4

Oracle Managed Files

Optimal Flexible Architecture naming conventions, F.2.3

Oracle Messaging Gateway, 4.10.3

postinstallation tasks, 8.4.4

Oracle Net

configuration file directory, 8.4.1

identifying Oracle home for listener, 5.4

lsnrctl command, 5.4

stopping listener, 5.4

stopping the listener, 5.4

Oracle Net Configuration Assistant

response file, A.2.1

Oracle Net Services

post-installation tasks, 8.4.1

Oracle Net Services Listener

ports, ranges and protocol, G.3

Oracle OLAP

about, J.2

Oracle Precompilers

postinstallation tasks, 8.4.5

Oracle Preinstallation RPM

about, 4.1.4

included with Oracle Linux, 4.1.4

installing, 3.3, 3.4

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

Installing, 6.5.1

OSDBA group description, 5.1.4.4

relinking, 6.6

user, 5.1.4.4

Oracle RPM Checker on IBM

Linux on System z, 4.6

Oracle Schemas, Preface

Oracle software owner user

configuring environment for, 5.5

determining default shell, 5.5

relationship with Oracle base directory, 4.16.1

Oracle Software Owner user

creating, 5.1.5.10

oracle user, 5.1.5.11

Oracle SQL Developer

accessing, 9.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, 8.4.7

Oracle Transparent Gateway

listed products, J.4

Oracle Universal Installer

guidelines for using, 7.2

installation guidelines, 7.2

response files, A

list of, A.2.1

running, 7.4.1

running in different languages, H.2

oracle user

and Oracle Preinstallation RPM, 4.1.4

configuring environment for, 5.5

creating, 5.1.5.10

determining default shell, 5.5

relationship with Oracle base directory, 4.16.1

Oracle user accounts

configuring, 8.3.2.1

Oracle XML DB

about, J.2

configuring or reinstalling, 8.4.8

configuring the ports, 8.4.8

ports, ranges and protocol, G.3

ORACLE_BASE environment variable, 4.17.2

setting, 5.5

ORACLE_HOME environment variable

setting, 5.4

unsetting, 5.5

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

oraInst.loc file

location, 5.1.1

location of, 5.1.1

oraInventory directory

See Oracle Inventory directory

oratab file, 4.17.1

formats, 4.17.1

location of, 4.17.1

OSASM groups

creating, 5.1.5.8

multiple databases, 5.1.4.4

SYSASM, 5.1.4.4

OSBACKUPDBA, 7.4.1

OSBACKUPDBA group, 5.1.4.3

creating, 5.1.5.3

OSDBA groups

creating, 5.1.5.1

creating for Oracle Grid Infrastructure, 5.1.5.6

description for database, 5.1.4.2

SYSDBA privilege, 5.1.4.2

SYSDBA privilege for Oracle Restart, 5.1.4.4

OSDGDBA, 7.4.1

OSDGDBA group, 5.1.4.3

creating, 5.1.5.4

OSKMDBA, 7.4.1

OSKMDBA group, 5.1.4.3

creating, 5.1.5.5

OSOPER groups

creating, 5.1.5.2

description for database, 5.1.4.2

SYSOPER privilege, 5.1.4.2, 5.1.4.2

OTN website

downloading installation software from, 7.3.1

P

package requirements

Linux x86-64, 4.8.1, 4.8.2, 4.8.3, 4.8.4, 4.9.1, 4.9.2, 4.9.3

packages

checking on IBM

Linux on System z, 4.6

checking on Linux, 4.11

panic_on_oops parameter

recommended value on Linux, D.1.1

partition

using with Oracle Automatic Storage Management, 6.3.3.1

partitions

creation for Oracle Automatic Storage Management disks, 6.3.3.2

passwd file, F.2.2.3

passwords

resetting, 9.7

with Oracle Enterprise Manager Database Express, 9.7.1

with SQL*Plus, 9.7.2

reviewing, 9.6

unlocking, 9.7

with SQL*Plus, 9.7.2

PATH environment variable

setting, 5.5

pathnames

Optimal Flexible Architecture, F.2.2.3

PDBs, Preface, 7.4.1

installation, 7.4.1

sample schema, 7.4.1

permissions

for data file directories, 4.20.2

for Oracle base directory, 4.17.2

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

root.sh script, backing up, 8.3.1

required tasks, 8.2

configuring Oracle Messaging Gateway, 8.4.4

Oracle Label Security, configuring, 8.4.2

Oracle Net Services, configuring, 8.4.1

Oracle Precompilers, 8.4.5

patches, installing and downloading, 8.2.1

postinstallation tasks

Oracle Text knowledge base, 8.4.7

preconfigured database

Oracle Automatic Storage Management disk space requirements, 6.3.3.1

requirements when using Oracle Automatic Storage Management, 6.3.3.1, 6.3.3.1

Pro*C/C++

configuring, 8.4.5.1

See also C compiler

process

stopping existing, 5.4

stopping listener process, 5.4

/proc/sys/fs/file-max file, D.1.1

/proc/sys/kernel/sem file, D.1.1

/proc/sys/kernel/shmall file, D.1.1

/proc/sys/kernel/shmmni file, D.1.1, D.1.1

/proc/sys/net/core/rmem_default file, D.1.1

/proc/sys/net/core/rmem_max file, D.1.1

/proc/sys/net/core/wmem_default file, D.1.1

/proc/sys/net/core/wmem_max file, D.1.1

/proc/sys/net/ipv4/ip_local_port_range file, D.1.1

ps command, 5.4

R

RAID

device names, D.3.1.2.2

using for Oracle data files, 4.20.1

RAM requirements, 4.3, 6.1

readme.txt file, G.2

recommendations

on perfomring software-only installations, 6.4

recovery files

options for placing on file system, 4.20

recovery of databases

Oracle Backup and Recovery, J.2

Red Hat Package Manager

See RPM

redo log, F.2.3

redo log files

in starter database, 9.10.2

locating, 9.10.2

naming, F.2.3

reviewing, 9.10

using Oracle Enterprise Manager Database Express with, 9.10.2

redundancy level

and space requirements for preconfigured database, 6.3.3.1, 6.3.3.1

for Oracle Automatic Storage Management, 6.3.3.1

redundant array of independent disks

See RAID

Removing Oracle Database Software, 10

requirements

checking, 4.3

hardware, 4.3, 6.1

response file installation

response files

preparing, A.2, A.2.2

templates, A.2

silent mode, A.3

errors, I.13

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

rmem_default file, D.1.1

rmem_default parameter

recommended value on Linux, D.1.1

rmem_max file, D.1.1

rmem_max parameter

recommended value on Linux, D.1.1

root script execution plan, 5.6

root scripts automation, 5.6

root user, 7.4.1, 7.4.1

logging in as, 4.2

roothas.sh, 6.4.2, 10.1, I.6

root.sh script

backing up, 8.3.1

RPMs

checking, 4.11

S

Sample Schemas

tablespaces and data files, 9.10.1

SAN (storage area network) disks, 6.3.3.2

schema passwords, 7.4.1

schemas

database schema passwords, 7.4.1

Oracle Schemas, about, Preface

Sample Schemas tablespaces and data files, 9.10.1

SCSI disks

device names, D.3.1.2.2

security

dividing ownership of Oracle software, 5.1

management tools, J.2

sem file, D.1.1

semmni parameter

recommended value on Linux, D.1.1

semmns parameter

recommended value on Linux, D.1.1

semmsl parameter

recommended value on Linux, D.1.1

semopm parameter

recommended value on Linux, D.1.1

separation of duty, 5.1

OSBACKUPDBA, 5.1.4.3, 7.4.1

OSDGDBA, 5.1.4.3, 7.4.1

OSKMDBA, 5.1.4.3, 7.4.1

SERVICE_NAMES initialization parameter, 9.8, 9.8

shell

determining default shell for oracle user, 5.5

SHELL environment variable

checking value of, 5.5

shmall file, D.1.1

shmall parameter

recommended value on Linux, D.1.1

shmmax parameter

recommended value on Linux, D.1.1

shmmni file, D.1.1, D.1.1

shmmni parameter

recommended value on Linux, D.1.1

SID, 9.8

setting ORACLE_SID environment variable, 5.5

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, 4.8, 4.9

checking software requirements, 4.11

drivers, 4.10

for Linux x86-64, 4.8.1, 4.8.2, 4.8.3, 4.8.4, 4.9.1, 4.9.2, 4.9.3

LDAP, 4.10.4

ODBC, 4.10.1

Oracle Messaging Gateway, 4.10.3

packages, 4.10

PAM, 4.10.2

programming environments, 4.10.5

web browsers, 4.10.6

SQL Developer

accessing, 9.5

SQL Server database, J.4

SQL*Plus

accessing, 9.4

ssh

and X11 Forwarding, 5.3

storage area network disks, 6.3.3.2

swap space

checking, 6.1.1

HugePages, 2.3.6

requirements, 4.3, 6.1

Sybase Adapter Server database, J.4

SYSASM

OSASM, 5.1.4.4

SYSBACKUP privilege, 5.1.4.3

sysctl command, D.1.2

sysctl.conf file, D.1.2

SYSDBA privilege

associated UNIX group, 5.1.4.2, 5.1.4.4

SYSDG privilege, 5.1.4.3

SYSKM privilege, 5.1.4.3

SYSOPER privilege

associated UNIX group, 5.1.4.2

SYSTEM

tablespace, description, 9.10.1

System Identifier, 9.8

See SID

system01.dbf data file, 9.10.1, 9.10.1

T

tablespaces, 9.10.1

defined, 9.10.1

expanding for large sorts, 9.10.1

in databases, 9.10.1

Optimal Flexible Architecture

special tablespaces, F.2.4

reviewing, 9.10

setting up, 9.10.1

SYSTEM, 9.10.1

TEMP, 9.10.1

UNDOTBS, 9.10.1

USERS, 9.10.1

TEMP

tablespace (temp01.dbf), 9.10.1

temp01.dbf data file, 9.10.1

temporary disk space

requirements, 4.3, 6.1

Teradata database, J.4

TMP environment variable, 4.3.3.3, 6.1.3

setting, 5.5

TMPDIR environment variable, 4.3.3.3, 6.1.3

setting, 5.5

TNS_ADMIN environment variable

unsetting, 5.5

tnsnames.ora file, 8.4.1

Transparent HugePages, 4.15

troubleshooting, I

disk space errors, 1.4

display errors, I.3

DISPLAY errors, 5.3

environment path errors, 1.3

fatal errors, I.8.2

file descriptors error, I.12

Memory Size error, I.11

ORA-00845 error, I.11

ORA-27123 error, I.12

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

U

UDP and TCP, 8.4.10.5, D.2

umask command, 5.5

Unbreakable Enterprise Kernel for Linux

about, 4.1.3

UNDOTBS

tablespace (undotbs01.dbf), 9.10.1

UNIX commands

chmod, 4.17.2, 4.20.2

chown, 4.17.2, 4.20.2

fdisk, D.3.1.2.2

free, 6.1.1

lsdev, D.3.1.2.2

mkdir, 4.17.2, 4.20.2

ps, 5.4

sysctl, D.1.2

umask, 5.5

unset, 5.5

unsetenv, 5.5

xhost, 4.2

xterm, 4.2

UNIX groups

checking for existing oinstall group, 5.1.1

OSDBA (dba), 5.1.4.2

OSDBA (dba) for Oracle Restart, 5.1.4.4

OSOPER (oper), 5.1.4.2

UNIX workstation

installing from, 4.2

unset command, 5.5

unsetenv command, 5.5

upgraded databases

configuring, 8.4.9

upgrading, 2.11, 2.11

operating sytem, 2.11.1

Oracle ASM, 2.11.2

Oracle Database, 2.11.1

useradd command, 5.1.5.11

users

creating the oracle user, 5.1.5.10

Oracle Restart, 5.1.4.4

USERS

tablespace (users01.dbf), 9.10.1

users and groups, 5.1

UTLRP.SQL

recompiling invalid SQL modules, 8.4.9

V

very large databases

Optimal Flexible Architecture naming mount points, F.2.2.2

W

web servers (Oracle HTTP Server), J.3

WebSphere MQ Series database, J.4

wmem_default file, D.1.1

wmem_default parameter

recommended value on Linux, D.1.1

wmem_max file, D.1.1

wmem_max parameter

recommended value on Linux, D.1.1

X

X Window

display errors, I.1

X Window system

enabling remote hosts, 4.2

X Window System

enabling remote hosts, 4.2

X11 forwarding errors, 5.3

xhost command, 4.2

XML data, J.2

xterm command, 4.2