Skip Headers

Table of Contents Image Oracle9i Database Administrator's Guide
Release 2 (9.2) for Windows

Part Number A95491-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback

Go to next page

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


Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback