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

unauthenticated access to, 5.7.2

ADMIN account

changing password for Oracle HTTP Server 9.0.3, 4.5.5.1

aliases, multiple on computers, 2.5.4

ANONYMOUS user

unauthenticated account access with, 5.7.2

APPC-enabled databases, H.4

Application Express

getting started, 4.5.10

logging in to, 4.5.10

setting up, 4.5.10.2

user roles, 4.5.10.1

Application Express Administration Services, 4.5.10.2

Application Express administrator, 4.5.10.1

Application Express user roles

Application Express administrator, 4.5.10.1

developer, 4.5.10.1

end user, 4.5.10.1

workspace administrator, 4.5.10.1

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

ASM See Automatic Storage Management

asmcmd utility, 3.6.4

ASMLib add-on support library, 3.6.1

Automatic Storage Management

asmcmd utility, 3.6.4

ASMLib add-on support library, 3.6.1

block device names, 2.12.5.1

block devices, 3.6.1

characteristics of failure groups, 2.12.2

checking disk availability, 2.12.5.1

configuring disks, 2.12.1, 2.12.3

configuring disks for Automatic Storage Management, 2.12.5

considerations before installing, 3.6.1

DAS disks, 2.12.4

database creation for, 3.6.3

disk devices, 1.8.2

disk groups, 2.12.2

disks, supported, 2.12.4

displaying attached disks, 2.12.5.1

Enterprise Manager Migrate Database wizard, 3.6.2

failure groups

examples, 2.12.2, 2.12.2

identifying, 2.12.2

identifying available disks, 2.12.5.1

identifying disks, 2.12.5.1

installation, testing, 3.6.4

installing, 3.6

managing, 5.3.2

migrating existing databases to, 3.6.2

mirroring, 2.12.2

Optimal Flexible Architecture file naming conventions, D.2.3

Oracle Clusterware, 1.8.2

Oracle home location for new installation, 3.6.1

partition creation, 2.12.4

password file, 3.6.1

recommendations for disk groups, 2.12.2

redundancy levels, 2.12.2

removing, 6.6

response files, A.1.2

running multiple databases on a single server, 3.6.1

SAN disks, 2.12.4

space required for preconfigured database, 2.12.2

SPFILE server parameter file, 3.6.1

starting and stopping, 5.3.1

upgrade advantages with separate Oracle homes, 3.6.1

Automatic Storage Management (ASM)

ASM disk group templates, 1.8.2

templates, 1.8.2

upgrading, 3.5.1

Automatic Storage Management disk groups

about, 1.8.2

creating, 3.6.2

managing, 5.3.2

Automatic Storage Management failure groups

about, 1.8.2

Automatic Storage Management instance

about, 1.8.2

creating, 3.6.2

B

backups of database

Oracle Database Recovery Manager, H.2

base directory

See Oracle base directory

Bash shell

default user startup file, 2.14

setting shell limits on Linux x86, 2.7

.bash_profile file, 2.14

Basic installation type

noninteractive installations, A.3.2

block device

device name, 2.12.5.1

block device discovery on Automatic Storage Management, 3.6.1

Bourne shell

default user startup file, 2.14

setting shell limits on Linux x86, 2.7

C

C shell

default user startup file, 2.14

setting shell limits on Linux x86, 2.7

certification, hardware and software, 1.4.1

Character Set Scanner, 1.12.1

checking distribution of the operating system, 2.3.1

checking version of the operating system, 2.3.1

chmod command, 2.9.2, 2.11.2

chown command, 2.9.2, 2.11.2

CLASSPATH environment variable, 4.3.3.3

client static library, generating, 4.2.5

cloning

Oracle home, B

Cluster Manager

ports, ranges and protocol, E.3

Cluster Ready Services (CSS). See Oracle Clusterware

Cluster Synchronization Services (CSS)

Automatic Storage Management, 1.8.2

ports, ranges and protocol, E.3

clusters

installation guidelines, 3.2

See also Oracle Clusterware, Oracle Real Application Clusters

Clusterware

installed before Oracle Database, 3.2

