Index

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

---

Symbols

"", SQL*Loader parameter, 2-16

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

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

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

---

Numerics

1521 port, C-10

1526 port, C-10

1575 port, C-10

1610 port, C-10

1620 port, C-10

---

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

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

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

application development

finding information, 6-2

audit trail

operating system, 2-19

Authentication Adapters

using, C-5

automatic startup/shutdown

on Windows NT and UNIX, 1-7

---

B

backslash (\), defined, xxii

---

C

C:\>, defined, xxii

C:\ORACLE, defined, 3-17

C:\ORANT, defined, 3-17

Choose Start >, defined, xxii

code conventions, used in this guide, xxii

configuration parameters

defined, B-2

LOCAL, C-4

NAMES.DIRECTORY_PATH, C-7

registry, B-1

SQLNET.AUTHENTICATION_SERVICES, C-6

TNS_ADMIN, C-4

USE_SHARED_SOCKET, C-5

configuration responsibilities

Oracle Audio Data, 5-3

Oracle interMedia Text, 5-5

Oracle Visual Information Retrieval, 5-9

configuration tools

for integrating Oracle with Active Directory,
4-14

configuring

Authentication Adapters, C-5

External Naming, C-7

Named Pipes Protocol Adapter, C-8

NDS Authentication Adapter, C-6

connecting

External Naming, C-8

LOCAL parameter, C-4

with NDS Native Naming Adapter, C-7

contact name, 4-5

contacting

Oracle Support Services, ix

Oracle Technical Publications, ix

Control Panel

defined, 2-17

integration with Oracle8i database, 2-17

starting, 2-15

CREATE LIBRARY command, 6-8

---

D

database tools

operating system support, 2-2

starting, 2-7

databases

file names, 3-17

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

DB_NAME directory, explained, 3-23

DEFAULT_HOME parameter, B-9

developing applications

for Windows NT, 6-2

DFS. See Distributed File System

diagnostic and tuning utilities

for Windows NT, 2-22

differences

between Windows NT and UNIX, 1-2

direct writes to disk

on Windows NT and UNIX, 1-4

directory names, convention used, xxii

directory server, 4-14

automatic discovery of directory servers, 4-6

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 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-2

disks

striping, 3-30

DisplayName parameter, B-9, C-3

DLLs

differences on Windows NT and UNIX, 1-5

external routines, 6-7

DNS-style naming convention, 4-16

documentation conventions, used in this guide, xxii

---

E

enterprise domains

different from Windows domains, 4-5

viewing in Active Directory, 4-9

enterprise roles

viewing in Active Directory, 4-9

enterprise user security

creation requirements, 4-13

defined, 4-4

enterprise users

viewing in Active Directory, 4-9

environment variables

ORACLE_HOME, 3-12

TNS_ADMIN, 3-14

error messages

Intercartridge Exchange, 6-15

logging, D-2

ORA-12547, D-19

OSD-04000 to OSD-04099, D-5

OSD-04100 to OSD-04199, D-10

OSD-04200 to OSD-04299, D-12

OSD-04300 to OSD-04399, D-16

OSD-04400 to OSD-04499, D-16

OSD-04500 to OSD-04599, D-17

Event Viewer

defined, 2-18

integration with Oracle8i database, 2-18

logging operating system audit trail, 2-19

overview, 2-18

starting, 2-15

exception conditions, Intercartridge Exchange,
6-14

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

Export Utility

operating system compatibility, 2-4

redirecting output, D-2

starting, 2-10

EXTERNAL clause, 6-8

External Naming, C-7

client configuration, C-8

connecting with SQL*Plus, C-8

NDS Native Naming Adapter, C-7

using, C-7

external routines

building a DLL, 6-7

creating a PL/SQL library, 6-8

EXTERNAL clause, 6-8

granting EXECUTE privileges, 6-8

registering with Oracle database, 6-7

using EXTPROC, 6-6

writing, 6-6

EXTPROC

responsibilities, 6-6

---

F

file names

convention used, xxii

file sizes

on Windows NT and UNIX, 1-4

files

database file names, 3-17

LISTENER.ORA, 6-5

ORACLE.KEY, 3-12

---

G

generic documentation references

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

LOG parameter use, D-2

Windows NT-specific error messages, D-2

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

---

H

HOME_COUNTER parameter, B-9

HOMEID, defined, xxiv

---

I

ICX. See Intercartridge Exchange

ImagePath parameter, B-9, C-3

Import Utility

operating system compatibility, 2-4

starting, 2-10

initialization parameters

on Windows NT and UNIX, 1-4

INST_LOC parameter, B-8

install accounts

on Windows NT and UNIX, 1-5

installation

differences on Windows NT and UNIX, 1-5

Intercartridge Exchange

accessing Web data, 6-10

configuring, 6-11

error messages, 6-15

exception conditions, 6-14

packaged functions, 6-12

stored packages, 6-12

troubleshooting, 6-17

using, 6-12

italic letters, defined, xxii

---

L

LAST_HOME parameter, B-9

LDAP

overview, 4-2

Lightweight Directory Access Protocol. See LDAP

