Oracle8(TM) Getting Started for Windows NT
Release 8.0.3
A54894-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Getting Started with Your Documentation

Documentation Formats

What Documentation Did I Receive?

Documentation Set

What Documentation Do I Read First?

Starting Oracle Information Navigator

Starting Adobe Acrobat Reader

2 Introducing Oracle8

What is Oracle8?

What Oracle8 Products are Available for Installation?

3 Starter Database Contents

Starter Database

Starter Database Contents

Initialization Parameter File

Data Dictionary

4 Database Tools

Choosing Which Database Tools to Use

Database Tools and Operating System Compatibility

Preferred Database Tools

Starting Database Tools

Oracle8 Utilities

Windows NT Tools

Oracle Enterprise Manager

Oracle Assistants

NT Backup Manager

NT Recovery Manager

Using SQL*Loader with Windows NT

Windows NT Processing Options

Direct Path Option

Control File Conventions

5 Database Co-existence and Migration

Database Co-existence and Migration Overview

Co-existence and Migration Decisions

Oracle7 and Oracle8 Client and Server Configuration

Install Oracle7 and Oracle8 in the Same Oracle Home

Install Oracle7 and Oracle8 on Separate Servers

Migrate Oracle7 Data to an Oracle8 Database

Upgrade Oracle7 Clients to Oracle8

Co-existence and Migration Networking Issues

Co-existence Issues

Migration Issues

Installing an Oracle7 and Oracle8 Database in the Same Oracle Home

Using Oracle Data Migration Assistant

Using the Migration Utility (MIG80)

Using Oracle Migration Assistant for Microsoft Access

Known Problems, Restrictions, and Workarounds

6 Configuration Tasks

What Must You Configure?

Configuring Net8

Configuring Oracle Enterprise Manager

Step 1: Start Oracle Services

Step 2: Create a Repository User Account

Step 3: Create an NT User Account

Step 4: Create Configuration Files

Step 5: Create the Repository and Discover Services

Configuring Oracle8 ConText Cartridge

Running Server Processes on Windows NT

7 Oracle8 Integration with Windows NT

What Oracle8 Database Events Are Monitored?

Performance Monitor

What Oracle8 Database Information is Monitored?

What Database Parameters Are Configured?

What Oracle8 Services Appear in the Control Panel?

What Oracle8 Database Tasks Can the User Manager Perform?

8 Understanding Oracle Enterprise Manager

Oracle Enterprise Manager

Overview of Oracle Enterprise Manager Components

Oracle Enterprise Manager Console Features

Common Services for Managing Databases

Integrated Applications

9 Creating a Database

Naming Conventions for Oracle8 Databases

Using Oracle Database Assistant

Creating a Database Manually

Step 1: Export an Existing Database

Step 2: Delete Database Files

Step 3: Modify or Create the INITSID.ORA File

Step 4: Create and Start an Oracle8 Service

Step 5: Prepare CREATE DATABASE SQL Statement

Step 6: Create a Database

Step 7: Import a Database

Step 8: Update ORACLE_SID in the Registry

Step 9: Back Up the New Database

10 Administering a Database

Starting and Stopping Oracle Services

Starting Oracle Services

Stopping Oracle Services

Auto-starting Oracle Services

Starting and Shutting Down a Database with Server Manager

Starting Server Manager

Starting a Database with Server Manager

Shutting Down a Database with Server Manager

Starting and Shutting Down a Database with Oracle Enterprise Manager

Starting a Database with Oracle Enterprise Manager

Shutting Down a Database with Oracle Enterprise Manager

Shutting Down a Database By Stopping a Service

Running Multiple Instances

Integrating Database User Authentication with Windows NT

Authenticating Database Administrators

Using Password Files

Using Operating System Authentication

Connecting as SYSOPER and SYSDBA

Connecting as INTERNAL

Changing the Internal Password:

Granting Database Roles with Windows NT

Encrypting Database Passwords

Using the Oracle Enterprise Manager Console

Performing Simple Single Tasks in the Navigator

Integrating Applications into the Console

11 Monitoring a Database

Database Monitoring Overview

Using Oracle8 Performance Monitor

Oracle8 Performance Monitor Setup Information

Accessing Oracle8 Performance Monitor

Monitoring Oracle8 Objects

Understanding Oracle8 Performance Objects

Oracle8 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

12 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool

Backing Up Files with OCOPY

Recovering Files with OCOPY

13 Applications Development

Building External Procedures

What are External Procedures?

Step 1: Installing and Configuring

Step 2: Writing an External Procedure

Step 3: Building a Shared Library

Step 4: Registering an External Procedure

Step 5: Executing an External Procedure

Additional Documentation

Compiling and Linking the Oracle XA Library

Compiling and Linking a Pro*C Program

Compiling and Linking an OCI Program

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

Exceptional Conditions and Error Messages

Troubleshooting

14 Oracle8 ConText Filters, Demos, and Workbench

Oracle8 ConText Filters

Setting Up Oracle8 ConText Filters

Creating Wrappers for Oracle8 ConText Filters

Using Oracle8 ConText Filters

Oracle8 ConText Cartridge Demos

Oracle8 ConText Cartridge Workbench

Oracle8 ConText Cartridge System Administration

Oracle8 ConText Cartridge Viewer

Oracle8 ConText Cartridge I/O Utility

A Directory Structures

Windows NT Server Directory Structure

Client Directory Structure

B Initialization Parameter Files

What Is an Initialization Parameter File?

Initialization Parameters

Creating a New Database-Initialization Parameters

C Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\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

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

Installing Additional Languages

F Distributing and Managing Oracle Software

Oracle Client Software Manager

Reviewing the Installation Requirements

Creating an OCSM Host Machine

Giving OCSM Clients Access to Oracle Home on the OCSM Host Machine

Registering the Client Machine

Understanding the Oracle Client Configuration Manager

Understanding Client User vs. Administrator Options

Assigning Products

Assigning Clients

Defining Installation Options

Defining Conflict Resolution Installation Options

Using Oracle Client Software Agent

Understanding OCSM Files

Distributing Software with OCSM

Systems Management Server

Oracle8 SMS Support

Distributing Oracle Software with SMS

G Troubleshooting

Database Connection Issues

Operating System Permission Issues

Using Oracle Trace

Contacting Oracle Worldwide Customer Support

How to Contact Oracle Worldwide Customer Support

Before You Call for Assistance

Glossary

Index

Copyright © 1997 Oracle Corporation.
All Rights Reserved.