Clusterware. See Oracle Clusterware

computers with multiple aliases, 2.5.4

computers, non-networked, 2.5.5

configuration assistants

failure, G.7.1

troubleshooting, G.7, G.7

configuring

kernel parameters, 2.7

Oracle Application Server 11g (new), 4.5.5.2

Oracle HTTP Server (new), 4.5.5

Oracle HTTP Server 11g (new), 4.5.5.2

configuring disks for Automatic Storage Management, 2.12.1, 2.12.3

Connection Manager

ports, ranges and protocol, E.3

control files

locating, 5.10.3

naming, D.2.3

reviewing, 5.10

using Oracle Enterprise Manager Database Control with, 5.10.3

CONTROL_FILES initialization parameter, 5.10.3

country codes, I

CSD

download location for WebSphere MQ, 2.3.5.3

requirements

on Linux, 2.3.5.3

csh.login file, 2.7

csh.login.local file, 2.7

custom database

failure groups for Automatic Storage Management, 2.12.2

requirements when using Automatic Storage Management, 2.12.2, 2.12.2

custom.rsp file, A.3.1

D

dadTool.pl utility, 4.5.9

DAS (direct attached storage) disks, 2.12.4

data files

creating separate directories for, 2.11.2

defined, 5.10.1

managing with Automatic Storage Management, 1.8.2

minimum disk space for, 2.11.1

naming, D.2.3

options for placing on file system, 2.11

recommendations for file system, 2.11.1

reviewing, 5.10

setting permissions on data file directories, 2.11.2

setting up, 5.10.1

Data Guard

ports, ranges and protocol, E.3

data loss

minimizing with Automatic Storage Management, 2.12.2

Data Mining Scoring Engine

about, H.2

installing, H.2

data mining tools

Data Mining Scoring Engine, H.2

Oracle Data Mining, H.2

Data Vault, 1.3.5

data warehousing tool

Oracle OLAP, H.2

Database Configuration Assistant

running in silent mode, A.6

troubleshooting, G.7

database configuration collections, 4.6

databases

Automatic Storage Management requirements, 2.12.2

files, 5.10.1

identifying, 5.8

initialization parameter file, 5.9

naming, 3.5.1, 3.6.3

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

recovery with Oracle Backup and Recovery, H.2

redo log files, 5.10.2

removing, 6.5

removing Oracle HTML DB, 6.4

security management, H.2

tablespaces, 5.10.1

upgrading, 3.5.1

DB_DOMAIN initialization parameter, 5.8

DB_NAME initialization parameter, 5.8, 5.8

DB2 database, H.4

DB2 z/OS database, H.4

DB2/400 database, H.4

dba group

and SYSDBA privilege, 2.6

creating, 2.6.2, 2.6.2, 2.6.3, 2.6.4, 2.6.4

description, 2.6

dbca.rsp file, A.3.1

default data files, 5.10.1

default file mode creation mask

setting, 2.14

default tablespaces, 5.10.1

deprecated and desupported components, Preface

developer, 4.5.10.1

device names

IDE disks, 2.12.5.1

RAID, 2.12.5.1

SCSI disks, 2.12.5.1

DHCP computers, installing on, 2.5.2

E

embedded PL/SQL gateway

about, 4.5.2.1

disabling, 4.5.3.2

enabling, 4.5.3.2

end user, 4.5.10.1

enterprise.rsp file, A.3.1

env command, 2.14

environment

checking settings, 2.14

configuring for oracle user, 2.14

environment variables

DISPLAY, 2.14, 2.14

NLS_LANG, F.1.1.2

ORACLE_BASE, 2.9.2, 2.14

ORACLE_HOME, 2.13, 2.14, 2.14

ORACLE_HOSTNAME, 2.5.3

ORACLE_SID, 2.14

PATH, 2.14

removing from shell startup file, 2.14

SHELL, 2.14

TMP and TMPDIR, 2.2.2, 2.14

TNS_ADMIN, 2.14

errata

Linux kernel errata, 2.3.2

errors

configuration assistants, G.7

installation, G.3, G.4, G.7.2

