Index

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

Numbers

64-bit database feature, Very Large Memory (VLM), main topic, A

A

account quotas

setting, 2.4.4

accounts

reviewing accounts and passwords, 5.1

setting account privileges, 2.4.3

setting account quotas, using the AUTHORIZE utility, 2.4.4

unauthenticated access through HTTP, 5.2.2

AL24UTFFSS character sets, upgrading issues, 1.9.2

ANONYMOUS user

unauthenticated account access through HTTP, 5.2.2

authentication methods

Kerberos, 2.1.4

Secure Socket Layer, 2.1.4

AUTHORIZE utility, 2.4.1, 2.4.2

AUTOGEN utility

considers pre-allocated reserved memory when tuning the system, 2.5.1

for setting or modifying SYSGEN parameters, 2.5.2

automating startup and shutdown, 4.5

B

Big Oracle Blocks (BOB), suggested parameter settings for VLM or 64-bit feature, A.2

buffers, DB_BLOCK_BUFFERS, recommendations for 64-bit feature (VLM), A.3

C

cache hit ratio, Oracle buffer cache, suggested parameter settings for 64-bit feature (VLM), A.2

cache, MRU (most recently used) end, tables in cache, DB_BLOCK_BUFFERS, 64-bit feature (VLM), A.3

caution

assignment of the rights identifier, 2.4.6

if installing additional Oracle Database 10g products in an existing Oracle home, stop all processes running in the Oracle home, 2.13

if you remove Oracle JVM, then Oracle Universal Installer removes all installed products that depend on Oracle JVM, including Oracle Database, 6.3

Oracle does not support using Oracle Universal Installer that is shipped with earlier releases, 3.3.2.1

REBOOT parameter, 2.5.2

removing an Oracle Database deletes all the data, 6.2

TCP/IP protocol stacks from other vendors may work with Oracle, but customers use these products at their own risk, 2.2

use the ORACLE10G account only for installing and maintaining Oracle software, 2.7.1

CD-ROM

copy to hard drive, for installation of Oracle Database, 3.3.1

installing Oracle Database from CD-ROM, 3.3.2

requirements, minimum hardware, 2.1.1

certification, hardware and software, 1.7.1

CGI programs, G.3.12

changes and enhancements, 1.2

Character Set Scanner, 1.9.2

character sets

AL24UTFFSS, 1.9.2

UTF8, 1.9.2

CLASSPATH logical, 4.7.4

clientadmin.rsp file

modifying a response file, B.1.3.1

clientcustom.rsp file

modifying a response file, B.1.3.1

clientruntime.rsp file

modifying a response file, B.1.3.1

cluster file system

definition, 1.10

code example

caching tables for performance, 64-bit feature (VLM), A.3

command to check if requisite patches are installed, 2.2

command to determine version of OpenVMS, 2.2

command to run Oracle Universal Installer in silent or suppressed mode, B.3

command to run Oracle Universal Installer noninteractively, B.2.3

creating the oraInst.loc file for noninteractive installation, B.2.1

DCL command to check disk format, 1.2.2

DCL command to set up X Window environment, 3.3.1, 3.3.2

for more information about other options for the runInstaller command, B.3

format a new disk using initialize command, 1.2.2

getting a list of command line options when you run Database Configuration Assistant, B.5.3

image dump, command to turn off this feature, 1.2.1

preparing response files for noninteractive installation, B.2.2

reformat existing disk from ODS-2 to ODS-5, 1.2.2

running Database Configuration Assistant in silent mode, B.5.3

running Oracle Network Configuration Assistant in silent mode, B.4

verifying correct database instance before shutdown, 5.7

commands

runInstaller

starting database, 3.3.2.2

SHOW SYSTEM

operating system information, 2.2

table of commands to stop processes running in Oracle home, 6.3

compatibility issues

Oracle product dependencies, 1.8

configuration

general purpose configuration with Database Configuration Assistant, 1.4

Configuration Assistant

database creation methods, 1.4

troubleshooting, F.5, F.5

control files

described, 5.5.3

locating, 5.5.3

reviewing, 5.5

using Oracle Enterprise Manager Grid Control with, 5.5.3

CONTROL_FILES initialization parameter, locating control files, 5.5.3

CSD

requirements, 2.2

customized database configuration, 1.5.1.3

custom.rsp file

modifying a response file, B.1.3.1

preparing response files, B.2.2

D

data files

creating separate directories for, 2.12

defined, 5.5.1

