Index

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

---

Symbols

"", SQL*Loader parameter, 2-18

"FIX n", SQL*Loader parameter, 2-18

"RECSIZE", SQL*Loader parameter, 2-18

"VAR xxxx", SQL*Loader parameter, 2-19

\\.\PhysicalDrivex, D-4

---

Numerics

1521 port, E-11

1526 port, E-11

1575 port, E-11

1610 port, E-11

1620 port, E-11

4GB RAM Tuning, 10-3

---

A

Access Control Lists

accessing security groups, 4-21

adding or removing users in security groups, 4-23

available security groups, 4-20

changing user permissions in security groups, 4-24

Active Directory

accessing security groups, 4-21

adding or removing users in security groups, 4-23

automatic discovery of directory servers, 4-6

changing permissions in security groups, 4-24

connecting to a database, 4-16, 4-17

creating security domains, 4-25

defined, 4-2

enhancement of directory object type descriptions, 4-8

how Oracle directory objects appear, 4-9

installation requirements, 8-10

integration with directory servers, 4-6

integration with Microsoft tools, 4-7

integration with Windows login credentials, 4-8

managing Access Control Lists, 4-20

managing security groups directory server

managing Access Control Lists, 4-20

procedures for installing Oracle into, 4-14

required Oracle configuration tools, 4-14

requirements for creating an Oracle Context, 4-11

requirements for creating an Oracle schema, 4-10

requirements for creating enterprise user security, 4-13

requirements for creating Net8 directory naming, 4-12

requirements for using Oracle, 4-10

testing connectivity from client computers, 4-16

testing connectivity with Microsoft tools, 4-17

testing connectivity with SQL*Plus, 4-7, 4-19

testing database connectivity, 4-7, 4-18

user interface extensions, 4-7

Active Directory Users and Computers

accessing directory server objects, 4-17

integration with Oracle objects in Active Directory, 4-7

testing database connectivity from, 4-18

ADMIN directory, explained, 3-22

administration tools

for enterprise users, 8-9

for external users, 8-6

Advanced Replication support

additional documentation, 5-24

configuration tasks, 5-22

creating a SPOOL file, 5-23, 5-24

data dictionary

tables, 5-24

initialization parameter requirements, 5-21

tablespace requirements, 5-21, 5-24

alert files, 9-13

for monitoring a database, 9-2

using, 9-13

alert view, 9-4

ALL_HOMES, registry subkey for multiple Oracle homes, C-8

ALTER DATABASE ARCHIVELOG command, 7-24

ALTER PACKAGE command, 5-23

application development

finding information, 12-2

ARCHIVE LOG LIST command, 7-24

ARCHIVELOG mode, 7-24

archiving mode

custom database, 7-23

starter database, 7-23

archiving procedures, 7-25

for redo log files, 7-23

specifying an archive destination, 7-25

UNC not allowed, 6-3, 7-23

audit trail

managing, 9-13

operating system, 2-22

AUDIT_FILE_DEST parameter, 9-13, B-4

AUDIT_TRAIL parameter, 9-11

auditing, 9-11

authentication

automatically enabling during installation, 8-13

connecting as INTERNAL without a password, 8-50

creating an operating system-authenticated user, 8-43

enhancements, 8-4

in Windows 2000 domains, 8-8

of enterprise users, 8-8

of external users, 8-6

overview, 8-2

setting OS_AUTHENT_PREFIX, 8-41

setting OSAUTH_PREFIX_DOMAIN, 8-41

using a password file, 7-16

using Windows native authentication methods, 8-2

when to use enterprise users, 8-5

when to use external users, 8-5

Authentication Adapters

using, E-6

authentication parameter settings

viewing, 8-24

authentication protocols

default protocol used, 8-3

with Windows 2000, 8-2

with Windows NT 4.0, 8-2

authorization

of external roles, 8-7, 8-9

when to use enterprise roles, 8-5

when to use external roles, 8-5

automatic startup/shutdown

on Windows NT and UNIX, 1-7

auto-starting

Oracle Services, 7-9

---

B

BACKGROUND_DUMP_DEST parameter, 6-16

using with trace files, 9-13

backslash (\), defined, xxix

backup

databases, 6-25

OCOPY file types, 11-4

stopping services to perform cold backups, 11-3

backup and recovery tools

OCOPY, 11-3

Recovery Manager (RMAN.EXE), 11-2

selecting, 11-2

third-party backup and recovery vendors, 11-3

block size, maximum, B-5

blocks per file, maximum, B-5

BUILD_DB.SQL script, 6-11, 6-17

location of, 6-4

BUILDALL.SQL script, 6-17

---

C

C:\>, defined, xxix

C:\ORACLE, defined, 3-17

C:\ORANT, defined, 3-17

CATALOG.SQL script, 6-21

location of, A-5

CATEXP.SQL script

location of, A-5

CATPROC.SQL script, 6-21

location of, A-5

CATREP.SQL, 5-23, 6-22

chart view, 9-4

Choose Start >, defined, xxix

CM

CmDiskFile registry value, C-13

CmHostName registry value, C-13

CmSrvrPath registry value, C-13

DefinedNodes registry value, C-13

ErrorLog registry value, C-13

MissCount registry value, C-13

PollInterval registry value, C-13

CMDLL registry value, C-12

CmHostName registry value, C-13

CmSrvrPath registry value, C-13

code conventions, used in this guide, xxix

cold backups, performing, 11-3

COMPATIBLE_NO_RECOVERY parameter, B-4

configuration files

TNSNAMES.ORA

ENCAPS.CFG, F-10

MASTER.CFG, F-8

configuration parameters

defined, C-2

LOCAL, E-5

NAMES.DIRECTORY_PATH, E-8

registry, C-1

SQLNET.AUTHENTICATION_SERVICES, E-7

TNS_ADMIN, E-5

USE_SHARED_SOCKET, E-6

configuration responsibilities

Oracle Audio Data, 5-3

Oracle interMedia Text, 5-5

Oracle Spatial, 5-9

Oracle Time Series, 5-11

Oracle Visual Information Retrieval, 5-13

configuration tasks

Advanced Replication support, 5-22

Oracle Spatial, 5-9

configuration tools

for integrating Oracle with Active Directory, 4-14

configuring

