Index

ADMIN directory, explained, 4-21

Adobe Acrobat Reader, starting, 1-11

Advanced Program-to-Program Communication (APPC), 2-15, 2-29, 2-37

Advanced Replication support, 7-6

additional documentation, 6-26

configuration tasks, 6-24

creating a SPOOL file, 6-25, 6-26

data dictionary

tables, 6-26

initialization parameter requirements, 6-24

tablespace requirements, 6-23, 6-26

alert files, 11-14

for monitoring a database, 11-2

using, 11-14

alert view, 11-5

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

ALTER DATABASE ARCHIVELOG command, 9-24

ALTER DATABASE CONVERT command, 5-40

ALTER DATABASE OPEN RESETLOGS command, 5-41

ALTER PACKAGE command, 6-25

APPC architecture, 2-15, 2-29, 2-37

ARCHIVE LOG LIST command, 9-23

ARCHIVELOG mode, 7-5, 9-23

archiving mode, 7-5

custom database, 9-23

starter database, 9-23

archiving procedures, 9-25

for redo log files, 9-23

specifying an archive destination, 9-25

UNC not allowed, 7-16, 8-3

assistant common files, 2-11, 2-26, 2-35

assistants

operating system compatibility, 3-4

Oracle Data Migration Assistant, 2-21

Oracle Database Configuration Assistant, 2-21, 2-24, 2-32

Oracle Migration Assistant for Microsoft Access, 2-33

Oracle Web Publishing Assistant, 2-24, 2-34

AUDIT_FILE_DEST parameter, 11-14

ATTRIB command, 3-10

audit trail

managing, 11-14

operating system, 3-23

AUDIT_TRAIL parameter, 11-12

auditing, 11-12

authentication

automatically enabling during installation, 10-3

connecting as INTERNAL without a password, 10-35

connecting as SYSOPER or SYSDBA without a password, 10-30

connecting without a password as a nonprivileged database user, 10-25

creating an operating system-authenticated user, 10-27

granting database roles through Windows NT, 10-40

of DBA users, 2-6

overview, 10-2

setting OS_AUTHENT_PREFIX, 10-26

SQLNET.ORA file, 10-2

using a password file, 9-17

using Windows NT Native authentication methods, 10-2

Authentication Adapters

using, D-5

auto-starting

Oracle Services, 9-8

BACKGROUND_DUMP_DEST parameter, 8-16

using with trace files, 11-14

backslash (\), defined, xxvii

backup

databases, 8-25

OCOPY file types, 12-4

stopping services to perform cold backups, 12-3

backup and recovery tools

Recovery Manager (RMAN.EXE), 12-3

OCOPY, 12-3

selecting, 12-2

third-party backup and recovery vendors, 12-3

Backup Manager

capabilities, 12-2

Bequeath

defined, 2-14, 2-29

block size, maximum, B-8

blocks per file, maximum, B-8

browsers

Java-enabled, 1-10

Microsoft Internet Explorer, 1-10

Netscape Navigator, 1-10

BUILD_DB.SQL script, 8-10, 8-17

location of, 8-4

BUILDALL.SQL script, 8-17

C:\>, defined, xxvii

C:\ORACLE, defined, 4-16

C:\ORANT, defined, xxviii, 4-16

C:\ORAWIN, defined, xxviii

C:\ORAWIN95, defined, xxviii

CATALOG.SQL script, 5-53, 8-21

CAT8004.SQL, 5-47

CATEXP.SQL script

CATNSNMP.SQL, capabilities, 7-9

CATOUT.LOG file, 5-41

CATPARR.SQL, 5-42

CATPROC.SQL script, 5-53, 8-21

CATREP.SQL, 5-42, 6-25, 8-22

chart view, 11-5

Choose Start >, defined, xxvii

code conventions, used in this guide, xxvii

cold backups, performing, 12-3

COMDEMO user name, 7-10

COMMIT_POINT_ STRENGTH parameter, B-4

Common Object Request Broker Architecture. See CORBA

COMPATIBLE parameter, 5-40, 5-49, 5-54, B-4

configuration files

TNSNAMES.ORA

ENCAPS.CFG, G-10

MASTER.CFG, G-9

configuration parameter

NAMES.DIRECTORY_PATH, D-7

configuration parameters

SQLNET.AUTHENTICATION_SERVICES, D-6

TNS_ADMIN, D-4

USE_SHARED_SOCKET, D-4

configuration requirements

Advanced Replication support, 6-3

for Oracle products, 6-2

multi-threaded external callouts, 6-3

multi-threaded server, 6-3

Net8, 6-2

Oracle COM Automation option, 6-2

Oracle Enterprise Manager, 6-2

Oracle Spatial cartridge, 6-2

Oracle Time Series cartridge, 6-2

Oracle Visual Information Retrieval cartridge, 6-2

PL/SQL external procedures, 6-3

configuration responsibilities

Oracle Audio Data cartridge, 6-4

Oracle ConText cartridge, 6-7

Oracle Spatial cartridge, 6-10

Oracle Time Series cartridge, 6-13

Oracle Visual Information Retrieval cartridge, 6-15

configuration tasks

Advanced Replication support, 6-24

Oracle Spatial cartridge, 6-11

configuring

Authentication Adapters, D-5

External Naming, D-7

Named Pipes Protocol Adapter, D-8

NDS Authentication Adapter, D-5

Windows NT Native Authentication Adapter, D-6

Connect

INTERNAL, from a remote machine, 7-11

CONNECT INTERNAL, 9-20

changing the INTERNAL password, 9-21

connecting without a password, 7-11, 10-3, 10-35

password, 9-20

using, 9-10, 9-20, 9-23

connecting

External Naming, D-8

LOCAL parameter, D-3

Oracle7 connections to Oracle8 databases, 5-9

Oracle8 Client r. 8.0/SQL*Net to Oracle8 database r. 8.1, 5-9

