Before You Begin

1 Getting Started with Your Documentation

Documentation Formats

What Documentation Did I Receive?

Online Documentation Set

Terms and Conditions

Release Notes and Readme Files

Installation

Database

Network

SQL*Plus

Oracle Options

Application Development

Oracle Web Publishing Assistant

What Documentation Do I Read First?

Starting Oracle Information Navigator

Starting Adobe Acrobat Reader

2 Introducing Oracle8i Enterprise Edition

Oracle8i Enterprise Edition Overview

Supported Operating Systems

4GB RAM Tuning (4GT) for Windows NT Server, Enterprise Edition

New in this Release

New Products

New Features

List of Oracle8i Enterprise Edition Products

Licensing Information

Oracle Enterprise Manager

Net8

Choosing Which Oracle Products to Install

How Server Installation Options Affect Network Configuration and Services

Oracle8i Enterprise Edition

Oracle8i Client

Programmer/2000

Supported Protocol Stack Vendors

Unsupported Features

3 Database Tools Overview

Choosing a Database Tool

Important: Oracle Enterprise Manager

Important: SQL*Plus and Server Manager

Database Tools and Operating System Compatibility

Preferred Database Tools

Starting Database Tools

Starting Database Tools in Multiple Oracle Homes

Starting Tools from Release 8.0.4 and later 8.0.x Multiple Oracle Homes

Starting Tools from Release 8.1.5 Multiple Oracle Homes

Starting Oracle Utilities

Starting Windows NT Tools

Starting Oracle Enterprise Manager

Starting Oracle Assistants

Starting Oracle for Windows NT Performance Monitor

Starting SQL*Plus

Using SQL*Loader

Windows NT Processing Options

Direct Path Option

Control File Conventions

Using Windows NT Tools

Control Panel

Which Oracle Services Appear in the Control Panel?

Event Viewer

What Oracle Database Events Are Monitored?

Performance Monitor

What Oracle Database Information is Monitored?

Registry

What Database Parameters Are Configured?

User Manager

What Oracle8i Database Tasks Can User Manager Perform?

4 Multiple Oracle Homes and Optimal Flexible Architecture

Introduction to Multiple Oracle Homes and OFA

Multiple Oracle Homes Overview

What Is an Oracle Home?

Benefits of Using Multiple Oracle Homes

Multiple Oracle Home Functionality in Different Releases

One-Listener Support of Multiple Oracle Homes

Multiple Oracle Home Environments

Release 8.0.4 and Later 8.0.x Oracle Home Environments

Release 8.1 Oracle Home Environment

Which Products Are Multiple Oracle Home-Enabled?

Products Supporting Multiple Oracle Homes

Products Supporting a Single Oracle Home

Products Not Supporting Multiple Oracle Homes

Products Not Associated with an Oracle Home

Working with Multiple Oracle Homes

Changing the Value of PATH, Using Oracle Home Selector

Changing the Value of PATH at the System Level

Changing the Value of PATH at the MS-DOS Command Prompt

Exiting the Oracle Universal Installer After Entering Name and PATH

Optimal Flexible Architecture Overview

Benefits of an OFA-Compliant Database

Characteristics of an OFA-Compliant Database

Differences Between Directory Trees by Release

Directory Tree of a Sample OFA-Compliant Database

OFA Directory Naming Conventions

ORACLE_BASE Directory

ORACLE_HOME Directory

ADMIN Directory

ORADATA Directory

DB_NAME Directory

OFA and Multiple Oracle Home Configurations

Specifying an ORACLE_HOME Directory

Default OFA Database

Non-Default OFA Database, Case 1

Non-Default OFA Database, Case 2

Increasing Reliability and Performance

Disk Mirroring

Disk Striping

Using Raw Partitions for Tablespaces

Comparison Between OFA on Windows NT and UNIX

Directory Naming

ORACLE_BASE Directory

Support for Symbolic Links on Windows NT

5 Installing, Migrating, and Upgrading Databases

Intended Audience

What To Do With Previous Oracle Database Releases

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

Oracle7 Database Applications

Different Client and Database Release Considerations

Oracle8i Client Release 8.1 to Oracle8i Database Release 8.1

Oracle8 Client Release 8.0/Oracle7 Client to Oracle8i Database Release 8.1

Oracle8i Client Release 8.1 to Oracle8 Release 8.0/Oracle7 Databases

Multi-Versioning

Install Oracle7 and Oracle8i Databases in Multiple Oracle Homes

Install Oracle7 and Oracle8i Databases on Separate Computers