listener

1521 port, C-10

1526 port, C-10

LOCAL parameter, C-4

LOG parameter

use of, D-2

logging error messages, D-2

---

M

memory resources

on Windows NT and UNIX, 1-4

monitoring

Oracle events, 2-18

MSHELP_TOOLS parameter, B-5

multiple Oracle home products, 3-7

multiple Oracle homes

ALL_HOMES registry subkey, B-8

before release 8.0.4, 3-3

benefits, 3-3

classification of products, 3-7

defined, xxiii

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

system identifier, 3-5, 3-6

use of one listener for spawning, 3-4

---

N

NAME parameter, B-8

Named Pipes Protocol Adapter

with an Oracle Names Server, C-8

NAMES.DIRECTORY_PATH parameter, C-7

naming method

External Naming, C-7

NDS Authentication Adapter

client configuration, C-6

NetWare Server configuration, C-6

using, C-6

NDS Native Naming Adapter

establishing connections with, C-7

using, C-7

Net8

configuring for external routines, 6-5

unsupported features, C-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-4

starting, 2-9

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-4

running, 4-15

setting up Access Control List security, 4-15

starting, 2-9

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, C-2

NLS_LANG parameter, B-5

non-multiple Oracle home products, 3-8

non-Oracle home products, 3-8

---

O

ObjectName parameter, B-9, C-3

OFA. See Optimal Flexible Architecture

OO4O parameter, B-8

operating systems

audit trail, 2-19

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

ORA_CWD parameter, B-5

ORA_SID_AUTOSTART parameter, B-5

ORA_SID_PFILE parameter, B-5

ORA_SID_SHUTDOWN parameter, B-5

ORA_SID_SHUTDOWN_TIMEOUT parameter,
B-5

ORA_SID_SHUTDOWNTYPE parameter, B-5

ORA-12547 error, D-19

Oracle Advanced Security

operating system compatibility, 2-4

Oracle Audio Data

configuration responsibilities, 5-3

Oracle Connection Manager

1610 port, C-10

1620 port, C-10

Oracle Context

creating with Net8 Configuration Assistant,
4-11

creation requirements, 4-11

defined, 4-9

Oracle Database Configuration Assistant

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

running, 4-15

Oracle Enterprise Login Assistant

starting, 2-9

Oracle Enterprise Manager

operating system compatibility, 2-4

running in a web browser, 2-13

single Oracle home product, 3-7

starting, 2-11

Oracle Enterprise Security Manager

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

creating security domains, 4-25

Oracle home

new-style, defined, 3-14

old-style, defined, 3-8

Oracle Home Selector

changing PATH value, 3-10

Oracle interMedia Text

configuration responsibilities, 5-5

Oracle Migration Workbench

starting, 2-9

Oracle Names

1575 port, C-10

Named Pipes Protocol Adapter, C-8

Oracle Objects for OLE

single Oracle home product, 3-7

starting, 2-9

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

single Oracle home product, 3-7

Oracle Provider for OLE DB

starting, 2-9

Oracle schema

creating with Net8 Configuration Assistant,
4-10

creation requirements, 4-10

Oracle Services

for Oracle8i database, 2-17

viewing in the Control Panel, 2-17

Oracle Visual Information Retrieval

configuration responsibilities, 5-9

Oracle Wallet Manager

operating system compatibility, 2-4

starting, 2-9

Oracle Web Publishing Assistant

starting, 2-9

ORACLE.KEY file, 3-12

ORACLE_BASE

changing the value, 3-20

explained, xxiii, 3-17, 3-20

ORACLE_BASE parameter, B-6

ORACLE_GROUP_NAME parameter, B-6

ORACLE_HOME

explained, xxiii

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

ORACLE_HOME_KEY parameter, B-6

ORACLE_HOME_NAME parameter, B-6

ORACLE_PRIORITY parameter, B-7

ORACLE_SID parameter, B-7

Oracle8i Client

directory structure, A-2

Oracle8i database

available Oracle Services, 2-17

using Control Panel, 2-17

using Event Viewer, 2-18

using User Manager, 2-21

OracleDBCreator security group

defined, 4-20

OracleDBSecurityAdmin security group

defined, 4-20

OracleDefaultDomain

directory server security domain, 4-25

OracleHOME_NAMEClientCache key, C-3

OracleHOME_NAMECMAdminService key, C-3

OracleHOME_NAMECManService key, C-3

OracleHOME_NAMETNSListener key, C-3

OracleHOME_NAMETNSListener service, C-9

OracleNetAdmins security group

defined, 4-20

ORADATA directory, explained, 3-22

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

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

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

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

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

OWAST parameter, B-7

OWAST_HOME parameter, B-7

OWASTDBS parameter, B-7

---

P

packaged functions

Intercartridge Exchange, 6-12

UTL_HTTP.REQUEST, 6-13

UTL_HTTP.REQUEST_PIECES, 6-13

PARFILE, using, D-2

partition

raw, 3-31

PATH parameter, B-8

PATH, changing the value of, 3-9

Performance Monitor

starting, 2-15

performance utilities