Authentication Adapters, E-6

External Naming, E-8

Named Pipes Protocol Adapter, E-9

NDS Authentication Adapter, E-7

CONNECT INTERNAL, 7-20

changing the INTERNAL password, 7-20

connecting without a password, 8-13, 8-50

from a remote machine, 7-20

password, 7-20

using, 7-11, 7-20, 7-24

connecting

External Naming, E-9

LOCAL parameter, E-5

to a database, 7-11, 7-24

with NDS Native Naming Adapter, E-8

Connecting to the database from a remote machine, 7-20

contact name, 4-5

contacting

Oracle Support Services, xv

Oracle Technical Publications, xv

control files

additional backslashes in r. 8.0.4, 6-3, 7-23

Control Panel

defined, 2-20

integration with Oracle8i database, 2-20, 7-3

starting, 2-17

CONTROL_FILES parameter, 6-16

copy modes, for OCOPY, 11-4

CORE_DUMP_DEST parameter, B-4

CPU_COUNT parameter, B-4

CREATE DATABASE command, 6-17

CREATE LIBRARY command, 12-8

CREATE USER command, 8-43

CRLOGDR

managing logical drives, D-14

reviewing disk layout, D-14

custom database

archiving mode, 7-23

---

D

data dictionary

Advanced Replication tables, 5-24

database administrator privileges

granting for a single database on a computer with Oracle Administration Assistant for Windows NT, 8-36, 8-37

granting for all databases on a computer with Oracle Administration Assistant for Windows NT, 8-18, 8-19

manually granting for all databases on a computer, 8-46

database backup and recovery tools

OCOPY, 11-3

Recovery Manager (RMAN), 11-2

third-party vendors, 11-3

database files

deleting, 6-13

database monitoring

using Performance Monitor, 9-2

with alert files, 9-13

with Event Viewer, 9-9

with trace files, 9-13

database operator privileges

granting for a single database on a computer with Oracle Administration Assistant for Windows NT, 8-36, 8-38

granting for all databases on a computer with Oracle Administration Assistant for Windows NT, 8-18, 8-20

manually granting for all databases on a computer, 8-46

database privileges

in Windows NT local groups, 8-46, 8-50, 8-56, 8-58

database tools

operating system support, 2-2

starting, 2-8

databases

backing up, 6-25

BUILD_DB.SQL script, 6-11

BUILDALL.SQL, 6-17

changing passwords, 6-22

connecting to, 7-11, 7-24

creating, 6-1

deleting, 6-13

exporting, 6-12

file names, 3-17

importing, 6-22

maximum size possible, B-6

monitoring, 9-1, 9-2

naming conventions, 6-2

Optimal Flexible Architecture, 3-24, 3-26, 3-28

Oracle Database Configuration Assistant, 6-4

password encryption, 7-22

shutting down, 7-11, 7-12

starting, 7-11

DB_FILES parameter, 6-16

DB_NAME directory, explained, 3-23

DB_NAME parameter, 6-15

DB_WRITER_PROCESSES parameter, B-4

DBLINK_ENCRYPT_LOGIN parameter, 7-22

DBVERIFY

operating system compatibility, 2-4

starting, 2-11

Decision Support System. See DSS

dedicated server mode

disabling, 5-15

enabling, 5-15

DEFAULT_HOME parameter, C-9

DefinedNodes registry value, C-13

deleting

password file, 7-19

developing applications

for Windows NT, 12-2

DFS. See Distributed File System

diagnostic and tuning utilities

for Windows NT, 2-29

differences

between Windows NT and UNIX, 1-2

direct writes to disk

on Windows NT and UNIX, 1-4

directory names, convention used, xxix

directory server, 4-14

automatic discovery of directory servers, 4-6

configuration requirements, 8-10

creating security domains, 4-25

enhancement of directory object type descriptions, 4-8

enterprise user security feature, 4-4

features integrated with Oracle8i, 4-3

how Oracle directory objects display in Active Directory, 4-9

installation requirements, 8-10

installation tasks, 4-14

integration with Active Directory, 4-6

integration with Microsoft tools, 4-7

integration with Windows login credentials, 4-8

Net8 directory naming feature, 4-3

overview, 4-2

requirements for creating an Oracle Context in Active Directory, 4-11

requirements for creating an Oracle schema in Active Directory, 4-10

requirements for creating enterprise user security in Active Directory, 4-13

requirements for creating Net8 directory naming in Active Directory, 4-12

requirements for using Oracle with Active Directory, 4-10

user interface extensions, 4-7

directory structures

OFA-compliant directory tree, 3-19

Oracle8i Client, A-7

Oracle8i Enterprise Edition, A-2

disk definition, D-3

disk layout

reviewing, D-16

disks

striping, 3-30

DisplayName parameter, C-11, E-3

DLLs

differences on Windows NT and UNIX, 1-5

external routines, 12-7

DNS-style naming convention, 4-16

documentation conventions, used in this guide, xxix

---

E

ENCAPS.CFG file, F-10

encrypting, database passwords, 7-22

enterprise domains

different from Windows domains, 4-5

viewing in Active Directory, 4-9

enterprise roles

administering, 8-59

authorizing in Windows 2000 domains, 8-9

environments in which to use, 8-5

viewing in Active Directory, 4-9

enterprise user security

creation requirements, 4-13

defined, 4-4

enterprise users

administering, 8-59

environments in which to use, 8-5

viewing in Active Directory, 4-9

environment variables

ORACLE_HOME, 3-12

TNS_ADMIN, 3-14

error messages

Intercartridge Exchange, 12-15

logging, G-2

ORA-01102, 6-2

ORA-12547, G-19

OSD-04000 to OSD-04099, G-5

OSD-04100 to OSD-04199, G-10

OSD-04200 to OSD-04299, G-12

OSD-04300 to OSD-04399, G-16

OSD-04400 to OSD-04499, G-16

OSD-04500 to OSD-04599, G-17

ErrorLog registry value, C-13

Event Viewer, 9-9

34 ID, 9-11

auditing, 9-11

blue (informational) icon, 9-11

defined, 2-21

for monitoring a database, 9-2

IDs other than 34, 9-11

integration with Oracle8i database, 2-21

logging operating system audit trail, 2-22

managing, 9-13

overview, 2-21

