Index

Microsoft Internet Explorer, 1-9

Bali, defined, 2-7

browsers

Java-enabled, 1-10

Netscape Navigator, 1-9

cartridges

automatically configuring, 6-2

Oracle8 ConText Cartridge, 6-13

in starter database, 3-2

CATNSNMP.SQL, capabilities, 3-4

CHARACTER SET parameter, 9-11

chart view, 11-6

CLIENTS.INI file, F-16

co-existence

databases, 5-2

networking issues, 5-8

COMMIT_POINT_ STRENGTH parameter, B-4

communication daemon, responsibilities, 8-6

COMPANY_NAME parameter, C-3, C-7

COMPATIBLE parameter, B-4

compiling

OCI with Oracle XA, 13-11

Oracle XA Library, 13-10

Pro*C with Oracle XA, 13-10

composite jobs, Job Scheduling System, 8-10

configuration parameters

defined, C-2

registry, C-1

CONNECT INTERNAL

connecting without a password, 10-20

passwords, 10-5, 10-19

using, 10-5, 10-19

CONNECT/AS SYSDBA, 10-18

CONNECT/AS SYSOPER, 10-18

connecting

as INTERNAL, 10-19

to a database, 10-5

with SYSOPER and SYSDBA, 10-18

console

features, 8-3

Oracle Enterprise Manager, 8-2

windows, 8-4

control files

creating with Oracle Database Assistant, 3-2

description, 3-7

starter database, 3-7

Control Panel

defined, 7-7

integration with Oracle8 database, 7-7

starting, 4-8

CONTROL_FILES parameter, 9-8, B-4

conventions, used in this manual, xx

copy modes, for OCOPY80, 12-4

CORE40 parameter, C-3

CREATE DATABASE statement, 9-10

CREATE LIBRARY command, 13-7

CREATE USER command, 10-15

CREATE USER OPS$USERID, using, 10-14

cross-platform job scripts, 8-10

CTXSYS user account, 3-4

database roles, 3-4

manually creating, 6-14

password, 3-4

data dictionary

contents, 3-8

description, 3-8

starter database, 3-8

data files

description, 3-6

RBS1ORCL.ORA, 3-6

starter database, 3-6

Data Manager

database administration applications

Backup Manager, 8-17

common features, 8-18

Data Manager, 8-17

Instance Manager, 8-16

Oracle Enterprise Manager, 8-15

Schema Manager, 8-16

Security Manager, 8-16

Software Manager, 8-18

SQL Worksheet, 8-16

Storage Manager, 8-16

database administrators, authenticating, 10-16

database backup and recovery tools, 12-3

Backup Manager, 12-2

NT Backup and Recovery Manager, 12-2

OCOPY80, 12-3

Recovery Manager (RMAN80), 12-3

third-party vendors, 12-3

database files, deleting, 9-7

database logins, granting, 10-14

database monitoring

using Performance Monitor, 11-3

with alert files, 11-15

with Event Viewer, 11-11

with trace files, 11-15

database roles

CTXSYS user account, 3-4

DBSNMP user account, 3-4

DEMO user account, 3-4

granting, 10-22

of SCOTT user account, 3-4

of SYS user account, 3-4

of SYSTEM user account, 3-4

database tools

operating system support, 4-2

starting, 4-5

databases

DB_BLOCK_SIZE parameter, B-4

DB_FILE_MULTIBLOCK_ READ_ COUNT parameter, B-4

DB_FILE_SIMULTANEOUS_ WRITES parameter, B-4

DB_FILES parameter, 9-9, B-4

DB_NAME parameter, 9-8

DBA authentication, 10-14

DBA_AUTHORIZATION parameter, 10-20

DBLINK_ENCRYPT_LOGIN parameter, 10-25

DBSNMP user account, 3-4

database roles, 3-4

dropping with CATNSNMP.SQL, 3-4

password, 3-4

default control file, CTL1ORCL.ORA, 3-7

