Contents

3 Database Tools Overview

Choosing a Database Tool

Database Tools and Operating System Compatibility

Preferred Database Tools

Starting Database Tools

Starting Database Tools in Multiple Oracle Homes

Starting Oracle8 Utilities

Starting Windows NT Tools

Starting Oracle Enterprise Manager

Starting Oracle Assistants

Starting SQL*Plus

Using ORADIM80

Using SQL*Loader

Windows NT Processing Options

Direct Path Option

Control File Conventions

Using Windows NT Tools

Control Panel

What Oracle8 Services Appear in the Control Panel?

Event Viewer

What Oracle8 Database Events Are Monitored?

Performance Monitor

What Oracle8 Database Information is Monitored?

Registry

What Database Parameters Are Configured?

User Manager

What Oracle8 Database Tasks Can the User Manager Perform?

4 Oracle Enterprise Manager Overview

Oracle Enterprise Manager Overview

Oracle Enterprise Manager Components

Oracle Enterprise Manager Console Features

Common Services for Managing Databases

Oracle Intelligent Agent and Communication Daemon

Service Discovery

Job Scheduling System

Event Management System

Repository

Security

Integrated Applications

Database Administration Applications

Common Features

Integrating Additional Applications

5 Starter Database Contents

Starter Database Guide

Starter Database Contents

User Names

System Identifier

Tablespaces

Data Files

Initialization Parameter File

Redo Log Files

Control File

Data Dictionary

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 Compliant Products

Non-Multiple Oracle Home Products

Working with Multiple Oracle Homes

Changing the Value of PATH

7 Migrating and Upgrading

Intended Audience

Installation Types When You Have Existing Databases

Database Coexistence and Multiple Oracle Homes Overview

Migrating and Upgrading Overview

What is Migrating?

What is Upgrading?

Migrating and Upgrading Using Multiple Oracle Homes

Choosing an Installation Type

Oracle7 Applications

Oracle7 Client Connections to Oracle8 Databases

Oracle8 Client Connections to Oracle7 Databases

Oracle7 Client and Oracle8 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

Migration Networking Issues

Migrating Oracle7 Clients

Using the Net8 Listener

Installing Appropriate Versions of SQL*Net

Editing the LISTENER.ORA File for Multiple Oracle Homes

Migrating Using Oracle Data Migration Assistant

Migrating Using Migration Utility (MIG80)

Step 1: Shut Down the Oracle7 Database

Step 2: Back Up the Oracle7 Database

Step 3: Prepare the Oracle7 Database for Migration

Step 4: Install Oracle8 Enterprise Edition

Step 5: Run the Migration Utility (MIG80)

Step 6: Create Oracle8 Services and Database Files

Step 7: Remove Oracle7 Software (Optional)

Upgrading an Oracle8 Database

Upgrading Using Oracle Data Migration Assistant

Upgrading Using CAT8004.SQL Script

Step 1: Shut Down the Release 8.0.3 Database

Step 2: Back Up the Release 8.0.3 Database

Step 3: Edit the COMPATIBLE Parameter in the Release 8.0.3 INITSID.ORA File

Step 4: Install Oracle8 Enterprise Edition Release 8.0.4

Step 5: Run the CAT8004.SQL Script

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

Migrate from Oracle ConText release 1.1.2 to release 2.0.4

Upgrade from Oracle ConText release 2.0.4 to release 2.3.6

Upgrade from release 2.0.6 to release 2.3.6

Upgrade from release 2.3.4 to release 2.3.6

Load Lexical Data

Configuring Oracle8 ConText Cartridge

Configuring After a Fresh Installation

Configuring After Upgrading or Migrating

Configuring Oracle8 ConText Cartridge 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

Step 1: Checking Tablespace Requirements

Step 2: Checking Initialization Parameters

Step 3: Performing Configuration Tasks

Step 4: Monitoring Data Dictionary Tables

Step 5: Upgrading Advanced Replication

9 Creating a Database

Naming Conventions for Oracle8 Databases

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

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

Downloading Patches from Oracle Worldwide Customer Support

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

Using Trace and Alert Files

Using the Performance Pack

Performance Monitor Applications

Oracle Performance Manager

Oracle TopSessions

Oracle Lock Manager

Oracle Tablespace Manager

Starting Performance Monitor Applications

Oracle Trace

Starting Oracle Trace

Oracle Expert

Starting Oracle Expert

13 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool

Backing Up Files with OCOPY

Recovering Files with OCOPY

14 Distributing and Managing Oracle Software

Overview

Systems Management Server

Oracle8 Enterprise Edition SMS Support

Distributing Oracle Software with SMS

De-installation Issue

15 Developing Applications

Building External Procedures

External Procedures Overview

Step 1: Installing and Configuring

Installing Oracle8 Enterprise Edition

Configuring Net8

Step 2: Writing an External Procedure

Step 3: Building a DLL

Step 4: Registering an External Procedure

Step 5: Executing an External Procedure

Step 6: Enabling Multi-threaded Callout Support

Additional Documentation

Compiling and Linking the Oracle XA Library

Compiling and Linking a Pro*C Program

Compiling and Linking an OCI Program

XA and TP Monitor Information

Accessing Web Data with Intercartridge Exchange

Configuring Intercartridge Exchange

Using Intercartridge Exchange

Packaged Function UTL_HTTP.REQUEST

Packaged Function UTL_HTTP.REQUEST_PIECES

UTL_HTTP Exception Conditions

UTL_HTTP.REQUEST

UTL_HTTP.REQUEST_PIECES

Exceptional Conditions and Error Messages

Troubleshooting

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 Filter and Wrapper

Step 2: Setting Up Oracle8 ConText Cartridge External Filters

Creating Wrappers for Oracle8 ConText Cartridge External Filters

Step 3: Specifying Oracle8 ConText Cartridge External Filters

Single Format Columns

Mixed Format Columns

Using Oracle8 ConText Cartridge Supplied External Filters for Manual Filtering

Oracle8 ConText Cartridge Demos

Using User Defined External Filters

Using Oracle8 ConText Cartridge Workbench

Administration Tools

Oracle8 ConText Cartridge Configuration Manager

Oracle8 ConText Cartridge System Administration

Document Viewers

Oracle8 ConText Cartridge Viewer Plugin

Oracle8 ConText Cartridge Viewer Cartridge

Oracle8 ConText Cartridge Viewer Control

Oracle8 ConText Cartridge I/O Utility

TextServer3 Dictionary Migration Tool

Oracle8 ConText Cartridge Workbench Demo

A Directory Structures

Windows NT Server Directory Structure

Client Directory Structure

B Initialization Parameters

Initialization Parameter File Overview

Location

Editing

Sample File

Initialization Parameters

Database Initialization Parameters

C Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

Parameters for Most Oracle Products

Product and Installation Parameters

Installation Parameters for Computers with One Oracle Home

Parameters Describing Each Oracle Home Directory on a Computer

IDx

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

Oracle Data Migration Assistant

Operating System Permission Issues

Using Oracle Trace

Contacting Oracle Worldwide Customer Support

Glossary

Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Index