reading, 9-11

red (stop sign) icon, 9-11

starting, 2-17

using, 9-9

yellow (exclamation point) icon, 9-11

exception conditions, Intercartridge Exchange, 12-14

EXECUTE privileges, on a PL/SQL library, 12-8

Export Utility

databases, 6-12

interactive mode, 6-12

operating system compatibility, 2-4

parameter mode, 6-12

redirecting output, G-2

starting, 2-11

extended partition

creating, D-7

defined, D-2

extents

maximum number per database, B-6

EXTERNAL clause, 12-8

External Naming, E-8

client configuration, E-9

connecting with SQL*Plus, E-9

NDS Native Naming Adapter, E-8

using, E-8

external OS roles

defined, 8-22

external roles

administering, 8-14

administering manually on Windows NT, 8-39

administering with Oracle Administration Assistant for Windows NT, 8-14

authorizing, 8-7

creating with Oracle Administration Assistant for Windows NT, 8-32

defined, 8-22

environments in which to use, 8-5

role authorization, 8-7

external routines

building a DLL, 12-7

creating a PL/SQL library, 12-8

EXTERNAL clause, 12-8

granting EXECUTE privileges, 12-8

registering with Oracle database, 12-7

using EXTPROC, 12-6

writing, 12-6

external users

administering, 8-14

administering manually on Windows NT, 8-39

administering with Oracle Administration Assistant for Windows NT, 8-14

authenticating, 8-6

creating manually, 8-40

creating with Oracle Administration Assistant for Windows NT, 8-26

creating without a domain name prefix, 8-7

environments in which to use, 8-5

user authentication, 8-6

EXTPROC

responsibilities, 12-6

---

F

file names

convention used, xxix

normalizing when using Recovery Manager, 11-2

file sizes

maximum possible, B-5

on Windows NT and UNIX, 1-4

files

alert, 9-13

database file names, 3-17

LISTENER.ORA, 12-5

maximum number per database, B-5

maximum size possible, B-5

ORACLE.KEY, 3-12

sample INIT.ORA, B-3

trace, 9-13

---

G

generic documentation references

calculating index size, B-5

CREATE DATABASE, 6-17

custom database archiving mode, 7-23

install test databases in a separate Oracle home, 3-3

location of initialization parameter file, B-2

LOG parameter use, G-2

managing the Event Viewer, 9-13

maximum number of data files, 6-16

PL/SQL sample programs, location of, A-5

running CATPROC.SQL, 6-21

starter database archiving mode, 7-23

Windows NT-specific archiving procedures, 7-25

Windows NT-specific audit trail availability, 9-11

Windows NT-specific audit trail facility, 9-11

Windows NT-specific authentication methods, 8-2

Windows NT-specific automatic database startup after reboot, 7-9

Windows NT-specific control file specifications, 6-14

Windows NT-specific database creation procedures, 6-4

Windows NT-specific error messages, G-2

Windows NT-specific initialization parameter file, B-2

Windows NT-specific instance startup file names, 7-11

Windows NT-specific local groups use, 8-46

Windows NT-specific location of SQL scripts, A-5

Windows NT-specific Oracle Enterprise Manager startup, 2-13

Windows NT-specific OS_AUTHENT_PREFIX case insensitivity, 8-41

Windows NT-specific parameter file name and location, B-2

Windows NT-specific password file name and location, 7-16

Windows NT-specific role syntax, 8-58

Windows NT-specific trace file names, 9-13

global groups, 8-9

GRANT EXECUTE ON command, 5-24

---

H

HI_SHARED_MEMORY_ADDRESS parameter, B-4

HOME_COUNTER parameter, C-9

HOMEID, defined, xxxi

Hostname parameter, 9-3, C-10

hostname value, 9-3

hybrid database environment

creating, 6-7

---

I

ICX. See Intercartridge Exchange

ImagePath parameter, C-11, E-3

Import Utility

databases, 6-22

interactive mode, 6-22

operating system compatibility, 2-4

parameter mode, 6-22

starting, 2-12

index size, calculating, B-5

initialization parameter file

defined, B-2

editing, B-2

location, B-2

modifying, 6-14

using PFILE option for database startup, 7-11

using the default file for database startup, 7-11

initialization parameter requirements

Advanced Replication Support, 5-21

initialization parameters

COMPATIBLE_NO_RECOVERY, B-4

CORE_DUMP_DEST, B-4

CPU_COUNT, B-4

DB_WRITER_PROCESSES, B-4

HI_SHARED_MEMORY_ADDRESS, B-4

LARGE_POOL_SIZE, B-4

LOG_BUFFER, B-4

on Windows NT and UNIX, 1-4

ORACLE_TRACE_COLLECTION_PATH, B-4

ORACLE_TRACE_FACILITY_NAME, B-4

ORACLE_TRACE_FACILITY_PATH, B-4

OS_AUTHENT_PREFIX, 8-41

OS_ROLES, 8-4, 8-9, 8-25, 8-54

SHARED_MEMORY_ADDRESS, B-4

SPIN_COUNT, B-4

INST_LOC parameter, C-8

install accounts

on Windows NT and UNIX, 1-5

installation

differences on Windows NT and UNIX, 1-5

INSTANCE_NAME parameter, 6-15

instances

creating, 6-27

defined, 7-4

modifying, 6-29

running multiple instances, 7-15

starting, 6-28

stopping, 6-28

interactive mode

Export Utility, 6-12

Import Utility, 6-22

Intercartridge Exchange

accessing Web data, 12-10

configuring, 12-11

error messages, 12-15

exception conditions, 12-14

packaged functions, 12-12

stored packages, 12-12

troubleshooting, 12-17

using, 12-12

INTERNAL

changing the INTERNAL password, 7-20

connecting as, 7-20

connecting without a password, 8-13, 8-50

password, 7-20

IODLL registry value, C-12

IPCDLL registry value, C-12

italic letters, defined, xxix

---

K

Kerberos, 8-9

default use of, 8-3

features, 8-2

---

L

LARGE_POOL_SIZE parameter, B-4

LAST_HOME parameter, C-9

LDAP

overview, 4-2

Legato Storage Manager

adding BIN directory to PATH, 11-7

Japanese version, 11-7

settings for multiple tape devices, 11-7