default data files

default initialization parameter file, INITORCL.ORA, 3-6

default redo log files

LOG1ORCL.ORA, 3-7

LOG2ORCL.ORA, 3-7

default tablespaces, 3-5

default user accounts, 3-3

DEMO user account, 3-4

database roles, 3-4

passwords, 3-4

directory structure

client, A-5

Windows NT Server, A-2

discovering services, 6-10

DISK_FULL error message, D-2

DisplayName parameter, C-11

distributing software

Oracle, F-2

Systems Management Server, F-18

documentation

Adobe Acrobat Reader, 1-10

finding specific information, 1-8

formats, 1-2

generic, 1-3

HTML, 1-2

included manuals, 1-4

Oracle Information Navigator, 1-2

PDF, 1-2

platform-specific, defined, 1-3

printed, 1-2

DR0INST.SQL, executing, 6-14

DRCRSYST.SQL, executing, 6-14

DRIVE_LOCKED error message, D-2

encrypting, database passwords, 10-25

error messages

Intercartridge Exchange, 13-16

logging, D-2

ORA-01102, 9-2

ORA-12547, 10-2, G-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-17

OSD-04500 to OSD-04599, D-18

Event Management System

Oracle Enterprise Manager, 8-12

proactive events management, 8-12

Event Management Window, Oracle Enterprise Manager, 8-5

event scripts, with Job Scheduling System, 8-14

blue (informational) icon, 11-13

defined, 7-2

for monitoring a database, 11-2

IDs other than 34, 11-13

integration with Oracle8 database, 7-2

logging operating system audit trail, 7-2

overview, 7-2

reading, 11-13

red (stop sign) icon, 11-13

using, 11-11

yellow (exclamation point) icon, 11-13

exception conditions, Intercartridge Exchange, 13-15

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

EXECUTE_SQL parameter, C-3

EXP80. See Export Utility

Export Utility

databases, 9-6

redirecting output, D-2

starting, 4-6

EXTERNAL clause, 13-7

external procedures

additional documentation, 13-9

building, 13-2

building a shared library, 13-6

configuring LISTENER.ORA file, 13-3

configuring TNSNAMES.ORA file, 13-3

creating, 13-2

creating a PL/SQL library, 13-7

defined, 13-2

EXTERNAL clause, 13-7

features, 13-2

granting EXECUTE privileges, 13-7

installing, 13-3

registering with Oracle8 database, 13-7

using EXTPROC, 13-3

writing, 13-5

EXTPROC, responsibilities, 13-3

FILE_CORRUPTED error message, D-2

FILE_NOT_FOUND error message, D-2

files

alert, 11-15

assistant common, 2-7

GLOBAL_NAMES parameter, 9-8

groups

Hostname parameter, 11-4, C-9

hostname value, 11-4

ICX. See Intercartridge Exchange

Identix, 2-9

ImagePath parameter, C-11

IMP80. See Import Utility

Import Utility

databases, 9-14

starting, 4-6

INDEX tablespace, 3-2

INIT.ORA file. See initialization parameter file

initialization parameter file

creating a customized version, 3-2

starter database, 3-6

initialization parameters

Instance Manager

capabilities, 8-16

Oracle Enterprise Manager, 8-16

defined, 7-7, 10-2, Glossary-3

instances

creating, 4-13

deleting, 4-13

editing, 4-14

running multiple instances, 10-13

starting, 4-13

stopping, 4-14

integrated applications

application programmatic interfaces, 10-28

of Oracle Enterprise Manager, 8-15

integration

applications into Oracle Enterprise Manager, 10-28

Oracle8 database and Windows NT, 7-1

Intercartridge Exchange

accessing web data, 13-11

configuring, 13-11

error messages, 13-16

exception conditions, 13-15

packaged functions, 13-12

stored packages, 13-12

troubleshooting, 13-17

using, 13-12

INTERNAL

