Before You Begin

1 Getting Started with Your Documentation

Documentation Formats

What Documentation Did I Receive?

Online Documentation Set

What Documentation Do I Read First?

Starting Oracle Information Navigator

Starting Adobe Acrobat Reader

2 Introducing Oracle8 Enterprise Edition

Oracle8 Enterprise Edition Overview

New Products and Features in This Release

Oracle SNMP Support

New Names for Upgrading and Downgrading Scripts

Task Page

What Products are on the CD-ROM?

Oracle Products for Windows NT, Windows 95, and Windows 98

Oracle Products for Windows 3.1x

3 Database Tools Overview

4 Oracle Enterprise Manager Overview

Oracle Enterprise Manager Overview

Oracle Enterprise Manager Components

Oracle Enterprise Manager Console Features

Common Services for Managing Databases

Integrated Applications

5 Starter Database Contents

Starter Database Guide

Starter Database Contents

Initialization Parameter File

6 Using Multiple Oracle Homes

Multiple Oracle Homes Overview

What Is Different About a Multiple Oracle Home Environment?

Which Products Are Multiple Oracle Home Enabled?

Multiple Oracle Home Enabled

Multiple Oracle Home Compliant

Non-Multiple Oracle Home

Product Installation Recommendations

Working with Multiple Oracle Homes

Changing the Value of PATH

7 Database Coexistence and Migration

Intended Audience

What To Do With Previous Oracle Database Releases

Database Coexistence and Multiple Oracle Homes Overview

Migrating, Upgrading, and Downgrading Overview

What is Migrating?

What is Upgrading?

What is Downgrading?

Migrating and Upgrading Using Multiple Oracle Homes

Checklist of Database Release Numbers

Export/Import Overview

Version 8 and Version 7 Client/Server Configurations

Install Oracle7 and Oracle8 Databases in the Same Oracle Home

Install Oracle7 and Oracle8 Databases in Multiple Oracle Homes

Install Oracle7 and Oracle8 Databases on Separate Computers

Migrate an Oracle7 Database to an Oracle8 Database

Upgrade an Oracle8 Database to the Current Oracle8 Database Release

Migrate Oracle7 Clients to Oracle8

Installing Two or More Databases Into the Same Oracle Home

Installing Databases Into Multiple Oracle Homes

Migrating an Oracle7 Database to Version 8

Migration Networking Issues

Migrating Using Oracle Data Migration Assistant

Migrating Using MIG80

Upgrading an Oracle8 Database Release 8.0.x to 8.0.5

Upgrading Using Oracle Data Migration Assistant

Upgrading Using SQL Scripts

Downgrading an Oracle8 Database to Release 8.0.x or Version 7

Migrating a Microsoft Access Database

Known Issues, Restrictions and Workarounds

8 Post-Installation Configuration Tasks

What Must You Configure?

Net8

Oracle Enterprise Manager

Step 1: Start Oracle Services on Managed Oracle8 Database

Step 2: Create a Repository User Account

Step 3: Create a Windows NT User Account on Managed Oracle8 Database Server

Step 4: Create Network Configuration Files

Step 5: Create the Repository and Discover Services

Oracle8 Spatial Cartridge

Configuring Oracle8 Spatial Cartridge

Oracle8 ConText Cartridge

Upgrading Oracle8 ConText Cartridge

Configuring Oracle8 ConText Cartridge

Configuring the CTXLING, CTXPLUS, and CTXQUERY Demos

Oracle8 ConText Cartridge Workbench

Upgrading Oracle8 ConText Cartridge Workbench

Configuring Oracle8 ConText Cartridge Viewer Cartridge

Configuring Oracle8 ConText Cartridge Configuration Manager

Configuring Oracle8 ConText Cartridge Workbench Demo

Oracle8 Image Cartridge

Configuring Oracle8 Image Cartridge

Configuring Oracle8 Image Cartridge Demos

Oracle8 Time Series Cartridge

Configuring Oracle8 Time Series Cartridge

Configuring Oracle8 Time Series Cartridge Demos

Oracle8 Visual Information Retrieval Cartridge

Configuring Oracle8 Visual Information Retrieval Cartridge

Configuring Oracle8 Visual Information Retrieval Cartridge Demos

Advanced Replication

Configuring Advanced Replication Support

9 Creating a Database

Before You Create a Database

Naming Conventions for Oracle8 Databases

Installing Oracle8 Server (the Database Component)

Creating a Database Overview

Using Oracle Database Assistant

Configure Oracle8 Cartridges Using Oracle Database Assistant

Delete a Database Using Oracle Database Assistant

Enable and Disable Multi-Threaded Support Using Oracle Database Assistant

Using BUILD_DB.SQL

Create \MYDIR Directory

Export an Existing Database

Delete Database Files

Modify the INITSID.ORA File

Create and Start an Oracle8 Service

Put CREATE DATABASE Statement in a Script

Create a Database

Import a Database

Update ORACLE_SID in the Registry

Back Up the New Database

