Index

configuration responsibilities, 8-50

configuration tasks, 8-52

creating a SPOOL file, 8-52, 8-53

data dictionary

tables, 8-54

initialization parameter requirements, 8-52

tablespace requirements, 8-51, 8-54

using, 8-55

alert files, 12-14

for monitoring a database, 12-2

using, 12-14

alert view, 12-6

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

ALTER DATABASE CONVERT, 7-32

ALTER DATABASE OPEN RESETLOGS, 7-33

ALTER PACKAGE, using, 8-53

ALTER USER command, 5-6

AmiPro format, supplied external filter, 16-5

API

parameter, C-9

value, C-6

assistant common files, 2-5

assistants

operating system compatibility, 3-3

Oracle Data Migration Assistant, 2-8

Oracle Database Assistant, 2-8

Oracle INTYPE File Assistant, 2-12

Oracle Migration Assistant for Microsoft Access, 2-9

Oracle Net8 Assistant, 2-9

Oracle Net8 Easy Config, 2-9

Oracle Patch Assistant, 2-3

Oracle Web Publishing Assistant, 2-13

audit trail, operating system, 3-20

ASYNC_READ, 7-26

ASYNC_WRITE, 7-26

AUDIT_TRAIL parameter, 12-12

auditing, 12-12

authentication

connecting as INTERNAL without a password, 11-14

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

connecting without a password as a nonprivileged database user, 11-3

creating an operating system-authenticated user, 11-7

granting database roles through Windows NT, 11-18

overview, 11-2

setting OS_AUTHENT_PREFIX, 11-4

setting OSAUTH_PREFIX_DOMAIN, 11-5

SQLNET.ORA file, 11-3

using a password file, 10-18

using Windows NT Native Authentication Adapter, 11-2

auto-starting

Oracle Services, 10-7

BACKGROUND_DUMP_DEST parameter, using with trace files, 12-14

backup

databases, 9-19

OCOPY80 file types, 13-4

backup and recovery tools

Backup Manager, 13-2

NT Backup and Recovery Manager, 13-3

OCOPY80, 13-3

Recovery Manager (RMAN80.EXE), 13-3

selecting, 13-2

third-party backup and recovery vendors, 13-3

Backup Manager

capabilities, 4-16, 13-2

Microsoft Internet Explorer, 1-8, 10-23

Bali, defined, 2-5

browsers

Java-enabled, 1-9

Netscape Navigator, 1-8, 10-23

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

cartridges

configuration guidelines, 8-2

creating data dictionary tables and views, 8-20

CAT8000.SQL, 7-33

CAT8004.SQL, 7-38, 7-42

CATMD.SQL

packages created, 8-20

CATNSNMP.SQL, capabilities, 5-5

CATOUT.LOG file, 7-33

CD-ROMs, order of installation, 2-4

chart view, 12-6

CHECKPOINT_PROCESS, 7-25

COMMIT_POINT_ STRENGTH parameter, B-4

communication daemon, responsibilities, 4-7

COMPANY_NAME parameter, C-6, C-9

COMPATIBLE parameter, 7-32, B-4

compiling

OCI with Oracle XA, 15-12

Oracle XA Library, 15-11

Pro*C with Oracle XA, 15-12

composite jobs, Job Scheduling System, 4-10

configuration parameters

defined, C-2

registry, C-1

configuration requirements

Advanced Replication support, 8-3

for Oracle products, 8-2

multi-threaded external callouts, 8-3

Net8, 8-2

Oracle Enterprise Manager, 8-2

Oracle Parallel Server, 8-2

Oracle8 ConText Cartridge, 8-3

Oracle8 ConText Cartridge System Administration tool, 16-13

Oracle8 ConText Cartridge Workbench demo, 8-38

Oracle8 Image Cartridge, 8-3

Oracle8 Spatial Cartridge, 8-3

Oracle8 Time Series Cartridge, 8-3

Oracle8 Visual Information Retrieval Cartridge, 8-3

PL/SQL external procedures, 8-3

configuration responsibilities

Advanced Replication support, 8-50

Net8, 8-3

Oracle Enterprise Manager, 8-4

Oracle8 ConText Cartridge, 8-21

Oracle8 Image Cartridge, 8-41

Oracle8 Spatial Cartridge, 8-18

Oracle8 Time Series Cartridge, 8-44

Oracle8 Visual Information Retrieval Cartridge, 8-47

configuration tasks

Advanced Replication support, 8-52

Oracle8 ConText Cartridge, 8-29

Oracle8 ConText Cartridge Demos, 8-32

Oracle8 ConText Cartridge demos, 8-32

Oracle8 ConText Cartridge Workbench, 8-33

Oracle8 ConText Cartridge Workbench Demos, 8-38

Oracle8 ConText Cartridge Workbench Viewer Cartridge, 8-33

Oracle8 Image Cartridge, 8-42

Oracle8 Image Cartridge Demos, 8-42

Oracle8 Spatial Cartridge, 8-18

Oracle8 Time Series Cartridge, 8-45

Oracle8 Time Series Cartridge Demos, 8-46

Oracle8 Visual Information Retrieval Cartridge, 8-48

Oracle8 Visual Information Retrieval Cartridge Demos, 8-49

configuring, LISTENER.ORA file, 15-3

CONNECT INTERNAL, 10-20

connecting without a password, 11-14

password, 10-20

using, 10-8, 10-20, F-3

connecting

to a database, 10-8, F-3

console

features, 4-3

Oracle Enterprise Manager, 4-2

windows, 4-5

contact information

documentation sales, 1-2

Legato, 2-6

control files

description, 5-9

starter database, 5-9

Control Panel

defined, 3-19

integration with Oracle8 database, 3-19, 10-3

CONTROL_FILES parameter, 9-9, B-4

conventions, used in this manual, xxi

copy modes, for OCOPY80, 13-4