alias for SYS and SYSDBA, 3-3

connecting without a password, 10-20

connecting as, 10-19

password of, 3-3

passwords, 10-5, 10-19

user account, 3-3

INVALID_FILE_NAME error message, D-2

Java Database Connectivity

OCI Driver, 2-6

Thin Client Driver, 2-6

Java Runtime Environment, 2-6

Java-enabled browsers, 1-10

JDBC. See Java Database Connectivity

Job Scheduling System

composite jobs, 8-10

event scripts, 8-14

lights out management, 8-9

optimized intelligent agent, 8-14

Oracle Enterprise Manager, 8-7

predefined event sets, 8-13

predefined job tasks, 8-8

scalability, 8-11, 8-13

scripts, 8-10

security, 8-11

storing and forwarding job scheduling, 8-9

unsolicited error detection, 8-12

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

LEXICAL_ERROR error message, D-2

lights out management, 8-9

linking

OCI with Oracle XA, 13-11

Oracle XA Library, 13-10

Pro*C with Oracle XA, 13-10

LISTENER.ORA file, external procedures, 13-3

LOCKING_VIOLATION error message, D-3

log view, 11-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_FILES parameter, B-4

LOG_SMALL_ENTRY_MAX_ SIZE parameter, B-4

LOG1ORCL.ORA file, 3-7

LOG2ORCL.ORA file, 3-7

LOGFILE parameter, 9-10, C-10

logging error messages, D-2

managing jobs, Oracle Enterprise Manager, 8-12

Map Window, Oracle Enterprise Manager, 8-5

MAXDATAFILES parameter, 9-10

Microsoft Internet Explorer, 1-9

MIG80. See Migration Utility

migration

Migration Utility (MIG80), 5-16

Oracle Data Migration Assistant, 5-14

Oracle Migration Assistant for Microsoft Access, 5-24

migration utility

monitoring

Oracle events, 7-2, 7-3

Oracle8 Objects, 11-6

Performance Monitor, 11-2

Performance Pack, 11-2

trace files, 11-2

MS_HELP parameter, C-3

MSHELP parameter, C-3

MTS_MAX_DISPATCHERS parameter, B-4

MTS_MAX_SERVERS parameter, B-5

MTS_SERVERS parameter, B-5

multi-threaded server (MTS), 2-3

Navigator Window, 8-4

NET START command, 9-11

Net8

configuring for external procedures, 13-3

configuring, 6-3

products, 2-10

protocol adapters, 2-10

NET80 parameter, C-3

Netscape Navigator, 1-9

network security and single sign-on Biometric Manager, 8-21

NLS support, E-2

NLS_LANG parameter, C-4, C-7, 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-4

NLSRTL33 parameter, C-4

NOARCHIVELOG parameter, 9-11

nonprivileged users, authenticating, 10-14

NT Backup Manager

capabilities, 12-3

operatiing system compatibility, 4-3

NT Recovery Manager

capabilities, 12-3

starting, 4-12

ObjectName parameter, C-11

OCI

defined, 2-8

Oracle XA Library, 13-11

OCOPY80

backup file types, 12-4

capabilities, 12-3

copy modes, 12-4

recovery file types, 12-6

starting, 4-7

syntax for backing up files, 12-5

syntax for recovering files, 12-6

OCSM. See Oracle Client Software Manager

ODBC. See Oracle Open Database Connectivity Driver

OPEN_CURSORS parameter, B-5

operating system

audit trail, 7-2

authentication, 10-18

troubleshooting, G-2

OPERF80.LOG file, 11-11

viewing Performance Monitor status, 11-11

OPS$, 10-14

optimized intelligent agent, Job Scheduling System, 8-14

ORA_ENCRYPT_LOGIN parameter, 10-25

ORA_NLS33 parameter, C-4

ORA_ORCL_PWFILE parameter, C-4

ORA_SHUTDOWN parameter, C-4

ORA_SHUTDOWN value, 10-12