minimum disk space for, 2.12

options for placing on file system, 2.12

recommendations for file system, 2.12

reviewing, 5.5

setting up, 5.5.1

Data Guard

ports, ranges and protocol, D.3

database

accounts

in databases created by Database Configuration Assistant, 5.1

configuration options, 1.5

creation methods

selecting, 1.4

Database Configuration Assistant

database accounts and passwords, 5.1

troubleshooting, F.5

environments

general purpose, 1.5.1.1

transaction processing, 1.5.1.2

files, 5.5.1

initialization parameter file, 5.4, 5.4.1

redo log files, in starter database, 5.5.2

removing, 6.2

tablespaces, 5.5.1

Database Configuration Assistant

and Oracle interMedia, 1.4

database creation methods, selecting, 1.4

database environments configured by, 1.4

response file, B.2.2

Database Configuration Assistant, running Database Configuration Assistant in noninteractive or silent mode, B.5

DB_BLOCK_BUFFERS

recommendations for 64-bit feature (VLM), A.3

suggested parameter settings for 64-bit feature (VLM), A.2

DB_BLOCK_SIZE. suggested parameter settings for 64-bit feature (VLM), A.2

DB_DOMAIN name parameter, global database name, identifying databases, 5.3

DB_NAME parameter, global database name, identifying databases, 5.3

dbca.rsp file

modifying a response file, B.1.3.1

preparing response files, B.2.2

DBSNMP

database account, in databases created by Database Configuration Assistant, 5.1

DCL command, to check disk format, overview, 1.2.2

decision support system (DSS)

parameter settings, VLM or 64-bit feature, A.2

query-intensive transactions, 64-bit database feature, or VLM, A.1.1

default initialization parameter file, init.ora, 5.4.1

devices

requirements

issues and restrictions, 2.3.3

E

Enterprise Manager Agent (EMAgent), C

enterprise.rsp file

modifying a response file, B.1.3.1

preparing response files, B.2.2

environment

descriptions, database types, 1.5.1

requirements, 2.8.1

environment variables

NLS_LANG, E.1

errors

configuration assistants, F.5

installation, F.4, F.5.2

noninteractive installation, F.6

silent mode, F.6

X Window, F.1

examples

see "code example" for sample codes, 1.2.1

F

fatal errors, F.5.2

file system

using for data files, 2.12

files

Files-11 On-Disk Structure Level 5 (ODS-5) format, 1.2.2

listener.ora, 4.7.1

mgw.ora, 4.7.4

Oracle Universal Installer log files, 3.4

oraInst.loc, B.2.1

permissions for creation, 2.6

setting permissions for creation, 2.4.10

supported devices, 2.3.3

tnsnames.ora, 4.7.1

G

general purpose configuration by using Database Configuration Assistant, 1.4

general purpose database environments, 1.5.1.1

GENPARAMS parameter, 2.5.2

global database name, identifying databases, 5.3

globalization support, E

H

hard drive installation of Oracle Database, 3.3.1

hardware

certification, 1.7.1

requirements, 2.1

home directory

description, also see Oracle home directory, 2.10.3

properties of Oracle Database accounts, choosing a home directory, 2.7.1

I

identifiers, process rights, 2.4.5

image dump, recommendation - do not define dump logical, 1.2.1

images

described, 2.1.2

initialization parameter file

description, 5.4.2

in database, 5.4.1

in databases, 5.4

init.ora, description, 5.4.1

initsid.ora, 5.4

Initialize command, formatting a new disk to ODS-5, 1.2.2

init.ora file, initialization parameter file, description, 5.4.1

initsid.ora initialization parameter file, 5.4

installation

cleaning up, 3.5

considerations, 1.7

errors, F.4, F.5.2

silent mode, F.6

guidelines

noninteractive installation and configuration, 3.1.1

Oracle Label Security, 3.1.1

Oracle Universal Installer, 3.1.1

reviewing product-specific installation guidelines, 3.1.1

log files, F.3, F.3

noninteractive

error handling, F.6

oraInst.loc file, B.2.1

Oracle software owner, 2.6

overview, 3.1

postinstallation tasks, 4, 5, 6

procedure requirements, 2.4

requirements

environment, 2.8.1

response files

preparing, B.2.2

silent mode, F.6

silent mode, B.2.3

terminated, 3.5

instance, account required to start, 2.4.7

issues and restrictions, port-specific, 2.3

J

JDK

installation issues, 2.3.2

