Index

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

A

admin directory, explained, 3.8.3

Advanced Replication support

data dictionary tables, 6.6.3

initialization parameter requirements, 6.6.2

tablespace requirements, 6.6.1, 6.6.3

alert files

monitoring a database, 8.1

using, 8.4

ALTER DATABASE ARCHIVELOG command, 7.9.1

application development

and data access, 19.2

finding information, 19.1

architecture

thread-based, 1.1.1

ARCHIVELOG mode, 7.9.1

archiving mode

controlling, 7.9

custom database, 7.9

starter database, 7.9

archiving procedures, 7.9.2

for redo log files, 7.9

specifying an archive destination, 7.9.2

UNC not allowed, 7.8

audit trail

managing, 8.3.2

operating system, 4.4.1

AUDIT_FILE_DEST

parameter, 8.3.2, 17.4

authentication

automatically enabling during installation, 12.4

enhancements, 12.3

OSAUTH_PREFIX_DOMAIN parameter, 13.2.1.1

overview, 12.1

using a password file, 7.5

using Windows native methods, 12.1

viewing parameter settings, 13.1.6

when to use enterprise users, 12.3.1

when to use external users, 12.3.1

authentication protocols

default protocol used, 12.2

with Windows 2000, 12.2

with Windows NT 4.0, 12.2

authorization

when to use enterprise roles, 12.3.1

when to use external roles, 12.3.1

auto-starting

Oracle Services, 7.1.5

B

background processes

querying, 1.1.1

BACKGROUND_DUMP_DEST, 8.4

backup

control files, 18.3.1.21

databases, 5.4.10

OCOPY file types, 10.3

stopping services to perform cold backups, 10.2

backup and recovery tools

selecting, 10.1

Backup Wizard

preferred tools, 4.1.2

bad file

specifying, 4.3.3

block size

maximum, 17.7

blocks for each file, maximum, 17.7

C

cold backups, performing, 10.2

commands

ALTER DATABASE ARCHIVELOG, 7.9.1

ARCHIVE LOG LIST, 7.9.1

CREATE DATABASE, 5.4.6

NET START, 5.4.7

REGEDT32, 5.4.9

configuration parameters

defined, 18.1

LOCAL, C.3.1

registry, defined, 18.1

TNS_ADMIN, C.3.2

USE_SHARED_SOCKET, C.3.3

configuring

Named Pipes Protocol Adapter, C.4.2

Oracle Spatial, 6.4

Oracle Text, 6.3

CONNECT /AS SYSDBA

connecting without a password, 12.4

using, 7.2

CONNECT INTERNAL

replacement, 4.1

connecting

LOCAL parameter, C.3.1

to a database, 7.2

control files

additional backslashes in r. 8.0.4, 5.2

maximum size, 17.7

Control Panel

operating system compatibility, 4.1.1

CREATE DATABASE command, 5.4.6

CREATE LIBRARY

command, 19.3.5

custom database

archiving mode, 7.9

D

data dictionary

Advanced Replication tables, 6.6.3

data warehousing

importing a sample schema, 5.3.1.1

database administrator privileges

for a single database on a computer, 13.1.10

for all databases on a computer, 13.1.3, 13.1.4

Database Configuration Assistant

deleting databases, 5.3.2

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.2

database connection

error messages, D.4

database files

deleting, 5.4.3

database monitoring

using Oracle Counters for Windows Performance Monitor, 8.2

with alert files, 8.4

with Event Viewer, 8.3

with trace files, 8.4

database operator privileges

for a single database on a computer, 13.1.11

for all databases on a computer, 13.1.3, 13.1.4

database privileges

in Windows local groups, 13.2.3.1

database roles

granting limited SYS privileges, 11.3

of default accounts, 11.4

database tools

operating system compatibility, 4.1.1

starting from the command line, 4.2.3

starting from the Start Menu, 4.2.2

starting in multiple Oracle Homes, 4.2.1

databases

backing up, 5.4.10

connecting to, 7.2

creating manually, 5.4

deleting, 5.4.3

exporting, 5.4.2

importing, 5.4.8

monitoring, 8.1

naming conventions, 5.1

password encryption, 7.7

shutting down, 7.2, 7.3

starting, 7.2

DB_NAME

directory, explained, 3.8.5

multiple Oracle homes, 3.2.5.2

DBLINK_ENCRYPT_LOGIN, 7.7

DBVERIFY