ORA_SHUTDOWN_TIMEOUT parameter, C-5

ORA_SHUTDOWN_TIMEOUT value, 10-12

ORA_SID_ SHUTDOWN_TIMEOUT parameter, C-4

ORA_SID_ SHUTDOWN_TIMEOUT value, 10-12

ORA_SID_ROLENAME

use of, 10-21

ORA_SID_SHUTDOWN parameter, C-4

ORA_SID_SHUTDOWN value, 10-12

ORA-12547 error, 10-2, G-2

Oracle Administrator Toolbar, defined, 2-9

Oracle Biometrics Manager, defined, 2-9

Oracle Call Interface. See OCI

Oracle Client Configuration Manager, defined, 2-9

Oracle Client Software Agent, defined, 2-9

Oracle Client Software Manager

access to Oracle home, F-8

capabilities, F-2

client user vs. administrator options, F-11

CLIENTS.INI file, F-16

creating a host machine, F-6

defining conflict resolution, F-14

distributing software, F-17

installation requirements, F-3

Microsoft remote registry service, F-4

registering the client machine, F-8

using, F-14

Oracle Data Migration Assistant, 5-14

defined, 2-3

Oracle Database Assistant, 9-2

cartridges, 3-2

creating an additional control file, 3-2

creating an initialization parameter file, 3-2

defined, 2-3

typical and custom options, 3-2

Oracle Enterprise Manager

applications, integrating, 10-28

Backup Manager, 8-17, 12-2

common services, 8-5

communication daemon, 8-6

configuration files, creating, 6-10

console features, 8-3, 10-25

console capabilities, 8-2

console windows, 8-4

console, using, 10-25

Data Manager, 8-17

database administration applications, 8-15

defined, 2-9

Event Management System, 8-12

Event Management Window, 8-5

Instance Manager, 8-16

integrated applications, 8-15

Job Scheduling System, 8-7

Job Scheduling Window, 8-5

key components, 8-3

logging on to the console, 10-26

managing jobs, 8-12

Map Window defined, 8-5

maps, creating, 10-27

Navigator, 10-27

Navigator view, 10-27

Navigator Window, 8-4

Oracle Advanced Networking Option, integrating, 8-21

Oracle Intelligent Agent, 8-6

Oracle Media Server, integrating, 8-19

Oracle Parallel Server, integrating, 8-20

Oracle Web Application Server, integrating, 8-21

overview, 8-2

Performance Pack, 11-2

repository, 8-14

repository, creating, 6-10

scheduling jobs, 8-7

Schema Manager, 8-16

security, 8-15

Security Manager, 8-16

service discovery, 8-7

services, discovering, 6-10

simple single tasks, 10-26

Software Manager, 8-18

SQL Worksheet, 8-16

starting, 4-8

Storage Manager, 8-16

Tcl scripts

User Manager, 6-7

user-defined groups, creating, 10-27

Oracle Enterprise Manager configuration, 6-4

creating a repository user account, 6-5

creating an NT user account, 6-6

overview, 6-4

starting Oracle Services, 6-5

Oracle Enterprise Manager SDK, defined, 2-10

Oracle Expert, 11-20

Oracle home

database co-existence, 5-10

defined, xxi

Oracle Information Navigator, 1-2

Oracle Information Navigator, starting, 1-8

Oracle Installer

defined, 2-5

error messages, D-2

Oracle instance. See instances, 7-7

Oracle Intelligent Agent

communicating with the console, 8-6

defined, 2-10

overview, 6-4

responsibilities, 8-6

starting, 6-5

ORACLE key, C-3

Oracle Lock Manager, 11-17

Oracle Migration Assistant for Microsoft Access

using, 5-24

Oracle Net8 Assistant

defined, 2-4

Oracle Net8 Easy Config, starting, 4-11

Oracle Objects for OLE, defined, 2-8

Oracle Open Database Connectivity Driver, 2-8