Oracle8 Client r. 8.1 to Oracle database v. 7 and r. 8.0, 5-11

Oracle8 Client r. 8.1 to Oracle8 database r. 8.1, 5-8

to a database, 9-10, 9-23

with NDS Native Naming Adapter, D-7

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

contact information

documentation sales, 1-2

Legato, 2-11, 2-26

control files

additional backslashes in r. 8.0.4, 7-16, 8-3

description, 7-14

starter database, 7-14

Control Panel

defined, 3-21

integration with Oracle8 database, 9-3

integration with Oracle8i database, 3-21

CONTROL_FILES parameter, 8-15, B-4

copy modes, for OCOPY, 12-4

CORBA, 2-21, 2-40, 13-2

CREATE DATABASE command, 8-17

CREATE LIBRARY command, 13-8

CREATE USER command, 10-27

CTXSYS user name, 7-10

advanced replication, 7-6

custom database

archiving mode, 9-23

available installation types, 7-4

configuration mode created, 7-5

database name created, 7-4

initial archiving mode, 7-5

operating system authentication, 7-6, 7-7

options, 7-6

overview, 7-2

schema created, 7-7

system identifier created, 7-4

data dictionary

Advanced Replication tables, 6-26

contents, 7-15

description, 7-15

starter database, 7-15

data files

starter database, 7-13

SYSTEM01.DBF, 7-13

TEMP01.DBF, 7-13

USERS01.DBF, 7-13

database backup and recovery tools

Recovery Manager (RMAN), 12-3

OCOPY, 12-3

third-party vendors, 12-3

database coexistence

issues, 5-7

overview, 5-3

using Performance Monitor, 11-3

database files

deleting, 8-13

database monitoring

with alert files, 11-14

with Event Viewer, 11-11

with trace files, 11-14

database privileges

in Windows NT local groups, 10-30, 10-35, 10-42, 10-44

database release coexistence issues, 5-8

database roles

COMDEMO user name, 7-10

CTXSYS user name, 7-10

DBSNMP user name, 7-9

DEMO user name, 7-10

granting through Windows NT, 10-40

MDSYS user name, 7-10

MTSSYS user name, 7-9

ORDSYS user name, 7-10

OUTLN user name, 7-9

SCOTT user name, 7-9

SYS user name, 7-9

SYSTEM user name, 7-9

database tools

operating system support, 3-2

starting, 3-7

database user, connecting without a password, 10-25

databases

available installation types, 7-3

backing up, 8-25

BUILD_DB.SQL script, 8-10

BUILDALL.SQL, 8-17

changing passwords, 8-22

coexistence, 5-3

connecting to, 9-10, 9-23

control files in starter database, 7-14

creating, 8-1

data dictionary in starter database, 7-15

data files in starter database, 7-13

installation in multiple homes, 5-13, 5-18

installation on separate computers, 5-14

maximum size possible, B-8

migration, 5-4, 5-15

monitoring, 11-1, 11-2

multi-versioning, 5-12

naming conventions, 8-2

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

Oracle Database Configuration Assistant, 8-4

parameters for a new database, B-4

password encryption, 9-22

redo log files in starter database, 7-14

rollback segments in starter database, 7-15

shutting down, 9-10, 9-11

starting, 9-10

system identifier, 7-11

tablespaces in starter database, 7-12

upgrading, 5-4, 5-16, 5-45

user names in starter database, 7-8

what to do with existing databases, 5-3

DB_BLOCK_BUFFERS parameter, B-4

DB_BLOCK_SIZE parameter, B-4

DB_FILE_MULTIBLOCK_ READ_ COUNT parameter, B-4

DB_FILES parameter, 8-16, B-4

DB_NAME directory, explained, 4-22

DB_NAME parameter, 8-15, B-4

DBLINK_ENCRYPT_LOGIN parameter, 9-22

DBSNMP user name, 7-9

database roles, 7-9

dropping with CATNSNMP.SQL, 7-9

password, 7-9

DBVERIFY

dedicated server mode, 7-5

starting, 3-9

Decision Support System. See DSS

disabling, 6-17

enabling, 6-17

default control files, CTL1SID.ORA, 7-14

default data files

default initialization parameter file, INIT.ORA, 7-13

default redo log files

default tablespaces, 7-12

default user names, 7-8

DEFAULT_HOME parameter, C-9

deleting

DFS. See Distributed File System

directory names, convention used, xxvii

directory structure, ??-A-13

directory structures

OFA-compliant directory tree, 4-18

Oracle8i Client, A-8

Oracle8i Enterprise Edition, A-2

Programmer/2000, A-11

disk definition, F-3

disks

striping, 4-30

DisplayName parameter, C-11, D-3

DISTRIBUTED_TRANSACTIONS parameter, B-4

DLL, external procedures, 13-7

DML_LOCKS parameter, B-4

documentation

Adobe Acrobat Reader, 1-11

availability, 2-21

formats supplied, 1-2

generic, 1-3

how to find specific information (online), 1-10

HTML, 1-2

list of included manuals, 1-4

Oracle Information Navigator, 1-2

ordering printed guides, 1-2

PDF, 1-2

printed, 1-2

documentation conventions, used in this guide, xxvii

DSS

database environment, 7-7, 8-7

importing a sample schema, 8-8

encrypting, database passwords, 9-22

Enterprise JavaBeans, 2-21, 2-40, 13-2

error messages

Intercartridge Exchange, 13-16

blue (informational) icon, 11-12

defined, 3-22

for monitoring a database, 11-2

IDs other than 34, 11-12

integration with Oracle8 database, 3-22

logging operating system audit trail, 3-23

managing, 11-14

overview, 3-22

reading, 11-12

red (stop sign) icon, 11-12

yellow (exclamation point) icon, 11-12

using, 11-11

exception conditions, Intercartridge Exchange, 13-16

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

existing databases, installation types, 5-3