operating system compatibility, 4.1.1

starting, 4.2.3

debugging external procedures, 19.4

developing applications

for Windows, 19.1

diagnostic and tuning utilities

for Windows, 4.5

disk striping, 3.10.2

DisplayName parameter, C.1.1

DLLs

compared to UNIX shared libraries, F.5

displaying with Task List, 4.5

external procedures, 19.3.4

Oracle Counters for Windows Performance Monitor, 18.3.4.1

Oracle Real Application Clusters, 18.4

E

encrypting, database passwords, 7.7

enhanced security, 6.1.1

enterprise roles

authorizing in Windows 2000 domains, 14.2, 14.2

environments in which to use, 12.3.1

enterprise users

environments in which to use, 12.3.1

environment variables

ORACLE_HOME, 3.5.1

TNS_ADMIN, 3.5.2

error messages

DIM-00000 to DIM-00039, D.3

Intercartridge Exchange, 19.5.4

ORA-00256, 5.2, 7.8

ORA-01102, 5.1

ORA-09275, D.1

ORA-09291, 5.2, 7.8

ORA-12541 TNS, 2.2

ORA-12560, D.4

OSD-04000 to OSD-04099, D.2.1

OSD-04018, 5.2, 7.8

OSD-04100 to OSD-04199, D.2.2

OSD-04200 to OSD-04299, D.2.3

OSD-04300 to OSD-04399, D.2.4

OSD-04400 to OSD-04499, D.2.5

OSD-04500 to OSD-04599, D.2.6

Event Viewer, 8.2

blue (informational) icon, 8.3

defined, 4.4.1

for monitoring a database, 8.1

integration with Oracle database, 4.4.1

logging operating system audit trail, 4.4.1

managing, 8.3.2

operating system compatibility, 4.1.1

reading, 8.3.1

red (stop sign) icon, 8.3

starting, 4.2.5

using, 8.3

yellow (exclamation point) icon, 8.3

exception conditions, Intercartridge Exchange, 19.5.3

executable images

modifying, 1.1.1

EXECUTE privileges, on a PL/SQL library, 19.3.5

Export

databases, 5.4.2

interactive mode, 5.4.2

operating system compatibility, 4.1.1

parameter mode, 5.4.2

preferred tools, 4.1.2

starting, 4.2.3

Export Wizard

preferred tools, 4.1.2

extended partition

defined, B.1

EXTERNAL clause, 19.3.5

external OS user

creating, 13.1.7, 13.2.1

external procedures

building a DLL, 19.3.4

creating a PL/SQL library, 19.3.5

debugging, 19.4

EXTERNAL clause, 19.3.5

granting EXECUTE privileges, 19.3.5

registering with Oracle database, 19.3.5

using EXTPROC, 19.3.2.2

writing, 19.3.3

external roles

administering, 13.1, 13.2

creating, 13.1.9

environments in which to use, 12.3.1

external users

administering, 13.1, 13.2

creating, 13.1.7, 13.2.1

environments in which to use, 12.3.1

EXTPROC

example, 19.3.3

explained, 19.3.2.1

responsibilities, 19.3.2.2

F

features

4GT tuning, 1.2.2

large user populations, 1.2.3

Oracle PKI, 1.3.1

file I/O enhancements, 1.1.2

file permissions, 6.1.1

files

alert, 8.4

maximum number for each database, 17.7

maximum size possible, 17.7

oracle.key, 3.5.1

sample init.ora, 17.2

size limitations, 1.1.2

trace, 8.4

H

Hostname parameter, 8.2.1

I

ICX. See Intercartridge Exchange

ImagePath parameter, C.1.1

Import

databases, 5.4.8

interactive mode, 5.4.8

operating system compatibility, 4.1.1

parameter mode, 5.4.8

preferred tools, 4.1.2

Import Wizard

preferred tools, 4.1.2

initialization parameter file

defined, 17.1

editing, 17.1.2

location, 17.1.1

initialization parameter requirements

Advanced Replication Support, 6.6.2

initialization parameters

OS_ROLES, 12.3, 14.2

path in registry, 18.3.1.5

instance

Oracle, 1.1.1

instances

modifying, 5.5.4

running multiple instances, 7.4

integration with Windows

4GT tuning, 1.2.2

Active Directory, 1.3.2

Oracle Fail Safe, 1.3.4

Oracle Net Naming, 1.3.2.1

Oracle PKI, 1.3.1