Migrate an Oracle7 Database to an Oracle8i Database

Upgrade an Oracle8 Database to the Current Oracle8i Database Release

Migrate Oracle7 Clients to Oracle8i Clients

Installing an Oracle 8.1 Database Where Version 7.x Already Exists

Migrating an Oracle7 Database to Oracle8i

Ten Issues That Can Affect Oracle7 to Oracle8i Migration

Installing Appropriate Versions of SQL*Net

Migrating Using Oracle Data Migration Assistant

What To Do Before Using Oracle Data Migration Assistant

Migrating Using MIG

Step 1: What To Do Before Using MIG

Review Migration Concepts

Use Appropriate SQL*DBA or SQL*Plus Versions

Check Database To Be Migrated Version Number

Check Character Set

Step 2: Shut Down the Oracle7 Database

Step 3: Back Up the Oracle7 Database

Step 4: Install MIG From Oracle8i Enterprise Edition CD-ROM

Step 5: Run MIG

Step 6: Create Oracle8i Services and Database Files

Step 7: Remove Oracle7 Software (Optional)

Upgrading an Oracle8 Database Release 8.0.x to 8.1.5

Upgrading Using Oracle Data Migration Assistant

Upgrading Using SQL Scripts

Step 1: Shut Down the Release 8.0.x Database

Step 2: Back Up the Release 8.0.x Database

Step 3: Edit the COMPATIBLE Parameter in the 8.0.x INITSID.ORA File

Step 4: Install Oracle8i Enterprise Edition Release 8.1.5

Step 5: Run the SQL Scripts

Migration Issues for Net8 and SQL*Net

Location of Network Configuration Files

Listener Configuration in Multiple Oracle Home Installations

Changing Listener.ora for Migrated Databases

Changes in Handling of TCP/IP Listening Address

Enabling NT Native Authentication

NT Authenticated Users in the Database

Connection using Multi-threaded Server Mode

Installing Appropriate Versions of SQL*Net

Installation of Oracle Names

Moving Database Files to an OFA-Compliant Directory

6 Post-Installation Configuration Tasks

What Products Must You Configure?

Oracle interMedia

Audio

Video

Image

Locator

Oracle interMedia Text

Oracle Options

Oracle Spatial

Oracle Time Series

Oracle Visual Information Retrieval

Multi-Threaded Server Support

Enabling Multi-Threaded Server Support for IIOP Clients

Enabling Multi-Threaded Server Support for Two-Task Net8 Clients

Disabling Multi-Threaded Server Support for Two-Task Net8 Clients

Advanced Replication

Checking Tablespace Requirements

Checking Initialization Parameters

Performing Configuration Tasks

Monitoring Data Dictionary Tables

Upgrading Advanced Replication

7 Starter and Custom Databases

Starter and Custom Database Overview

Starter Database Contents

User Names and Passwords

Connecting to the Database From a Remote Machine

Connecting Without a Password

System Identifier and Database Name

Global Database Name

Tablespaces

Data Files

Initialization Parameter File

Redo Log Files

Control File

Rollback Segments

Data Dictionary

Creating Control, Data, and Log Files on Remote Computers

8 Creating a Database

Before You Create a Database

Naming Conventions for Oracle Databases

Installing Oracle Server (the Database Component)

Creating Data Files and Log Files on Remote Computers

Creating a Database Using Tools

Using Oracle Database Configuration Assistant

Creating a Database

Modifying a Database

Deleting a Database

Using BUILD_DB.SQL

How to Create a Database

Creating Directories

Exporting an Existing Database

Deleting Database Files

Modifying the INIT.ORA File

Creating and Starting an Oracle Service

Putting the CREATE DATABASE Statement in a Script

Creating a Database

Importing a Database

Updating the ORACLE_SID in the Registry

Backing Up the New Database

Storing Database Files on Compressed Drives

Using ORADIM to Administer an Oracle Instance

Creating an Instance

Starting an Instance

Stopping an Instance

Modifying an Instance

9 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 SQL*Plus

Starting and Shutting Down a Database Using Services

Running Multiple Instances

Creating Password Files

Viewing Password Files

Deleting 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

10 Authenticating Database Users with Windows NT

Authentication Overview

Automatically Enabling Operating System Authentication During Installation

Oracle Administration Assistant for Windows NT

Adding a Computer

Granting Database Administrator and Database Operator Privileges using Oracle Administration Assistant for Windows NT

Connecting to a Database

Create a Nonprivileged Database User using Oracle Administration Assistant for Windows NT

