Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

What's New in Oracle Database for Windows

Oracle Database 10g New Features

Oracle9i Release 2 (9.2.0.2) New Feature

Oracle9i Release 2 (9.2) New Features

Oracle9i Release 1 (9.0.1) New Features

1 Oracle Database Architecture on Windows

Oracle Database on Windows Architecture

Thread-Based Architecture

File I/O Enhancements

Raw File Support

Oracle Database Scalability on Windows

Support for Very Large Memory (VLM) Configurations

4 GB RAM Tuning (4GT)

Large User Populations

Oracle Database Integration with Windows

Oracle PKI Integration with Windows

Oracle Services for Microsoft Transaction Server

Oracle Fail Safe Integration with Windows

Oracle Real Application Clusters Integration with Windows

Other Sources of Information

2 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

One-Listener Support of Multiple Oracle Homes

Changing the Value of PATH

Changing the Value of PATH Using Oracle Universal Installer

Changing the Value of PATH at the System Level

Changing the Value of PATH at the Command Prompt

Exiting Oracle Universal Installer After Entering Name and PATH

Setting Variables in the Environment or the Registry

Setting ORACLE_HOME

Consequences of Setting ORACLE_HOME

Setting 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

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

Using Raw Partitions for Tablespaces

Comparison Between OFA on Windows and UNIX

Directory Naming

ORACLE_BASE Directory

Support for Symbolic Links on Windows

3 Database Tools on Windows

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 Windows Tools

Using SQL*Loader

Windows Processing Options

Default (No Processing Option) or "str terminator_string"

Case Study Files

Specifying the Bad File

Control File Conventions

Using Windows Tools

Using Event Viewer to Monitor a Database

Using Microsoft Management Console to Administer a Database

Using Oracle Counters for Windows Performance Monitor

Using Registry Editor to Modify Configuration Information

Using Task Manager to Monitor Applications and Processes

Using Local Users and Groups to Manage Users and Groups

Using User Manager to Manage Users

Optional Windows Diagnostic and Tuning Utilities

4 Postinstallation Database Creation on Windows

Naming Conventions for Oracle Database

Accessing Data Files and Log Files on Remote Computers

Creating a Database on Windows Using Database Configuration Assistant

Creating a Database on Windows Using Command-Line Tools

Creating Directories

Exporting an Existing Database

Deleting Database Files

Modifying the Initialization Parameter File

Starting an Oracle Database Instance

Creating and Starting an Oracle Database Service

Putting the CREATE DATABASE Statement in a Script

Running the CREATE DATABASE Script

Importing a Database

Updating ORACLE_SID in the Registry

Backing Up the New Database

Using ORADIM to Administer an Oracle Database Instance

Creating an Instance

Starting an Instance and Services

Stopping an Instance and Services

Editing an Instance

Deleting an Instance

5 Postinstallation Configuration Tasks on Windows

Resetting Passwords for Default Accounts

NTFS File System and Windows Registry Permissions

File Permissions

File Permissions Set by Oracle Universal Installer

File Permissions Set by Database Configuration Assistant

File Permissions Set by Database Upgrade Assistant

Setting NTFS File System Security

Setting Windows Registry Security

Configuring External Job Support for the Scheduler on Windows

Oracle interMedia on Windows

Upgrading Oracle interMedia from an Earlier Release

Configuring Oracle interMedia Audio, Video, Image, and Locator

Configuring Oracle interMedia Demos

Configuring Oracle Text on Windows

Configuring Oracle Spatial on Windows

Configuring Advanced Replication on Windows

Checking Tablespace and Rollback Segment Requirements

Adding and Modifying Initialization Parameters

Monitoring Data Dictionary Tables

6 Administering a Database on Windows

Managing Oracle Database Services

Oracle Database Service Naming Conventions for Multiple Oracle Homes

Starting Oracle Database Services

Stopping Oracle Database Services

Auto-starting Oracle Database Services

Starting and Shutting Down a Database with SQL*Plus

Starting and Shutting Down a Database Using Services

Starting Multiple Instances

Creating and Populating Password Files

Viewing and Hiding the Password File

Connecting Remotely to the Database as SYS

Automatically Encrypted Database Passwords

Creating Control, Data, and Log Files on Remote Computers

Archiving Redo Log Files

Changing Archive Mode to ARCHIVELOG

Enabling Automatic Archiving

7 Monitoring a Database on Windows

Database Monitoring Overview

Using Oracle Counters for Windows Performance Monitor

Registry Information

Accessing Oracle Counters for Windows Performance Monitor

Modifying Views

Understanding Oracle Database Performance Objects

Oracle Counters for Windows Performance Monitor Troubleshooting Information

Using Event Viewer

Reading Event Viewer

Managing Event Viewer

Viewing Threads

8 Tuning Windows to Optimize Oracle Database

Windows Tuning Overview

Large Page Support

When to Use User-Thread Mode

Enabling User-Thread Mode

Disabling User-Thread Mode

Reduce Priority of Foreground Applications on Server Console

Configure Windows Server to Be an Application Server

Disable Unnecessary Services

Remove Unused Network Protocols

Reset Network Protocol Bind Order

Apply Latest Reliable Windows Server Service Pack

Use Hardware or Operating System Striping

Multiple Striped Volumes for Sequential and Random Access

Multiplex Windows Server Virtual Memory Paging File

Close All Unnecessary Foreground Applications