Oracle Services for MTS, 1.3.3

interactive mode

Export, 5.4.2

Import, 5.4.8

Intercartridge Exchange

accessing Web data, 19.5

configuring, 19.5.1

error messages, 19.5.4

exception conditions, 19.5.3

packaged functions, 19.5.2

stored packages, 19.5.2

using, 19.5.2

internet applications

developing, 19.2.1

IPC

DeviceNic registry value, 18.4.3

InstanceID registry value, 18.4.3

K

Kerberos, 14.1

default use of, 12.2

features, 12.2

keys

defined, 18.2

L

Load Wizard

preferred tools, 4.1.2

local database role

creating with Oracle Administration Assistant for Windows, 13.1.8

local groups

with database privileges, 13.2.3.1

LOCAL networking parameter, C.3.1

Local Users and Groups

operating system compatibility, 4.1.1

LOG_ARCHIVE_DEST_n, 5.2, 7.8, 7.9.2

LOG_ARCHIVE_FORMAT parameter, 7.9.2

LOG_ARCHIVE_START, 7.9.2

M

mapped drives, 5.2, 7.8

MAXDATAFILES, 5.4.4

memory usage, 9.3

Microsoft Certificate Services, 16.2.2

Microsoft Certificate Stores, 16.2.1

Microsoft Management Console

defined, 4.4.2

integration with Oracle database, 4.4.2

operating system compatibility, 4.1.1

requirements, 13.1

starting, 4.2.5

Microsoft ODBC Administration

starting, 4.2.2

Migration Utility

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

MMC. See Microsoft Management Console

monitoring

alert files, 8.1

Event Viewer, 8.1

Management Pack, 8.1

Oracle Counters for Windows Performance Monitor, 8.1

Oracle events, 4.4.3

trace files, 8.1

multiple instances, running, 7.4

multiple Oracle homes

ALL_HOMES registry subkey, 18.3.3

benefits, 3.2.2

environment, 3.2.5

functionality in different releases, 3.2.3

introduction, 3.1

overview, 3.2

program groups, 3.2.5.1, 3.2.5.2

registry entries, 3.2.5.1, 3.2.5.2

service names, 3.2.5.1, 3.2.5.2

service naming conventions, 7.1.1

system identifier, 3.2.5.1, 3.2.5.2

use of one listener for spawning, 3.2.4

N

Named Pipes Protocol Adapter

with an Oracle Names Server, C.4.2

naming conventions for multiple Oracle homes, 7.1.1

NET START command, 5.4.7

networking parameters

LOCAL, C.3.1

TNS_ADMIN, C.3.2

USE_SHARED_SOCKET, C.3.3

NOARCHIVELOG mode, 7.9.1

NTFS

file system permission setting, 6.1

NTLM, 14.1

default use of, 12.2

features, 12.2

NTS. See Windows native authentication

O

Object Type Translator

operating system compatibility, 4.1.1

ObjectName parameter, C.1.1

OCOPY

and raw files, 1.1.3

backup file types, 10.3

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

OLTP

importing a sample schema, 5.3.1.1

operating system authentication

automatically enabling during installation, 12.4

connecting as SYSDBA without a password, 12.4

OSAUTH_PREFIX_DOMAIN parameter, 13.2.1.1

operating systems

audit trail, 4.4.1

authentication overview, 12.1

OPERFCFG

operating system compatibility, 4.1.1

starting, 4.2.3

syntax examples, 18.8.1

Optimal Flexible Architecture

benefits, 3.6.1

characteristics of a database, 3.6.2

default OFA database, 3.9.2

differences since previous releases, 3.7

introduction, 3.1

nondefault OFA database 1, 3.9.3

nondefault OFA database 2, 3.9.4

overview, 3.6

Windows and UNIX differences, 3.11

ORA_DBA local group

adding users to, 12.4

ORA_ENCRYPT_LOGIN, 7.7

ORA-00256 error, 5.2

ORA-12560 TNS, 2.2

Oracle Administration Assistant for Windows

adding a computer to the navigation tree, 13.1.2

connecting to a database, 13.1.5

creating a local database role, 13.1.8

creating an external OS user, 13.1.7

creating an external role, 13.1.9

database connection issues, 13.1.5.1

granting administrator privileges, 13.1.10

granting operator privileges, 13.1.11

managing remote computers, 13.1.1

operating system compatibility, 4.1.1