Using ORADIM80 to Administer the Oracle Instance

Creating an Instance

Starting an Instance

Stopping an Instance

Modifying an Instance

Deleting an Instance

10 Administering a Database

Managing Oracle Services

Oracle Service Naming Conventions for Multiple Oracle Homes

Available Oracle Services

Starting Oracle Services

Stopping Oracle Services

Auto-starting Oracle Services

Starting and Shutting Down a Database with Server Manager

Starting and Shutting Down a Database with Oracle Enterprise Manager

Shutting Down a Database By Stopping a Service

Running Multiple Instances

Creating Password Files

Connecting as INTERNAL with a Password File

Changing the INTERNAL Password

Encrypting Database Passwords

Archiving Redo Log Files

Step 1: Change the Archive Mode to ARCHIVELOG

Step 2: Enable Automatic Archiving

Using the ORADEBUG Utility

11 Authenticating Database Users with Windows NT

Authentication Overview

Connecting Without a Password as a Nonprivileged Database User

Step 1: Perform Authentication Tasks on the Oracle8 Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Connecting as SYSOPER and SYSDBA Without a Password

Step 1: Perform Authentication Tasks on the Oracle8 Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Connecting as INTERNAL Without a Password

Step 1: Perform Authentication Tasks on the Oracle8 Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Granting Database Roles through Windows NT

Step 1: Perform Authentication Tasks on the Oracle8 Database Server

Step 2: Perform Authentication Tasks on the Client Computer

12 Monitoring a Database

Database Monitoring Overview

Using Oracle8 Performance Monitor

Installation

Registry Information

Accessing Oracle8 Performance Monitor

Monitoring Oracle8 Objects

Understanding Oracle8 Performance Objects

Oracle8 Performance Monitor Troubleshooting Information

Using the Event Viewer

Accessing the Event Viewer

Reading the Event Viewer

Using the Event Viewer

Managing the Event Viewer

Using Trace and Alert Files

Using Performance Management Packs

Oracle Diagnostics Pack

Oracle Tuning Pack

Oracle Change Management Pack

13 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool

Backing Up Files with OCOPY80

Recovering Files with OCOPY80

Using Legato Storage Manager to Back Up Tapes

14 Distributing and Managing Oracle Software

Overview

Systems Management Server

Oracle8 Enterprise Edition SMS Support

Distributing Oracle Software with SMS

15 Developing Applications

16 Using Oracle8 ConText Cartridge

Starting Oracle8 ConText Cartridge

Oracle8 ConText Cartridge Control Utility

MS-DOS Command Prompt

Using Oracle8 ConText Cartridge Supplied External Filters

Step 1: Identify Supplied External Filters and Wrappers

Step 2: Modify Release 2.0 Supplied External Filters and Wrappers (Optional)

Step 3: Specify Wrappers for Supplied External Filters

Using Oracle8 ConText Cartridge Supplied External Filters for Manual Filtering

Creating User-Defined External Filters

A Directory Structures

Windows NT Server Directory Structure

Client Directory Structure

B Oracle8 Database Specifications for Windows NT

Initialization Parameter File Overview

Location of the Initialization Parameter File

Editing the Initialization Parameter File

Sample File

Initialization Parameters

Initialization Parameters Without Windows NT-Specific Values

Database Initialization Parameters

Calculating Database Limits

Calculating Index Size

Setting Resource Costs

C Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

Parameters for Most Oracle Products

Parameters Describing Each Oracle Home Directory on a Computer

Parameters for Oracle8 Performance Monitor

Parameters for Oracle Services

Modifying a Registry Value

Adding a Registry Parameter

D Messages and Codes

Logging Error Messages

Oracle Installer Error Messages

Codes 09200-09499: Oracle8 Database Messages

Codes 04000-04999: Windows NT-Specific Oracle Messages

File I/O Errors: OSD-04000 to OSD-04099

Memory Errors: OSD-04100 to OSD-04199

Process Errors: OSD-04200 to OSD-04299

ORADEBUG Errors: OSD-04221 to OSD-04225

Loader Errors: OSD-04300 to OSD-04399

Semaphore Errors: OSD-04400 to OSD-04499

Miscellaneous Errors: OSD-04500 to OSD-04599

E National Language Support

NLS_LANG Parameters and Components

Default Values for NLS_LANG

NLS_LANG Settings in MS-DOS Mode and Batch Mode

Installing Additional Languages

F Troubleshooting

Database Connection Issues

Oracle8 Performance Monitor Issues

Migration Issues

Migration Error ORA-54 with Batch Migration Scripts

Rollback Segments Error During Migration

System Tablespace Extend Error

OCIW32.DLL Error Message

Oracle Data Migration Assistant

Operating System Permission Issues

DOS Compatibility Mode on Windows 95 or Windows 98 Computers

Replication Manager and Snapshot Replication Sites

Oracle Web Publishing Assistant

Oracle Assistants

Oracle Database Assistant

Oracle8 ConText Cartridge Workbench

Registering CTXV236.OCX on Windows 95 Clients