internationalization class, 4.7.4

run time class, 4.7.4

K

Kerberos authentication, requirements, 2.1.4

L

licensing information, 1.3

listener

identifying Oracle home for, 2.13

lsnrctl command, 2.13

stop command example, 2.13

stopping existing listener process before new db installation, 2.13

listener.ora file

modifying for external procedures, 4.7.4

static service information, 4.7.1

local device, using for data files, 2.12

log files, troubleshooting

installation error while a configuration assistant is running, F.3

installation error while the Installer is copying or linking files, F.3

reviewing log file of an installation session, F.4

logical volume manager (LVM), database storage options, 1.6.1

LRS, also see Log roll-forward server (LRS), A

lsnrctl command

stopping the listener process, 2.13

M

Mailbox driver, OpenVMS

preinstallation, 2.2

MAXSYSGROUP, 2.4.1

memory

advantages to reserving memory for an SGA, 2.5.1

memory-resident global sections, using the Reserved Memory Registry, 2.5.1

MGW_AGENT service name, 4.7.4

mgwextproc service, adding static service information, 4.7.4

mgw.ora file, modifying, 4.7.4

MIN_GBLPAGES, calculating, 2.5

MIN_GBLSECTIONS, calculating, 2.5

modifying system parameters, 2.5

most recently used MRU, tables in cache, DB_BLOCK_BUFFERS, 64-bit feature (VLM), A.3

MQSeries

class, 4.7.4

MRU (most recently used), tables in cache, DB_BLOCK_BUFFERS, 64-bit feature (VLM), A.3

multiple databases, 2.4.7

multiple Oracle homes, supported by Oracle Database 10g, 1.7.2

N

Net Configuration Assistant, troubleshooting, F.5

NLS_LANG environment variable, E.1

NLS_LANG parameter

about, E.1

noninteractive installation

oraInst.loc file, B.2.1

preparing response files, templates, B.2.2

silent mode

errors, F.6

running Oracle Universal Installer, B.2.3

noninteractive installations

running Oracle Universal Installer, B.2.3

noninteractive mode, running Database Configuration Assistant in noninteractive or silent mode, B.5

O

ODS-5

disk structure, Files-11 On-Disk Structure Level 5 format, 1.2.2

formatted CD-ROM disks provided by Oracle, 2.1.1

OLS

also see Oracle Label Security, 3.1.1

OLTP (Online Transaction Processing)

database environments, 1.5.1.2

OLTP, Online Transaction Processing

transactions, read/write transactions and 64-bit database feature, or VLM, A.1.1

Online Transaction Processing (OLTP) environment descriptions, 1.5.1.2

OpenVMS

system parameters, 2.5

OpenVMS Mailbox driver

preinstallation, 2.2

operating system

configuration, 2.6

options

database configuration options, 1.5

ORA_ROOT

Oracle

account

home directory, 2.7.1

postinstallation tasks, 4.6

preinstallation tasks, 2.8

buffer cache, cache hit ratio, suggested parameter settings for 64-bit feature (VLM), A.2

home directory

description, 2.10.3

recommended path, 2.10.3

requirement for, 2.10.3

requirements, 2.10.3

home name, 2.10.3

internationalization class, 4.7.4

JDBC class, 4.7.4

Label Security

installation guidelines, 3.1.1

postinstallation tasks, 4.7.2

Oracle Client is installed separately from the database, 1.3

Oracle Spatial

Motif requirement, 2.2

requirement for example programs, 2.2

oracle user

configuring environment for, 2.14

Oracle Wallet Manager and Secure Socket Layer, 2.1.4

parallel server, re-installing, 3.5

precompilers, postinstallation tasks, 4.7.5

Server DBA account, 2.4.1

Server, automating startup and shutdown, 4.5

software

owner user, configuring user’s environment, 2.14

owner user, preinstallation setup tasks to perform, 2.8

removing, 6.3

tools, adding or upgrading, 5.6.1

Oracle Advanced Security

add-on product for Oracle Net Server or Oracle Net Client, 2.1.4

Oracle Wallet Manager, 2.1.4

Oracle Database

64-bit feature cannot be removed, A

account quotas required, 2.4.4

Client

chip set requirements, 2.1.1

creating account, 2.4.1

creating data file directories, 2.12

custom installation, 1.3, 3.3.2.2

Enterprise Edition installation, 1.3

minimum disk space requirements, 2.12

relinking Oracle code, 5.7

Server

disk space requirements, 2.1.3