noninteractive installation, G.8

silent mode, G.8

X Window, G.1

X Window display errors, G.2

/etc/csh.login file, 2.7

/etc/csh.login.local file, 2.7

/etc/oraInst.loc file, G.4

/etc/pam.d/login file, 2.7

/etc/profile file, 2.7

/etc/profile.local file, 2.7

/etc/security/limits.so file, 2.7

/etc/sysctl.conf file, 2.7

EXAMPLE tablespace

description, 5.10.1

example01.DBF data file, 5.10.1

examples

Automatic Storage Management failure groups, 2.12.2, 2.12.2

Oracle base directories, 2.8.1

external jobs

operating system user required for, 2.6

external redundancy

Automatic Storage Management redundancy level, 2.12.2

extjob executable

operating system user required for, 2.6

F

failure group

examples of Automatic Storage Management failure groups, 2.12.2

failure groups

characteristics of Automatic Storage Management failure group, 2.12.2

examples in Automatic Storage Management, 2.12.2

in Automatic Storage Management, 1.8.2

FAQ for installation, H

fatal errors, G.7.2

fdisk command, 2.12.5.1

features

deprecated, Preface

file mode creation mask

setting, 2.14

file sets, 2.3

file system

appropriate for Oracle base directory, 2.9.2

data file and recovery file placement options, 2.11

NFS, 1.4.4

requirements for Oracle base directory, 2.9.2

using for data files, 2.11.1

writing to, 1.4.4

file-max file, 2.7

file-max parameter

recommended value on Linux x86, 2.7

files, D.2.3

$ORACLE_HOME/dbs/initsid.ora, 5.9

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

.bash_profile, 2.14

contol, D.2.3

control, 5.10.3

custom.rsp, A.3.1

data files, D.2.3

dbca.rsp, A.3.1

default shell startup file, 2.7

editing shell startup file, 2.14

enterprise.rsp, A.3.1

/etc/csh.login, 2.7

/etc/csh.login.local, 2.7

/etc/group, D.2.2.3

/etc/oraInst.loc, G.4

/etc/pam.d/login, 2.7

/etc/passwd, D.2.2.3

/etc/profile, 2.7

/etc/profile.local, 2.7

/etc/security/limits.so, 2.7

/etc/sysctl.conf, 2.7

listener.ora, 4.3.1

.login, 2.14

mgw.ora, 4.3.3.3

oraInst.loc, 2.6.1, 2.9.1

oraInst.loc file, A.2

oratab, 2.9.1, 2.9.1

/proc/sys/fs/file-max, 2.7

/proc/sys/kernel/sem, 2.7, 2.7

/proc/sys/kernel/shmall, 2.7, 2.7

/proc/sys/kernel/shmmax, 2.7

shmmax file, 2.7

/proc/sys/kernel/shmmni, 2.7

/proc/sys/net/ipv4/ip_local_port_range, 2.7

.profile, 2.14

redo log, 5.10.2

response files, A.3

standard.rsp, A.3.1

tnsnames.ora, 4.3.1

free

UNIX command, 2.2.1

frequently asked installation questions, H

G

Gateways products FAQ, H.4

getting started

Application Express, 4.5.10

Global Database Name

about, 3.5.1, 3.6.3

global database name, 5.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.6.1

creating the dba group, 2.6.2, 2.6.3, 2.6.4

creating the oinstall group, 2.6.1

H

hardware certification, 1.4.1

hardware requirements, 2.2

high redundancy

Automatic Storage Management redundancy level, 2.12.2

home directory

See Oracle home directory

host name, setting before installation, 2.5.3

HTTP Server

choosing, 4.5.2

httpd.conf

modifications if running Oracle9i, 4.5.5.1

I

IBM DB2 database, H.4

IBM DB2 z/OS database, H.4

IBM DB2/400 database, H.4

IBM WebSphere MQ

requirement on Linux, 2.3.5.3

IBM WebSphere MQ Series databases, H.4

id command, 2.6.6

IDE disks

device names, 2.12.5.1

Informix Server database, H.4

initialization parameter

