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 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 Database Configuration Assistant

Create a Database

Importing Sample Schemas

Delete a Database

Creating a Database Manually

Creating Directories

Exporting an Existing Database

Deleting Database Files

Modifying the Initialization Parameter File

Creating and Starting an Oracle 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 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

Configuring Oracle interMedia Audio, Video, Image, and Locator

Configuring Oracle interMedia Demos

Oracle Text

Configuring Oracle Text

Oracle Spatial

Manually Configuring Oracle Spatial

Shared Server Support

Enabling Shared Server Support for Java Clients

Enabling Shared Server Support for Two-Task Oracle Net Clients

Disabling Shared Server Support for Two-Task Oracle Net Clients

Advanced Replication

Checking Tablespace and Rollback Segment Requirements

Adding and Modifying Initialization Parameters

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 and Populating Password Files

Viewing and Hiding the Password File

Connecting Remotely to the Database as SYS

Encrypting Database Passwords

Creating Control, Data, and Log Files on Remote Computers

Archiving Redo Log Files

Changing Archive Mode to ARCHIVELOG

Enabling Automatic Archiving

Using 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

Modifying Views

Understanding Oracle Performance Objects

Oracle for Windows NT Performance Monitor Troubleshooting Information

Using Event Viewer

Reading Event Viewer

Managing Event Viewer

Trace Files

Alert Files

Viewing Threads

5 Tuning Windows NT to Optimize Oracle9i

Windows NT Tuning Overview

Reduce Priority of Foreground Applications on Server Console

Configure Windows NT Server to Be an Application Server

Disable Unnecessary Services

Remove Unused Network Protocols

Reset Network Protocol Bind Order

Apply Latest Reliable Windows NT Server Service Pack

Use Hardware or Operating System Striping

Windows NT Server Stripe Set Example

Multiple Striped Volumes for Sequential and Random Access

Multiplex Windows NT Server Virtual Memory Paging File

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 and Recovering Files with OCOPY Utility

7 Oracle9i Database Specifications for Windows

Initialization Parameter File Overview

Location of Initialization Parameter File

Editing Initialization Parameter File

Sample File

SGA_MAX_SIZE Parameter

Initialization Parameters Without Windows NT-Specific Values

Displaying Initialization Parameter Values

Uneditable Database Initialization Parameters

Calculating Database Limits

A Storing Tablespaces on Raw Partitions

Raw Partition Overview

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