Index

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

Numerics

10.1 deprecated and desupported components, Preface

10.1 new features, Preface

9.2.0.4 new features, Preface

A

accessibility software, Java Access Bridge, A

accounts, 5.2.1

ANONYMOUS, 5.2.1

BI, 5.2.1

CTXSYS, 5.2.1

DBSNMP, 5.2.1

DIP, 5.2.1

DMSYS, 5.2.1

EXFSYS, 5.2.1

HR, 5.2.1

IX, 5.2.1

LBACSYS, 5.2.1

MDDATA, 5.2.1

MDSYS, 5.2.1

MGMT_VIEW, 5.2.1

ODM, 5.2.1

ODM_MTR, 5.2.1

OE, 5.2.1

OLAPSYS, 5.2.1

ORDPLUGINS, 5.2.1

ORDSYS, 5.2.1

OUTLN, 5.2.1

PM, 5.2.1

SCOTT, 5.2.1

SH, 5.2.1

SI_INFORMTN_SCHEMA, 5.2.1

SYS, 5.2.1

SYSMAN, 5.2.1

SYSTEM, 5.2.1

WK_TEST, 5.2.1

WKPROXY, 5.2.1

WKSYS, 5.2.1

WMSYS, 5.2.1

XDB, 5.2.1

admin directory, explained, B.4.3

Administrators group

requirements for Oracle installations, 3.1

AL24UTFFSS character sets, 1.10.1

ANONYMOUS

username, 5.2.1

ASM

characteristics of failure groups, 2.3.3.1

configuring disks, 2.3.3.3

disk groups, 2.3.3.1

failure groups, 2.3.3.1

examples, 2.3.3.1

identifying, 2.3.3.1

overview, 1.6

recommendations for disk groups, 2.3.3.1

redundancy levels, 1.6

removing an instance, 6.3.3.1

space required for preconfigured database, 2.3.3.1

storage option for datafiles, 2.3.1

authentication support

preinstallation requirements, 2.3.6

automatic storage management. See ASM

B

backup

perform before upgrading, 3.1

batch mode

setting the NLS_LANG parameter, D.3

username, 5.2.1

C

certification, hardware and software, 2.2

Character Set Scanner, 1.10.1

character sets

AL24UTFFSS, 1.10.1

UTF8, 1.10.1

cluster file system

storage option for datafiles, 2.3.1

components

for single Oracle homes, 1.2.6.1

installation of single Oracle home components, 1.2.6.1

removing database, Oracle Internet Directory, and Net Services services and registry entries, 6.3.3.2

removing manually on Windows NT/2000/XP, 6.3.3.2

system requirements, 2.1

using in different languages, C.2.2

configuration assistants

troubleshooting, F.4, F.4

configuring disks for ASM, 2.3.3.3

configuring raw devices, 2.3.4

control files, 5.7

raw devices, 2.3.4

CTXSYS

username, 5.2.1

custom database

failure groups for ASM, 2.3.3.1

requirements when using ASM, 2.3.3.1

custom.rsp file

description, C.1

D

data dictionary

description, 5.9

in starter database, 5.9

data loss

minimizing with ASM, 2.3.3.1

Database Configuration Assistant

troubleshooting, F.4

Database Control

accessing, 5.1

changing passwords, 5.2.2.2

default ports, E.1

listing initializations parameters, 5.4

listing tablespaces, 5.5

unlocking accounts, 5.2.2.2

viewing control files, 5.7

viewing redo log files, 5.6

Database Custom installation type

defined, 1.3

databases

accounts, 5.2.1

ASM requirements, 2.3.3.1

control files, 5.7

data dictionary, 5.9

datafiles, 5.5

initialization parameter file, 5.4

redo log files, 5.6

removing, 6, 6.3.3.2

removing Oracle HTML DB, 6.1

rollback segments, 5.8

tablespaces, 5.5, 5.5

undo segments, 5.8

upgrade requirements, 1.10

datafiles, 5.5

creating separate directories for, 2.3.2

managing with ASM, 1.6

minimum disk space for, 2.3.2

options for placing on file systems, 2.3.2

recommendations for file system, 2.3.2

storage options, 2.3.1

DB_DOMAIN parameter, 5.3

DB_NAME

directory, explained, B.4.5

DB_NAME parameter, 5.3

dbca.rsp file

description, C.1

DBSNMP

username, 5.2.1

DBSNMP user password, 3.6

default control files, 5.7

default datafiles, 5.5

default initialization parameter file

init.ora, 5.4

default tablespaces, 5.5

deinstallation

of database, Oracle Internet Directory, and Net Services services and registry entries, 6.3.3.2