job_queue_process, 4.6

initialization parameter file

description, 5.9

in databases, 5.9

initsid.ora, 5.9

initialization parameters

DB_NAME, 5.8

DOMAIN_NAME, 5.8

SERVICE_NAMES, 5.8

initsid.ora file, 5.9

initsid.ora initialization parameter file, 5.9

installation

accessing installation software, 3.3

Automatic Storage Management requirements, 2.12.2

available products, 1.6, 1.6

cleaning up after a failed installation, G.9

clusters, installation guidelines, 3.2

component-specific guidelines, 3.2

computer aliases, multiple, 2.5.4

considerations, 1.4

errors, G.4, G.7.2

silent mode, G.8

FAQ for Oracle Database products, H

laptops, 2.5.5

log files, G.3, G.3

noninteractive

error handling, G.8

oraInst.loc file, A.2

overview, 1

reinstalling Oracle software, 3.2

response files, A, A.3

preparing, A.3, A.3.2

silent mode, G.8

templates, A.3

silent mode, A.3.2, A.4

upgrading, H.1

with other components, H

installation errors

steps to resolve, G.3

installation guidelines, 3.5.1, 3.5.1

Oracle Label Security, 3.2

installation overview, 1.1

installation software

copying to a hard disk, 3.3.2.2

extracting, 3.3.1.2

installation software, accessing, 3.3

installCCRSQL.sh, 4.6.1, G.6

installing

other languages, 4.5.7

instance

instance identifier (SID), 2.14

IP addresses, multiple, 2.5.3

ip_local_port_range file, 2.7

ip_local_port_range parameter

recommended value on Linux x86, 2.7

IPC protocol address

Oracle Messaging Gateway setting, 4.3.3.1

J

JDK

internationalization class, 4.3.3.3

run-time class, 4.3.3.3

JDK requirements, 2.3

K

kernel

Linux errata, 2.3.2

kernel parameters

changing, 2.7

configuring, 2.7

Korn shell

default user startup file, 2.14

setting shell limits on Linux x86, 2.7

ksh

See Korn shell

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

limits.so file, 2.7

Linux

kernel errata, 2.3.2

setting shell limits, 2.7

listener

identifying Oracle home for, 2.13

lsnrctl command, 2.13

stopping, 2.13, 2.13

stopping existing listener process, 2.13

listener.ora file, 4.3.1

modifying for external procedures, 4.3.3.1

local device

using for data files, 2.11.1

log files, G.3, G.3

troubleshooting, G.4

logical volume manager

See LVM

loopback adapters

non-networked computers, 2.5.5

lsdev command, 2.12.5.1

lsnrctl command, 2.13

LVM

recommendations for Automatic Storage Management, 2.12.2

M

mask

setting default file mode creation mask, 2.14

memory requirements, 2.2

MGW_AGENT service name, 4.3.3.2

mgwextproc service

adding static service information, 4.3.3.1

mgw.ora file

modifying, 4.3.3.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 Automatic Storage Management disk groups, 2.12.2

mkdir command, 2.9.2, 2.11.2

Mode

Connected, 4.6

Disconnected, 4.6

mode

setting default file mode creation mask, 2.14

mount point

for Oracle base directory, 2.8.1

mount point directories, 3.3.2.2

mount point directory

choosing, C.3

mount points

Optimal Flexible Architecture conventions for creating, D.2

MQSeries

class, 4.3.3.3

multihomed computers, installing on, 2.5.3

multiple aliases, computers with, 2.5.4

multiple Oracle homes, 1.4.2

N

naming subdirectories, D.2.2.5

NAS devices

creating files on for use with 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.5.4

non-networked computers, 2.5.5

primary, on computers with multiple aliases, 2.5.4

See also loopback adapters, primary network adapters

network attached storage devices

See NAS devices

network cards, multiple, 2.5.3

Network File System See NFS

network setup

about, 2.5

computers with multiple aliases, 2.5.4

network topics

DHCP computers, 2.5.2

laptops, 2.5.5

multiple network cards, 2.5.3

non-networked computers, 2.5.5

new installation