Lightweight Directory Access Protocol. See LDAP

listener

1521 port, E-11

1526 port, E-11

OracleHOME_NAMETNSListener service, 7-5

OracleHOME_NAMETNSListenerLSNR service, 7-5

local database role

creating with Oracle Administration Assistant for Windows NT, 8-30

local groups

with database privileges, 8-46, 8-50, 8-56, 8-58

LOCAL parameter, E-5

local roles

defined, 8-22

LOG parameter

use of, G-2

log view, 9-5

LOG_ARCHIVE_DEST_n parameter, 6-3, 7-23, 7-25

LOG_ARCHIVE_FORMAT parameter, 7-25

LOG_ARCHIVE_START parameter, 7-25

LOG_BUFFER parameter, B-4

LOGFILE parameter, C-11

logging error messages, G-2

logical partitions

assigning symbolic links, D-11

creating, D-9

LSNRCTL utility

starting from the Control Panel, F-6, F-8

---

M

mapped drives, 6-3, 7-23

memory resources

on Windows NT and UNIX, 1-4

Microsoft Management Console

defined, 2-27

integration with Oracle8i database, 2-27

requirements, 8-15

running Oracle Administration Assistant for Windows NT from, 8-15

Microsoft SNMP, F-3

Migration Utility

operating system compatibility, 2-4

starting, 2-12

MissCount registry value, C-13

monitoring

alert files, 9-2

databases, 9-1

Event Viewer, 9-2

Management Pack, 9-2

Oracle events, 2-21, 2-23

Oracle8i Objects, 9-5

Performance Monitor, 9-2

trace files, 9-2

MSHELP_TOOLS parameter, C-5

multiple instances, running, 7-15

multiple Oracle home products, 3-7

multiple Oracle homes

ALL_HOMES registry subkey, C-8

before release 8.0.4, 3-3

benefits, 3-3

classification of products, 3-7

defined, xxx

environment, 3-5

for releases 8.0.4 to 8.0.5, 3-3

for releases 8.1.3 and 8.1.4, 3-3

functionality in different releases, 3-3

introduction, 3-2

on Windows NT and UNIX, 1-6

overview, 3-2

program groups, 3-5, 3-6

registry entries, 3-5, 3-6

service names, 3-5, 3-6

service naming conventions, 7-2, 7-4, 7-5

system identifier, 3-5, 3-6

use of one listener for spawning, 3-4

multi-threaded server

configuring with Oracle Database Configuration Assistant, 5-15

disabling, 5-15

enabling, 5-15

---

N

NAME parameter, C-8

Named Pipes Protocol Adapter

with an Oracle Names Server, E-9

NAMES.DIRECTORY_PATH parameter, E-8

naming conventions for multiple Oracle homes, 7-2

naming method

External Naming, E-8

NDS Authentication Adapter

client configuration, E-7

NetWare Server configuration, E-7

using, E-7

NDS Native Naming Adapter

establishing connections with, E-8

using, E-8

NET START command, 6-20

Net8

configuring for external routines, 12-5

unsupported features, E-2

Net8 Assistant

creating and modifying net service name objects in a directory server, 4-15

included with Oracle8i Client, 4-12, 4-13

operating system compatibility, 2-5

starting, 2-10

Net8 Configuration Assistant

automatically discovering directory server information, 4-9

configuring client access to a directory server, 4-15

configuring Oracle software with a directory server, 4-6, 4-8

creating the Oracle Context, 4-11, 4-14

creating the Oracle schema, 4-10, 4-14

included with Oracle8i Client, 4-12, 4-13

operating system compatibility, 2-5

running, 4-15

setting up Access Control List security, 4-15

starting, 2-10

Net8 directory naming

connecting to a database through a directory server, 4-16

creation requirements, 4-12

defined, 4-3

testing connectivity from client computers, 4-17

testing connectivity with Microsoft tools, 4-17

NET8 parameter, E-2

NLS_LANG parameter, C-5

NOARCHIVELOG mode, 7-24

non-multiple Oracle home products, 3-8

non-Oracle home products, 3-8

nonprivileged database user

creating manually, 8-40

creating with Oracle Administration Assistant for Windows NT, 8-26

NTLM, 8-9

default use of, 8-3

features, 8-2

---

O

ObjectName parameter, C-11, E-3

OCOPY

backup file types, 11-4

capabilities, 11-3

copy modes, 11-4

operating system compatibility, 2-4

recovery file types, 11-6

starting, 2-12

syntax for backing up files, 11-5

syntax for recovering files, 11-6

OFA. See Optimal Flexible Architecture

OLTP

database environment, 6-7

importing a sample schema, 6-8

Online Transaction Processing. See OLTP

OO4O parameter, C-8

operating system authentication

automatically enabling during installation, 8-13

connecting as INTERNAL without a password, 8-13, 8-50

creating an authenticated user

creating, 8-43

setting OS_AUTHENT_PREFIX, 8-41

setting OSAUTH_PREFIX_DOMAIN, 8-41

operating systems

audit trail, 2-22

authentication overview, 8-2

OPERF.LOG file, 9-9

viewing Performance Monitor status, 9-9

OPERFCFG

starting, 2-12

syntax examples, C-21

OPS$, 8-41

OPSM

registry entries, C-14

Optimal Flexible Architecture

benefits, 3-15

characteristics of a database, 3-16

default OFA database, 3-24

differences since previous releases, 3-17

introduction, 3-2

non-default OFA database 1, 3-26

non-default OFA database 2, 3-28

NT and UNIX differences, 3-31

OFA-compliant directory tree, 3-19

Oracle Parallel Server option, 3-20

overview, 3-14

ORA_AFFINITY parameter, C-6

ORA_CWD parameter, C-5

ORA_DBA local group

adding users to, 8-13, 8-46

ORA_ENCRYPT_LOGIN parameter, 7-22

ORA_OPER local group

adding users to, 8-46

ORA_SHUTDOWN parameter, 7-13

ORA_SID_AUTOSTART parameter, 7-13, C-5

ORA_SID_DBA local group

adding users to, 8-46

ORA_SID_OPER local group

adding users to, 8-46

ORA_SID_PFILE parameter, 7-13, C-5

ORA_SID_SHUTDOWN parameter, 7-13, C-5