CORE40 parameter, C-6

CREATE DATABASE statement, 9-11

CREATE LIBRARY command, 15-6

CREATE USER, 11-7

creating, wrappers, 16-7

cross-platform job scripts, 4-10

CTXFORM demo, 8-38

CTXLING, Oracle8 ConText Cartridge demonstration, 8-32

CTXPLUS, Oracle8 ConText Cartridge demonstration, 8-32

Custom Configuration

contents, 5-2

database installation type, 5-2

using Oracle Database Assistant, 5-2

custom database

advanced replication support, 5-2

cartridges and options, 5-2

contents, 5-2

database files, 5-3

database name, 5-2

system identifier, 5-2

tablespaces, 5-3

user names, 5-3

using Oracle Database Assistant, 5-2

Customer Support

contacting, F-6

downloading patches with Oracle Patch Assistant, 10-22

data dictionary

Advanced Replication tables, 8-54

contents, 5-10

description, 5-10

starter database, 5-10

data files

description, 5-8

RBS1SID.ORA, 5-8

starter database, 5-8

SYS1SID.ORA, 5-8

TMP1SID.ORA, 5-8

USR1SID.ORA, 5-8

Data Manager

capabilities, 4-17

Oracle Enterprise Manager, 4-15

database administration applications

Backup Manager, 4-16

common features, 4-18

Data Manager, 4-17

Instance Manager, 4-16

Schema Manager, 4-17

Security Manager, 4-16

Software Manager, 4-18

SQL Worksheet, 4-16

Storage Manager, 4-16

database backup and recovery tools, 13-3

Backup Manager, 13-2

NT Backup and Recovery Manager, 13-2

OCOPY80, 13-3

Recovery Manager (RMAN80), 13-3

third-party vendors, 13-3

database coexistence

issues, 7-4

overview, 7-2

database files

deleting, 9-8

for custom database, 5-3

for starter database, 5-3

database monitoring

using Performance Monitor, 12-3

with alert files, 12-14

with Event Viewer, 12-11

with trace files, 12-14

database name

in Windows NT local groups, 11-10, 11-14, 11-20, 11-22

database privileges

database roles

DBSNMP user name, 5-5

DEMO user name, 5-5

granting through Windows NT, 11-18

MDSYS user name, 5-5

of SYS user name, 5-5

ORDSYS user name, 5-5

SCOTT user name, 5-5

SYSTEM user name, 5-5

database tools

operating system support, 3-2

starting, 3-5

database user, connecting without a password, 11-3

databases

backing up, 9-19

BUILD_DB.SQL script, 9-6

changing passwords, 9-16

coexistence, 7-2

connecting to, 10-8, F-3

contents of starter database, 5-4

control file in starter database, 5-9

creating, 9-1

data dictionary in starter database, 5-10

data files in starter database, 5-8

deleting, 9-8

exporting, 9-7

importing, 9-16

installation in multiple homes, 7-8, 7-15

installation in the same home, 7-7, 7-13

installation on separate computers, 7-9

migrating Microsoft Access, 7-43

migration, 7-3, 7-10

monitoring, 12-1, 12-2

naming conventions, 9-2

Oracle Database Assistant, 9-2

parameters for a new database, B-4

password encryption, 10-21

redo log files in starter database, 5-9

shutting down, 10-8, 10-9, 10-15

starting, 10-8, 10-9

system identifier, 5-6

tablespaces in starter database, 5-7

upgrading, 7-3, 7-11, 7-36

user names in starter database, 5-4

what to do with existing databases, 7-2

DB_BLOCK_SIZE parameter, B-4

DB_FILE_MULTIBLOCK_ READ_ COUNT parameter, B-4

DB_FILE_NAME_CONVERT, 7-26

DB_FILE_SIMULTANEOUS_ WRITES parameter, B-4

DB_FILE_STANDBY_NAME_CONVERT, 7-26

DB_FILES parameter, 9-10, B-4

DB_NAME parameter, 9-9

DB_WRITERS, 7-26

DBA_AUTHORIZATION parameter, 11-14

DBLINK_ENCRYPT_LOGIN parameter, 10-21

DBSNMP user account

dropping with CATNSNMP.SQL, 5-5

DBSNMP user name, 5-5

password, 5-5

DBVERIFY

DEFAULT_HOME parameter, C-10

starting, 3-7

DBWR_IO_SLAVES, 7-26

default control file, CTL1SID.ORA, 5-9

default data files

RBS1SID.ORA, 5-8

SYS1SID.ORA, 5-8

TMP1SID.ORA, 5-8

USR1SID.ORA, 5-8

default initialization parameter file, INITSID.ORA, 5-8

default redo log files

LOG1SID.ORA, 5-9

LOG2SID.ORA, 5-9

LOG3SID.ORA, 5-9

LOG4SID.ORA, 5-9

default tablespaces, 5-7

default user names, 5-4

DEMO user name, 5-5

configuring for Oracle8 Image Cartridge, 8-42

passwords, 5-5

demos

configuring for Oracle8 Time Series Cartridge, 8-46

configuring for Oracle8 Visual Information Retrieval Cartridge, 8-49

Oracle8 ConText Cartridge, 8-32

directory structure

client, A-7

Windows NT Server, A-2

discovering services, for Oracle Enterprise Manager, 8-13

DISK_ASYNCH_IO, 7-26

DISK_FULL error message, D-2

DisplayName parameter, C-14

distributing software

Oracle, 14-2

Systems Management Server, 14-3

DLL, external procedures, 15-5

documentation

Adobe Acrobat Reader, 1-9

finding specific information, 1-8

formats, 1-2

generic, 1-3

HTML, 1-2

included manuals, 1-3

Oracle Information Navigator, 1-2

PDF, 1-2

printed, 1-2

documentation sales, 1-2

documentation set, (list of included manuals), 1-3