of Oracle components, 6.3.3.2

deprecated and desupported components for 10.1, Preface

differences

between installing Oracle on Windows and UNIX, 1.2.2

DIP

username, 5.2.1

E

Enterprise Edition installation type

defined, 1.3

Enterprise Manager

default ports, E.1

enterprise.rsp file

description, C.1

environment variables

TEMP and TMP, 2.1.3

errors

configuration assistants, F.4

installation, F.3, F.4.2

noninteractive installation, F.5

silent mode, F.5

EXAMPLE tablespace

description, 5.5

example01.DBF datafile, 5.5

raw device for, 2.3.4

example01.DBF datafile, 5.5

examples

ASM failure groups, 2.3.3.1

EXFSYS

username, 5.2.1

external redundancy

ASM redundancy level, 1.6

F

failure group

ASM, 2.3.3.1

characteristics of ASM failure group, 2.3.3.1

examples of ASM failure groups, 2.3.3.1

fatal errors, F.4.2

features, new for 10.1, Preface

features, new for 9.2.0.4, Preface

file systems

datafile and recovery file placement options, 2.3.2

storage option for datafiles, 2.3.1

system requirements, 1.10.3, 2.1.2.1

using for datafiles, 2.3.2

files

control files

raw devices, 2.3.4

listener.ora, 4.3.7

Oracle Universal Installer log files, F.3

password file

raw device, 2.3.4

redo log files

raw devices, 2.3.4

server parameter file

raw devices, 2.3.4

SPFILE

raw devices, 2.3.4

tnsnames.ora, 4.3.7

G

generic documentation references

Windows-specific NLS_LANG values, D.2

Windows-specific NLS_TERRITORY values, D.2

Windows-specific parameter file name and location, 5.4

Windows-specific redo log file location, 5.6

Windows-specific redo log file size, 5.6

global database name

defined, 5.3

globalization support, D.2

H

hardware certification, 2.2

high redundancy

ASM redundancy level, 1.6

username, 5.2.1

I

initialization parameter file

description, 5.4

in database, 5.4

init.ora, 5.4

installactions.log file, F.3

installation

ASM requirements, 2.3.3.1

completing, 3.6

differences between installing Oracle on UNIX and Windows, 1.2.2

errors, F.3, F.4.2

silent mode, F.5

guidelines, 3.6

in noninteractive mode, C.1

log files, F.2, F.2

noninteractive

error handling, F.5

of single Oracle home components, 1.2.6.1

preinstallation, 3.1

raw device requirements, 2.3.4

requirements, 2.1

response files

silent mode, F.5

restrictions on installing in pre-8.1.5 homes, 1.2.4

restrictions on using old Oracle Installer, 1.2.4

reviewing a log of an installation session, F.3

installation guidelines, 3.6

iSQL*Plus

default ports, E.1

username, 5.2.1

J

Java Access Bridge

about, A.1

configuring, A.3.2

installing, A.3.1

JRE 1.4.2, A.2

Java Runtime Environment

requirements, 2.1.2.1

restrictions on modifying, 1.2.4

version used by Oracle, 1.2.4

JRE. See Java Runtime Environment

L

languages

installing Oracle components in different languages, C.2.1

using Oracle components in different languages, C.2.2

LBACSYS

username, 5.2.1

licensing issues, 1.2.1

listener

stopping existing listener process, 2.3.5

listener.ora file, 4.3.7

local device

using for datafiles, 2.3.2

log files, F.2, F.2

reviewing an installation session, F.3

troubleshooting, F.3

logical volume manager

See LVM

LVM

configuring raw devices, 2.3.4

recommendations for ASM, 2.3.3.1

M

MDDATA

username, 5.2.1

MDSYS

username, 5.2.1

MGMT_VIEW

username, 5.2.1

MS-DOS mode

setting the NLS_LANG parameter, D.3

multiple Oracle homes

System Identifier, 5.3

N

Net Configuration Assistant

troubleshooting, F.4

Net Services

removing, 6.3.3.2

netca.rsp file

description, C.1

new features for 10.1, Preface

new features for 9.2.0.4, Preface

NLS_LANG parameter, D.1

setting in MS-DOS mode and batch mode, D.3

territory and character set defaults, D.2

noninteractive installation

overview, C.1

silent mode errors, F.5

normal redundancy

ASM redundancy level, 1.6

NTDBI004, 4

NTFS

system requirements, 1.10.3, 2.1.2.1

O

ODM

username, 5.2.1

ODM_MTR

username, 5.2.1

OEM

See Oracle Enterprise Manager

OFA

standard, B

OLAPSYS

