Skip Headers
Oracle9
i
Database Platform Guide
Release 2 (9.2) for Windows
Part No. B10163-01
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Organization
Related Documentation
Conventions
Documentation Accessibility
What's New in Oracle9
i
for Windows
Oracle9
i
Release 2 (9.2.0.2) New Feature
Oracle9
i
Release 2 (9.2) New Features
Oracle9
i
Release 1 (9.0.1) New Features
1
Oracle9
i
Architecture on Windows
Oracle9
i
on Windows Architecture
Thread-Based Architecture
File I/O Enhancements
Raw File Support
Oracle9
i
Scalability on Windows
Support for Very Large Memory (VLM) Configurations
4 GB RAM Tuning (4GT)
Large User Populations
Oracle9
i
Integration with Windows
Oracle PKI Integration with Windows
Oracle9
i
Integration with Active Directory
Oracle Net Naming with Active Directory
Oracle Services for Microsoft Transaction Server
Oracle Fail Safe Integration with Windows
Oracle Real Application Clusters Guard Integration with Windows
Other Sources of Information
2
Oracle9
i
Services on Windows
Introduction to Oracle9
i
Services
Oracle9
i
Services Available on Windows
Using Oracle9
i
Services
Multiple Oracle HTTP Server Listeners on the Same Computer
3
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
Oracle8
i
Release 8.1.3 to Oracle9
i
Release 2 (9.2)
Oracle8
i
Release 8.1.5 to Oracle9
i
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 Oracle8
i
Releases 8.1.3, 8.1.4, and 8.1.5
Changing the Value of PATH
Changing the Value of Path Using Oracle Home Selector
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
Disk Mirroring
Disk Striping
Using Raw Partitions for Tablespaces
Comparison Between OFA on Windows and UNIX
Directory Naming
ORACLE_BASE Directory
Support for Symbolic Links on Windows
4
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 Oracle8
i
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
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
5
Postinstallation Database Creation on Windows
Naming Conventions for Oracle Databases
Accessing Data Files and Log Files on Remote Computers
Creating a Database on Windows Using Database Configuration Assistant
Create a Database
Importing Sample Schemas
Delete a Database
Creating a Database on Windows Using Command-Line Tools
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 to Administer an Oracle Instance
Creating an Instance
Starting an Instance
Stopping an Instance
Modifying an Instance
Deleting an Instance
6
Postinstallation Configuration Tasks on Windows
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
Oracle
inter
Media on Windows
Upgrading Oracle
inter
Media from an Earlier Release
Configuring Oracle
inter
Media Audio, Video, Image, and Locator
Configuring Oracle
inter
Media Demos
Configuring Oracle Text on Windows
Configuring Oracle Spatial on Windows
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
Configuring Advanced Replication on Windows
Checking Tablespace and Rollback Segment Requirements
Adding and Modifying Initialization Parameters
Monitoring Data Dictionary Tables
7
Administering a Database on Windows
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
Starting 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
8
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 Performance Objects
Oracle Counters for Windows Performance Monitor Troubleshooting Information
Using Event Viewer
Reading Event Viewer
Managing Event Viewer
Trace Files
Alert Files
Viewing Threads
9
Tuning Windows to Optimize Oracle9
i
Windows Tuning Overview
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
10
Backing Up and Recovering Database Files on Windows
Selecting a Backup and Recovery Tool
Integrating RMAN with a Media Manager on Windows
Backing Up and Recovering Files with OCOPY
11
Oracle9
i
Default Accounts and Passwords on Windows
Accounts and Passwords Overview
Unlocking and Changing Passwords
Granting Limited SYS Database Role Privileges
Reviewing Accounts and Passwords
12
Authenticating Database Users with Windows
Windows Native Authentication Overview
Windows Authentication Protocols
User Authentication and Role Authorization Methods
Authentication and Authorization Methods To Use
Authentication and Authorization Integration with Active Directory
Task 1: Install and Configure Components
Task 2: Set Registry Parameter OSAUTH_X509_NAME
Task 3: Start and Use Oracle Enterprise Security Manager
Using Oracle9
i
Directory Server Features with Active Directory
Operating System Authentication Enabled at Installation
13
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 OS User
Creating a Local Database Role
Creating an External OS 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 OS User
External User Authentication Tasks on the Oracle9
i
Database Server
External User Authentication Tasks on the Client Computer
Manually Granting Administrator and Operator Privileges for Databases
SYSDBA/SYSOPER Authentication Tasks on the Oracle9
i
Database Server
SYSDBA/SYSOPER Authentication Tasks on the Client Computer
Manually Creating an External Role
External Role Authorization Tasks on the Oracle9
i
Database Server
External Role Authorization Tasks on the Client Computer
Manually Migrating Users
14
Administering Enterprise Users and Roles on Windows
Enterprise User Authentication
Enterprise Role Authorization
15
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
Oracle Enterprise Login Assistant
16
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
17
Oracle9
i
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-Specific Values
Displaying Initialization Parameter Values
Uneditable Database Initialization Parameters
Calculating Database Limits
18
Configuration Parameters and the Registry
About Configuration Parameters
Registry Overview
Registry Parameters
Parameters for Oracle Counters for Windows Performance Monitor
Parameters for Oracle Services
Oracle Real Application Clusters Registry Parameters
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
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 OPERFCFG
Using Oracle Administration Assistant for Windows
19
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
Oracle Services for Microsoft Transaction Server
Pro*C/C++ and Pro*COBOL Applications
OLE DB
Developing Windows Applications
Developing Internet Applications
Building External Procedures
External Procedures Overview
Installing and Configuring
Installing Oracle9
i
Database
Configuring Oracle Net Services
Writing an External Procedure
Building a DLL
Registering an External Procedure
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
Getting Started with Your Documentation
B
Storing Tablespaces on Raw Partitions
Raw Partition Overview
Physical Disk
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
LOCAL
TNS_ADMIN
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 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 Oracle9
i
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
Enterprise User Authentication
Raw Partitions
Services Autostart
F
Oracle9
i
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
G
Oracle9
i
Database for 64-Bit Windows
Unsupported Features on 64-Bit Windows
Oracle9
i
Architecture on 64-Bit Windows
Database Tools for 64-Bit Windows
Backing Up and Recovering 64-Bit Database Files
Users and Roles for 64-Bit Windows
Configuration Parameters for 64-Bit Windows
Oracle9
i
release 2 (9.2.0.2) for 64-bit Windows Documentation
Glossary
Index
Copyright © 2003 Oracle Corporation
All rights reserved
Index