Oracle products

package definition files, F-18

Systems Management Server support, F-18

Oracle Security Server Manager, defined, 2-9

Oracle Services

auto-starting, 10-4

creating with ORADIM80, 10-3

defined, 7-7

for Oracle8 database, 7-7

shutting down a database, 10-12

stopping, 10-4

viewing in the Control Panel, 7-7

Oracle tool, defined, Glossary-6

Oracle Trace

overview, 11-19

starting, 11-19

troubleshooting, G-3

Oracle Video Cartridge, 2-4

Oracle Web Application Server, 2-4

Oracle Web Publishing Assistant

defined, 2-4, 7-8

Oracle WebServer Manager, defined, 2-9

Oracle XA Library

additional documentation, 13-11

compiling and linking a Pro*C program, 13-10

compiling and linking an OCI program, 13-11

functions

overview, 13-10

ORACLE_GROUP_NAME parameter, C-5, C-7

ORACLE_HOME parameter, C-5, C-7

ORACLE_SID parameter, 9-15, 10-2, C-5

Oracle8

defined, 2-2

installable products, 2-4

key features, 2-2

new features, 2-3

Oracle8 Buffer Cache, 11-8

Oracle8 ConText Cartridge

running server processes, 6-16

defined, 2-7

starting servers, 6-16

Oracle8 ConText Cartridge Demos, 14-7

defined, 2-7

list of, 14-7

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

Oracle8 ConText Cartridge System Administration, defined, 2-8

Oracle8 ConText Cartridge Viewer

defined, 2-8

Oracle8 ConText Cartridge Workbench

defined, 2-8

overview, 14-7

Oracle8 ConText Filters

creating wrappers, 14-4

Oracle8 Data Dictionary Cache, 11-8

Oracle8 Data Files, 11-9

Oracle8 database

authenticating database administrators, 10-16

authenticating database users, 10-14

available Oracle Services, 7-7

cartridges in starter database, 3-2

granting database logins, 10-14

granting database roles with Windows NT, 10-22

included cartridges, 3-2

informal name for Oracle8 Enterprise Edition, Glossary-6

integration with Windows NT, 7-1

operating system permission problems, G-2

password encryption, 10-25

selecting a backup and recovery tool, 12-2

shutting down, 10-5

shutting down a database with a service, 10-12

starter database, 3-2

starter database contents, 3-3

starter database control file, 3-7

starter database data dictionary, 3-8

starter database data files, 3-6

starter database initialization parameter file, 3-6

starter database redo log files, 3-7

starter database tablespaces, 3-5

starter database user accounts, 3-3

starting, 10-5

transaction processing monitor, 13-10

typical option, 3-2

using Control Panel, 7-7

using Event Viewer, 7-2

using Performance Monitor, 7-3

using User Manager, 7-9

Oracle8 database backup and recovery tools

Backup Manager, 12-2

NT Backup and Recovery Manager, 12-2

OCOPY80, 12-3

Recovery Manager (RMAN80.EXE), 12-3

third-party vendors, 12-3

Oracle8 DBWR stats1, 11-9

Oracle8 DBWR stats2, 11-9

Oracle8 Dynamic Space Management, 11-10

Oracle8 Enterprise Edition

defined, Glossary-6

formal name for Oracle8 database, Glossary-6

Oracle8 Free List, 11-10

Oracle8 Libary Cache, 11-10

Oracle8 Objects, 11-5, 11-12

monitoring, 11-6

Oracle8 Performance Monitor

Oracle8 Performance Utility, defined, 2-8

Oracle8 Redo Log Buffer, 11-10

Oracle8 Sorts, 11-10

Oracle8 Utilities

defined, 2-6

operating system compatibility, 4-2

ORACLE80 parameter, C-5

OracleAgent

defined, 7-7, 10-3

OracleClientCache80 key, C-11

OracleConTextService80

defined, 7-7, 10-3

OracleNames80 key, C-11