setting system parameters, 2.5.2

Oracle Enterprise Management Agent

HTTP port, changing, D.4

ports

ranges and protocol, D.3

Oracle Enterprise Manager, Grid Control

using to modify control files, 5.5.3

using to modify redo log files, 5.5.2

using to view control files, 5.5.3

using to view redo log files, 5.5.2

Oracle inventory

log files, 3.4

Oracle Inventory

description, 2.10.1

directory description, 2.10.1

Oracle Label Security

installation guidelines, 3.1.1

Oracle Messaging Gateway

class, 4.7.4

Oracle Network Configuration Assistant, running Oracle Network Configuration Assistant in silent mode, B.4

Oracle Network Manager

and Oracle Advanced Security, 2.1.4

Configuration Assistant

response file, B.2.2

configuration file directory, 4.7.1

listener, running Oracle Network Configuration Assistant in silent mode, B.4

lsnrctl command, 2.13

Services, postinstallation tasks, 4.7.1

stopping a listener process, 2.13

stopping existing listener, 2.13

stopping the listener, 2.13

Oracle recovery files

guidelines, 2.11

Oracle SQL*Net Listener

ports, ranges and protocol, D.3

Oracle Technology Network website

downloading installation software from, 3.2, 3.2

Oracle Universal Installer, 3.1.1

creating an Oracle Database during the installation, 1.5

database creation methods, 1.4

installation from CD-ROM, 3.3.2

installation from hard disk, 3.3.1

installation guidelines, 3.1.1

inventory

oraInventory directory, 3.4

list of response file names, B.1.3.1

log files, 3.4

ORACLE_HOME logical

oracle account home directory, 2.7.1

requirements, 2.3.1

ORACLE_HOME logical, setting for running Database Configuration Assistant in noninteractive mode, B.5.3

oraInventory directory, 3.4

See Oracle Inventory directory

P

paging

determine amount of paging configured on the system, 2.1.1

parameter

DB_DOMAIN name, global database name, identifying databases, 5.3

DB_NAME, global database name, identifying databases, 5.3

GENPARAMS, 2.5.2

SAVPARAMS, 2.5.2

SERVICE_NAMES, global database name, identifying databases, 5.3

SYSGEN, 2.5

passwords

changing, 4.4

management, unlocking database accounts, 5.2

resetting, 5.2

reviewing, 5.1

revoked after installation, for all Oracle system administration accounts, 5.2

unlocking, 5.2

patches

requirements, 2.2

performance, benefit of 64-bit database feature, or VLM, A.1.1

permissions

file creation, 2.6

port numbers

managing, D

portlist.ini file, D.2

ports

access URLs, D.2

configured for applications, D.2

Data Guard, ranges and protocol, D.3

default ranges, D

Oracle Enterprise Management Agent HTTP, changing, D.4

Oracle Enterprise Management Agent, ranges and protocol, D.3

Oracle SQL*Net Listener, ranges and protocol, D.3

postinstallation

required tasks

main topic, 4.2

Oracle Label Security, configuring, 4.7.2

Oracle Net Services, configuring, 4.7.1

Oracle Precompilers, 4.7.5

patches, installing and downloading, 4.2.1

postinstallation tasks

required, 4.2.1

precompilers

Pro*C/C++, 4.7.5

Pro*COBOL, 4.7.5

Pro*FORTRAN, 4.7.5

preinstallation tasks

as the System user, 2.7

Oracle Network Manager

setup tasks, 2.9.2.1

Pro*C/C++ precompiler, 4.7.5

Pro*COBOL precompiler, 4.7.5

Pro*FORTRAN

requirements, 2.2, 2.2

Pro*FORTRAN precompiler, 4.7.5

process

stopping existing, 2.13

stopping existing listener process, 2.13

process rights identifier, 2.4.5

Program Global Area (PGA)

sorts and SORT_AREA_SIZE parameter, A.2

suggested parameter settings for 64-bit feature (VLM), A.2

ps command, 2.13

Q

query-intensive transactions (DSS), 64-bit database feature, or VLM, A.1.1

quotas, account, 2.4.4

R

RAID, using for Oracle data files, 2.12

RAM

determining amount of RAM installed on the system, 2.1.1

readme.txt file, D.2

read/write transactions (OLTP), 64-bit database feature, or VLM, A.1.1

recovery files, options for placing on file system, 2.12

redo log files

in starter database, 5.5.2

locating, in starter database, 5.5.2

