Contents

Title and Copyright Information

List of Tables

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

1 Introduction

Document Plan

Task Mapping

2 Oracle9i Differences between Windows 98, Windows NT, and UNIX

3 Oracle9i Architecture on Windows

Oracle9i on Windows Architecture

Thread-Based Architecture

Other Sources of Information

4 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 Tools from Oracle8 Release 8.0.4 and Later 8.0.x Multiple Oracle Homes

Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes

Starting Database Tools from the Start Menu

Starting Database Tools

Starting Database Tools from the Command Line

Starting Windows 98 Tools

Using SQL*Loader

Windows 98 Processing Options

Direct Path Option

Control File Conventions

Using Windows Tools

Registry

What Database Parameters Are Configured?

5 Multiple Oracle Homes and Optimal Flexible Architecture

Introduction to Multiple Oracle Homes and OFA

Multiple Oracle Homes Overview

What Is an Oracle Home?

Benefit of Using Multiple Oracle Homes

Multiple Oracle Home Functionality in Different Releases

Oracle8 Releases Before 8.0.4

Oracle8 Releases 8.0.4 to 8.0.6

Oracle8i Release 8.1.3 to Oracle9i Release 1 (9.0.1.1.0)

Oracle8i Release 8.1.5 to Oracle9i Release 1 (9.0.1.1.0)

One-Listener Support of Multiple Oracle Homes

Multiple Oracle Home Environments

Oracle Home Environments in Oracle8 Releases 8.0.4 and Later 8.0.x

Oracle Home Environments in Oracle8i Releases 8.1.3, 8.1.4, and 8.1.5

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

Top-Level Oracle Directory

Database Filenames

Database Filename Extensions

OFA Directory Naming Conventions

ORACLE_BASE Directory

Changing ORACLE_BASE at the System Level on Windows 95 or 98:

ORACLE_HOME Directory

ADMIN Directory

ORADATA Directory

DB_NAME Directory

OFA and Multiple Oracle Home Configurations

Specifying an ORACLE_HOME Directory

Installing a Default OFA Database: Example

Installing a Nondefault OFA Database: Example 1

Installing a Nondefault OFA Database: Example 2

6 Oracle9i Default Accounts and Passwords

Overview

Unlocking and Changing Passwords

Granting Limited SYS Database Role Privileges

Reviewing Accounts and Passwords

7 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

Modifying a Registry Value with REGEDIT

Adding a Registry Parameter with REGEDIT

Adding or Modifying Initialization File Parameters and Registry Parameters with Oracle9i Navigator's "Parameter Configurer"

Introducing Database Parameter Configuration Assistant

Introduction to Manipulating Database Initialization Parameters

Opening a window to manipulate database initialization files

Creating a new initialization file

To open an already existing parameter file

To add a parameter

Deleting a Parameter

Modifying a Parameter Value

Saving the parameters

Introduction to Manipulating Oracle9i Configuration Parameters

Opening a window to manipulate configuration parameters

Modifying a parameter value

Deleting a particular parameter

8 Developing Applications for Windows

Finding Information on Application Development for Windows 98

Java Enhancements

XML Support

Application Wizards

Oracle COM/COM+ Integration Feature

OLE DB

Developing Windows Applications

Building External Procedures

External Procedures Overview

Task 1: Installing and Configuring

Installing the Oracle9i Database

Configuring Oracle Net

Task 2: Writing an External Procedure

Task 3: Building a DLL

Task 4: Registering an External Procedure

Task 5: Executing an External Procedure

Debugging External Procedures

Using Package DEBUG_EXTPROC

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 Error Messages

Logging Error Messages

ORA-09275: CONNECT INTERNAL No Longer Supported

OSD-04000 to OSD-04599: 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

DIM-00000 to DIM-00039: ORADIM Command Syntax Errors

Database Connection Issues

B Getting Started with Your Documentation

Glossary

Index