EXP. See Export Utility

Export Utility

databases, 8-12

interactive mode, 8-12

create logical partitions, F-8

parameter mode, 8-12

starting, 3-9

extended partition

creating, F-7

defined, F-2

EXTERNAL clause, 13-9

External Naming, D-7

client configuration, D-8

connecting with Server Manager, D-8

NDS Native Naming Adapter, D-7

using, D-7

external procedures

additional documentation, 13-11

building, 13-4

building a DLL, 13-7

creating, 13-4

creating a PL/SQL library, 13-8

defined, 13-4

enabling multi-threaded callout support, 13-10

EXTERNAL clause, 13-9

features, 13-4

granting EXECUTE privileges, 13-8

registering with Oracle database, 13-8

using EXTPROC, 13-5

writing, 13-6

EXTPROC, responsibilities, 13-5

file names, convention used, xxvii

file size, maximum possible, B-8

files

alert, 11-14

assistant common, 2-11, 2-26, 2-35

database file names, 4-16

LISTENER.ORA, 13-5

maximum number per database, B-8

maximum size possible, B-8

sample INIT.ORA, B-3

trace, 11-14

generic documentation references

calculating index size, B-9

CREATE DATABASE, 8-17

custom database archiving mode, 9-23

earliest releases that can be migrated, 5-5

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

location of initialization parameter file, B-2

managing the Event Viewer, 11-14

maximum number of data files, 8-16

Microsoft operating systems certified on version 8, 2-2

multi-versioning, 5-12

name and location of convert file, 5-40

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

product versions certified on version 8, 2-8

running CATPROC.SQL, 8-21

SORT_AREA_SIZE default value, B-5

specifying archive destinations, B-4

starter database archiving mode, 9-23

starting Server Manager (SVRMGRL), 3-10

supported operating systems, 2-2

Windows NT-specific archiving procedures, 9-25

Windows NT-specific audit trail availability, 11-12

Windows NT-specific audit trail facility, 11-12

Windows NT-specific authentication methods, 10-2

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

Windows NT-specific control file specifications, 8-14

Windows NT-specific CONTROL_FILE parameter value, B-4

Windows NT-specific database creation procedures, 8-4

Windows NT-specific database migration instructions, 5-21

Windows NT-specific initialization parameter file, B-2

Windows NT-specific instance startup file names, 9-10

Windows NT-specific local groups use, 10-30

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

Windows NT-specific LOG_ARCHIVE_DEST format, B-4

Windows NT-specific LOG_ARCHIVE_DEST value, B-4

Windows NT-specific LOG_ARCHIVE_FORMAT format, B-4

Windows NT-specific migration instructions, 5-1

Windows NT-specific NLS_LANG values, E-3

Windows NT-specific NLS_TERRITORY values, E-3

Windows NT-specific Oracle Enterprise Manager startup, 3-12

Windows NT-specific OS_AUTHENT_PREFIX case insensitivity, 10-26

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

Windows NT-specific parameter file values, B-4

Windows NT-specific password file name and location, 9-17

Windows NT-specific Password Utility installation, 2-24, 2-34

Windows NT-specific redo log file location, 7-14

Windows NT-specific redo log file size, 7-14

Windows NT-specific role granting, 10-40

Windows NT-specific role syntax, 10-44

Windows NT-specific trace file names, 11-14

Windows NT-specific upgrading instructions, 5-1

GRANT EXECUTE ON command, 6-26

HOME_COUNTER parameter, C-9

HOME_NAME, defined, xxix

HOMEID

defined, xxix

Host Naming

Hostname parameter, 11-3, C-10

hostname value, 11-3

hybrid database environment, 7-7

creating, 8-8

ICX. See Intercartridge Exchange

IMAGECFG utility, 2-3

ImagePath parameter, C-11, D-3

IMP. See Import Utility

Import Utility

databases, 8-22

interactive mode, 8-22

index size, calculating, B-9

parameter mode, 8-22

starting, 3-9

INDX tablespace, description, 7-12

INDX01.DBF

using PFILE option for database startup, 9-10

initialization parameter file

starter database, 7-13

using the default file for database startup, 9-10

initialization parameter requirements

Advanced Replication Support, 6-24

initialization parameters

AUDIT_TRAIL, B-4

BACKGROUND_DUMP_DEST, B-4

COMMIT_POINT_ STRENGTH, B-4

COMPATIBLE, B-4

CONTROL_FILES, B-4

DB_BLOCK_BUFFERS, B-4

DB_BLOCK_SIZE, B-4

DB_FILE_MULTIBLOCK_ READ_ COUNT, B-4

DB_FILES, B-4

DB_NAME, B-4

DISTRIBUTED_TRANSACTIONS, B-4

DML_LOCKS, B-4

JOB_QUEUE_INTERVAL, B-4

JOB_QUEUE_PROCESSES, B-4

LOG_ARCHIVE_DEST, B-4

LOG_ARCHIVE_FORMAT, B-4

LOG_ARCHIVE_START, B-4

LOG_BUFFER, B-4

LOG_CHECKPOINT_ INTERVAL, B-4

LOG_CHECKPOINT_ TIMEOUT, B-4

LOG_FILES, B-4

MAX_DUMP_FILE_SIZE, B-5

MTS_DISPATCHERS, B-5

MTS_MAX_DISPATCHERS, B-5

OS_AUTHENT_PREFIX, 10-26, B-5

PROCESSES, B-5

REMOTE_LOGIN_PASSWORDFILE, B-5

SHARED_POOL_SIZE, B-5

TEXT_ENABLE, B-5

TIMED_STATISTICS, B-5

TRANSACTIONS_PER_ ROLLBACK_SEGMENT, B-5

USER_DUMP_DEST, B-5

INST_LOC parameter, C-8

installation

Net8 Client, 2-9, 2-10

Net8 Server, 2-9

Instance Manager

INSTANCE_NAME parameter, 8-15