adding entry for Application Express, 4.5.5.1

adding new MIME types, 4.5.5.1

configuring Oracle Application Server 10g, 4.5.5.2, 4.5.5.2

configuring Oracle HTTP Server, 4.5.5

configuring Oracle HTTP Server 9.0.3, 4.5.5.1

modifications to support SQL Workshop, 4.5.5.1

modifying httpd.conf, 4.5.5.1

modifying marvel.conf, 4.5.5.2

modifying wdbsvr.app, 4.5.5.1

NFS

mount options, C.5

using for installation, 1.4.4

NLS_LANG environment variable, F.1.1.2

nobody user

checking existence of, 2.6.6

description, 2.6

nofile

shell limit on Linux x86, 2.7

noninteractive installation

oraInst.loc file, A.2

response files

preparing, A.3, A.3.2

templates, A.3

silent mode, A.3.2, A.4

errors, G.8

noninteractive mode

about, A.1

reasons for using, A.1.1

See also response files, silent mode, A.1

non-networked computers, 2.5.5

non-Oracle databases, listed, H.4

normal redundancy, Automatic Storage Management redundancy level, 2.12.2

nproc

shell limit on Linux x86, 2.7

O

obfuscate

password, 4.5.9

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 2.6.1

creating, 2.6.1

description, 2.6

OLAP tools

about, H.2

Oracle OLAP, H.2

OLS

See Oracle Label Security

OMF

See Oracle Managed Files

online help

not working, G.12

oper group

and SYSOPER privilege, 2.6

creating, 2.6.3

description, 2.6

operating system

checking distribution and version, 2.3.1

operating system groups

creating the dba group, 2.6.3, 2.6.4

creating the oinstall group, 2.6.1

oinstall, 2.6

OSDBA, 2.6

OSOPER, 2.6

osoper, 2.6

requirements, 2.6

operating system requirements, 2.3

operating system users

checking existence of the nobody user, 2.6.6

creating the oracle user, 2.6.5

nobody, 2.6

oracle, 2.6

requirements, 2.6

root user, 3.5.1

unprivileged user, 2.6

Optimal Flexible Architecture

Automatic Storage Management, D.2.3

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 Managed Files, D.2.3

pathnames, D.2.2.3

recommendations for Oracle base directory, 2.8.1

recommended path for Oracle base directory, 2.8.1

recommended path for Oracle home directory, 2.8.3

recommended path for Oracle Inventory directory, 2.8.2

special tablespaces, D.2.4

standard, D

using seperate segments, D.2.4

Oracle Application Server, H.2

Oracle applications

installing with Oracle Database, H.3

Oracle base directory

creating, 2.9.2

creating new, 2.9.2

description, 2.8.1

determining disk space on, 2.9.1

disk space requirements, 2.9.1, 2.9.2

equivalent directory on Microsoft Windows, 2.8.1

examples, 2.8.1

identifying appropriate file system, 2.9.2

identifying existing, 2.9.1

mount point for, 2.8.1

naming conventions, D.2.2

recommended path, 2.8.1

relationship with Oracle software owner user, 2.8.1

requirement for, 2.8.1

requirements for existing directory, 2.9.1

requirements on file system, 2.9.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 Automatic Storage Management, 1.8.2

used with Oracle Real Application Clusters, H.1

Oracle components

using in different languages, F.1.2

Oracle CSS Daemon

configuration, deleting, 6.7.3

Oracle Data Mining

about, H.2

installing, H.2

Oracle Database

administering and monitoring, H.2

creating data file directories, 2.11.2

Custom installation, 1.6

Enterprise Edition installation, 1.6

getting started using

accessing, 5.4, 5.5

starting and stopping database, 5.4, 5.5

installing with Oracle applications, H.3

installing with other Oracle components, H

minimum disk space requirements, 2.11.1

multiple databases on a single server with Automatic Storage Management, 3.6.1

naming, 3.5.1, 3.6.3

privileged groups, 2.6

requirements with Automatic Storage Management, 2.12.2

security management, H.2

setting ORACLE_SID environment variable, 2.14

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