ORA_SID_SHUTDOWN_TIMEOUT parameter, 7-14, C-5

ORA_SID_SHUTDOWNTYPE parameter, 7-14, C-5

ORA-00256 error, 6-3, 7-23

ORA-09291 error, 6-3, 7-23

ORA-12547 error, G-19

Oracle Administration Assistant for Windows NT

adding a computer to the navigation tree, 8-16

connecting to a database, 8-21

creating a local database role, 8-30

creating a nonprivileged database user, 8-26

creating an external role, 8-32

granting administrator privileges for a single database on a computer, 8-37

granting administrator privileges for all databases on a computer, 8-19

granting operator privileges for a single database on a computer, 8-38

granting operator privileges for all databases on a computer, 8-20

managing Oracle 7.x and Oracle 8.0.x computers, 8-15

managing remote computers, 8-15

saving a navigation tree configuration, 8-16

setting the OS_AUTHENT_PREFIX parameter, 8-24

setting the OS_ROLES parameter, 8-25

starting, 2-10

troubleshooting database connection issues, 8-23

using, 8-14, C-19, C-22

using the Oracle Home Configuration snap-in, C-19

using the Performance Monitoring snap-in, C-22

viewing database authentication parameter settings, 8-24

Oracle Advanced Security

operating system compatibility, 2-5

Oracle Audio Data

configuration responsibilities, 5-3

Oracle Connection Manager

1610 port, E-11

1620 port, E-11

OracleHOME_NAMECManService service, 7-5

Oracle Context

creating with Net8 Configuration Assistant, 4-11

creation requirements, 4-11

defined, 4-9

Oracle Data Migration Assistant

starting, 2-10

Oracle database

creating for a multipurpose environment, 6-7

creating for a warehousing environment, 6-7

creating for an OLTP environment, 6-7

sample OLTP schema, 6-8

sample Warehousing schema, 6-8

Oracle Database Configuration Assistant

configuring cartridges, 6-9

creating a multipurpose database environment, 6-7

creating a warehousing database environment, 6-7

creating an OLTP database environment, 6-7

deleting databases, 6-10

importing a sample OLTP schema, 6-8

importing a sample Warehousing schema, 6-8

multi-threaded support, 6-10

registering a database object in a directory server, 4-8, 4-15

running, 4-15

starting, 2-10

Oracle Enterprise Login Assistant

starting, 2-11

Oracle Enterprise Manager

Backup Wizard, 11-2

Management Pack, 9-2

operating system compatibility, 2-4

running in a web browser, 2-15

single Oracle home product, 3-7

starting, 2-13

Oracle Enterprise Security Manager

creating enterprise users, roles, and domains, 4-15, 8-8, 8-9

creating security domains, 4-25

using, 8-11

using simple authentication, 8-12

using with Windows native authentication, 8-12

Oracle home

new-style, defined, 3-14

old-style, defined, 3-8

Oracle Home Configuration snap-in

using, C-19

Oracle Home Selector

changing PATH value, 3-10

Oracle interMedia Text

configuration responsibilities, 5-5

Oracle Migration Workbench

starting, 2-10

Oracle Names

1575 port, E-11

Named Pipes Protocol Adapter, E-9

OracleHOME_NAMEClientCache, 7-5

OracleHOME_NAMEClientCache service, 7-5

Oracle Objects for OLE

single Oracle home product, 3-7

Oracle Open Database Connectivity Driver

single Oracle home product, 3-7

Oracle Parallel Server option

Optimal Flexible Architecture, 3-20

single Oracle home product, 3-7

Oracle Performance Monitor

accessing, 9-4

alert view, 9-4

chart view, 9-4

for monitoring a database, 9-2

Hostname parameter, 9-3

log view, 9-5

monitoring Oracle8i Objects, 9-5

OPERF.LOG, 9-9

Oracle8i Buffer Cache, 9-7

Oracle8i Data Dictionary Cache, 9-7

Oracle8i Data Files, 9-7

Oracle8i Free List, 9-8

Oracle8i Library Cache, 9-7

Oracle8i Redo Log Buffer, 9-7

parameters, C-9, C-20

password, 9-3

registry information, 9-3

Report View, 9-5

single Oracle home product, 3-7

troubleshooting information, 9-9

username parameter, 9-3

using, 9-2

Oracle Performance Monitoring

using, C-22

Oracle schema

creating with Net8 Configuration Assistant, 4-10

creation requirements, 4-10

Oracle Services

auto-starting, 7-9

for Oracle8i database, 2-20

naming conventions for multiple Oracle homes, 7-2

OracleAgent, 7-5

OracleServiceSID, 7-4

OracleTNSListener, 7-4

OracleWebAssistant, 7-5

shutting down a database by stopping a service, 7-12

starting, 7-6

stopping, 7-7

viewing in the Control Panel, 2-20

Oracle SNMP Agent

configuring, F-4

Oracle SNMP Encapsulator

starting, F-6

Oracle SNMP Master Agent

starting, F-6

Oracle SNMP Master Agent and Encapsulator

controlling, F-6

Oracle Spatial

configuration responsibilities, 5-9

configuration tasks, 5-9

Oracle SQLJ Translator

directory structure, A-6

Oracle Time Series

configuration responsibilities, 5-11

Oracle Visual Information Retrieval

configuration responsibilities, 5-13

Oracle Wallet Manager

operating system compatibility, 2-5

starting, 2-10

Oracle Web Publishing Assistant

starting, 2-10

Oracle WebDB

starting, 2-11

ORACLE.KEY file, 3-12

ORACLE_BASE

changing the value, 3-20

explained, xxx, 3-17, 3-20

ORACLE_BASE parameter, C-6

ORACLE_GROUP_NAME parameter, C-6

ORACLE_HOME

directory structure, A-2

explained, xxx

ORACLE_HOME directory

explained, 3-21

specifying, 3-23

ORACLE_HOME environment variable

consequences of setting, 3-13

how it is set, 3-12

ORACLE_HOME parameter, C-6

ORACLE_HOME_KEY parameter, C-6

ORACLE_HOME_NAME parameter, C-6

ORACLE_PRIORITY parameter, C-7

ORACLE_SID parameter, 6-23, 7-4, 7-15, C-7

ORACLE_TRACE_COLLECTION_PATH parameter, B-4