instances

creating, 8-27, 8-28

defined, 9-4

modifying, 8-30

running multiple instances, 9-16

interactive mode

Intercartridge Exchange

accessing Web data, 13-12

configuring, 13-12

error messages, 13-16

exception conditions, 13-16

packaged functions, 13-13

stored packages, 13-13

troubleshooting, 13-18

using, 13-13

INTERNAL, 10-40

alias for SYS and SYSDBA, 7-9

changing the INTERNAL password, 9-21

connecting as, 9-20

connecting without a password, 7-7, 7-9, 7-11, 10-35

password, 7-9, 9-20

user name, 7-9

italic letters, defined, xxvii

Java products

overview, 13-2

Java stored procedures, 2-21, 13-2

Java Virtual Machine, 2-21, 2-40, 13-2

Java-enabled browsers, 1-10

JOB_QUEUE_INTERVAL parameter, B-4

JOB_QUEUE_PROCESSES parameter, B-4

Kerberos Authentication Adapter

supported vendors, 2-43

Kerberos authentication method

see Oracle Advanced Networking Option

LAST_HOME parameter, C-9

Legato NetWorker, defined, 2-11, 2-26

Legato Storage Manager

adding BIN directory to PATH, 12-7

defined, 2-11, 2-26

listener

1521 port, D-13

1526 port, D-13

OracleHOME_NAMETNSListener80 service, D-10

OracleHOME_NAMETNSListener80LSNR service, D-10

local groups

with database privileges, 10-30, 10-35, 10-42, 10-44

LOCAL parameter, D-3

log view, 11-5

LOG_ARCHIVE_DEST parameter, 7-16, 8-3, 9-25, B-4

LOG_ARCHIVE_FORMAT parameter, 9-25, B-4

LOG_ARCHIVE_START parameter, 9-25, B-4

LOG_BUFFER parameter, B-4

LOG_CHECKPOINT_ INTERVAL parameter, B-4

LOG_CHECKPOINT_ TIMEOUT parameter, B-4

LOG_FILES parameter, B-4

LOGFILE parameter, C-11

logical partitions

assigning symbolic links, F-10

creating, F-8

Logical Unit Type 6.2 Protocol Adapter, 2-15, 2-29, 2-37

LSNRCTL80 utility

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

LU6.2

See Logical Unit Type 6.2 Protocol Adapter, 2-15, 2-29, 2-37

LU6.2 Protocol Adapter, 2-43

supporting networks, 2-15, 2-29, 2-37

supporting topologies, 2-15, 2-29, 2-37

management, G-2

managing, Oracle Services, 9-2

mapped drives, 7-16, 8-3

MAX_DUMP_FILE_SIZE parameter, B-5

MAX_IO_SIZE, B-5

MDSYS user name, 7-10

Microsoft Internet Explorer, 1-10

Microsoft SNMP, G-3

MIG. See Migration Utility

migration

instructions, 5-27

multiple Oracle homes, 5-5

Optimal Flexible Architecture, 5-61

overview, 5-4

SQL*Net, 5-24, 5-60

U0703040.SQL script, 5-42

using appropriate tool versions, 5-28

Migration Utility

Oracle events, 3-22, 3-24

using, 5-27

MIGSID.ORA file, 5-36, 5-41

monitoring

alert files, 11-2

databases, 11-1

Event Viewer, 11-2

Oracle8 Objects, 11-5

Performance Monitor, 11-2

Performance Pack, 11-2

trace files, 11-2

MSHELP_TOOLS parameter, C-5

MTS_DISPATCHERS parameter, B-5

specifying a value, B-5

MTS_MAX_DISPATCHERS parameter, B-5

MTS_MAX_SERVERS parameter, B-5

MTS_SERVERS parameter, B-5

MTSSYS user name, 7-9

database roles, 7-9

password, 7-9

multiple instances, running, 9-16

multiple Oracle home products, 4-7

Multiple Oracle Homes

use of one listener for spawning, 4-5

multiple Oracle homes

multi-threaded callout support

setting OracleExtprocAgent, 13-11

enabling, 13-10

multi-threaded server

configuring with Oracle Database Configuration Assistant, 2-21, 6-17

disabling, 6-17

enabling, 6-17

specifying MTS_DISPATCHERS, B-5

multi-threaded server mode

same as shared server mode, 7-5

multi-versioning, 5-12

NAME parameter, C-8

Named Pipes

defined, 2-13

Named Pipes Protocol Adapter

with an Oracle Names Server, D-8

NAMES.DIRECTORY_PATH parameter, D-7

naming conventions for multiple Oracle homes, 9-2

naming method

External Naming, D-7

NDS Authentication Adapter

client configuration, D-6

NetWare Server configuration, D-5, D-6

establishing connections with, D-7

using, D-5

NDS Native Naming Adapter

using, D-7

NET START command, 8-19

Net8

configuring for external procedures, 13-5

Net8 Assistant

defined, 2-12, 2-27

Net8 Client, defined, 2-11, 2-26, 2-35

Net8 Easy Config

defined, 2-12, 2-27, 2-35

Net8 Server, defined, 2-12

NET80 parameter, D-2

Netscape Navigator, 1-10

network

topologies supporting LU6.2 protocol, 2-15, 2-29, 2-37

Network Security, described, 2-16, 2-30, 2-38

NLS support, E-3

NLS_LANG environment variable, 5-29

NLS_LANG parameter, C-5, E-2

territory and character set defaults, E-3

NLS_LANGUAGE parameter, B-5

NLS_SORT parameter, B-5

NLS_TERRITORY parameter, B-5

NOARCHIVELOG mode, 7-5, 9-23

Non-multiple Oracle home products, 4-8

non-multiple Oracle home products, 4-8

Non-Oracle Home Products, 4-8

Non-Oracle home products, 4-8

Object Request Broker (ORB), 2-21, 13-2