Automatic Storage Management, 1.8.2, 3.6.2

Oracle Database SID

about, 3.5.1

naming rules, 3.5.1

Oracle E-Business Suite, 4.6.3, 6.3

Oracle Enterprise Management Agent

HTTP port, changing, E.4

ports

ranges and protocol, E.3

Oracle Enterprise Manager, 1.9

Database Control

logging into, 5.2

port number, 5.2

using to modify control files, 5.10.3

using to modify redo log files, 5.10.2

using to view control files, 5.10.3

using to view redo log files, 5.10.2

database migration to Automatic Storage Management, 3.6.2

Migrate Wizard, 3.6.2

Oracle Enterprise Manager Database Console

ports, ranges and protocol, E.3

Oracle Enterprise Manager Database Control

ports, changing, E.5

Oracle Enterprise Manager Migrate Database wizard, 3.6.2

Oracle Event Manager

ports, ranges and protocol, E.3

Oracle home

cloning, B

Oracle home directory

Automatic Storage Management considerations, 3.6.1

description, 2.8.3

identifying for listener, 2.13

multiple homes, network considerations, 2.5.3

recommended path, 2.8.3

requirement for, 2.8.3

requirements, 2.8.3

using to identify Oracle base directory, 2.9.1

Oracle home name, 2.8.3

Oracle host name, setting before installation, 2.5.3

Oracle HTML DB

removing from the database, 6.4

Oracle HTTP Server

about, 4.5.2.2

Oracle HTTP Server 10g

configuring (new), 4.5.5.2

Oracle HTTP Server 9.0.3

changing ADMIN password, 4.5.5.1

configuring (new), 4.5.5.1

Oracle internationalization class, 4.3.3.3

Oracle Internet Directory, H.2

Oracle Inventory

description, 2.8.2

pointer file, 2.6.1

Oracle Inventory directory

description, 2.8.2

recommended path, 2.8.2

Oracle Inventory group

checking for existing, 2.6.1

creating, 2.6.1, 2.6.1

description, 2.6

Oracle JDBC class, 4.3.3.3

Oracle Label Security

installation guidelines, 3.2

post-installation tasks, 4.3.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, D.2.3

Oracle Messaging Gateway

CSD requirements

on Linux, 2.3.5.3

postinstallation tasks, 4.3.3

requirements on Linux, 2.3.5.3

Oracle Messaging Gateway class, 4.3.3.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, 4.3.1

identifying Oracle home for listener, 2.13

lsnrctl command, 2.13

stopping existing listener, 2.13

stopping listener, 2.13

stopping the listener, 2.13

Oracle Net Configuration Assistant

response file, A.3.1

Oracle Net Services

post-installation tasks, 4.3.1

Oracle OLAP

about, H.2

Oracle Precompilers

postinstallation tasks, 4.3.4

Oracle Procedural Gateway

listed products, H.4

Oracle Real Application Clusters (RAC)

Advanced installation method, 1.5.1

installed before Oracle Database, 3.2

installing with Oracle Enterprise Manager, H.2

Oracle Clusterware

about, H.1

Oracle Schemas, Preface

Oracle software

removing, 6.8

Oracle Software Owner user

creating, 2.6.5.1

Oracle software owner user

configuring environment for, 2.14

creating, 2.6.5

description, 2.6

determining default shell, 2.14

relationship with Oracle base directory, 2.8.1

setting shell limits for, 2.7

Oracle SQL Developer

accessing, 5.5

Oracle SQL*Net Listener

ports, ranges and protocol, E.3

Oracle Storage Compatibility Program (OSCP)

certification of NAS devices, C

Oracle Technology Network (OTN)

downloading documentation from, Preface

Oracle Text knowledge base, 4.3.6

Oracle Transparent Gateway

listed products, H.4

Oracle Ultra Search

ports, changing, E.6

ports, ranges and protocol, E.3

Oracle Universal Installer

Automatic Storage Management behavior, 3.6.1

guidelines for using, 3.2

installation guidelines, 3.2

response files, A

list of, A.3.1, A.3.1, A.3.1