DRIVE_LOCKED error message, D-2

encrypting, database passwords, 10-21

error messages

Intercartridge Exchange, 15-19

logging, D-2

ORA-01102, 9-2

ORA-12547, F-2

Oracle Installer, D-2

Oracle8 database, D-4

OSD-04000 to OSD-04099, D-7

OSD-04100 to OSD-04199, D-12

OSD-04200 to OSD-04299, D-14

OSD-04300 to OSD-04399, D-17

OSD-04400 to OSD-04499, D-18

OSD-04500 to OSD-04599, D-18

resolving, F-6

Event Management System

Oracle Enterprise Manager, 4-12

proactive events management, 4-12

Event Management Window, Oracle Enterprise Manager, 4-5

event scripts, with Job Scheduling System, 4-14

Event Viewer, 12-11

34 ID, 12-12

auditing, 12-12

blue (informational) icon, 12-12

defined, 3-20

for monitoring a database, 12-2

IDs other than 34, 12-12

integration with Oracle8 database, 3-20

logging operating system audit trail, 3-20

overview, 3-20

reading, 12-12

red (stop sign) icon, 12-12

yellow (exclamation point) icon, 12-12

using, 12-11

exception conditions, Intercartridge Exchange, 15-19

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

EXECUTE_SQL parameter, C-6

existing databases, installation types, 7-2

EXP80. See Export Utility

Export Utility

databases, 9-7

external filters (supplied), Oracle8 ConText Cartridge, 16-4

redirecting output, D-2

starting, 3-7

EXTERNAL clause, 15-6

external procedures

additional documentation, 15-11

creating a PL/SQL library, 15-6

defined, 15-2

enabling multi-threaded callout support, 15-9

EXTERNAL clause, 15-6

features, 15-2

granting EXECUTE privileges, 15-6

installing, 15-3

registering with Oracle8 database, 15-6

using EXTPROC, 15-3

using Oracle7 network configuration files, 8-2

writing, 15-4

EXTPROC, responsibilities, 15-3

FILE_CORRUPTED error message, D-2

FILE_NOT_FOUND error message, D-2

files

alert, 12-14

assistant common, 2-5

GC_FREELIST_GROUPS, 7-25

GC_ROLLBACK_SEGMENTS, 7-25

GC_SAVE_ROLLBACK_LOCKS, 7-25

GC_SEGMENTS, 7-25

GC_TABLESPACES, 7-25

GLOBAL_NAMES parameter, 9-9

GRANT EXECUTE ON command, 8-54

HOME_COUNTER parameter, C-10

HOME_NAME, defined, xxii

HOMEID

defined, xxii

registry naming convention, C-4

Hostname parameter, 12-4, C-12

hostname value, 12-4

ICX. See Intercartridge Exchange

ID parameter, C-6, C-9

ImagePath parameter, C-14

IMP80. See Import Utility

Import Utility

databases, 9-16

creating a customized version, 5-2

INIT.ORA file. See initialization parameter file

INIT_SQL_FILES, 7-25

initialization parameter file

INITSID.ORA, 5-8

starter database, 5-8

using PFILE option for database startup, 10-8

using the default file for database startup, 10-8

initialization parameter requirements

Advanced Replication Support, 8-52

initialization parameters

installing, Oracle8 ConText Cartridge wrappers and external filters, 16-4

Instance Manager

capabilities, 4-16

Oracle Enterprise Manager, 4-16

instances

running multiple instances, 10-17

starting, 3-15

stopping, 3-15

integrated applications, of Oracle Enterprise Manager, 4-15

Intercartridge Exchange

accessing web data, 15-13

configuring, 15-13

error messages, 15-19

exception conditions, 15-19

packaged functions, 15-15

stored packages, 15-15

troubleshooting, 15-21

using, 15-15

INTERNAL, 11-18

alias for SYS and SYSDBA, 5-4

connecting without a password, 11-14

connecting as, 10-20

password, 5-4, 10-20

user name, 5-4

INVALID_FILE_NAME error message, D-2

IO_TIMEOUT, 7-25

IPQ_ADDRESS, 7-25

IPQ_NET, 7-25

Java Database Connectivity

JDBC OCI Driver, 2-7

JDBC Thin Driver, 2-6

Java Runtime Environment, 2-6

Java-enabled browsers, 1-9

JDBC. See Java Database Connectivity

Job Scheduling System

composite jobs, 4-10

event scripts, 4-14

lights out management, 4-10

optimized intelligent agent, 4-13

Oracle Enterprise Manager, 4-8

predefined event sets, 4-13

predefined job tasks, 4-9

scalability, 4-11, 4-13

scripts, 4-10

security, 4-11

storing and forwarding job scheduling, 4-9

unsolicited error detection, 4-12

Job Scheduling Window, Oracle Enterprise Manager Console, 4-5

JOB_QUEUE_INTERVAL, 7-26

JOB_QUEUE_PROCESSES, 7-26

LAST_HOME parameter, C-10

Legato NetWorker, defined, 2-6

Legato Storage Manager, 2-4

Legato Storage Manager, defined, 2-6

lexical data, loading, 8-26

LEXICAL_ERROR error message, D-2

lights out management, 4-10

linking

OCI with Oracle XA, 15-12

Oracle XA Library, 15-11

Pro*C with Oracle XA, 15-12

LISTENER.ORA file

external procedures, 15-3

migration, 7-19

LM_DOMAINS, 7-25

LM_NON_FAULT_TOLERANT, 7-25

local groups

with database privileges, 11-10, 11-14, 11-20, 11-22

LOCKING_VIOLATION error message, D-3

log view, 12-6

LOG_ARCHIVE_BUFFER_ SIZE parameter, B-4

LOG_ARCHIVE_BUFFERS parameter, B-4

LOG_ARCHIVE_DEST parameter, B-4