Object Type Translator (OTT), defined, 2-18, 2-31, 2-39

ObjectName parameter, C-11, D-3

OCOPY

backup file types, 12-4

capabilities, 12-3

copy modes, 12-4

recovery file types, 12-6

syntax for backing up files, 12-5

syntax for recovering files, 12-6

ODBC. See Oracle Open Database Connectivity Driver

OEMREP01.DBF

database environment, 7-7, 8-7

OFA. See Optimal Flexible Architecture

OLTP

importing a sample schema, 8-8

One, 4-5

Online Transaction Processing. See OLTP

OO4O parameter, C-8

Open Systems Interconnect (OSI) model, 2-15, 2-29, 2-37

OPEN_CURSORS parameter, B-5

OPEN_LINKS parameter, B-5

operating system authentication, 7-6, 7-7

automatically enabling during installation, 10-3

connecting as INTERNAL without a password, 10-35

connecting as SYSOPER or SYSDBA without a password, 10-30

connecting without a password as a nonprivileged database user, 10-25

creating an authenticated user

creating, 10-27

granting database roles through Windows NT, 10-40

setting OS_AUTHENT_PREFIX, 10-26

SQLNET.ORA file, 10-2

operating systems

audit trail, 3-23

authentication overview, 10-2

supported, 2-2

OPERF.LOG file, 11-10

viewing Performance Monitor status, 11-10

OPERFCFG

defined, 2-4

characteristics of a database, 4-14

syntax examples, C-18

OPS$, 10-26

Optimal Flexible Architecture

benefits, 4-14

default OFA database, 4-24

defined, 2-6

differences since previous releases, 4-16

introduction, 4-2

moving database files, 5-61

non-default OFA database 1, 4-26

non-default OFA database 2, 4-28

NT and UNIX differences, 4-32

OFA-compliant directory tree, 4-18

Oracle Parallel Server option, 4-19

overview, 4-13

ORA_AFFINITY parameter, C-6

ORA_CWD parameter, C-5

ORA_ENCRYPT_LOGIN parameter, 9-22

ORA_SHUTDOWN parameter, 9-12

ORA_SID_AUTOSTART parameter, 9-11, C-5

ORA_SID_PFILE parameter, 9-11, C-5

ORA_SID_SHUTDOWN parameter, 9-12, C-5

ORA_SID_SHUTDOWN_TIMEOUT parameter, 9-13, C-5

ORA_SID_SHUTDOWNTYPE parameter, 9-13, C-5

ORA-00256 error, 7-16, 8-3

ORA-09291 error, 7-16, 8-3

Oracle, 2-43

Oracle Administration Assistant for Windows NT

defined, 2-4, 2-18

using, C-16, C-19

Oracle Administration Assistant snap-in

Kerberos authentication method, 2-17, 2-30, 2-38

Oracle Advanced Networking Option

RADIUS authentication method, 2-17, 2-30, 2-38

Oracle Advanced Networking option - Export Edition

defined, 2-5

Oracle Advanced Security Administrator's Guide, 2-43

Oracle Application Wizards for Microsoft Visual Studio

configuration responsibilities, 6-4

Oracle AppWizard for Microsoft Visual C++

defined, 2-5, 2-18, 2-31

Oracle Audio Data cartridge

Oracle Call Interface

defined, 2-19, 2-31, 2-39

Oracle COM Automation option

OracleHOME_NAMECManService service, D-12

defined, 2-5, 2-19

Oracle Connection Manager

1610 port, D-13

1620 port, D-13

defined, 2-19

Oracle ConText cartridge

configuration responsibilities, 6-7

Oracle Data Migration Assistant

advanced replication, 7-6

using, 5-25, 5-45

Oracle database

available types, 7-3

configuration mode created, 7-5

creating for a DSS environment, 8-7

creating for a hybrid environment, 8-8

creating for an OLTP environment, 8-7

custom database overview, 7-2

Custom installation type, 7-3

database name created, 7-4

database types created, 7-4

initial archiving mode, 7-5

Minimal installation type, 7-3

operating system authentication, 7-7

options, 7-6

sample DSS schema, 8-8

sample OLTP schema, 8-8

schema created, 7-7

starter database control file, 7-14

starter database data dictionary, 7-15

starter database data files, 7-13

starter database initialization parameter file, 7-13

starter database overview, 7-2

starter database redo log files, 7-14

starter database rollback segments, 7-15

starter database tablespaces, 7-12

starter database user names, 7-8

system identifier, 7-11

system identifier created, 7-4

Typical installation type, 7-3

Oracle Database Configuration Assistant

Oracle Enterprise Manager

operating system compatibility, 3-4

Performance Pack, 11-2

single Oracle home product, 4-8

starting, 3-12

status for release 8.1.4, 3-2

Oracle for Windows NT Performance Monitor

parameters, C-9, C-18

Oracle Home Configuration snap-in

changing PATH value, 4-10

using, C-16

Oracle Home Selector

installation, 2-34

Oracle Image cartridge

defined, 2-20, 2-32

Oracle Information Navigator, starting, 1-10

Oracle Intelligent Agent

Oracle Java option

defined, 2-21, 2-33, 2-40

Oracle Java Tools

Oracle JDBC Drivers

defined, 2-21, 2-24, 2-32, 2-40

Oracle Migration Assistant for Microsoft Access

defined, 2-33

Named Pipes Protocol Adapter, D-8

Oracle Names

1575 port, D-13

defined, 2-22

OracleHOME_NAMEClientCache80, D-11

OracleHOME_NAMEClientCache80 service, D-11

OracleHOME_NAMENamesService80, D-11

OracleHOME_NAMENamesService80 service, D-11

Oracle Objects for OLE

defined, 2-22, 2-33, 2-40

Oracle Objects option

defined, 2-22, 2-33, 2-40

defined, 2-22

Oracle Open Database Connectivity Driver

Oracle Parallel Server option