OracleServiceORCL

OracleServiceSID key, C-11

OracleStartORCL

OracleStartSID key, C-11

OracleTNSListener80

OracleTNSListener80 key, C-11

OracleWebAssistant key, C-11

OracleWebAssistant, defined, 10-3

ORADIM80

creating Oracle Services, 10-3

list of parameters, 4-15

moving or copying password files, 10-17

starting, 4-5

using, 4-13

ORAPWD80

creating password files, 10-16

starting, 4-7

using, 10-19

OraTcl, using with database commands, 8-10

OS_AUTHENT_PREFIX parameter, B-5

OS_AUTHENT_PREFIX, setting, 10-14

OS_AUTHENT_PREFIX, using, 10-14

OS_ERROR error message, D-3

OS_ROLES, using, 10-22

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

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

OTRACE73 parameter, C-5

OTT_DFLT parameter, C-5

OTT80 parameter, C-5

overview

managing and distributing Oracle software, F-2

monitoring a database, 11-2

Oracle Enterprise Manager, 8-2

OWAST parameter, C-5

package definition files, Oracle products, F-18

packaged functions

Intercartridge Exchange, 13-12

UTL_HTTP.REQUEST, 13-13

UTL_HTTP.REQUEST_PIECES, 13-13

parameters

defined, C-2

registry, C-1

PARFILE, using, D-2

password file

authenticating database administrators, 10-16

creating, 10-16

modifying with Server Manager, 10-17

Password parameter, C-9

Password Utility. See ORAPWD80

passwords

changing for SYS user account, 3-5

changing for SYSTEM user account, 3-5

changing with ALTER USER command, 3-5

connecting without an INTERNAL password, 10-20

encryption, 10-25

for CTXSYS user account, 3-4

for databases, 9-14

for DBSNMP user account, 3-4

for DEMO user account, 3-4

for INTERNAL user account, 3-3, 10-5, 10-19

for SCOTT user account, 3-4

for SYS user account, 3-4

for SYSTEM user account, 3-4

PERF_FILE_NAME parameter, C-10

PERFORMANCE key, C-8

Performance Monitor, 11-3

defined, 7-3

integration with Oracle8 database, 7-3

monitoring specific Oracle events, 7-3

viewing OPERF80.LOG file status., 11-11

Performance Pack, monitoring a database, 11-2

PERMISSION_DENIED error message, D-3

PL/SQL, external procedures, 13-2

PLSQL23 parameter, C-5

PLSQL80 parameter, C-5

PLUS_DFLT parameter, C-5

PLUS80 parameter, C-5

PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 13-15

predefined event sets, with Job Scheduling System, 8-13

Pro*C, compiling and linking, 13-10

PRO18 parameter, C-6

PRO80 parameter, C-6

proactive events management

Event Management System, 8-12

PROCESSES parameter, B-5

protocol adapters, defined, Glossary-7

PWDSID.ORA file, 10-16

RBS1ORCL.ORA

RDBMS80_ARCHIVE parameter, C-6

RDBMS73 parameter, C-6

RDBMS80 parameter, C-6

RDBMS80_CONTROL parameter, C-6

READ_ERROR error message, D-3

RECALIBRATION_FAILURE error message, D-3

recovering, an Oracle8 database, 12-2

recovery file types, OCOPY80, 12-6

Recovery Manager (RMAN80)

redo log files

starter database, 3-7

REGEDT32 command, 9-15

registering, an external procedure, 13-7

registry

A2OW1Z15, C-3

adding parameters, C-15

API, C-3

API parameter, C-7

COMPANY_NAME, C-3, C-7

configuration parameters, C-1

CORE40, C-3

DisplayName, C-11

EXECUTE_SQL, C-3

Hostname, C-9

Hostname parameter, 11-4

ImagePath, C-11

keys, C-2

LOGFILE, C-10

modifying values, C-12

MS_HELP, C-3