LOG_ARCHIVE_FORMAT parameter, B-4

LOG_CHECKPOINT_ INTERVAL parameter, B-4

LOG_FILE_NAME_CONVERT, 7-26

LOG_FILE_STANDBY_NAME_CONVERT, 7-26

LOG_FILES parameter, B-4

LOG_SMALL_ENTRY_MAX_ SIZE parameter, B-4

LOG1SID.ORA file, 5-9

LOG2SID.ORA file, 5-9

LOG3SID.ORA file, 5-9

LOG4SID.ORA file, 5-9

LOGFILE parameter, C-13

logging error messages, D-2

Lotus 123 format, supplied external filter, 16-5

Lotus Freelance format, supplied external filter, 16-5

managing jobs, Oracle Enterprise Manager, 4-12

managing, Oracle Services, 10-2

Map Window, Oracle Enterprise Manager, 4-5

MAX_IO_SIZE, B-5

MDSYS user name, 5-5

creating manually, 8-19

Microsoft Access, migrating to Oracle8, 7-43

password, 5-5

Microsoft Excel format, supplied external filter, 16-5

Microsoft Internet Explorer, 1-8, 10-23

Microsoft PowerPoint format, supplied external filters, 16-5

Microsoft Word format, supplied external filters, 16-5

MIG80. See Migration Utility

migration

instructions, 7-20

LISTENER.ORA file, 7-19

multiple Oracle homes, 7-3

Net8 Listener, 7-17

networking issues, 7-16

Oracle7 Clients, 7-16

overview, 7-3

SQL*Net, 7-17

tools, 7-16

Migration Utility

MTS_MAX_DISPATCHERS parameter, B-5

using, 7-20

MIGSID.ORA file, 7-30, 7-32

monitoring

alert files, 12-2

databases, 12-1

Event Viewer, 12-2

Oracle events, 3-20, 3-22

Oracle8 Objects, 12-6

Performance Monitor, 12-2

Performance Pack, 12-2

trace files, 12-2

MS_HELP parameter, C-6

MSHELP parameter, C-6

MTS_MAX_SERVERS parameter, B-5

MTS_SERVERS parameter, B-5

multiple instances, running, 10-17

multiple Oracle homes, 6-1

ALL_HOMES registry subkey, C-10

defined, xxii, 2-4

environment, 6-4

HOMEID registry naming convention, C-4

impact on registry, C-3

migration, 7-3

overview, 6-2, 7-2

registry subkeys, C-4, C-5

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

system identifier, 5-6

upgrading, 7-3

working with, 6-6

multi-threaded callout support

setting ORA_EXTPROC_THREADED, 15-10

enabling, 15-9

setting OracleExtprocAgent, 15-10

multi-threaded server

configuring with Oracle Database Assistant, 2-8

external callouts supported, 2-4

initialization parameters, B-5

NAME parameter, C-11

naming conventions for multiple Oracle homes, 10-2

Navigator Window, 4-5

NET START command, 9-14

Net8

configuration requirements, 8-2

configuration responsibilities, 8-3

configuring for external procedures, 15-3

products, 2-10

Net8 Client, defined, 2-10

Net8 Listener, migration, 7-17

Net8 Server, defined, 2-10

NET80 parameter, C-6

Netscape Navigator, 1-8, 10-23

networking, migration, 7-16

NLS support, E-2

NLS_LANG environment variable, 7-21

NLS_LANG parameter, C-6, C-10, C-11, E-2

default values, E-2

territory and character set defaults, E-3

NLS_LANGUAGE parameter, B-5

NLS_SORT parameter, B-5

NLS_TERRITORY parameter, B-5

NLSRTL32 parameter, C-6

NLSRTL33 parameter, C-6

NT Backup Manager

NT Recovery Manager

Object Type Translator (OTT), defined, 2-12

ObjectName parameter, C-14

obsolete Oracle7 parameters, 7-25

OCI

defined, 2-7, 2-19

Oracle XA Library, 15-12

OCOPY80

backup file types, 13-4

copy modes, 13-4

recovery file types, 13-6

syntax for backing up files, 13-5

syntax for recovering files, 13-6

ODBC. See Oracle Open Database Connectivity Driver

OI_NLS32 parameter, C-6

OPEN_CURSORS parameter, B-5

operating system

audit trail, 3-20

authentication overview, 11-2

troubleshooting, F-4

operating system authentication

connecting as INTERNAL without a password, 11-14

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

connecting without a password as a nonprivileged database user, 11-3

creating an authenticated user

creating, 11-7

granting database roles through Windows NT, 11-18

setting OS_AUTHENT_PREFIX, 11-4

setting OSAUTH_PREFIX_DOMAIN, 11-5

SQLNET.ORA file, 11-3

OPERF80.LOG file, 12-10

viewing Performance Monitor status, 12-10

OPS$, 11-4

optimized intelligent agent, Job Scheduling System, 4-13

OPTIMIZER_PARALLEL_PASS, 7-25

options

ORA_ENCRYPT_LOGIN parameter, 10-21

ORA_EXTPROC_THREADED

setting for multi-threaded callout support, 15-10

ORA_EXTPROC_THREADED parameter, C-7

ORA_NLS33 parameter, C-7

ORA_SHUTDOWN parameter, C-7

ORA_SHUTDOWN value, 10-15

ORA_SHUTDOWN_TIMEOUT parameter, C-7

ORA_SHUTDOWN_TIMEOUT value, 10-15

ORA_SID_PWFILE parameter, C-7

ORA_SID_SHUTDOWN parameter, C-7

ORA_SID_SHUTDOWN value, 10-15

ORA_SID_SHUTDOWN_TIMEOUT parameter, C-7

ORA_SID_SHUTDOWN_TIMEOUT value, 10-15

ORA-12547 error, F-2

Oracle Administrator Toolbar, defined, 2-7