Optimal Flexible Architecture, 4-19

defined, 2-23

Oracle Partitioning option

defined, 2-23

Oracle Performance Monitoring snap-in

using, C-19

Oracle Primary snap-in

configuration guidelines, 6-2

Oracle products

for Windows NT and Windows 95/98, 2-8

Oracle Server

defined, 2-23

Oracle Services

auto-starting, 9-8

for Oracle8 database, 3-21

naming conventions for multiple Oracle homes, 9-2

OracleAgent, 9-4

OracleConTextService, 9-4

OracleExtprocAgent, 9-4

OracleServiceSID, 9-4

OracleTNSListener, 9-4

OracleWebAssistant, 9-5

shutting down a database by stopping a service, 9-11

starting, 9-5

stopping, 9-6

viewing in the Control Panel, 3-21

Oracle Services for MTS

defined, 2-23, 2-33, 2-40

defined, 2-6, 2-23, 2-33

Oracle SNMP Agent

configuring, G-4

Oracle SNMP Encapsulator

starting, G-6

Oracle SNMP Master Agent

starting, G-6

Oracle SNMP Master Agent and Encapsulator

controlling, G-6

Oracle Software Packager

Oracle Spatial cartridge

configuration responsibilities, 6-10

configuration tasks, 6-11

Oracle SQLJ Translator

defined, 2-23, 2-40

directory structure, A-6

documentation, 13-3

Oracle Time Series cartridge

configuration responsibilities, 6-13

defined, 2-24

Oracle Universal Installer

advanced replication, 7-6

available database installation types, 7-4

configuration mode created, 7-5

database name created, 7-4

defined, 2-24, 2-34, 2-41

initial archiving mode, 7-5

operating system authentication, 7-7

options, 7-6

schema created, 7-7

system identifier created, 7-4

Oracle Utilities

defined, 2-24, 2-34

Oracle Visual Information Retrieval cartridge

configuration responsibilities, 6-15

Oracle Web Publishing Assistant

defined, 2-24, 2-34

explained, xxviii, 4-16, 4-19

ORACLE_BASE

changing the value, 4-19

ORACLE_BASE parameter, C-6

ORACLE_GROUP_NAME parameter, C-6

ORACLE_HOME

explained, xxviii

ORACLE_HOME directory

explained, 4-21

specifying, 4-23

ORACLE_HOME parameter, C-6

ORACLE_HOME, explained, xxviii

ORACLE_HOME_KEY parameter, C-6

ORACLE_HOME_NAME parameter, C-6

ORACLE_PRIORITY parameter, C-7

ORACLE_SID parameter, C-7

ORACLE_SID parameter, 8-23, 9-4, 9-16

Oracle7 applications, database coexistence, 5-7

Oracle7 Clients

migration to Oracle8, 5-17

Oracle7 database, migrating, 5-21

Oracle8 Buffer Cache, 11-7

Oracle8 Data Dictionary Cache, 11-7

Oracle8 Data Files object, 11-8

Oracle8 database

available Oracle Services, 3-21

connecting to, 9-10, 9-23

password encryption, 9-22

selecting a backup and recovery tool, 12-2

shutting down, 9-10, 9-11

shutting down a database with a service, 9-12

specifications, B-8

starting, 9-10

using Event Viewer, 3-22

using Performance Monitor, 3-24

using User Manager, 3-28

Oracle8 database backup and recovery tools

Recovery Manager (RMAN.EXE), 12-3

OCOPY, 12-3

third-party vendors, 12-3

Oracle8 Free List, 11-9

Oracle8 Library Cache, 11-9

Oracle8 Objects, monitoring, 11-5

Oracle8 Performance Monitor

Oracle8 Redo Log Buffer, 11-8

Oracle8 Sorts, 11-9

Oracle8 Utilities

installation option explained, 2-8

Oracle8i

new features, 2-4

new products, 2-4

Oracle8i Client

directory structure, A-8

Oracle8i database

using Control Panel, 3-21

Oracle8i Enterprise Edition

defined, 2-2

directory structure, A-2

installable products, 2-7

installation option explained, 2-8

OracleAgent, defined, 9-4

OracleConTextService, defined, 9-4

OracleExtprocAgent, defined, 9-4

OracleHOME_NAMEClientCache service, 2-10

OracleHOME_NAMEClientCache80 key, D-2

OracleHOME_NAMEClientCache80 service, D-11

OracleHOME_NAMECMAdminService80 key, D-2

OracleHOME_NAMECMAdminService80 service, 2-10, D-2

OracleHOME_NAMECManService service, D-12

OracleHOME_NAMECManService80 key, D-2

OracleHOME_NAMECManService80 service, 2-10

OracleHOME_NAMENamesService80 service, D-11

OracleHOME_NAMETNSListener service, D-8

OracleHOME_NAMETNSListener80 key, D-2

OracleHOME_NAMETNSListener80 service, 2-10, D-10

OracleHOME_NAMETNSListener80LSNR service, D-10

OracleServiceSID, 9-4

starting the database, 9-11

stopping the database, 9-11

OracleSNMPPeerMasterAgent

MASTER.CFG file, G-9

OracleTNSListener

defined, 9-4

OracleWebAssistant service, defined, 9-5

ORADATA directory, explained, 4-22

ORADEBUG

debugging utility, 9-27

starting, 9-27

ORADIM

changing the INTERNAL password, 9-21

creating an instance, 8-27

modifying an instance, 8-30

moving or copying password files, 9-18

starting an instance, 8-29

stopping an instance, 8-29

ORAPWD

creating password files, 9-17

ORB (Object Request Broker), 2-21, 13-2

ORDSYS user name, 7-10

OS_AUTHENT_PREFIX parameter, 10-26, B-5

OS_ROLES parameter, 10-40

OSD-04018 error, 7-16, 8-3

OUTLN user name, 7-9