on Windows NT and UNIX, 1-7

performance, increasing, 3-30

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 6-14

Pre-SPAWNED dedicated server processes

Net8 unsupported feature, C-2

Process Explode, 2-22

Process Viewer, 2-22

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

---

Q

QuickSlice, 2-22

---

R

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

RAID configuration, 3-30

raw partition

defined, 3-31

on Windows NT and UNIX, 1-9

RDBMS_ARCHIVE parameter, B-7

RDBMS_CONTROL parameter, B-7

Recovery Manager

operating system compatibility, 2-4

starting, 2-10

registering, an external routine, 6-7

registry

adding parameters, B-12

ALL_HOMES subkey, B-8

configuration parameters, B-1

DEFAULT_HOME, B-9

DisplayName, B-9, C-3

HOME_COUNTER, B-9

ImagePath, B-9, C-3

INST_LOC, B-8

keys, B-2

LAST_HOME, B-9

modifying values, B-10

MSHELP_TOOLS, B-5

NAME, B-8

NET8 parameter, C-2

NLS_LANG, B-5

ObjectName, B-9, C-3

OO4O, B-8

ORA_AFFINITY, B-6

ORA_CWD, B-5

ORA_SID_AUTOSTART, B-5

ORA_SID_PFILE, B-5

ORA_SID_SHUTDOWN, B-5

ORA_SID_SHUTDOWN_TIMEOUT, B-5

ORA_SID_SHUTDOWNTYPE, B-5

ORACLE_BASE, B-6

ORACLE_GROUP_NAME, B-6

ORACLE_HOME, B-6

ORACLE_HOME_KEY, B-6

ORACLE_HOME_NAME, B-6

ORACLE_PRIORITY, B-7

ORACLE_SID, B-7

OracleHOME_NAMEClientCache key, C-3

OracleHOME_NAMECMAdminService key,
C-3

OracleHOME_NAMECManService key, C-3

OracleHOME_NAMETNSListener key, C-3

OWAST, B-7

OWAST_HOME, B-7

OWASTDBS, B-7

parameter values, B-2

PATH, B-8

RDBMS_ARCHIVE, B-7

RDBMS_CONTROL, B-7

REG_DWORD, B-3, B-13

REG_EXPAND_SZ, B-3, B-13

REG_MULTI_SZ, B-3, B-13

REG_SZ, B-3, B-13

REGEDT32, B-10, B-12

starting, 2-15

Registry Editor, B-2

registry entries

multiple Oracle homes, 3-5, 3-6

reliability, increasing, 3-30

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

---

S

security groups

accessing, 4-21

adding or removing users, 4-23

changing user permissions, 4-24

service

how to start and stop, C-10

listed, C-10

service names

multiple Oracle homes, 3-5, 3-6

services

available with Oracle8i database, 2-17

on Windows NT and daemons on UNIX, 1-2

viewing in the Control Panel, 2-17

SID. See system identifier

single log on

for accessing servers and databases, C-7

single Oracle home products, 3-7

Single Sign-On connections, 4-4

SPAWN

Net8 unsupported feature, C-2

SQL*Loader

control file conventions, 2-17

direct path option, 2-16

operating system compatibility, 2-4

starting, 2-11

using, 2-15

SQL*Plus

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

operating system compatibility, 2-3

starting, 2-10

SQLNET.AUTHENTICATION_SERVICES parameter, C-6

square brackets, defined, xxii

stored packages, Intercartridge Exchange, 6-12

striping disks, 3-30

symbolic links, 3-32

symbols, list of, xxiv

system identifier

multiple Oracle homes, 3-5, 3-6

---

T

Task List, 2-22

Task Manager

starting, 2-15

threads

on Windows NT and UNIX, 1-3

TKPROF

operating system compatibility, 2-4

starting, 2-11

TNS_ADMIN parameter, C-4

setting in the environment, 3-14

TNSNAMES.ORA file, 6-5

top-level directory, explained, 3-17

TRCROUTE

Net8 unsupported feature, C-2

troubleshooting

Intercartridge Exchange, 6-17

ORA-12547 error, D-19

ORA-28575 error, D-19

TNS-12203 error, D-19

---

U

UNIX

differences between UNIX and Windows NT,
1-2

Optimal Flexible Architecture, 3-31

unsupported features

Net8, C-2

USE_SHARED_SOCKET parameter, C-5

User Manager

defined, 2-21

integration with Oracle8i database, 2-21

starting, 2-15

UTL_HTTP.REQUEST, Intercartridge Exchange,
6-13

UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 6-13

---

V

variables, convention used, xxii

---

W

web browser

running Oracle Enterprise Manager, 2-13

Web data, Intercartridge Exchange, 6-10

Windows

directory structure for database, A-2

Windows 2000 domains

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

Windows Explorer

accessing directory server objects, 4-17

integration with Oracle objects in Active Directory, 4-7

testing database connectivity from, 4-18

Windows NT

diagnostic and tuning utilities, 2-22

tools, 2-5

Windows NT tools

operating system compatibility, 2-5

---

X

X.500 naming convention, 4-16