username, 5.2.1

operating systems, supported, 2.1.1

Optimal Flexible Architecture

default OFA database, B.5.2

differences since previous releases, B.3

nondefault OFA database 1, B.5.3

nondefault OFA database 2, B.5.4

Windows and UNIX differences, B.7

Oracle Advanced Security

preinstallation requirements, 2.3.6

Oracle Database

creating datafile directories, 2.3.2

datafile storage options, 2.3.1

minimum disk space requirements, 2.3.2

requirements with ASM, 2.3.3.1

Oracle Enterprise Manager

options, 1.7

preinstallation requirements, 2.3.7

Oracle home

single Oracle home components, 1.2.6.1

Oracle HTML DB

removing from the database, 6.1

Oracle Internet Directory

removing, 6.3.3.2

running command line tools in MS-DOS mode, D.3

Oracle Net Services

configuring, 4.3.7

postinstallation tasks, 4.3.7

stopping existing listener, 2.3.5

Oracle Real Application Clusters

upgrade requirements, 1.10.3

Oracle services

stopping, 3.1

Oracle Snap-Ins for Microsoft Management Console

preinstallation requirements for integration with Oracle, 2.3.10

Oracle Universal Installer

defined, 1.2.4

documentation on using, 1.2.4

log files, F.3

removing components, 6.3

restrictions on installing in pre-8.1.5 homes, 1.2.4

running components in different languages, C.2.2

running in different languages, C.2.1

running in noninteractive mode, C.1

running silently, C.1

Oracle Utilities

setting in MS-DOS mode, D.3

Oracle Windows services

stopping, 3.1

ORACLE_BASE

explained, B.4.1

ORACLE_HOME

directory structure, B.4.2

specifying, B.5.1

ORADATA directory, explained, B.4.4

ORDPLUGINS

username, 5.2.1

ORDSYS

username, 5.2.1

OUTLN

username, 5.2.1

P

partitions

raw, B.6.3

using with ASM, 2.3.3.1

password file

raw device for, 2.3.4

passwords

changing, 5.2, 5.2.2

DBSNMP, 3.6

guidelines, 3.6

SYS, 3.6

SYSMAN, 3.6

SYSTEM, 3.6

patch set information, 4.1

performance, increasing, B.6

Personal Edition installation type

defined, 1.3

personal.rsp file

description, C.1

PL/SQL modules

validating, 4.2

username, 5.2.1

ports

default port ranges, E

postinstallation

changing passwords, 5.2.2

Oracle Net Services, configuring, 4.3.7

validating invalid PL/SQL modules, 4.2

preconfigured database

ASM disk space requirements, 2.3.3.1

requirements when using ASM, 2.3.3.1

preinstallation

perform database backup, 3.1

requirements for Oracle Advanced Security, 2.3.6

requirements for Oracle Enterprise Manager, 2.3.7

requirements for Oracle Snap-Ins for Microsoft Management Console, 2.3.10

stop services, 3.1

tasks, 3.1

process

stopping existing listener process, 2.3.5

R

RAID

recommended ASM redundancy level, 2.3.3.1

using for Oracle datafiles, 2.3.2

RAID. See Redundant Array of Independent Disks

raw devices

configuring, 2.3.4

for control files, 2.3.4

for EXAMPLE tablespace, 2.3.4

for password file, 2.3.4

for redo log files, 2.3.4

for server parameter file, 2.3.4

for SPFILE, 2.3.4

for SYSAUX tablespace, 2.3.4

for SYSTEM tablespace, 2.3.4

for TEMP tablespace, 2.3.4

for UNDOTBS tablespace, 2.3.4

for USERS tablespace, 2.3.4

storage option for datafiles, 2.3.1

raw logical volumes

See raw devices

raw partitions

defined, B.6.3

See raw devices

recovery files

options for placing on file system, 2.3.2

redo log files

in starter database, 5.6

raw devices for, 2.3.4

redundancy level

and space requirements for preconfigured database, 2.3.3.1

for ASM, 1.6

Redundant Array of Independent Disks, B.6.1

redundant array of independent disks

See RAID

registry

exercise care when using, 6.3.3.2

reliability, increasing, B.6

removing

ASM instance, 6.3.3.1

components with Oracle Universal Installer, 6.3

database, Oracle Internet Directory, and Net Services services and registry entries, 6.3.3.2

Oracle components manually on Windows NT/2000/XP, 6.3.3.2

Oracle databases, 6

Oracle HTML DB from the database, 6.1

Oracle software, 6

required service packs, 2.1.1

requirements

for installation, 2.1

for Java Runtime Environment, 2.1.2.1