Oracle Biometrics Manager, defined, 2-7

Oracle Call Interface. See OCI

Oracle Connection Manager, defined, 2-7

Oracle Data Gatherer, 2-3

Oracle Data Gatherer, defined, 2-8

Oracle Data Migration Assistant

defined, 2-8

configuring cartridges, 9-5

using, 7-19, 7-36

Oracle Database Assistant

creating an initialization parameter file, 5-2

defined, 2-8

deleting databases, 9-5

multi-threaded support, 9-5

Oracle DECnet Protocol Adapter, defined, 2-19

Oracle Enterprise Manager

Backup Manager, 4-16, 13-2

common services, 4-6

communication daemon, 4-7

configuration files, 8-13

configuration requirements, 8-2

configuration responsibilities, 8-4

configuration tasks, 8-6

console capabilities, 4-2

console features, 4-3

console windows, 4-5

creating a repository, 8-13

Data Manager, 4-17

database administration applications, 4-15

defined, 2-8

discovering services, 8-13

Event Management System, 4-12

Event Management Window, 4-5

Instance Manager, 4-16

integrated applications, 4-15

Job Scheduling System, 4-8

Job Scheduling Window, 4-5

key components, 4-3

managing jobs, 4-12

Map Window defined, 4-5

Navigator Window, 4-5

operating system compatibility, 3-3

Oracle Intelligent Agent, 4-7

overview, 4-2, 8-4

Performance Pack, 12-2

Replication Manager, integrating, 4-19

Security Manager, 4-16

service discovery, 4-8

setup environments, 8-5

shutting down the database, 10-9

Software Manager, 4-18

SQL Worksheet, 4-16

starting, 3-11

starting the database, 10-9

Storage Manager, 4-16

Tcl scripts

User Manager, 8-9

Oracle Enterprise Manager configuration

creating a repository user account, 8-7

creating an NT user account, 8-9

starting Oracle Services, 8-6

Oracle Enterprise Manager SDK, defined, 2-9

Oracle File Packager, defined, 2-9

Oracle Home Selector, 2-3, 6-6

Oracle home, See multiple Oracle homes

Oracle Information Navigator, starting, 1-8

Oracle Installer

communicating with the console, 4-7

error messages, D-2

Oracle Intelligent Agent

Oracle INTYPE File Assistant, defined, 2-12

overview, 8-4

responsibilities, 4-7

starting, 8-6

Oracle Lock Manager, 12-16

Oracle LU6.2 Protocol Adapter

defined, 2-11, 2-19

Oracle Migration Assistant for Microsoft Access

Oracle Named Pipes Protocol Adapter

defined, 2-11, 2-19

Oracle Names Server

defined, 2-10, 2-18

Oracle Net8 Assistant

Oracle Net8 Easy Config, 8-3

Oracle NetBIOS Protocol Adapter, defined, 2-19

Oracle Objects for OLE, defined, 2-12, 2-19

Oracle Open Database Connectivity Driver, 2-7, 2-19

Oracle Parallel Server Manager Server, defined, 2-12

Oracle Parallel Server Option, 2-3

defined, 2-12

Oracle Parallel Server, configuration requirements, 8-2

Oracle Patch Assistant, 2-3

defined, 2-12

configuration guidelines, 8-2

using, 10-22

Oracle products

for Windows 3.1, 2-18

for Windows NT and Windows 95, 2-5

package definition files, 14-2

Systems Management Server support, 14-2

Oracle Replication Manager, defined, 2-13

Oracle Security Server Manager, defined, 2-13

Oracle Services

auto-starting, 10-7

for Oracle8 database, 3-19

naming conventions for multiple Oracle homes, 10-2

OracleAgent, 10-5

OracleConTextService80, 10-5

OracleExtprocAgent, 10-5

OracleServiceSID, 10-4

OracleStartSID, 10-4

OracleTNSListener80, 10-4

OracleWebAssistant, 10-5

shutting down a database by stopping a service, 10-15

starting, 10-6

stopping, 10-6

viewing in the Control Panel, 3-19

Oracle SPX Protocol Adapter

defined, 2-11, 2-19

Oracle TCP/IP Protocol Adapter

Oracle Trace

Oracle Trace Collection Services, defined, 2-13

Oracle Web Publishing Assistant, defined, 2-13

Oracle WebServer Manager, defined, 2-13

Oracle WebServer, installation sequence, 2-4

Oracle XA Library

additional documentation, 15-13

compiling and linking a Pro*C program, 15-12

compiling and linking an OCI program, 15-12

functions, 15-11

overview, 15-11

ORACLE_GROUP_NAME parameter, C-7, C-10

ORACLE_HOME parameter, C-8, C-10

ORACLE_HOME_NAME parameter, C-8, C-10

ORACLE_HOME_SERVICE parameter, C-8

ORACLE_SID parameter, C-8

ORACLE_SID parameter, 9-17, 10-4, 10-17

Oracle7

changed parameter names in Oracle8, 7-26

obsolete parameters, 7-25

Oracle7 applications, database coexistence, 7-4

Oracle7 Clients

connecting to Oracle8 databases, 7-5

migration, 7-16

migration to Oracle8, 7-12

Oracle7 database, migrating, 7-16

Oracle7 Utilities, defined, 2-14

Oracle8 Buffer Cache, 12-8

Oracle8 Clients, connecting to Oracle7 databases, 7-6

Oracle8 ConText Cartridge

configuration responsibilities, 8-21

configuration tasks, 8-29

configuring Oracle8 ConText Cartridge Configuration Manager, 8-36

configuring Oracle8 ConText Cartridge Workbench Viewer Cartridge, 8-33

creating wrappers, 16-7

defined, 2-14

demons, 8-32

installing wrappers and external filters, 16-4

loading lexical data, 8-26

Oracle8 ConText Cartridge Workbench demo, 8-38