ORACLE_TRACE_FACILITY_NAME parameter, B-4

ORACLE_TRACE_FACILITY_PATH parameter, B-4

Oracle8i Buffer Cache, 9-7

Oracle8i Client

directory structure, A-7

Oracle8i Data Dictionary Cache, 9-7

Oracle8i Data Files object, 9-7

Oracle8i database

available Oracle Services, 2-20

connecting to, 7-11, 7-24

password encryption, 7-22

selecting a backup and recovery tool, 11-2

shutting down, 7-11, 7-12

shutting down a database with a service, 7-13

specifications, B-5

starting, 7-11

using Control Panel, 2-20

using Event Viewer, 2-21

using Microsoft Management Console, 2-27

using Performance Monitor, 2-23

using User Manager, 2-26

Oracle8i database backup and recovery tools

OCOPY, 11-3

Recovery Manager (RMAN.EXE), 11-2

third-party vendors, 11-3

Oracle8i Enterprise Edition

directory structure, A-2

Oracle8i Free List, 9-8

Oracle8i Library Cache, 9-7

Oracle8i Objects, monitoring, 9-5

Oracle8i Redo Log Buffer, 9-7

Oracle8i Sorts, 9-8

OracleAgent, defined, 7-5

OracleDBCreator security group

defined, 4-20

OracleDBSecurityAdmin security group

defined, 4-20

OracleDefaultDomain

directory server security domain, 4-25

OracleHOME_NAMEClientCache key, E-3

OracleHOME_NAMEClientCache service, 7-5

OracleHOME_NAMECMAdminService key, E-3

OracleHOME_NAMECManService key, E-3

OracleHOME_NAMECManService service, 7-5

OracleHOME_NAMETNSListener key, E-3

OracleHOME_NAMETNSListener service, 7-5, E-10

OracleHOME_NAMETNSListenerLSNR service, 7-5

OracleNetAdmins security group

defined, 4-20

OracleServiceSID, 7-4

starting the database, 7-12

stopping the database, 7-12

OracleSNMPPeerMasterAgent

MASTER.CFG file, F-8

OracleTNSListener

defined, 7-4

OracleWebAssistant service, defined, 7-5

ORADATA directory, explained, 3-22

ORADEBUG

debugging utility, 7-26

starting, 7-26

ORADIM

changing the INTERNAL password, 7-20

creating an instance, 6-27

modifying an instance, 6-29

moving or copying password files, 7-18

operating system compatibility, 2-5

starting, 2-12

starting an instance, 6-28

stopping an instance, 6-28

ORAPWD

creating password files, 7-16

operating system compatibility, 2-5

starting, 2-12

OS database administrators

defined, 8-22

OS database operators

defined, 8-22

OS_AUTHENT_PREFIX parameter, 8-24, 8-40, 8-41

OS_ROLES parameter, 8-25

not required in Windows 2000 domains, 8-9

using with external roles, 8-4, 8-25, 8-54

OSAUTH_PREFIX_DOMAIN parameter, 8-7, 8-15, 8-41, 8-42, 8-49

OSAUTH_X509_NAME parameter, 8-8, 8-10

OSD-04000 to OSD-04099 error codes, G-5

OSD-04018 error, 6-3, 7-23

OSD-04100 to OSD-04199 error codes, G-10, G-12

OSD-04300 to OSD-04399 error codes, G-16

OSD-04400 to OSD-04499 error codes, G-16

OSD-04500 to OSD-04599 error codes, G-17

OWAST parameter, C-7

OWAST_HOME parameter, C-7

OWASTDBS parameter, C-7

---

P

packaged functions

Intercartridge Exchange, 12-12

UTL_HTTP.REQUEST, 12-13

UTL_HTTP.REQUEST_PIECES, 12-13

parameter mode

Export Utility, 6-12

Import Utility, 6-22

PARFILE, using, G-2

partition

extended, D-2

logical partition, D-5

physical disk, D-4

raw, 3-31, D-2

password file

authenticating database administrators, 7-16

connecting as INTERNAL, 7-20

creating, 7-16

deleting, 7-19

hiding, 7-17

viewing, 7-18

Password parameter, C-10

passwords

changing for SYS user name, 7-21

changing for SYSTEM user name, 7-21

changing the INTERNAL password, 7-20

connecting without a password with INTERNAL, 8-13, 8-50

encryption, 7-22

for databases, 6-22

for INTERNAL user name, 7-20

PATH parameter, C-8

PATH, changing the value of, 3-9

PERF_FILE_NAME parameter, C-11

Performance, C-14

PERFORMANCE key, C-9

Performance Monitor, 9-2

defined, 2-23

integration with Oracle8i database, 2-23

monitoring specific Oracle events, 2-23

starting, 2-17

viewing OPERF.LOG file status, 9-9

Performance Pack, monitoring a database, 9-2

performance utilities

on Windows NT and UNIX, 1-7

performance, increasing, 3-30

PFILE option, 7-11

PhysicalDrive, D-4

PL/SQL

sample programs, location of, A-5

PMDLL registry value, C-12

PollInterval registry value, C-13

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 12-14

Pre-SPAWNED dedicated server processes

Net8 unsupported feature, E-2

privileges

in Windows NT local groups, 8-46, 8-50, 8-56, 8-58

Process Explode, 2-29

Process Viewer, 2-29

processes

on Windows NT and UNIX, 1-3

products

multiple Oracle home products, 3-7

non-multiple Oracle home products, 3-8

single Oracle home products, 3-7

supporting multiple Oracle homes, 3-7

program groups

multiple Oracle homes, 3-5, 3-6

PWDSID.ORA file, 7-16

---

Q

QuickSlice, 2-29

---

R

RAID (Redundant Array of Inexpensive Disks), 3-32

RAID configuration, 3-30

raw partition

defined, 3-31, D-2

logical partition, D-5

on Windows NT and UNIX, 1-9

overview, D-2

physical disk, D-4

RDBMS_ARCHIVE parameter, C-7

RDBMS_CONTROL parameter, C-7

recovering, an Oracle8i database, 11-2

recovery file types, OCOPY, 11-6

Recovery Manager

capabilities, 11-2

operating system compatibility, 2-5

overview, 11-2

starting, 2-13

redo log files

