Contents

Title and Copyright Information

Contact Us!

How to Contact Oracle Technical Publications

How to Contact Oracle Support Services

Resources for Oracle Partners and Developers

Before You Begin

Prerequisites

Intended Audience

How This Guide Is Organized

Documentation and Code Conventions

1 Oracle8i Differences between Windows NT and UNIX

2 Database Tools Overview

Choosing a Database Tool

Tools and Operating System Compatibility

Preferred Database Tools

Starting Database Tools

Starting 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.6 Multiple Oracle Homes

Starting Tools

Starting Oracle Utilities from the Command Line

Starting Oracle Enterprise Manager

Starting Windows NT Tools

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?

Registry

What Database Parameters Are Configured?

User Manager

What Oracle8i Database Tasks Can User Manager Perform?

Optional Windows NT Diagnostic and Tuning Utilities

3 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

Changing the Value of PATH

Using Oracle Home Selector

At the System Level

At the MS-DOS Command Prompt

Exiting Oracle Universal Installer After Entering Name and PATH

Setting Variables in the Environment or the Registry

ORACLE_HOME

Consequences of Setting ORACLE_HOME

TNS_ADMIN

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

4 Using Oracle8i Client Directory Features with Active Directory

Overview

What are LDAP and a Directory Server?

What is Active Directory?

Oracle8i Directory Server Features

Net8 Directory Naming Features

Enterprise User Security Features

Integration with Active Directory

Automatic Discovery of Directory Servers

Integration with Microsoft Tools

User Interface Extensions for Net8 Directory Naming

Enhancement of Directory Object Type Descriptions

Integration with Windows Login Credentials

How Do Oracle Directory Objects Display in Active Directory?

Requirements for Using Oracle8i with Active Directory

Oracle Schema Creation Requirements

Oracle Context Creation Requirements

Net8 Directory Naming Requirements

Enterprise User Security Requirements

Installing and Configuring Oracle8i in an Active Directory Environment

Installation Tasks

Required Configuration Tools

Post-Installation Configuration Tasks

Testing Connectivity

Testing Connectivity from Client Computers

Testing Connectivity from Microsoft Tools

Accessing Connectivity Tools

Testing Connectivity

Connecting With SQL*Plus

Managing Access Control Lists for Oracle Directory Objects

Accessing the Security Groups

Adding or Removing Users

Changing User Permissions

Creating Security Domains

5 Post-Installation Configuration Tasks

Oracle interMedia Client

Audio

Video

Image

Locator

Text

Oracle interMedia Audio, Video, Image, and Locator Configuration Responsibilities

Configuring Oracle interMedia Audio, Video, Image, and Locator

Configuring Oracle interMedia, Audio, Video, Image, and Locator Demos

Oracle interMedia Text Configuration Responsibilities

Oracle Visual Information Retrieval Client

Configuring Oracle Visual Information Retrieval Client

6 Developing Applications

Finding Information on Application Development for Windows NT

Building External Routines

External Routines Overview

Step 1: Installing and Configuring

Installing the Oracle8i Database

Configuring Net8

Step 2: Writing an External Routine

Step 3: Building a DLL

Step 4: Registering an External Routine

Step 5: Executing an External Routine

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 Client Directory Structure

Filename Extensions

B Oracle8i 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

Modifying a Registry Value with REGEDT32

Adding a Registry Parameter with REGEDT32

C Net8 Configuration

Unsupported Net8 Features

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

Using the NDS Naming Method

NetWare Server Configuration

Client Configuration

Client Connection

Configuring Security for Named Pipes Protocol

Named Pipes Protocol on Windows 95

Net8 Port Numbers

D Error Messages

Logging Error Messages

Codes 04000-04999: Windows-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

Database Connection Issues

Glossary

Index