starting servers, 16-2

supplied external filters, setting up, 16-6

upgrading, 8-21

upgrading Oracle8 ConText Cartridge Workbench, 8-33

user defined external filters, 16-11

Oracle8 ConText Cartridge Demos, defined, 2-14

Oracle8 ConText Cartridge I/O Utility, defined, 2-15

Oracle8 ConText Cartridge System Administration

defined, 2-15

tool, 16-13

Oracle8 ConText Cartridge Viewer

defined, 2-15

Oracle8 ConText Cartridge Viewer Cartridge, defined, 2-15

Oracle8 ConText Cartridge Workbench

administration tools, 16-12

defined, 2-14

demo, 16-17

described, 16-12

document viewers, 16-14

I/O Utility, 16-16

TextServer3 Dictionary Migration Tool, 16-16

Oracle8 ConText ConText Cartridge Configuration Manager, defined, 2-14

Oracle8 Data Dictionary Cache, 12-8

Oracle8 Data Files, 12-8

Oracle8 database

Oracle8 database backup and recovery tools

Backup Manager, 13-2

NT Backup and Recovery Manager, 13-2

OCOPY80, 13-3

Recovery Manager (RMAN80.EXE), 13-3

third-party vendors, 13-3

Oracle8 DBWR stats1, 12-9

Oracle8 DBWR stats2, 12-9

Oracle8 Dynamic Space Management, 12-9

Oracle8 Enterprise Edition

defined, 2-2, 2-16

installable products, 2-4

Oracle8 Free List, 12-9

Oracle8 Image Cartridge

configuration responsibilities, 8-41

configuration tasks, 8-42

defined, 2-16

running ORDIINST.SQL, 8-42

Oracle8 Image Cartridge Demos, configuration tasks, 8-42

Oracle8 Library Cache, 12-10

Oracle8 Objects, 12-5

Oracle8 Objects Option, 8-2

Oracle8 Objects Option, defined, 2-16

Oracle8 Objects, monitoring, 12-6

Oracle8 Partioning Option, 8-2

Oracle8 Partitioning Option, defined, 2-16

Oracle8 Performance Monitor

Oracle8 Performance Utility, defined, 2-17

Oracle8 Redo Log Buffer, 12-9

Oracle8 Sorts, 12-10

Oracle8 Spatial Cartridge

configuration responsibilities, 8-18

configuration tasks, 8-18

creating MDSYS user, 8-19

developing applications with SDO80.LIB, 8-20

running CATMD.SQL, 8-20

Oracle8 Spatial Data Cartridge Utilities, defined, 2-17

Oracle8 Time Series Cartridge, 2-3

configuration responsibilities, 8-44

configuration tasks, 8-45

Oracle8 Time Series Cartridge Demos, configuration tasks, 8-46

Oracle8 Utilities

Oracle8 Visual Information Retrieval Cartridge, 2-3

configuration responsibilities, 8-47

configuration tasks, 8-48

Oracle8 Visual Information Retrieval Cartridge Demos, configuration tasks, 8-49

ORACLE80 parameter, C-8

OracleAgent

defined, 10-5

starting, 8-6

OracleConTextService80, defined, 10-5

OracleExtprocAgent, defined, 10-5

OracleServiceSID, defined, 10-4

OracleStartSID, defined, 10-4

OracleTNSListener80, defined, 10-4

OracleWebAssistant, defined, 10-5

ORADEBUG

debugging utility, 10-24

starting, 10-24

ORADIM80

moving or copying password files, 10-20

list of parameters, 3-16

creating password files, 10-18

using, 3-14

ORAPWD80

OraTcl, using with database commands, 4-10

ORDIINST.SQL, running, 8-42

ORDSYS user name, 5-5

OS_AUTHENT_PREFIX parameter, 11-4, B-5

password, 5-5

OS_ERROR error message, D-3

OS_ROLES parameter, 11-18

OSAUTH_PREFIX_DOMAIN parameter, 11-5

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

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

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

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

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

OTRACE73 parameter, C-8

OTT_DFLT parameter, C-8

OTT80 parameter, C-8

overview

managing and distributing Oracle software, 14-2

monitoring a database, 12-2

Oracle Enterprise Manager, 4-2

OWAST parameter, C-8

package definition files, Oracle products, 14-2

packaged functions

Intercartridge Exchange, 15-15

UTL_HTTP.REQUEST, 15-15

UTL_HTTP.REQUEST_PIECES, 15-17

PARALLEL_DEFAUILT_MAX_SCANS, 7-25

PARALLEL_DEFAULT_SCAN_SIZE, 7-25

parameters

defined, C-2

registry, C-1

PARFILE, using, D-2

password file

authenticating database administrators, 10-18

connecting as INTERNAL, 10-20

creating, 10-18

hiding, 10-18

Password parameter, C-12

Password Utility. See ORAPWD80

passwords

changing for SYS user name, 5-6

changing for SYSTEM user name, 5-6

changing with ALTER USER command, 5-6

connecting without an INTERNAL password, 11-14

encryption, 10-21

for databases, 9-16

for DBSNMP user name, 5-5

for DEMO user name, 5-5

for INTERNAL user name, 5-4, 10-20

for MDSYS user name, 5-5

for ORDSYS user name, 5-5

for SCOTT user name, 5-5

for SYS user name, 5-5

for SYSTEM user name, 5-5

patches, downloading from Customer Support, 10-22

PATH, 6-6

PATH parameter, C-11

PDF format, supplied external filter, 16-5

PERF_FILE_NAME parameter, C-13

PERFORMANCE key, C-11

Performance Monitor, 12-3

defined, 3-22

integration with Oracle8 database, 3-22

monitoring specific Oracle events, 3-22

viewing OPERF80.LOG file status, 12-10

Performance Pack, monitoring a database, 12-2