running, 3.5.1

running in different languages, F.2

oracle user

configuring environment for, 2.14

creating, 2.6.5, 2.6.5.1, 2.6.5.2

description, 2.6

determining default shell, 2.14

relationship with Oracle base directory, 2.8.1

setting shell limits for, 2.7

Oracle Validated Configuration RPM

about, 1.2.2

installing, 1.2.3

Oracle XML DB

about, H.2

ports, E.7

ports, changing, E.7

ports, ranges and protocol, E.3

ORACLE_BASE environment variable, 2.9.2

removing from shell startup file, 2.14

setting, 2.14

ORACLE_HOME environment variable

removing from shell startup file, 2.14

setting, 2.13

unsetting, 2.14

ORACLE_HOSTNAME environment variable

about, 2.5.3

computers with multiple aliases, 2.5.4

multihomed computers, 2.5.3

setting before installation, 2.5.3

ORACLE_SID environment variable

removing from shell startup file, 2.14

setting, 2.14

Oracle9i

modifying wdbsvr.app, 4.5.5.1

oraInst.loc file, 2.9.1, 2.9.1

location, 2.6.1

location of, 2.6.1

oraInventory directory

See Oracle Inventory directory

oratab file, 2.9.1

formats, 2.9.1

location of, 2.9.1

OSDBA group

and SYSDBA privilege, 2.6

creating, 2.6.2, 2.6.3, 2.6.4

description, 2.6

OSOPER group

and SYSOPER privilege, 2.6

description, 2.6

OTN Web site

downloading installation software from, 3.3.1

OUI

See Oracle Universal Installer

P

packages, checking, 2.3.3

partition

using with Automatic Storage Management, 2.12.2

partitions

creation for Automatic Storage Management disks, 2.12.4

passwd command, 2.6.5.2

passwd file, D.2.2.3

password

obfuscating, 4.5.9

password file for Automatic Storage Management, 3.6.1

passwords

resetting, 5.7

with Database Control, 5.7.1

with SQL*Plus, 5.7.2

reviewing, 5.6

specifying for response files, A.1

unlocking, 5.7

with Database Control, 5.7.1

with SQL*Plus, 5.7.2

R

RAID

device names, 2.12.5.1

recommended Automatic Storage Management redundancy level, 2.12.2

using for Oracle data files, 2.11.1

RAM requirements, 2.2

readme.txt file, E.2

reconfiguring CSS, 6.7

recovery files

options for placing on file system, 2.11

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

locating, 5.10.2

naming, D.2.3

reviewing, 5.10

using Oracle Enterprise Manager Database Control with, 5.10.2

redundancy level

and space requirements for preconfigured database, 2.12.2, 2.12.2

for Automatic Storage Management, 2.12.2

redundant array of independent disks

See RAID

reinstalling Oracle software, 3.2

removing

Oracle HTML DB from the database, 6.4

Rendezvous

requirement on Linux, 2.3.5.3

requirements

hardware, 2.2

response files

about, A.1

Automatic Storage Management, A.1.2

creating with template, A.3.1

custom.rsp, 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

passing values at command line, A.1

passwords, A.1

security, A.1

specifying with Oracle Universal Installer, A.4

standard.rsp, A.3.1

See also silent mode, noninteractive mode, A.1

response files installation

about, A

rmem_default file, 2.7

rmem_default parameter

recommended value on Linux, 2.7

rmem_max file, 2.7

rmem_max parameter

recommended value on Linux, 2.7

roadmap for installing Oracle Database components, H

root user, 3.5.1, 3.5.1

logging in as, 2.1

root.sh script

backing up, 4.2.1

RPM

checking, 2.3.3

rpm command, 2.3.3

S

Sample Schemas

tablespaces and data files, 5.10.1

SAN (storage area network) disks, 2.12.4

schemas

database schema passwords, 3.5.1

Oracle HTML DB schema removal, 6.4

Oracle Schemas, about, Preface

Sample Schemas tablespaces and data files, 5.10.1

SCSI disks

device names, 2.12.5.1

security

management tools, H.2

T