of TNSNAMES.ORA file, G-9, G-10

overview

OWAST parameter, C-7

OWAST_HOME parameter, C-7

OWASTDBS parameter, C-7

packaged functions

Intercartridge Exchange, 13-13

UTL_HTTP.REQUEST, 13-14

UTL_HTTP.REQUEST_PIECES, 13-14

parameter mode

Export Utility, 8-12

Import Utility, 8-22

partition

extended, F-2

logical partition, F-4

physical disk, F-4

raw, 4-31, F-2

password file

authenticating database administrators, 9-17

connecting as INTERNAL, 9-20

Password parameter, C-10

Password Utility. See ORAPWD

passwords

PATH parameter, C-8

PATH, changing the value of, 4-10

PERF_FILE_NAME parameter, C-11

PERFORMANCE key, C-9

Performance Monitor, 11-3

defined, 3-24

integration with Oracle8 database, 3-24

monitoring specific Oracle events, 3-24

viewing OPERF.LOG file status, 11-10

Performance Pack, monitoring a database, 11-2

performance, increasing, 4-30

PFILE option, 9-10

PhysicalDrive, F-4

PL/SQL

configuring external procedures, 6-3

external procedures, 13-4

sample programs, location of, A-5

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 13-16

privileges

in Windows NT local groups, 10-30, 10-35, 10-42, 10-44

Pro*C/C++

defined, 2-41

Pro*COBOL

defined, 2-41

PROCESSES parameter, B-5

products

multiple Oracle home products, 4-7

non-multiple Oracle home products, 4-8

single Oracle home products, 4-7

Products supporting multiple Oracle homes, 4-7

program groups

multiple Oracle homes, 4-5, 4-6

Programmer/2000

directory structure, A-11

installation option explained, 2-8

protocol stack vendors, 2-42

PWDSID.ORA file, 9-17

R0703040.SQL, 5-42

RADIUS authentication method

see Oracle Advanced Networking Option

RAID (Redundant Array of Inexpensive Disks), 4-33

RAID configuration, 4-30

raw partition

defined, 4-31, F-2

logical partition, F-4

overview, F-2

physical disk, F-4

RBS tablespace, description, 7-12

RBS01.DBF

RDBMS_ARCHIVE parameter, C-7

RDBMS_CONTROL parameter, C-7

recovering, an Oracle8 database, 12-2

recovery file types, OCOPY, 12-6

Recovery Manager, 12-3

capabilities, 12-3

registering, an external procedure, 13-8

redo log files

starter database, 7-14

REDO01.LOG file, 7-14

REDO02.LOG file, 7-14

REDO03.LOG file, 7-14

REDO04.LOG file, 7-14

REGEDT32 command, 8-23

registry

A2OWIZ81, C-5

adding parameters, C-14

ALL_HOMES subkey, C-8

configuration parameters, C-1

DEFAULT_HOME, C-9

DisplayName, C-11, D-3

modifying values, C-12

ObjectName, C-11, D-3

ORA_SID_AUTOSTART, 9-11, C-5

ORA_SID_PFILE, 9-11, C-5

ORA_SID_SHUTDOWN, 9-12, C-5

ORA_SID_SHUTDOWN_TIMEOUT, 9-13, C-5

ORA_SID_SHUTDOWNTYPE, 9-13, 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_NAMEClientCache80 key, D-2

OracleHOME_NAMECMAdminService80 key, D-2

OracleHOME_NAMECManService80 key, D-2

OracleHOME_NAMETNSListener80 key, D-2

OWAST, C-7

OWAST_HOME, C-7

OWASTDBS, C-7

parameter values, C-2

REG_EXPAND_SZ, C-2, C-15

REG_MULTI_SZ, C-2, C-15

REG_SZ, C-2, C-15

REGEDT32, C-12, C-14

starting, 3-12

update ORACLE_SID, 8-23

Username, 11-3, C-10

using OPERFCFG, C-18

Registry Editor, C-2

registry entries

multiple Oracle homes, 4-5, 4-6

reliability, increasing, 4-30

remote computers, accessing database files, 7-16

REMOTE parameter, D-4

REMOTE_LOGIN_PASSWORDFILE parameter, 9-17, 9-20, B-5

replication, configuration tasks, 6-24

Report View, 11-5

RMAN. See Recovery Manager

roles

granting through Windows NT, 10-40

of COMDEMO user name, 7-10

of CTXSYS user name, 7-10

of DBSNMP user name, 7-9

of DEMO user name, 7-10

of MDSYS user name, 7-10

of MTSSYS user name, 7-9

of ORDSYS user name, 7-10

of OUTLN user name, 7-9

of SCOTT user name, 7-9

of SYS user name, 7-9

of SYSTEM user name, 7-9

rollback segments

contents, 7-15

starter database, 7-15

Schema Manager

schema, INTERNAL user name, 7-9

schemas

importing an DSS sample schema, 8-8

importing an OLTP sample schema, 8-8

SCOTT user name, 7-9

scripts

supported vendors, 2-42, 2-43

SecurID Authentication Adapter

Security Manager

SELECT * FROM ALL_OBJECTS query, 6-25

Server Manager

running multiple instances, 9-16

shutting down the database, 9-10

starting, 3-10, 9-10

starting the database, 9-10

status for release 8.1.4, 3-2

using appropriate version, 5-28

using ORADEBUG, 9-27

using SQL*Plus as an alternative, 3-2

service

how to start and stop, D-10

listed, D-10

service names

multiple Oracle homes, 4-5, 4-6

SERVICE_NAME parameter, 8-15

services, 9-2

auto-starting, 9-8

available with Oracle8 database, 3-21

managing, 9-2

OracleAgent, 9-4

OracleConTextService, 9-4

OracleExtprocAgent, 9-4, 13-11

OracleServiceSID, 9-4

OracleTNSListener, 9-4

OracleWebAssistant, 9-5

shutting down a database by stopping a service, 9-11