PERMISSION_DENIED error message, D-3

PFILE option, using, 10-8

PL/SQL

configuring external procedures, 8-3

external procedures, 15-2

PLSQL23 parameter, C-8

PLSQL80 parameter, C-8

PLUS_DFLT parameter, C-8

PLUS80 parameter, C-8

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 15-19

predefined event sets

with Job Scheduling System, 4-13

privileges

in Windows NT local groups, 11-10, 11-14, 11-20, 11-22

Pro*C, compiling and linking, 15-12

PRO18 parameter, C-9

PRO80 parameter, C-9

proactive events management

Event Management System, 4-12

PROCESSES parameter, B-5

protocol adapters, defined, 2-11

PUPBLD.SQL, 7-33

PWDSID.ORA file, 10-18

RBS1SID.ORA

RDBMS80_ARCHIVE parameter, C-9

RDBMS73 parameter, C-9

RDBMS80 parameter, C-9

RDBMS80_CONTROL parameter, C-9

READ_ERROR error message, D-3

RECALIBRATION_FAILURE error message, D-3

recovering, an Oracle8 database, 13-2

recovery file types, OCOPY80, 13-6

Recovery Manager, 13-3

registering, an external procedure, 15-6

redo log files

LOG1SID.ORA, 5-9

LOG2SID.ORA, 5-9

LOG3SID.ORA, 5-9

LOG4SID.ORA, 5-9

starter database, 5-9

REGEDT32 command, 9-17

registry

A2OWIZ80, C-6

adding parameters, C-16

ALL_HOMES subkey, C-10

API, C-6

API parameter, C-9

COMPANY_NAME, C-6, C-9

configuration parameters, C-1

CORE40, C-6

HOMEID naming convention, C-4

Hostname, 12-4, C-12

ID, C-6, C-9

ImagePath, C-14

impact of multiple Oracle homes, C-3, C-4, C-5

keys, C-2

LAST_HOME, C-10

LOGFILE, C-13

modifying values, C-14

MS_HELP, C-6

MSHELP, C-6

NAME, C-11

NET80, C-6

NLS_LANG, C-6, C-10, C-11

ORA_EXTPROC_THREADED, C-7

ORA_NLS32, C-7

ORA_NLS33, C-7

ORA_SHUTDOWN, 10-15, C-7

ORA_SHUTDOWN_TIMEOUT, 10-15, C-7

ORA_SID_ SHUTDOWN, C-7

ORA_SID_PWFILE, C-7

ORA_SID_SHUTDOWN, 10-15

ORA_SID_SHUTDOWN_TIMEOUT, 10-15, C-7

Oracle Patch Assistant keys, 10-22

ORACLE_GROUP_NAME, C-7, C-10

ORACLE_HOME, C-8, C-10

ORACLE_HOME_NAME, C-8, C-10

ORACLE_HOME_SERVICE, C-8

ORACLE_SID, C-8

ORACLE80, C-8

OTRACE73, C-8

OTT_DFLT, C-8

OTT80, C-8

OWAST, C-8

parameter values, C-2

Password, C-12

password value, 12-4

PATH, C-11

PERF_FILE_NAME, C-13

PERFORMANCE key, C-11

PLSQL23, C-8

PLSQL80, C-8

PLUS_DFLT, C-8

PLUS80, C-8

PRO18, C-9

PRO80, C-9

REG_EXPAND_SZ, C-2, C-17

REG_MULTI_SZ, C-2, C-17

REG_SZ, C-2, C-17

REGEDT32, C-14, C-16

SHARED_ORACLE_HOME, C-9, C-10

SQLPATH, C-9

REMOTE_LOGIN_PASSWORDFILE parameter, 10-18, 10-20, B-5

SVRMGR, C-9

update ORACLE_SID, 9-17

Username, 12-4, C-12

Registry Editor, C-2

replication, configuration tasks, 8-52

Report View, 12-6

repository database

Oracle Enterprise Manager, 4-14

overview, 8-4

user account, 8-7

Required Support Files

version 7.3.4, 2-18

version 8.0, 2-17

RMAN80. See Recovery Manager

roles

granting through Windows NT, 11-18

MDSYS user name, 5-5

of DBSNMP user name, 5-5

of DEMO user name, 5-5

of SCOTT user name, 5-5

of SYSTEM user name, 5-5

ORDSYS user name, 5-5

SYS user name, 5-5

ROLLBACK_DATA tablespace, description, 5-7

scalability

Job Scheduling System, 4-11

with Job Scheduling System, 4-13

scheduling jobs, Oracle Enterprise Manager, 4-8

Schema Manager

capabilities, 4-17

schema, INTERNAL user name, 5-4

SCOTT user name, 5-5

database roles of, 5-5

password of, 5-5

SDO80.LIB, Oracle8 Spatial Cartridge application development, 8-20

security

of Oracle Enterprise Manager, 4-15

with Job Scheduling System, 4-11

with Oracle Enterprise Manager, 4-15

Security Manager, 4-16

SELECT * FROM ALL_OBJECTS, 8-53

SEQUENCE_CACHE_HASH_BUCKETS, 7-25

SERIALIZABLE, 7-25

Server Manager

running CATREP8M.SQL script, 8-53

running multiple instances, 10-17

shutting down the database, 10-8

starting, 3-9, 10-8, F-3

starting the database, 10-8

using ORADEBUG, 10-24

service discovery, Oracle Enterprise Manager, 4-8

services, 10-2

auto-starting, 10-7

available with Oracle8 database, 3-19

managing, 10-2

OracleAgent, 10-5

OracleConTextService80, 10-5

OracleExtprocAgent, 10-5, 15-10

OracleServiceSID, 10-4

OracleStartSID, 10-4

OracleTNSListener80, 10-4

OracleWebAssistant, 10-5

shutting down a database by stopping a service, 10-15