archiving, 7-23

REG_MULTI_SZ, C-14

REGEDT32 command, 6-23

registering, an external routine, 12-7

registry

adding parameters, C-17

ALL_HOMES subkey, C-8

CmDiskFile, C-13

CMDLL, C-12

CmHostName, C-13

CmSrvrPath, C-13

configuration parameters, C-1

DEFAULT_HOME, C-9

DefinedNodes, C-13

DisplayName, C-11, E-3

entries for CM, C-13

entries for OPSM, C-14

ErrorLog, C-13

HOME_COUNTER, C-9

Hostname, 9-3, C-10

ImagePath, C-11, E-3

INST_LOC, C-8

IODLL, C-12

IPCDLL, C-12

keys, C-2

LAST_HOME, C-9

LOGFILE, C-11

MissCount, C-13

modifying values, C-15

MSHELP_TOOLS, C-5

NAME, C-8

NET8 parameter, E-2

NLS_LANG, C-5

ObjectName, C-11, E-3

OO4O, C-8

ORA_AFFINITY, C-6

ORA_CWD, C-5

ORA_SHUTDOWN, 7-13

ORA_SID_AUTOSTART, 7-13, C-5

ORA_SID_PFILE, 7-13, C-5

ORA_SID_SHUTDOWN, 7-13, C-5

ORA_SID_SHUTDOWN_TIMEOUT, 7-14, C-5

ORA_SID_SHUTDOWNTYPE, 7-14, C-5

ORACLE_BASE, C-6

ORACLE_GROUP_NAME, C-6

ORACLE_HOME, C-6

ORACLE_HOME_KEY, C-6

ORACLE_HOME_NAME, C-6

ORACLE_PRIORITY, C-7

ORACLE_SID, C-7

OracleHOME_NAMEClientCache key, E-3

OracleHOME_NAMECMAdminService key, E-3

OracleHOME_NAMECManService key, E-3

OracleHOME_NAMETNSListener key, E-3

OWAST, C-7

OWAST_HOME, C-7

OWASTDBS, C-7

parameter values, C-2

Password, C-10

password value, 9-3

PATH, C-8

PERF_FILE_NAME, C-11

PERFORMANCE key, C-9

PMDLL, C-12

PollInterval, C-13

RDBMS_ARCHIVE, C-7

RDBMS_CONTROL, C-7

REG_DWORD, C-3, C-18

REG_EXPAND_SZ, C-3, C-18

REG_MULTI_SZ, C-3, C-18

REG_SZ, C-3, C-18

REGEDT32, C-15, C-17

STARTDLL, C-12

starting, 2-17

update ORACLE_SID, 6-23

Username, 9-3, C-10

using OPERFCFG, C-21

Registry Editor, C-2

registry entries

multiple Oracle homes, 3-5, 3-6

reliability, increasing, 3-30

remote computers

managing with Oracle Administration Assistant for Windows NT, 8-15

remote computers, accessing database files, 7-22

REMOTE_LOGIN_PASSWORDFILE parameter, 7-17, 7-20

replication, configuration tasks, 5-22

Report View, 9-5

requirements

for creating an Oracle Context in Active Directory, 4-11

for creating an Oracle schema in Active Directory, 4-10

for creating enterprise user security in Active Directory, 4-13

for creating Net8 directory naming in Active Directory, 4-12

for using Oracle with Active Directory, 4-10

resources, xv

role authorization

description, 8-4

in Windows 2000 domains, 8-9

of external roles, 8-7

roles

authorization method enhancements, 8-4

authorized in Windows 2000 domains, 8-9

authorizing, 8-7

creating a local database role with Oracle Administration Assistant for Windows NT, 8-30

creating an external role with Oracle Administration Assistant for Windows NT, 8-32

when to use enterprise roles, 8-5

when to use external roles, 8-5

---

S

schemas

importing an OLTP sample schema, 6-8

importing an Warehousing sample schema, 6-8

scripts

location of, A-5

security groups

accessing, 4-21

adding or removing users, 4-23

changing user permissions, 4-24

SELECT * FROM ALL_OBJECTS query, 5-23

Server Manager

running multiple instances, 7-16

shutting down the database, 7-11

starting, 7-11

starting the database, 7-11

using ORADEBUG, 7-26

service

how to start and stop, E-11

listed, E-11

service names

multiple Oracle homes, 3-5, 3-6

SERVICE_NAME parameter, 6-15

services, 7-2

auto-starting, 7-9

available with Oracle8i database, 2-20

on Windows NT and daemons on UNIX, 1-2

OracleAgent, 7-5

OracleServiceSID, 7-4

OracleTNSListener, 7-4

OracleWebAssistant, 7-5

shutting down a database by stopping a service, 7-12

starting, 6-16, 7-6

stopping, 7-7

viewing in the Control Panel, 2-20

SET INSTANCE command, 8-49, 8-53, 8-59

SET ORACLE_SID=SID, 7-16

SETLINKS utility, D-11

create symbolic links, D-11, D-13

ignoring links, D-12

removing links, D-12

shadow process memory, B-6

shared server mode, 5-16

SHARED_MEMORY_ADDRESS parameter, B-4

SHUTDOWN command

options, 7-12

using, 7-12

shutting down

databases, 7-11, 7-12

SID. See system identifier

simple authentication

using with Oracle Enterprise Security Manager, 8-12

single log on

for accessing servers and databases, E-8

single Oracle home products, 3-7

Single Sign-On connections, 4-4

snap-ins

Oracle Home Configuration, C-19

Oracle Performance Monitoring, C-22

SNMP

description of support for Oracle products, F-2

in a TCIP/IP network, F-2

managed elements, F-2

management framework, F-2

management station, F-2

master agent, F-2

Oracle SNMPPeerMasterAgent, F-3

OracleSNMPPeerEncapsulator, F-3

subagents, F-2

SPAWN

Net8 unsupported feature, E-2

specifying an archiving file format, 7-25

SPIN_COUNT parameter, B-4

SPOOL command, using, 5-23, 5-24

SQL scripts

location of, A-5

SQL*Loader

control file conventions, 2-19

direct path option, 2-19

operating system compatibility, 2-5

starting, 2-13

using, 2-17

SQL*Plus

connecting to a database through Active Directory, 4-7, 4-19