MSHELP, C-3

NET80, C-3

ORA_SHUTDOWN, 10-12, C-4

ORA_SHUTDOWN_TIMEOUT, 10-12, C-5

ORA_SID_ SHUTDOWN, 10-12, C-4

ORA_SID_SHUTDOWN_TIMEOUT, 10-12, C-4

ORACLE key, C-3

ORACLE_GROUP_NAME, C-5, C-7

ORACLE_HOME, C-5, C-7

ORACLE_SID, C-5

ORACLE80, C-5

OracleClientCache80 key, C-11

OracleNames80 key, C-11

OracleServiceSID key, C-11

OracleStartSID key, C-11

OracleTNSListener80 key, C-11

OracleWebAssistant key, C-11

OTRACE73, C-5

OTT_DFLT, C-5

OTT80, C-5

OWAST, C-5

parameter values, C-2

PLUS80, C-5

PRO18, C-6

PRO80, C-6

REG_EXPAND_SZ, C-2, C-15

REG_MULTI_SZ, C-2, C-15

REG_SZ, C-2, C-15

REGEDT32, C-12, C-15

SHARED_ORACLE_HOME, C-6, C-7

SQLPATH, C-6

SVRMGR, C-6

update ORACLE_SID, 9-15

Username, C-9

Username parameter, 11-4

Registry Editor, C-2

REMOTE_LOGIN_ PASSWORDFILE parameter, B-5

REMOTE_LOGIN_PASSWORDFILE

operating system authentication, 10-18

setting, 10-19

Report View, 11-6

repository user account, 6-5

repository, Oracle Enterprise Manager, 8-14

Required Support Files

roles

of CTXSYS user account, 3-4

of DBSNMP user account, 3-4

of DEMO user account, 3-4

of SCOTT user account, 3-4

of SYS user account, 3-4

of SYSTEM user account, 3-4

ROLLBACK_DATA tablespace, description, 3-5

scalability

Job Scheduling System, 8-11

with Job Scheduling System, 8-13

scheduling jobs, Oracle Enterprise Manager, 8-7

Schema Manager

capabilities, 8-16

schema, INTERNAL user account, 3-3

SCOTT user account, 3-4

database roles of, 3-4

password of, 3-4

security

of Oracle Enterprise Manager, 8-15

with Job Scheduling System, 8-11

with Oracle Enterprise Manager, 8-15

Security Manager, 8-16

granting database logins, 10-14

Server Manager

running multiple instances, 10-13

shutting down the database, 10-5

starting, 4-6, 10-5

starting the database, 10-5

user password file information, 10-17

server processes, Oracle8 ConText Cartridge, 6-16

service discovery, Oracle Enterprise Manager, 8-7

services

auto-starting, 10-4

available with Oracle8 database, 7-7

creating, 9-9

creating with ORADIM80, 10-3

OracleAgent, 10-3

OracleConTextService80, 10-3

OracleServiceORCL, 10-2

OracleStartORCL, 10-2

OracleTNSListener80, 10-2

OracleWebAssistant, 10-3

shutting down a database, 10-12

starting, 9-9, 10-2

starting Oracle Services, 10-2

stopping, 10-4

viewing in the Control Panel, 7-7

SET ORACLE_SID=SID, 10-13

shared library, external procedures, 13-6

SHARED_ORACLE_HOME parameter, C-6, C-7

SHARED_POOL_SIZE parameter, B-5

SHARING_VIOLATION error message, D-3

SHUTDOWN command

options, 10-6

using, 10-6

shutting down, databases, 10-5

SID. See system identifier

SMS. See Systems Management Server

Software Manager, capabilities, 8-18

SORT_READ_FAC parameter, B-5

SORT_SPACEMAP_SIZES parameter, B-5

SQL Worksheet

capabilities, 8-16

control file conventions, 4-16

SQL*Loader

direct path option, 4-16

SQL*Net version 2

SQL*Plus