tablespaces, 5.10.1

defined, 5.10.1

in databases, 5.10.1

reviewing, 5.10

setting up, 5.10.1

expanding for large sorts, 5.10.1

Optimal Flexible Architecture

special tablespaces, D.2.4

SYSTEM, 5.10.1

TEMP, 5.10.1

UNDOTBS, 5.10.1

USERS, 5.10.1

tcsh shell

setting shell limits on Linux x86, 2.7

TEMP

tablespace (temp01.dbf), 5.10.1

temp01.dbf data file, 5.10.1

temporary disk space

requirements, 2.2

Teradata database, H.4

TIBCO Rendezvous

requirement on Linux, 2.3.5.3

TMP environment variable, 2.2.2

setting, 2.14

TMPDIR environment variable, 2.2.2

setting, 2.14

TNS_ADMIN environment variable

unsetting, 2.14

tnsnames.ora file, 4.3.1

adding a connect descriptor, 4.3.3.2

MGW_AGENT service name, 4.3.3.2

modifying for external procedures, 4.3.3.2

translated version

installing, 4.5.7

troubleshooting, G

fatal errors, G.7.2

images, G.11

online help not working, G.12

U

ulimit command, 2.7

umask, 2.14

umask command, 2.14, 2.14

UNDOTBS

tablespace (undotbs01.dbf), 5.10.1

Uninstall, 6.3, 6.4, 6.5, 6.6

uninstall, 6.3, 6.4, 6.5, 6.6

UNIX commands, 2.14

chmod, 2.9.2, 2.11.2

chown, 2.9.2, 2.11.2

env, 2.14

fdisk, 2.12.5.1

free, 2.2.1

id, 2.6.6

lsdev, 2.12.5.1

mkdir, 2.9.2, 2.11.2

passwd, 2.6.5.2

ps, 2.13

rpm, 2.3.3

sysctl, 2.7, 2.7

ulimit, 2.7

umask, 2.14

unset, 2.14

unsetenv, 2.14

useradd, 2.6.5.2

xhost, 2.1

xterm, 2.1

UNIX groups

checking for existing oinstall group, 2.6.1

creating the dba group, 2.6.2

UNIX users

creating the oracle user, 2.6.5.1

setting shell limits for on Linux x86, 2.7

UNIX workstation

installing from, 2.1

unprivileged user

checking existence of, 2.6.6

nobody user, 2.6

unset command, 2.14

unsetenv command, 2.14

upgraded databases

configuring, 4.2.2

upgrading, 1.12

advantages with separate Oracle homes, 3.6.1

Automatic Storage Management, 3.5.1

databases, 3.5.1

obfuscating password, 4.5.9.1

user roles

Application Express administrator, 4.5.10.1

developer, 4.5.10.1

end user, 4.5.10.1

workspace administrator, 4.5.10.1

useradd command, 2.6.5.2

USERS

tablespace (users01.dbf), 5.10.1

users

checking existence of the nobody user, 2.6.6

creating the oracle user, 2.6.5, 2.6.5.1

operating system nobody user, 2.6

Oracle software owner user, 2.6

setting shell limits for UNIX users on Linux x86, 2.7

UTLRP.SQL

recompiling invalid SQL modules, 4.2.2

V

very large databases

Optimal Flexible Architecture naming mount points, D.2.2.2

W

wdbsvr.app

modifications if running Oracle9i, 4.5.5.1

Web servers (Oracle HTTP Server), H.3

WebSphere MQ

CSD download location, 2.3.5.3

CSDs required

on Linux, 2.3.5.3

requirement on Linux, 2.3.5.3

WebSphere MQ class, 4.3.3.3

WebSphere MQ Series database, H.4

Windows

analogy for Oracle base directory, 2.8.1

wmem_default file, 2.7

wmem_default parameter

recommended value on Linux, 2.7

wmem_max file, 2.7

wmem_max parameter

recommended value on Linux, 2.7

workspace administrator, 4.5.10.1

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

XML DB HTTP server

disabling, 4.5.3.2

enabling, 4.5.3.2

xterm command, 2.1