Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle9i for Windows

Oracle9i Release 2 (9.2) New Features

Oracle9i Release 1 (9.0.1) New Features

1 Introduction

Document Plan

Task Mapping

2 Oracle9i Windows/UNIX Differences

Automatic Startup and Shutdown

Background Processing and Batch Jobs

Diagnostic and Tuning Utilities

Direct Writes to Disk

Dynamic Link Libraries (DLLs)

Hot Backups

Initialization Parameters: Multiple Database Writers

Install Accounts and Groups

Installation

Memory Resources

Microsoft Transaction Server

Multiple Oracle Homes and OFA

Processes and Threads

Raw Partitions

Services

3 Using Oracle9i on Windows 2000

How to Perform Common Tasks in Windows NT and Windows 2000

Other Differences Between Windows NT and Windows 2000

DNS Domain Name

Microsoft Management Console

Enterprise User Authentication

Raw Partitions

Services Autostart

4 Oracle9i Architecture on Windows

Oracle9i on Windows Architecture

Thread-Based Architecture

File I/O Enhancements

Raw File Support

Oracle9i Scalability on Windows

Support for Very Large Memory (VLM) Configurations

4 GB RAM Tuning (4GT)

Large User Populations

Oracle9i Integration with Windows

Oracle PKI Integration

Active Directory

Oracle Net Naming with Active Directory

ORACLEMTSRecoveryService

Oracle Fail Safe

Oracle Real Application Clusters Guard

Other Sources of Information

5 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 from the Command Line

Starting Oracle Enterprise Manager Console

From the Start Menu or Command Line

From a Web Browser

Starting Windows Tools

Using SQL*Loader

Windows Processing Options

Default (No Processing Option) or "str terminator_string"

"FIX n"

"VAR n"

Case Study Files

Specifying the Bad File

Control File Conventions

Using Windows Tools

Event Viewer

Microsoft Management Console

Oracle Performance Monitor for Windows NT

Registry Editor

Task Manager

User Manager

Optional Windows Diagnostic and Tuning Utilities

6 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 2 (9.2)

Oracle8i Release 8.1.5 to Oracle9i Release 2 (9.2)

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 on Windows NT

At the System Level on Windows 98

At the 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 NT:

Changing ORACLE_BASE at the System Level on Windows 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

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

7 Oracle9i Services on Windows

Introduction to Oracle9i Services

Oracle9i Services Available on Windows

Using Oracle9i Services

8 Oracle9i Default Accounts and Passwords

Overview

Unlocking and Changing Passwords

Granting Limited SYS Database Role Privileges

Reviewing Accounts and Passwords

9 Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID

MSHELP_TOOLS

NLS_LANG

ORA_CWD

ORA_SID_AUTOSTART

ORA_SID_PFILE

ORA_SID_SHUTDOWN

ORA_SID_SHUTDOWN_TIMEOUT

ORA_SID_SHUTDOWNTYPE

ORA_TZFILE

ORACLE_AFFINITY

ORACLE_BASE

ORACLE_GROUP_NAME

ORACLE_HOME

ORACLE_HOME_KEY

ORACLE_HOME_NAME

ORACLE_PRIORITY

ORACLE_SID

RDBMS_ARCHIVE

OSAUTH_PREFIX_DOMAIN

OSAUTH_X509_NAME

RDBMS_CONTROL

SQLPATH

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

INST_LOC

OO4O

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES

DEFAULT_HOME

HOME_COUNTER

LAST_HOME

IDx

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

Parameters for Oracle Performance Monitor for Windows NT

Parameters for Oracle Services

Oracle Real Application Clusters Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\CM

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\IPC

Parameter Data Types and Default Values

Modifying a Registry Value with regedt32

Adding a Registry Parameter with regedt32

Adding or Modifying Registry Parameters with Oracle Administration Assistant for Windows NT

Starting Oracle Administration Assistant for Windows NT

Adding Oracle Home Parameters

Editing Oracle Home Parameters

Deleting Oracle Home Parameters

Modifying Oracle Performance Monitor for Windows NT Parameters

Using OPERFCFG Utility

Using Oracle Administration Assistant for Windows NT

10 Developing Applications for Windows

Finding Information on Application Development for Windows

Java Enhancements

XML Support

Support for Internet Applications

Application Wizards

Oracle COM/COM+ Integration Feature

ORACLEMTSRecoveryService

Pro*C/C++ and Pro*COBOL Applications

OLE DB

Developing Windows Applications

Developing Internet Applications

Building External Procedures

External Procedures Overview

Task 1: Installing and Configuring

Installing Oracle9i Database

Configuring Oracle Net Services

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

UTL_HTTP.REQUEST

UTL_HTTP.REQUEST_PIECES

Exception Conditions and Error Messages

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