Create a Local Database Role

Create an External OS Role

Connecting Without a Password as a Nonprivileged Database User

Step 1: Perform Authentication Tasks on the Oracle8i Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Connecting as SYSDBA and SYSOPER Without a Password

Step 1: Perform Authentication Tasks on the Oracle8i Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Connecting as INTERNAL Without a Password

Step 1: Perform Authentication Tasks on the Oracle8i Database Server

Step 2: Perform Authentication Tasks on the Client Computer

Granting Database Roles through Windows NT

Step 1: Perform Authentication Tasks on the Oracle8i Database Server

Step 2: Perform Authentication Tasks on the Client Computer

11 Monitoring a Database

Database Monitoring Overview

Using Oracle Performance Monitor

Registry Information

Accessing Oracle Performance Monitor

Monitoring Oracle8i Objects

Understanding Oracle Performance Objects

Oracle 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

Viewing Threads Using the Oracle Administration Assistant for Windows NT

12 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool

Backing Up Files with OCOPY

Recovering Files with OCOPY

Using Legato Storage Manager to Back Up Tapes

13 Developing Applications

Java Products Overview

Oracle Java Option

Oracle Java Utilities

Oracle Java Database Connectivity (JDBC) Drivers

Oracle SQLJ Translator

Building External Procedures

External Procedures Overview

Installing and Configuring

Installing Oracle8i Enterprise Edition

Configuring Net8

Writing an External Procedure

Building a DLL

Registering an External Procedure

Executing an External Procedure

Enabling Multi-Threaded Callout Support

Additional Documentation

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

Exception Conditions and Error Messages

Troubleshooting

A Directory Structures

Oracle8i Enterprise Edition Directory Structure

ORACLE_HOME

ADMIN

ORADATA

Oracle8i Client Directory Structure

Oracle Programmer Directory Structure

Net8 Directory Structure

B Oracle8i Database Specifications for Windows NT

Initialization Parameter File (INIT.ORA) Overview

Location of the Initialization Parameter File

Editing the Initialization Parameter File

Sample File

Initialization Parameters

Initialization Parameters Without Windows NT-Specific Values

Displaying Initialization Parameter Values

Database Initialization Parameters

Calculating Database Limits

Calculating Index Size

C Oracle 8i Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES

IDx

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES Parameters

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

Parameters for Oracle for Windows NT Performance Monitor

Parameters for Oracle Services

Modifying a Registry Value with REGEDT32

Adding a Registry Parameter with REGEDT32

Adding and Modifying Oracle Home Parameters

Starting the Oracle Home Configuration Snap-In

Adding Oracle Home Parameters

Editing Oracle Home Parameters

Deleting Oracle Home Parameters

Modifying Oracle for Windows NT Performance Monitor Parameters

Using OPERFCFG

Using the Oracle Performance Monitoring Snap-In

D Net8 Configuration Parameters, Services, and Port Numbers

Understanding Net8 Registry Parameter and Subkeys

Net8 Parameters

Net8 Service Subkeys

Understanding Optional Configuration Parameters

LOCAL

TNS_ADMIN

USE_SHARED_SOCKET

Advanced Network Configuration

Configuring Authentication Methods

NDS Authentication

Windows NT Native Authentication

Using the NDS Naming Method

NetWare Server Configuration

Client Configuration

Client Connection

Configuring Security for Named Pipes Protocol

Net8 Services and Port Numbers

Services

TCP/IP Port Numbers

E National Language Support

NLS_LANG Parameters

Commonly Used Values for NLS_LANG

NLS_LANG Settings in MS-DOS Mode and Batch Mode

F Storing Tablespaces on Raw Partitions

Raw Partition Overview

Disk Definition

Raw Partition Definition

Physical Disk

Logical Partition

Physical Disk and Logical Partition Considerations

Frequently Asked Questions

Compatibility Issues

Creating an Extended Partition

Creating Logical Partitions in an Extended Partition

Assigning Symbolic Links to Each Logical Partition

Removing or Ignoring Links

Creating a Tablespace in a Raw Partition

G SNMP Support

What Is the Purpose of SNMP?

Oracle SNMP Support

Oracle SNMP Agent for Oracle Services

Configuring Oracle SNMP Agent

Controlling the Master Agent and the Encapsulator

Starting the Master Agent

Starting the Encapsulator

Understanding the MASTER.CFG File

Understanding the ENCAPS.CFG File

Installing Oracle SNMP Agent with Other Network Management Systems

Glossary

Index

---