for Oracle Enterprise Manager, 2.3.7

for upgrading a database, 1.10

preinstallation, 3.1

service packs, 2.1.1

response files

custom.rsp, C.1

dbca.rsp, C.1

documentation on, C.1.1

enterprise.rsp, C.1

modifying, C.1.1

netca.rsp, C.1

on the media, C.1

personal.rsp, C.1

specifying during installation, C.1.2

standard.rsp, C.1

using, C.1

rollback segments

starter database, 5.8

root user, 3.6

S

SCOTT

username, 5.2.1

server parameter file

raw device, 2.3.4

service pack requirements, 2.1.1

SERVICE_NAMES parameter, 5.3

services

stopping, 3.1

stopping existing, 2.3.5

username, 5.2.1

SI_INFORMTN_SCHEMA

username, 5.2.1

silent installation

overview, C.1

single Oracle home

components, 1.2.6.1

software

removing, 6

software certification, 2.2

SPFILE

raw devices, 2.3.4

SQL*Plus

setting the NLS_LANG parameter in MS-DOS mode, D.3

Standard Edition installation type

defined, 1.3

standard.rsp file

description, C.1

starter database

accounts, 5.2.1

stopping

existing services, 2.3.5

striping disks, B.6.2

supported operating systems, 2.1.1

symbolic links, B.7.3

SYS

user password, 3.6

username, 5.2.1

SYSAUX tablespace

for raw devices, 2.3.4

SYSMAN

username, 5.2.1

SYSMAN user password, 3.6

SYSTEM

tablespace for raw devices, 2.3.4

tablespace, description, 5.5

user password, 3.6

username, 5.2.1

system requirements, 2.1

for NTFS file systems, 1.10.3, 2.1.2.1

system01.dbf datafile, 5.5, 5.5

T

tablespaces, 5.5

expanding for large sorts, 5.5

in database, 5.5

TEMP, 5.5

USERS, 5.5, 5.5

TEMP

environment variable, 2.1.3

tablespace (temp01.dbf), 5.5

tablespace for raw devices, 2.3.4

temp01.dbf datafile, 5.5

temporary directory, 2.1.3

temporary disk space

checking, 2.1.3

freeing, 2.1.3

test, 2.3

tmp directory

checking space in, 2.1.3

freeing space in, 2.1.3

TMP environment variable, 2.1.3

tnsnames.ora file, 4.3.7

troubleshooting, F

fatal errors, F.4.2

Inventory log files, F.3

U

Ultra Search

default ports, E.1

undo segments

starter database, 5.8

UNDOTBS

tablespace (undotbs01.dbf), 5.5

tablespace for raw device, 2.3.4

UNIX

differences between installing Oracle on Windows, 1.2.2

unsupported components

on Windows Terminal Server, 2.2.3.2

on Windows XP, 2.2.2

upgrading

backing up before upgrading, 3.1

considerations, 1.10

requirements for Oracle Real Application Clusters, 1.10.3

usernames

ANONYMOUS, 5.2.1

BI, 5.2.1

changing passwords, 5.2.2

CTXSYS, 5.2.1

DBSNMP, 5.2.1

DIP, 5.2.1

DMSYS, 5.2.1

EXFSYS, 5.2.1

HR, 5.2.1

IX, 5.2.1

LBACSYS, 5.2.1

MDDATA, 5.2.1

MDSYS, 5.2.1

MGMT_VIEW, 5.2.1

ODM, 5.2.1

ODM_MTR, 5.2.1

OE, 5.2.1

OLAPSYS, 5.2.1

ORDPLUGINS, 5.2.1

ORDSYS, 5.2.1

OUTLN, 5.2.1

PM, 5.2.1

SCOTT, 5.2.1

SH, 5.2.1

SI_INFORMTN_SCHEMA, 5.2.1

SYS, 5.2.1

SYSMAN, 5.2.1

SYSTEM, 5.2.1

WK_TEST, 5.2.1

WKPROXY, 5.2.1

WKSYS, 5.2.1

WMSYS, 5.2.1

XDB, 5.2.1

USERS

tablespace (users01.dbf), 5.5

tablespace for raw device, 2.3.4

UTF8 character set, 1.10.1

utlrp.sql file, 4.2

W

Windows

differences in Oracle installation with UNIX, 1.2.2

Windows Terminal Servers

unsupported components, 2.2.3.2

Windows XP

unsupported components, 2.2.2

WK_TEST

username, 5.2.1

WKPROXY

username, 5.2.1

WKSYS

username, 5.2.1

WMSYS

username, 5.2.1

X

XDB

username, 5.2.1