saving a navigation tree configuration, 13.1.2

setting OS_AUTHENT_PREFIX, 13.1.6

starting, 4.2.2

using, 13.1, 18.7, 18.8.2

using the Oracle Counters for Windows Performance Monitor snap-in, 18.8.2

using the Oracle Home Configuration snap-in, 18.7

viewing authentication settings, 13.1.6

Oracle Advanced Security

operating system compatibility, 4.1.1

Oracle Counters for Windows Performance Monitor

accessing, 8.2.2

defined, 4.4.3

for monitoring a database, 8.1

Hostname parameter, 8.2.1

integration with Oracle database, 4.4.3

integration with Windows, F.3

monitoring specific Oracle events, 4.4.3

operating system compatibility, 4.1.1

parameters, 18.3.4.1

Password parameter, 8.2.1

registry information, 8.2.1

starting, 4.2.2, 4.2.5, E.1

troubleshooting information, 8.2.5

Username parameter, 8.2.1

using, 8.2, 18.8.2

Oracle database

connecting to, 7.2

password encryption, 7.7

selecting a backup and recovery tool, 10.1

shutting down, 7.2, 7.3

specifications, 17.7

starting, 7.2

Oracle Database Upgrade Assistant

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.2

Oracle Directory Manager

starting, 4.2.2

Oracle Enterprise Login Assistant

preferred tools, 4.1.2

security, 1.3.1

starting, 4.2.2

Oracle Enterprise Manager

Management Pack, 8.1

Oracle Enterprise Manager Configuration Assistant

starting, 4.2.2

Oracle Enterprise Manager Console

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.2, 4.2.3

starting from a Web browser, 4.2.4.2

starting tools, 4.2.4.1

Oracle Enterprise Security Manager

using, 12.3.2.3

Oracle home

new-style, defined, 3.5.2

Oracle Home Configuration snap-in

using, 18.7

Oracle Home Selector

changing PATH value, 3.3.1

Oracle INTYPE File Assistant

starting, 4.2.2

Oracle Locale Builder

starting, 4.2.2

Oracle Managed Files, 5.4.6

Oracle Migration Workbench

operating system compatibility, 4.1.1

starting, 4.2.2

Oracle MTS Recovery Service

operating system compatibility, 4.1.1

Oracle Names

Named Pipes Protocol Adapter, C.4.2

Oracle Net

configuring for external procedures, 19.3.2.2

Oracle Net Configuration Assistant

operating system compatibility, 4.1.1

starting, 4.2.2

Oracle Net Manager

operating system compatibility, 4.1.1

starting, 4.2.2

Oracle Net Naming

with Active Directory, 1.3.2.1

Oracle Portal

operating system compatibility, 4.1.1

Oracle public key infrastructure, 16.1

Oracle Real Application Clusters

registry values, 18.4

Oracle Services

auto-starting, 7.1.5

naming conventions for multiple Oracle homes, 7.1.1

shutting down a database, 7.3

starting, 7.1.3

stopping, 7.1.4

Oracle Spatial

configuring, 6.4

Oracle Text

configuring, 6.3

Oracle Wallet Manager, 1.3.1, 15.3.1

preferred tools, 4.1.2

starting, 4.2.2

Oracle Wallets, 15.3

storing in the registry, 15.3

storing private keys and trust points, 15.1

ORACLE_BASE

explained, 3.8.1

ORACLE_HOME

directory structure, 3.8.2

environment variable, 3.5.1, 3.5.1.1

specifying, 3.9.1

ORACLE_SID, 5.4.9, 7.4

OracleHOME_NAMEClientCache, C.1.1

OracleHOME_NAMECMAdminService, C.1.1

OracleHOME_NAMECManService, C.1.1

OracleHOME_NAMETNSListener, C.1.1

OracleHOME_NAMETNSListener service, C.4.2

oracle.key file, 3.5.1

ORADATA directory, explained, 3.8.4

ORADIM

command syntax errors, D.3

modifying an instance, 5.5.4

moving or copying password files, 7.5

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

ORAPWD

creating password files, 7.5

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

OS_AUTHENT_PREFIX parameter

case insensitivity, 13.2.1.1

defined, 13.1.6

using, 13.2.1.1

OS_ROLES parameter

defined, 13.1.6

not required in Windows 2000 domains, 14.2

using with external roles, 12.3

OSAUTH_PREFIX_DOMAIN, 13.2.1.1