reviewing, 5.5

using Oracle Enterprise Manager Grid Control with, 5.5.2

redundant array of independent disks

also see RAID, 2.12

relative path to response file causes installation failure, B.2.3, B.3

relinking

Oracle code, 5.7

Oracle products, 5.7

requirements

CD-ROM, 2.1.1

devices, 2.3.3

disk space, 2.1.3

file permissions, 2.6

hardware, 2.1

JDK

used by Oracle Java applications, 2.3.2

Kerberos authentication, 2.1.4

Oracle Advanced Security

an add-on product, 2.1.4

ORACLE_HOME, 2.3.1

Secure Socket Layer

requires a compatible wallet, 2.1.4

system configuration, 2.6

Reserved Memory Registry, 2.5.1

response file

how to install and configure Oracle products noninteractively, main topic, B

names, B.1.3.1

relative path to response file causes installation failure, B.2.3, B.3

table of files provided with Oracle Database for noninteractive installation, B.2.2

template, running Database Configuration Assistant in noninteractive or silent mode, B.5

RMAN

enabling automated backups with Oracle Recovery Manager, 1.6.2

runInstaller command

options, B.3

S

SAME (stripe and mirror everything) methodology, file system recommendations, 1.6.1

SAVPARAMS parameter, 2.5.2

scalability, advantage of 64-bit database feature, or VLM, A.1.1

security issues, 2.4.7

seed database, Database Configuration Assistant, 1.4

SERVICE_NAMES parameter, global database name, identifying databases, 5.3

Set Volume command, changing a disk to ODS-5, 1.2.2

setting account privileges, 2.4.3

setting account quotas, 2.4.4

SGA protection, 2.4.6

SHOW SYSTEM command

operating system information, 2.2

shutdown and startup, 4.5

silent mode

installation, B.2.3

running Database Configuration Assistant in silent mode or noninteractive mode, B.5

running Oracle Network Configuration Assistant in silent mode, B.4

sizer command, 2.2

software certification, 1.7.1

software only, installation choice, 1.5.1.4

SORT_AREA_SIZE parameter. suggested parameter settings for 64-bit feature (VLM), A.2

SQLJ class, 4.7.4

starting instances, 2.4.7

startup and shutdown, 4.5

static service information, adding for mgwextproc service, 4.7.4

stripe and mirror everything (SAME) methodology

file system recommendations, 1.6.1

suppressed mode, running Oracle Universal Installer in silent or suppressed mode, B.3

SYS account, 2.4.1

SYS database account, in databases created by Database Configuration Assistant, 5.1

SYSGEN parameters, 2.5

SYSMAN

database account, in databases created by Database Configuration Assistant, 5.1

utility

reserving memory for an SGA, 2.5.1

using the Reserved Memory Registry, 2.5.1

system

parameters, 2.5

summary of requirements, 2.6

SYSTEM account, 2.4.1

SYSTEM database account, in databases created by Database Configuration Assistant, 5.1

System Global Area (SGA)

no need to estimate maximum SGA, a 64-bit database feature, or VLM, A.1.2

System Identifier (SID) identifies a specific database instance, 5.3

System user, preinstallation tasks, 2.7

T

tablespaces

defined, 5.5.1

in databases, 5.5.1

reviewing, 5.5

setting up, 5.5.1

template, response file template, running Database Configuration Assistant in noninteractive or silent mode, B.5

tnsnames.ora file

adding a connect descriptor, 4.7.4

configuring Oracle Network Manager services, 4.7.1

MGW_AGENT service name, 4.7.4

modifying for external procedures, 4.7.4

tools

adding or upgrading, 5.6.1

transaction processing, database environments, 1.5.1.2

troubleshooting

fatal errors, F.5.2

main topic, F

oraInventory log files, 3.4

U

UAF, 2.4.1

UIC GROUP number, 2.4.1

upgraded databases, configuring, 4.3

upgrading

Oracle products, 5.6.1

to Oracle Database 10g from previous Oracle version, 1.8

upgrade issues, 1.9

user and group numbers, 2.4.1

UTF8 character set, 1.9.2

UTLRP.SQL

recompiling invalid SQL modules, 4.3

V

Very Large Memory (VLM)

introduction, A

reserving memory, 2.5.1

W

WebSphere MQ

checking requirements, 2.2

class, 4.7.4

CSDs required, 2.2

X

X Window

and X/Motif Software development, Motif requirement, 2.2

display errors, F.1