SQL, external procedures, 13-2

starting, 4-12

SQLPATH parameter, C-6

starter database, Glossary-10

default SID and database name, 3-2

initialization parameter file, 3-6

Oracle8 database, 3-2

starting

Oracle Services, 10-2

Oracle8 Performance Monitor, 11-5

performance monitoring applications, 11-20

Server Manager, 10-5

STARTUP, use of, 10-5

stopping, Oracle Services, 10-4

Storage Manager, capabilities, 8-16

stored packages, Intercartridge Exchange, 13-12

SVRMGR parameter, C-6

SVRMGR30. See Server Manager

syntax

for backing up files with OCOPY80, 12-5

for recovering files with OCOPY80, 12-6

SYS user account, 3-4

changing the password, 3-5

database roles of, 3-4

password of, 3-4

SYS1ORCL.ORA

SYSDBA, connecting as, 10-18

SYSOPER, connecting as, 10-18

system identifier

SYSTEM tablespace, description, 3-5

in starter database, 3-2

SYSTEM user account, 3-4

changing the password, 3-5

database roles of, 3-4

password of, 3-4

Systems Management Server

capabilities

defined, 2-3

distributing software, F-18

Oracle product support, F-18

package definition files, F-18

products available for installation, F-18

tablespaces

containing RBS1ORCL.ORA, 3-6

containing SYS1ORCL.ORA, 3-6

containing TMP1ORCL.ORA, 3-6

containing USR1ORCL.ORA, 3-6

creating an extra tablespace, 3-2

expanding for large sorts, 3-5

INDEX, 3-2

ROLLBACK_DATA, 3-5

starter database, 3-5

SYSTEM, 3-5

TEMPORARY_DATA, 3-5

USER_DATA, 3-5

Tcl

including database commands, 8-10

scripts

TEMPORARY_DATA tablespace, description, 3-5

TEMPORARY_TABLE_ LOCKS parameter, B-5

third-party backup and recovery vendors, 12-3

TMP1ORCL.ORA

TNSNAMES.ORA file, external procedures, 13-3

TOO_MANY_OPEN_FILES error message, D-3

Tool Command Language. See Tcl

trace files, 11-15

for monitoring a database, 11-2

using, 11-15

using BACKGROUND_DUMP_DEST parameter, 11-15

using USER_DUMP_DEST, 11-15

transaction processing monitor

additional documentation, 13-11

interacting with Oracle8 database, 13-10

types, 13-10

TRANSACTIONS_PER_ ROLLBACK_ SEGMENT parameter, B-5

troubleshooting

Intercartridge Exchange, 13-17

operating system permission problems, G-2

ORA-12547 error, 10-2, G-2

using Oracle Trace, G-3

typical option, database type, 3-2

unsolicited error detection, Job Scheduling System, 8-12

user accounts

changing passwords for SYS and SYSTEM, 3-5

CTXSYS, 3-4

DBSNMP, 3-4

DEMO, 3-4

INTERNAL, 3-3

SCOTT, 3-4

starter database, 3-3

SYS, 3-4

SYSTEM, 3-4

User Manager

defined, 7-9

for Oracle Enterprise Manager, 6-7

integration with Oracle8 database, 7-9

starting, 4-8

USER_DATA tablespace, description, 3-5

USER_DUMP_DEST parameter, B-5

USER_DUMP_DEST, using, 11-15

Username parameter, C-9

USR1ORCL.ORA

UTL_HTTP.REQUEST, Intercartridge Exchange, 13-13

UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 13-13

web data, Intercartridge Exchange

Windows NT

directory structure for database, A-2

tools, 4-2

user account, 6-6

wizards

Oracle Data Migration Assistant, 2-3, 5-14

Oracle Database Assistant, 2-3, 9-2

Oracle INTYPE File Assistant, 2-4

Oracle Migration Assistant for Microsoft Access, 5-24

Oracle Web Publishing Assistant, 2-4