OSAUTH_PREFIX_DOMAIN parameter, 13.1.1, 13.2.1.1

OSAUTH_X509_NAME parameter, 14.1

P

packaged functions

Intercartridge Exchange, 19.5.2

UTL_HTTP.REQUEST, 19.5.2.1

UTL_HTTP.REQUEST_PIECES, 19.5.2.2

parameter mode

Export, 5.4.2

Import, 5.4.8

parameters

AUDIT_FILE_DEST, 8.3.2

BACKGROUND_DUMP_DEST, 8.4

DBLINK_ENCRYPT_LOGIN, 7.7

DEFAULT_HOME, 18.3.3.1

DisplayName, 18.3.4.2, C.1.1

HOME_COUNTER, 18.3.3.2

Hostname, 8.2.1, 18.3.4.1

ImagePath, 18.3.4.2, C.1.1

INST_LOC, 18.3.2.1

LAST_HOME, 18.3.3.4

LOCAL, C.3.1, C.3.1

LOG_ARCHIVE_DEST_n, 5.2, 7.8, 7.9.2

LOG_ARCHIVE_FORMAT, 7.9.2

LOG_ARCHIVE_START, 7.9.2

LOGFILE, 18.3.4.1

MSHELP_TOOLS, 18.3.1.1

NAME, 18.3.3.3

NLS_LANG, 18.3.1.2

ObjectName, 18.3.4.2, C.1.1

OO4O, 18.3.2.2

ORA_AFFINITY, 18.3.1.10

ORA_CWD, 18.3.1.3

ORA_ENCRYPT_LOGIN, 7.7

ORA_SID_AUTOSTART, 18.3.1.4

ORA_SID_PFILE, 18.3.1.5

ORA_SID_SHUTDOWN, 18.3.1.6

ORA_SID_SHUTDOWN_TIMEOUT, 18.3.1.7

ORA_SID_SHUTDOWNTYPE, 18.3.1.8

Oracle Counters for Windows Performance Monitor, 18.8

ORACLE_BASE, 18.3.1.11

ORACLE_GROUP_NAME, 18.3.1.12

ORACLE_HOME, 18.3.1.13

ORACLE_HOME_KEY, 18.3.1.14

ORACLE_HOME_NAME, 18.3.1.15

ORACLE_PRIORITY, 18.3.1.16

ORACLE_SID, 5.4.9, 7.4, 18.3.1.17

OS_AUTHENT_PREFIX, 13.1.6

OS_ROLES, 13.1.6

OSAUTH_PREFIX_DOMAIN, 13.1.1, 13.2.1.1, 18.3.1.18

OSAUTH_X509_NAME, 14.1, 18.3.1.19

Password, 8.2.1

PATH, 18.3.3.3

PERF_FILE_NAME, 18.3.4.1

RDBMS_ARCHIVE, 18.3.1.20

RDBMS_CONTROL, 18.3.1.21

REMOTE_LOGIN_PASSWORDFILE, 7.5

SQLPATH, 18.3.1.22

TNS_ADMIN, 3.5.2, C.3.2

USE_SHARED_SOCKET, C.3.3

Username, 8.2.1, 18.3.4.1

partition

raw, 3.10.3

partitions

extended, B.1

logical partition, B.1.2

physical disk, B.1.1

raw, B.1

password

encryption, 7.7

utility, 7.5

password file

authenticating database administrators, 7.5

creating, 7.5

hiding, 7.5

viewing, 7.5.1

Password parameter, 8.2.1, 18.3.4.1

Password Utility

operating system compatibility, 4.1.1

passwords

changing, 11.2

for default accounts, 11.4

not needed with SYSDBA, 12.4

PATH, changing the value of, 3.3

PERFORMANCE key, 18.3.4.1

Performance Monitor

See Oracle Counters for Windows Performance Monitor

Performance Pack, monitoring a database, 8.1

performance, increasing, 3.10

PhysicalDrive, B.1.1

Symbols

\.PhysicalDrivex, B.1.1

PL/SQL Embedded Gateway, 19.1.3

postinstallation

setting NTFS file system permissions, 6.1

setting Windows registry security, 6.1.3

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 19.5.3

privileges

in Windows local groups, 13.2.3.1

Pro C-C++

starting, 4.2.2

Pro*C/C++

operating system compatibility, 4.1.1

Pro*COBOL

operating system compatibility, 4.1.1