starting, 8-16, 9-5

stopping, 9-6

viewing in the Control Panel, 3-21

SET INSTANCE command, 10-33, 10-39, 10-45

SET ORACLE_SID=SID, 9-16

SETLINKS utility, F-10

create symbolic links, F-10, F-12

ignoring links, F-11

removing links, F-11

shared server mode, 6-18, 7-5

same as multi-threaded server mode, 7-5

SHARED_POOL_SIZE parameter, B-5

SHUTDOWN command

options, 9-10

using, 9-10

shutting down

databases, 9-10, 9-11

SID. See system identifier

single log on

for accessing servers and databases, D-7

single Oracle home products, 4-7

Single Sign-On, described, 2-17, 2-30, 2-38

SNA, 2-15, 2-29, 2-37

snap-ins

Oracle Home Configuration, C-16

Oracle Performance Monitoring, C-19

SNMP, G-2

description of support for Oracle products, G-2

in a TCIP/IP network, G-2

managed elements, G-2

management framework, G-2

management station, G-2

master agent, G-2

Oracle SNMPPeerMasterAgent, G-3

OracleSNMPPeerEncapsulator, G-3

subagents, G-2

specifying an archiving file format, 9-25

SPOOL command, using, 6-25, 6-26

SPX

defined, 2-13, 2-28

SPX Protocol Adapter

SQL scripts

SQL Worksheet

SQL*DBA, using appropriate version, 5-28

SQL*Loader

control file conventions, 3-20

direct path option, 3-19

appropriate versions, 5-24, 5-60

using, 3-19

SQL*Net

SQL*Plus

defined, 2-25, 2-34, 2-41

functionality enhancements, 3-2

operating system compatibility, 3-4

starting, 3-18

status for release 8.1.4, 3-2

SQL, external procedures, 13-4

SQLJ. See Oracle SQLJ Translator

SQLNET.AUTHENTICATION_SERVICES parameter, D-6

SQLNET.ORA file, operating system authentication, 10-2

square brackets, defined, xxvii

starter database

starting

databases, 9-10

Oracle Services, 9-5

Oracle8 Performance Monitor, 11-4

Server Manager, 9-10

STARTUP command, 9-10

stopping, Oracle Services, 9-6

stored packages, Intercartridge Exchange, 13-13

striping disks, 4-30

SVRMGR versions, 5-28

SVRMGRL. See Server Manager

symbols, list of, xxix

syntax

for backing up files with OCOPY, 12-5

for recovering files with OCOPY, 12-6

SYS user name, 7-9

changing the password, 7-8, 9-21

connecting without a password, 10-30

SYSDBA

SYSOPER

connecting without a password, 10-30

system identifier

defined, 9-4

for Oracle database, 7-11

multiple Oracle homes, 4-5, 4-6, 7-12

System Network Architecture (SNA), 2-15, 2-29, 2-37

SYSTEM tablespace, description, 7-12

SYSTEM user name, 7-9

changing the password, 7-8, 9-21

SYSTEM01.DBF

Advanced Replication support, 6-23, 6-26

tablespaces

containing INDX01.DBF, 7-13

containing OEMREP01.DBF, 7-13

containing RBS01.DBF, 7-13

containing SYSTEM01.DBF, 7-13

containing TEMP01.DBF, 7-13

containing USERS01.DBF, 7-13

expanding for large sorts, 7-12

INDX, 7-12

RBS, 7-12

starter database, 7-12

TCP/IP

TCP/IP Protocol Adapter

TEMP tablespace, description, 7-12

TEMP01.DBF

TEXT_ENABLE parameter, B-5

third party applications, 5-10

third-party backup and recovery vendors, 12-3

TIMED_STATISTICS parameter, B-5

TKPROF

top-level directory, explained, 4-16

TNS_ADMIN parameter, D-4

TNSNAMES.ORA file, 13-5

overview, G-9, G-10

trace files, 11-14

creating with ORADEBUG, 9-27

for monitoring a database, 11-2

using, 11-14

using BACKGROUND_DUMP_DEST parameter, 11-14

using USER_DUMP_DEST, 11-14

TRANSACTIONS_PER_ ROLLBACK_ SEGMENT parameter, B-5

troubleshooting

Intercartridge Exchange, 13-18

with ORADEBUG, 9-27

U0703040.SQL script, 5-42

U0800030.SQL script, 5-52

U0800040.SQL script, 5-52

U0800050.SQL script, 5-52

UNC, 7-16, 8-3

Universal Naming Convention, 7-16, 8-3

UNIX

Optimal Flexible Architecture, 4-32

upgrading

multiple Oracle homes, 5-5

Optimal Flexible Architecture, 5-61

overview, 5-4

tools, 5-45

U0800020.SQL script, 5-52

U0800030.SQL script, 5-52

U0800040.SQL script, 5-52

U0800050.SQL script, 5-52

USE_SHARED_SOCKET parameter, D-4

User Manager

defined, 3-28

integration with Oracle8 database, 3-28

starting, 3-12

user names

changing passwords for SYS and SYSTEM, 7-8

starter database, 7-8

SYS, 7-9

SYSTEM, 7-9

USER_DUMP_DEST parameter, 8-16, 11-14, B-5

Username parameter, C-10

USERS tablespace, description, 7-12

USERS01.DBF

UTL_HTTP.REQUEST, Intercartridge Exchange, 13-14

UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 13-14

UTLXPLAN.SQL script

variables, convention used, xxvii

viewing

password file, 9-19

Web data, Intercartridge Exchange, 13-12

Windows NT

directory structure for database, A-2

tools, 3-3

Windows NT local groups

with database privileges, 10-3, 10-30, 10-35, 10-42, 10-44

Windows NT Native Authentication Adapter

Windows NT Native authentication methods, use of, 10-2

using, D-6

WINSOCK2 support, D-4

XAVIEW.SQL script