Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle9i for Windows

Windows Integration

Oracle Database Configuration Assistant Improvements

Oracle Internet Directory Administration Improvements

Using Oracle9i on Windows 2000

Oracle9i Desupported and Deprecated Features

1 Postinstallation Database Creation

Before You Create a Database

Naming Conventions for Oracle Databases

Accessing Data Files and Log Files on Remote Computers

Creating a Database Using Tools

Using Oracle Database Configuration Assistant

Create a Database

Importing Sample Schemas

Delete a Database

Creating a Database Manually

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

Using the ORADIM Utility to Administer an Oracle Instance

Creating an Instance

Starting an Instance

Stopping an Instance

Modifying an Instance

Deleting an Instance

2 Postinstallation Configuration Tasks

Oracle interMedia

Audio

Video

Image

Locator

Oracle 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 Text Configuration Responsibilities

Oracle Spatial

Configuring Oracle Spatial

Shared Server Support

Enabling Shared Server Support for IIOP Clients

Enabling Shared Server Support for Two-Task Oracle Net Clients

Disabling Shared Server Support for Two-Task Oracle Net Clients

Advanced Replication

Task 1: Checking Tablespace and Rollback Segment Requirements

Task 2: Checking Initialization Parameters

Task 3: Monitoring Data Dictionary Tables

3 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 Remotely to the Database as SYS

Encrypting Database Passwords

Creating Control, Data, and Log Files on Remote Computers

Archiving Redo Log Files

Task 1: Change the Archive Mode to ARCHIVELOG

Task 2: Enable Automatic Archiving

Using the ORADEBUG Utility

4 Monitoring a Database

Database Monitoring Overview

Using Oracle for Windows NT Performance Monitor

Registry Information

Accessing Oracle for Windows NT Performance Monitor

Monitoring Oracle9i Objects

Understanding Oracle Performance Objects

Oracle for Windows NT Performance Monitor Troubleshooting Information

Using the Event Viewer

Accessing the Event Viewer

Reading the Event Viewer

Using the Event Viewer to Display More Information

Managing the Event Viewer

Using Trace and Alert Files

Viewing Threads Using the Oracle Administration Assistant for Windows NT

5 Tuning Windows NT to Optimize Oracle9i

Overview

Reduce Priority of Foreground Applications on the Server Console

Configure Windows NT Server to Be an Application Server

Disable Unnecessary Services

Remove Unused Network Protocols

Reset the Network Protocol Bind Order

Apply Latest Reliable Windows NT Server Service Pack

Use Hardware or Operating System Striping

Multiple Striped Volumes for Sequential and Random Access

Span Windows NT Server Virtual Memory Paging File Across Physical Volumes

General Page File Sizing Tip

Close All Unnecessary Foreground Applications

Startup Folder

Virtual DOS Machines

Screen Savers

6 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool

Integrating RMAN with a Media Manager on Windows NT

Backing Up Files with the OCOPY Utility

Recovering Files with the OCOPY Utility

Using Legato Storage Manager

Settings for Multiple Tape Devices

Japanese Version of Legato Storage Manager

7 Oracle9i Database Specifications for Windows

Initialization Parameter File (init.ora) Overview

Location of the Initialization Parameter File

Editing the Initialization Parameter File

Sample File

SGA_MAX_SIZE parameter

Initialization Parameters Without Windows NT-Specific Values

Displaying Initialization Parameter Values

Database Initialization Parameters

Calculating Database Limits

A 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

Creating a Tablespace in a Raw Partition

Glossary

Index