Process Explode, 4.5

Process Viewer, 4.5

program groups

multiple Oracle homes, 3.2.5.1, 3.2.5.2

PWDSID.ORA file, 7.5

Q

QuickSlice, 4.5

R

RAID. See Redundant Array of Independent Disks

raw files

using, 1.1.3

raw partition

defined, B.1

logical partition, B.1.2

overview, B.1

physical disk, B.1.1

raw partitions

defined, 3.10.3

recovering

Oracle database, 10.1

Recovery Manager

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

Recovery Wizard

preferred tools, 4.1.2

redo log files

archiving, 7.9

Redundant Array of Independent Disks

REGEDT32 command, 5.4.9

registering an external procedure, 19.3.5

registry

adding parameters, 18.6

ALL_HOMES subkey, 18.3.3

and multiple Oracle homes, 3.2.5.1, 3.2.5.2

and Oracle Real Application Clusters, 18.4

Cluster Manager, 18.4.2

ClusterID, 18.4.2

ClusterName, 18.4.2

CmDiskFile, 18.4.2

CMDLL, 18.4.1

CmHostName, 18.4.2

configuration parameters, defined, 18.1

DEFAULT_HOME, 18.3.3.1

DefinedNodes, 18.4.2

DeviceNic, 18.4.3

DisplayName, 18.3.4.2, C.1.1

editor, 18.2

editor, starting, 4.2.5

HOME_COUNTER, 18.3.3.2

Hostname, 8.2.1, 18.3.4.1

ImagePath, 18.3.4.2, C.1.1

INST_LOC, 18.3.2.1

InstanceID, 18.4.3

Inter-Process Communication, 18.4.3

IODLL, 18.4.1

IPCDLL, 18.4.1

keys, defined, 18.2

LAST_HOME, 18.3.3.4

LOGFILE, 18.3.4.1

MissCount, 18.4.2

modifying values, 18.5

MSHELP_TOOLS, 18.3.1.1

NAME, 18.3.3.3

NLS_LANG, 18.3.1.2

ObjectName, 18.3.4.2, C.1.1

OO4O, 18.3.2.2

ORA_AFFINITY, 18.3.1.10

ORA_CWD, 18.3.1.3

ORA_SID_AUTOSTART, 18.3.1.4

ORA_SID_PFILE, 18.3.1.5

ORA_SID_SHUTDOWN, 18.3.1.6

ORA_SID_SHUTDOWN_TIMEOUT, 18.3.1.7

ORA_SID_SHUTDOWNTYPE, 18.3.1.8

ORACLE_BASE, 18.3.1.11

ORACLE_GROUP_NAME, 18.3.1.12

ORACLE_HOME, 18.3.1.13

ORACLE_HOME_KEY, 18.3.1.14

ORACLE_HOME_NAME, 18.3.1.15

ORACLE_PRIORITY, 18.3.1.16

ORACLE_SID, 18.3.1.17

OracleHOME_NAMEClientCache, C.1.1

OracleHOME_NAMECMAdminService, C.1.1

OracleHOME_NAMECManService, C.1.1

OracleHOME_NAMETNSListener, C.1.1

OSAUTH_PREFIX_DOMAIN, 13.2.1.1, 18.3.1.18

OSAUTH_X509_NAME, 18.3.1.19

Password, 8.2.1, 18.3.4.1

PATH, 18.3.3.3

PERF_FILE_NAME, 18.3.4.1

PERFORMANCE key, 18.3.4.1

PollInterval, 18.4.2

PublicNames, 18.4.2

RDBMS_ARCHIVE, 18.3.1.20

RDBMS_CONTROL, 18.3.1.21

REG_DWORD, 18.2, 18.6

REG_EXPAND_SZ, 18.2, 18.6

REG_MULTI_SZ, 18.2, 18.6

REG_SZ, 18.2, 18.6

REGEDT32, 18.5, 18.6

ServiceName, 18.4.2

setting security, 6.1.3

SQLPATH, 18.3.1.22

STARTDLL, 18.4.1

update ORACLE_SID, 5.4.9

Username, 8.2.1, 18.3.4.1

using OPERFCFG, 18.8.1

Registry Editor

operating system compatibility, 4.1.1

reliability, increasing, 3.10

remote computers

managing with Oracle Administration Assistant for Windows, 13.1.1

remote computers, accessing database files, 7.8

REMOTE_LOGIN_PASSWORDFILE, 7.5