operating system compatibility, 2-3

starting, 2-13

SQLNET.AUTHENTICATION_SERVICES parameter, E-7

SQLNET.ORA file

location of, 8-2, 8-42, 8-44, 8-49, 8-51, 8-53, 8-54, 8-58

setting to enable Windows native authentication, 8-2, 8-42, 8-44, 8-49, 8-51, 8-53, 8-54, 8-58

square brackets, defined, xxix

STARTDLL registry value, C-12

starter database

archiving mode, 7-23

starting

databases, 7-11

Oracle Performance Monitor, 9-4

Oracle Services, 7-6

Server Manager, 7-11

STARTUP command, 7-11

stopping, Oracle Services, 7-7

stored packages, Intercartridge Exchange, 12-12

striping disks, 3-30

symbolic links, 3-32

creating, D-11, D-13

ignoring, D-12

removing, D-12

symbols, list of, xxxi

syntax

for backing up files with OCOPY, 11-5

for recovering files with OCOPY, 11-6

SYS user name

changing the password, 7-21

SYSDBA privileges

connecting based on your NT local group, 8-49

granting for a single database on a computer with Oracle Administration Assistant for Windows NT, 8-36, 8-37

granting for all databases on a computer with Oracle Administration Assistant for Windows NT, 8-18, 8-19

manually granting for all databases on a computer, 8-46

mapping to a local group, 8-46

SYSOPER privileges

connecting based on your NT local group, 8-49

granting for a single database on a computer with Oracle Administration Assistant for Windows NT, 8-36, 8-38

granting for all databases on a computer with Oracle Administration Assistant for Windows NT, 8-18, 8-20

manually granting for all databases on a computer, 8-46

mapping to a local group, 8-46

system identifier

defined, 7-4

multiple Oracle homes, 3-5, 3-6

SYSTEM user name

changing the password, 7-21

---

T

tablespaces

Advanced Replication support, 5-21, 5-24

Task List, 2-29

Task Manager

starting, 2-18

using, 2-28

third-party backup and recovery vendors, 11-3

threads

on Windows NT and UNIX, 1-3

TKPROF

operating system compatibility, 2-5

starting, 2-13

TNS_ADMIN parameter, E-5

setting in the environment, 3-14

TNSNAMES.ORA file, 12-5

overview, F-8, F-10

top-level directory, explained, 3-17

trace files, 9-13

creating with ORADEBUG, 7-26

for monitoring a database, 9-2

using, 9-13

using BACKGROUND_DUMP_DEST parameter, 9-13

using USER_DUMP_DEST, 9-13

TRCROUTE

Net8 unsupported feature, E-2

troubleshooting

Intercartridge Exchange, 12-17

ORA-12547 error, G-19

ORA-28575 error, G-19

Oracle Administration Assistant for Windows NT connection issues, 8-23

TNS-12203 error, G-19

with ORADEBUG, 7-26

tuning Windows NT Server operating system, 10-2

---

U

UNC, 6-3, 7-22

universal groups, 8-9

Universal Naming Convention, 6-3, 7-22

UNIX

differences between UNIX and Windows NT, 1-2

Optimal Flexible Architecture, 3-31

unsupported features

Net8, E-2

USE_SHARED_SOCKET parameter, E-6

user authentication

description, 8-4

external users, 8-6

in Windows NT 4.0 domains, 8-6

of enterprise users, 8-8

of external users, 8-6

User Manager

defined, 2-26

integration with Oracle8i database, 2-26

starting, 2-18

USER_DUMP_DEST parameter, 6-16, 9-13

Username parameter, C-10

users

authentication enhancement methods, 8-4

when to use enterprise users, 8-5

when to use external users, 8-5

UTL_HTTP.REQUEST, Intercartridge Exchange, 12-13

UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 12-13

UTLXPLAN.SQL script

location of, A-5

---

V

variables, convention used, xxix

viewing

password file, 7-18

---

W

Warehousing

importing a sample schema, 6-8

warehousing database environment

creating, 6-7

web browser

running Oracle Enterprise Manager, 2-15

Web data, Intercartridge Exchange, 12-10

Windows 2000 domains

administering external users and roles with Oracle Administration Assistant for Windows NT, 8-14

required domains for Oracle clients and server to use directory server features, 4-10

role authorization, 8-9

setting the OSAUTH_X509_NAME parameter, 8-8

user authentication, 8-8

Windows authentication protocols

default protocol used, 8-3

with Windows 2000, 8-2

with Windows NT 4.0, 8-2

Windows Explorer

accessing directory server objects
, 4-17

integration with Oracle objects in Active Directory, 4-7

testing database connectivity from, 4-18

Windows native authentication

benefits, 8-2

enhancements, 8-4

installation of, 8-2

methods and use of, 8-2

overview, 8-2

role authorization enhancements, 8-4

setting the SQLNET.ORA file, 8-2, 8-42, 8-44, 8-49, 8-51, 8-53, 8-54, 8-58

user and role requirements, 8-4

user authentication enhancements, 8-4

using Kerberos, 8-9

using with Oracle Enterprise Security Manager, 8-12

Windows NT

diagnostic and tuning utilities, 2-29

directory structure for database, A-2

tools, 2-5

Windows NT 4.0 domains

administering external users and roles manually, 8-39

administering external users and roles with Oracle Administration Assistant for Windows NT, 8-14

basic features, 8-4

user authentication, 8-6

Windows NT local groups

with database privileges, 8-13, 8-46, 8-50, 8-56, 8-58

Windows NT tools

operating system compatibility, 2-5

Windows NT tuning

applying latest service packs, 10-13

closing unnecessary foreground applications, 10-20

configuring server to be an application server, 10-7

disable unnecessary services, 10-9

multiple striped volumes for sequential and random access, 10-19

overview, 10-2

reducing priority of foreground applications on sever, 10-6

removing unused network protocols, 10-10

resetting the network protocol bind order, 10-11

screen savers, 10-21

spanning server virtual memory paging file across physical volumes, 10-20

startup folder, 10-21

using hardware and operating system striping, 10-14

virtual DOS machines, 10-21

wizards

Oracle Enterprise Manager Backup Wizard, 11-2

---

X

X.500 naming convention, 4-16

XAVIEW.SQL script

location of, A-5