9 Authenticating Database Users with Windows

Windows Native Authentication Overview

Windows Authentication Protocols

User Authentication and Role Authorization Methods

Authentication and Authorization Methods To Use

Operating System Authentication Enabled at Installation

10 Administering External Users and Roles on Windows

Oracle Administration Assistant for Windows

Managing a Remote Computer

Adding a Computer and Saving Your Configuration

Granting Administrator Privileges for All Databases on a Computer

Granting Operator Privileges for All Databases on a Computer

Connecting to a Database

Troubleshooting Connection Problems

Viewing Database Authentication Parameter Settings

Creating an External Operating System User

Creating a Local Database Role

Creating an External Operating System Role

Granting Administrator Privileges for a Single Database

Granting Operator Privileges for a Single Database

Manually Administering External Users and Roles

Manually Creating an External Operating System User

External User Authentication Tasks on the Oracle Database Server

External User Authentication Tasks on the Client Computer

Manually Granting Administrator and Operator Privileges for Databases

SYSDBA/SYSOPER Authentication Tasks on the Oracle Database Server

SYSDBA/SYSOPER Authentication Tasks on the Client Computer

Manually Creating an External Role

External Role Authorization Tasks on the Oracle Database Server

External Role Authorization Tasks on the Client Computer

Manually Migrating Users

11 Storing Oracle Wallets in the Windows Registry

Storing Private Keys and Trust Points

Storing User's Profile

Registry Parameters for Wallet Storage

Oracle Wallet Manager

12 Oracle PKI Integration with Windows

Oracle Public Key Infrastructure

Windows Public Key Infrastructure

Microsoft Certificate Stores

Microsoft Certificate Services

Using Microsoft Certificate Stores with Oracle PKI Applications

13 Oracle Database Specifications for Windows

Initialization Parameter File Overview

Location of the Initialization Parameter File

Editing The Initialization Parameter File

Database Configuration Assistant Renames init.ora

SGA_MAX_SIZE Parameter

Initialization Parameters Without Windows-Specific Values

Displaying Initialization Parameter Values

Uneditable Database Initialization Parameters

Calculating Database Limits

14 Configuration Parameters and the Registry

About Configuration Parameters

Registry Overview

Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME

ORA_SID_AUTOSTART

ORA_SID_SHUTDOWN

ORA_SID_SHUTDOWN_TIMEOUT

ORA_SID_SHUTDOWNTYPE

ORACLE_AFFINITY

ORACLE_GROUP_NAME

ORACLE_HOME_KEY

ORACLE_HOME_NAME

ORACLE_PRIORITY

OSAUTH_PREFIX_DOMAIN

OSAUTH_X509_NAME

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

Parameters for Oracle Counters for Windows Performance Monitor

Parameters for Oracle Database Services

Oracle Real Application Clusters Registry Parameters

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR

Modifying a Registry Value with regedt32

Adding a Registry Parameter with regedt32

Adding or Modifying Registry Parameters with Oracle Administration Assistant for Windows

Starting Oracle Administration Assistant for Windows

Adding Oracle Home Parameters

Editing Oracle Home Parameters

Deleting Oracle Home Parameters

Modifying Oracle Counters for Windows Performance Monitor Parameters

Using OPERFCFGver

Using Oracle Administration Assistant for Windows

15 Developing Applications for Windows

Finding Information on Application Development for Windows

Java Enhancements

Support for Internet Applications

Application Wizards

Oracle COM/COM+ Integration Feature

Oracle Services For Microsoft Transaction Server

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

Developing Windows Applications

Developing Internet Applications

Building External Procedures

External Procedures Overview

Installing and Configuring

Installing Oracle Database

Configuring Oracle Net Services

Writing an External Procedure

Registering an External Procedure

Executing an External Procedure

Debugging External Procedures

Using Package DEBUG_EXTPROC

Accessing Text Files with UTL_FILE

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 Getting Started with Your Documentation

B Storing Tablespaces on Raw Partitions

Raw Partition Overview

Logical Partition

Physical Disk and Logical Partition Considerations

Compatibility Issues

Creating a Tablespace in a Raw Partition

C Oracle Net Services Configuration on Windows

Understanding Oracle Net Services Registry Parameters and Subkeys

Oracle Net Service Subkeys

Listener Requirements

Understanding Optional Configuration Parameters

USE_SHARED_SOCKET

Advanced Network Configuration

Configuring Authentication Method

Configuring Security for Named Pipes Protocol

Modifying Configuration of External Procedures for Higher Security

D Error Messages on Windows

ORA-09275: CONNECT INTERNAL No Longer Supported

OSD-04000 to OSD-04599: Windows-Specific Oracle Database 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

E Using Oracle Database on Windows 2000

How to Perform Common Tasks in Windows NT and Windows 2000

Other Differences Between Windows NT and Windows 2000

No DNS Domain Name for Windows 2000 Computer

Microsoft Management Console Included in Windows 2000

Services Autostart

F Oracle Database Windows/UNIX Differences

Automatic Startup and Shutdown

Background Processing and Batch Jobs

Diagnostic and Tuning Utilities

Direct Writes to Disk

Dynamic Link Libraries (DLLs)

Initialization Parameters: Multiple Database Writers

Install Accounts and Groups

Memory Resources

Microsoft Transaction Server

Multiple Oracle Homes and OFA

Processes and Threads

Glossary

Index