role authorization

description, 12.3

in Windows 2000 domains, 14.2

method enhancements, 12.3

roles

authorized in Windows 2000 domains, 14.2

creating, 13.1.9

creating a local database role with Oracle Administration Assistant for Windows, 13.1.8

of default accounts, 11.4

when to use enterprise roles, 12.3.1

when to use external roles, 12.3.1

S

schemas

data warehousing, 5.3.1.1

OLTP, 5.3.1.1

Server Manager

replacement, 4.1

service names

multiple Oracle homes, 3.2.5.1, 3.2.5.2

services, 7.1.1

auto-starting, 7.1.5

defined, 2.1

Oracle Object Service, 2.2

Oracle OLAP Agent, 2.2

Oracle OLAP Services 9.0.1.1.0, 2.2

OracleCMService9i, 2.2

OracleDirectoryService_SID, 2.2

OracleEXTPRC, 2.2

OracleGSDService, 2.2

OracleHOME_NAMEAgent, 2.2

OracleHOME_NAMEClientCache, 2.2

OracleHOME_NAMECMAdmin, 2.2

OracleHOME_NAMECMan, 2.2

OracleHOME_NAMEHTTPServer, 2.2

OracleHOME_NAMEManagementServer, 2.2

OracleHOME_NAMEPagingServer, 2.2

OracleHOME_NAMETNSListener, 2.2

OracleMSCSService, 2.2

OracleMTSRecoveryService, 2.2

OracleNAMES, 2.2

OracleServiceSID, 2.2

OracleSNMPPeerEncapsulator, 2.2

OracleSNMPPeerMasterAgent, 2.2

OraFenceService, 2.2

shutting down a database, 7.3

starting, 5.4.5, 7.1.3

stopping, 7.1.4

using, 2.3

SET INSTANCE command, 13.2.2.2, 13.2.3.1

SET ORACLE_SID=SID, 7.4

shared server

configuring, 6.5

disabling, 6.5

enabling, 6.5

Shared server process, 1.2.3

shutting down

databases, 7.2, 7.3

single sign-on, 1.3.2

snap-ins

Oracle Counters for Windows Performance Monitor, 18.8.2

Oracle Home Configuration, 18.7

specifying an archiving file format, 7.9.2

SQL*Loader

control file conventions, 4.3.4

direct path option, 4.3.2

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.3

SQL*Plus

operating system compatibility, 4.1.1, 4.1.1

preferred tools, 4.1.2

shutting down the database, 7.2

starting, 4.2.2, 4.2.3, 7.2

starting the database, 7.2

SQL*Plus Worksheet

preferred tools, 4.1.2

starting, 4.2.2

sqlnet.ora file

and Windows native authentication, 13.2.2.2, 13.2.3.1

location of, 13.2.2.2, 13.2.3.1

Start HTTP Server

starting, 4.2.2

starter database

archiving mode, 7.9

starting

databases, 7.2

Oracle Counters for Windows Performance Monitor, 8.2.2

Oracle Services, 7.1.3

SQL*Plus, 7.2

Stop HTTP Server

starting, 4.2.2

stopping, Oracle Services, 7.1.4

stored packages, Intercartridge Exchange, 19.5.2

storing private keys and trust points

Oracle Wallets, 15.1

striping disks, 3.10.2

symbolic links, 3.11.3

creating, B.2

SYSDBA privileges

connecting without a password, 12.4

for a single database on a computer, 13.1.10

for all databases on a computer, 13.1.3, 13.1.4

SYSOPER privileges

for a single database on a computer, 13.1.11

for all databases on a computer, 13.1.3, 13.1.4

system identifier

multiple Oracle homes, 3.2.5.1, 3.2.5.2

T

tablespaces

Advanced Replication support, 6.6.1, 6.6.3

Task List, 4.5

Task Manager

operating system compatibility, 4.1.1

starting, 4.2.5

using, 4.4.5

threads

and Microsoft Management Console, 4.4.2

and multiple Oracle instances, 1.1.1

and Oracle services, 2.1

and ORASTACK, 1.1.1

and shared server process, 1.2.3

and UNIX processes, F.13

defined, 1.1.1

optional and required, 1.1.1

process errors, D.2

processor affinity, 18.3.1.10

scheduling priority, 18.3.1.16

TKPROF

operating system compatibility, 4.1.1

starting, 4.2.3

TNS_ADMIN networking parameter, C.3.2