starting, 9-10, 10-6

stopping, 10-6

viewing in the Control Panel, 3-19

SESSION_CACHED_CURSORS, 7-25

SET INSTANCE command, 11-13, 11-17, 11-23

SET ORACLE_SID=SID, 10-17

SHARED_ORACLE_HOME parameter, C-9, C-10

SHARED_POOL_SIZE parameter, B-5

SHARING_VIOLATION error message, D-3

SHUTDOWN command

options, 10-8

using, 10-8

shutting down

databases, 10-8, 10-9, 10-15

SMS. See Systems Management Server

SNAPSHOT_REFRESH_INTERVAL, 7-26

SNAPSHOT_REFRESH_PROCESSES, 7-26

Software Manager, capabilities, 4-18

SORT_READ_FAC parameter, B-5

SORT_SPACEMAP_SIZES parameter, B-5

SPOOL command, using, 8-52, 8-53

SQL Worksheet

capabilities, 4-16

control file conventions, 3-18

SQL*Loader

direct path option, 3-17

SQL*Net Client, defined, 2-20

using, 3-17

SQL*Net

appropriate versions, 7-17

products, 2-18

SQL*Net Server, defined, 2-18

SQL*Plus

defined, 2-18, 2-20

operating system compatibility, 3-3

starting, 3-14

SQL, external procedures, 15-2

SQLNET.ORA file, operating system authentication, 11-3

SQLPATH parameter, C-9

starter database

advanced replication support, 5-2

cartridges and options, 5-2

contents, 5-2, 5-4

control file, 5-9

data dictionary, 5-10

data files, 5-8

database files, 5-3

database name, 5-2

initialization parameter file, 5-8

redo log files, 5-9

system identifier, 5-2

tablespaces, 5-3, 5-7

Typical Configuration, 5-2

user names, 5-3, 5-4

starting

databases, 10-8, 10-9

Oracle Services, 10-6

Oracle8 Performance Monitor, 12-5

performance monitoring applications, 12-18

Server Manager, 10-8, F-3

STARTUP command

use of, F-3

using, 10-8

stopping, Oracle Services, 10-6

Storage Manager, capabilities, 4-16

stored packages, Intercartridge Exchange, 15-15

SVRMGR parameter, C-9

SVRMGR30. See Server Manager

syntax

for backing up files with OCOPY80, 13-5

for recovering files with OCOPY80, 13-6

SYS user name, 5-5

changing the password, 5-6

database roles of, 5-5

password of, 5-5

SYS1SID.ORA

connecting without a password, 11-10

SYSDBA

SYSOPER

connecting without a password, 11-10

System Administration tool, Oracle8 ConText Cartridge, 16-13

system identifier

defined, 10-4

for Oracle8 database, 5-6

multiple Oracle homes, 5-6

SYSTEM tablespace, description, 5-7

SYSTEM user name, 5-5

changing the password, 5-6

database roles of, 5-5

password of, 5-5

Systems Management Server

capabilities

defined

distributing software, 14-3

Oracle product support, 14-2

package definition files, 14-2

products available for installation, 14-3

tablespaces

Advanced Replication support, 8-51, 8-54

containing RBS1SID.ORA, 5-8

containing SYS1SID.ORA, 5-8

containing TMP1SID.ORA, 5-8

containing USR1SID.ORA, 5-8

expanding for large sorts, 5-7

for custom database, 5-3

for starter database, 5-3

ROLLBACK_DATA, 5-7

starter database, 5-7

SYSTEM, 5-7

TEMPORARY_DATA, 5-7

USER_DATA, 5-7

Tcl

including database commands, 4-10

scripts

TEMPORARY_DATA tablespace, description, 5-7

TEMPORARY_TABLE_ LOCKS parameter, B-5

TextServer3 Dictionary Migration Tool

defined, 2-16

third-party backup and recovery vendors, 13-3

TKPROF

TMP1SID.ORA

external procedures, 15-3

TNSNAMES.ORA file, 15-3

TOO_MANY_OPEN_FILES error message, D-3

Tool Command Language. See Tcl

trace files, 12-14

creating with ORADEBUG, 10-24

for monitoring a database, 12-2

using, 12-14

using BACKGROUND_DUMP_DEST parameter, 12-14

using USER_DUMP_DEST, 12-14

transaction processing monitor

additional documentation, 15-13

interacting with Oracle8 database, 15-11

types, 15-11

TRANSACTIONS_PER_ ROLLBACK_ SEGMENT parameter, B-5

troubleshooting, F-6

Intercartridge Exchange, 15-21

operating system permission problems, F-4

ORA-12203 error, F-2

ORA-12547 error, F-2

ORA-28575 error, F-2

using Oracle Trace, F-5

with ORADEBUG, 10-24

Typical Configuration

contents, 5-2

database installation type, 5-2

UNLIMITED_ROLLBACK_SEGMENTS, 7-25

unsolicited error detection, Job Scheduling System, 4-12

upgrading

external filters for Oracle8 ConText Cartridge, 16-6

multiple Oracle homes, 7-3

Oracle8 ConText Cartridge, 8-21

overview, 7-3

tools, 7-36

wrappers for Oracle8 ConText Cartridge, 16-6

User Manager

for Oracle Enterprise Manager, 8-9

integration with Oracle8 database, 3-26

changing passwords for SYS and SYSTEM, 5-6

user names

DBSNMP, 5-5

DEMO, 5-5

for custom database, 5-3

for starter database, 5-3

INTERNAL, 5-4

MDSYS, 5-5

ORDSYS, 5-5

SCOTT, 5-5

starter database, 5-4

SYS, 5-5

SYSTEM, 5-5

USER_DATA tablespace, description, 5-7

USER_DUMP_DEST parameter, B-5

USER_DUMP_DEST, using, 12-14

Username parameter, C-12

USR1SID.ORA