tools, starting

Database Configuration Assistant, 4.2.2

DBVERIFY, 4.2.3

Event Viewer, 4.2.5

Export, 4.2.3

Microsoft Management Console, 4.2.5

Microsoft ODBC Administration, 4.2.2

Migration Utility, 4.2.3

OCOPY, 4.2.3

OPEFCFG, 4.2.3

Oracle Administration Assistant for Windows, 4.2.2

Oracle Counters for Windows Performance Monitor, 4.2.2, 4.2.5

Oracle Database Upgrade Assistant, 4.2.2

Oracle Directory Manager, 4.2.2

Oracle Enterprise Login Assistant, 4.2.2

Oracle Enterprise Manager Configuration Assistant, 4.2.2

Oracle Enterprise Manager Console, 4.2.2, 4.2.3

Oracle INTYPE File Assistant, 4.2.2

Oracle Locale Builder, 4.2.2

Oracle Migration Workbench, 4.2.2

Oracle Net Configuration Assistant, 4.2.2

Oracle Net Manager, 4.2.2

Oracle Wallet Manager, 4.2.2

ORADIM, 4.2.3

ORAPWD, 4.2.3

Pro C-C++, 4.2.2

Recovery Manager, 4.2.3

Registry Editor, 4.2.5

SQL*Loader, 4.2.3

SQL*Plus, 4.2.2, 4.2.3

SQL*Plus Worksheet, 4.2.2

Start HTTP Server, 4.2.2

Stop HTTP Server, 4.2.2

Task Manager, 4.2.5

TKPROF, 4.2.3

User Manager, 4.2.5

trace files

for monitoring a database, 8.1

using, 8.4

troubleshooting

ORA-12560 error, D.4

ORA-28575 error, D.4

TNS-12203 error, D.4

tuning Windows Server operating system, 9.1

U

UNC, 5.2, 7.8

Universal Naming Convention, 5.2, 7.8

UNIX

and Optimal Flexible Architecture, 3.11

and Windows, Oracle differences, F

USE_SHARED_SOCKET networking parameter, C.3.3

user authentication

description, 12.3

enhancement methods, 12.3

when to use enterprise users, 12.3.1

when to use external users, 12.3.1

User Manager

defined, 4.4.7

integration with Oracle database, 4.4.7

operating system compatibility, 4.1.1

preferred tools, 4.1.2

starting, 4.2.5

Username parameter, 8.2.1

usernames

changing, 11.2

of administrative accounts, 11.4

UTL_HTTP.REQUEST, Intercartridge Exchange, 19.5.2.1

UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 19.5.2.2

V

viewing

password file, 7.5.1

W

Wallet Resource Locator, 16.2.3

Web browser

running Oracle Enterprise Manager, 4.2.4.2

Web data, Intercartridge Exchange, 19.5

Windows

and UNIX, Oracle differences, F

diagnostic and tuning utilities, 4.5

extensions for internet development, 19.2.1

Windows 2000 domains

administering external users and roles with Oracle Administration Assistant for Windows, 13.1

role authorization, 14.2

Windows authentication protocols

default protocol used, 12.2

with Windows 2000, 12.2

with Windows NT 4.0, 12.2

Windows domains

administering external users and roles, 13.2

basic features, 12.3

Windows local groups

with database privileges, 12.4, 13.2.3.1

Windows native authentication

benefits, 12.1

enhancements, 12.3

installation of, 12.1

methods and use of, 12.1

overview, 12.1

role authorization enhancements, 12.3

setting the sqlnet.ora file, 13.2.2.2, 13.2.3.1

user and role requirements, 12.3

user authentication enhancements, 12.3

Windows tuning

applying latest service packs, 9.7

closing unnecessary foreground applications, 9.10

configuring server to be an application server, 9.3

disable unnecessary services, 9.4

foreground applications, 9.2

multiple striped volumes for sequential and random access, 9.8.1

overview, 9.1

removing unused network protocols, 9.5

resetting the network protocol bind order, 9.6

using hardware and operating system striping, 9.8

Windows-specific

archiving procedures, 7.9.2

audit trail availability, 8.3.1

audit trail facility, 8.3.1

automatic database startup after restart, 7.1.5

initialization parameter file, 17.1

parameter file location, 17.1.1

parameter filename and location, 17.1

password filename and location, 7.5

role syntax, 13.2.3.1

trace file names, 8.4