Contents

Beta Draft

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database for Windows

• Oracle Database 10g Release 2 (10.2) New Features
• Oracle Database 10g Release 1 (10.1) New Features

1 Oracle Database Architecture on Windows

• 1.1 Oracle Database on Windows Architecture
• • 1.1.1 Automatic Storage Management
  • 1.1.2 Thread-Based Architecture
  • 1.1.3 File I/O Enhancements
  • 1.1.4 Raw File Support
• 1.2 Oracle Database Scalability on Windows
• • 1.2.1 Support for Very Large Memory (VLM) Configurations
  • 1.2.2 Windows 4 GB RAM Tuning (4GT)
  • 1.2.3 Large User Populations
• 1.3 Oracle Database Integration with Windows
• • 1.3.1 Oracle PKI Integration with Windows
  • 1.3.2 Oracle Services for Microsoft Transaction Server
  • 1.3.3 Oracle Fail Safe Integration with Windows
  • 1.3.4 Oracle Real Application Clusters Integration with Windows
• 1.4 Other Sources of Information

2 Database Tools on Windows

• 2.1 Choosing a Database Tool
• • 2.1.1 Database Tools and Operating System Compatibility
  • 2.1.2 Preferred Database Tools
• 2.2 Starting Database Tools
• • 2.2.1 Starting Database Tools in Multiple Oracle Homes
  • • 2.2.1.1 Starting Tools from Oracle8 Release 8.0.4 and Later 8.0.x Multiple Oracle Homes
    • 2.2.1.2 Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes
  • 2.2.2 Starting Database Tools from the Start Menu
  • 2.2.3 Starting Database Tools from the Command Line
  • 2.2.4 Starting Windows Tools
• 2.3 Using SQL*Loader
• • 2.3.1 Windows Processing Options
  • • 2.3.1.1 Default (No Processing Option) or "str terminator_string"
    • 2.3.1.2 "FIX n"
    • 2.3.1.3 "VAR n"
  • 2.3.2 Case Study Files
  • 2.3.3 Specifying the Bad File
  • 2.3.4 Control File Conventions
• 2.4 Using Windows Tools
• • 2.4.1 Using Event Viewer to Monitor a Database
  • 2.4.2 Using Microsoft Management Console to Administer a Database
  • 2.4.3 Using Oracle Counters for Windows Performance Monitor
  • 2.4.4 Using Registry Editor to Modify Configuration Information
  • 2.4.5 Using Task Manager to Monitor Applications and Processes
  • 2.4.6 Using Local Users and Groups to Manage Users and Groups
• 2.5 Optional Windows Diagnostic and Tuning Utilities

3 Postinstallation Database Creation on Windows

• 3.1 Naming Conventions for Oracle Database
• 3.2 Accessing Data Files and Log Files on Remote Computers
• 3.3 Creating a Database on Windows Using Database Configuration Assistant
• 3.4 Creating a Database on Windows Using Command-Line Tools
• • 3.4.1 Creating Directories
  • 3.4.2 Exporting an Existing Database
  • 3.4.3 Deleting Database Files
  • 3.4.4 Modifying the Initialization Parameter File
  • 3.4.5 Starting an Oracle Database Instance
  • 3.4.6 Creating and Starting an Oracle Database Service
  • 3.4.7 Putting the CREATE DATABASE Statement in a Script
  • 3.4.8 Running the CREATE DATABASE Script
  • 3.4.9 Importing a Database
  • 3.4.10 Updating ORACLE_SID in the Registry
  • 3.4.11 Backing Up the New Database
• 3.5 Using ORADIM to Administer an Oracle Database Instance
• • 3.5.1 Creating an Instance
  • 3.5.2 Starting an Instance and Services
  • 3.5.3 Stopping an Instance and Services
  • 3.5.4 Editing an Instance
  • 3.5.5 Deleting an Instance

4 Postinstallation Configuration Tasks on Windows

• 4.1 Windows Firewall
• • 4.1.1 Oracle Executables Requiring Firewall Exceptions
  • 4.1.2 Configuring the Windows Firewall
  • 4.1.3 Troubleshooting Windows Firewall Exceptions
• 4.2 Resetting Passwords for Default Accounts
• 4.3 NTFS File System and Windows Registry Permissions
• • 4.3.1 File Permissions
  • • 4.3.1.1 File Permissions Set by Oracle Universal Installer
    • 4.3.1.2 File Permissions Set by Database Configuration Assistant
    • 4.3.1.3 File Permissions Set by Database Upgrade Assistant
  • 4.3.2 Setting NTFS File System Security
  • 4.3.3 Setting Windows Registry Security
• 4.4 Configuring External Job Support for the Scheduler on Windows
• 4.5 Oracle interMedia on Windows
• • 4.5.1 Upgrading Oracle interMedia from an Earlier Release
  • 4.5.2 Configuring Oracle interMedia Audio, Video, Image, and Locator
  • 4.5.3 Configuring Oracle interMedia Demos
• 4.6 Configuring Oracle Text on Windows
• 4.7 Configuring Oracle Spatial on Windows
• 4.8 Configuring Advanced Replication on Windows
• • 4.8.1 Checking Tablespace and Rollback Segment Requirements
  • 4.8.2 Adding and Modifying Initialization Parameters
  • 4.8.3 Monitoring Data Dictionary Tables

5 Administering a Database on Windows

• 5.1 Managing Oracle Database Services
• • 5.1.1 Oracle Database Service Naming Conventions for Multiple Oracle Homes
  • 5.1.2 Starting Oracle Database Services
  • 5.1.3 Stopping Oracle Database Services
  • 5.1.4 Auto-starting Oracle Database Services
• 5.2 Starting and Shutting Down a Database with SQL*Plus
• 5.3 Starting and Shutting Down a Database Using Services
• 5.4 Starting Multiple Instances
• 5.5 Creating and Populating Password Files
• • 5.5.1 Viewing and Hiding the Password File
• 5.6 Connecting Remotely to the Database as SYS
• 5.7 Automatically Encrypted Database Passwords
• 5.8 Creating Control, Data, and Log Files on Remote Computers
• 5.9 Archiving Redo Log Files
• • 5.9.1 Changing Archive Mode to ARCHIVELOG
  • 5.9.2 Enabling Automatic Archiving

6 Monitoring a Database on Windows

• 6.1 Database Monitoring Overview
• 6.2 Using Oracle Counters for Windows Performance Monitor
• • 6.2.1 Registry Information
  • 6.2.2 Accessing Oracle Counters for Windows Performance Monitor
  • 6.2.3 Modifying Views
  • 6.2.4 Understanding Oracle Database Performance Objects
  • 6.2.5 Oracle Counters for Windows Performance Monitor Troubleshooting Information
• 6.3 Using Event Viewer
• • 6.3.1 Reading Event Viewer
  • 6.3.2 Managing Event Viewer
• 6.4 Trace Files
• 6.5 Alert Logs
• 6.6 Viewing Threads

7 Tuning Windows to Optimize Oracle Database

• 7.1 Windows Tuning Overview
• 7.2 Large Page Support
• 7.3 Reduce Priority of Foreground Applications on Server Console
• 7.4 Configure Windows Server to Be an Application Server
• 7.5 Disable Unnecessary Services
• 7.6 Remove Unused Network Protocols
• 7.7 Reset Network Protocol Bind Order
• 7.8 Setting the Order of Multiple Network Interface Cards
• 7.9 Apply Latest Reliable Windows Server Service Pack
• 7.10 Use Hardware or Operating System Striping
• • 7.10.1 Multiple Striped Volumes for Sequential and Random Access
• 7.11 Multiplex Windows Server Virtual Memory Paging File
• 7.12 Close All Unnecessary Foreground Applications

8 Authenticating Database Users with Windows

• 8.1 Windows Native Authentication Overview
• 8.2 Windows Authentication Protocols
• 8.3 User Authentication and Role Authorization Methods
• • 8.3.1 Authentication and Authorization Methods To Use
• 8.4 Operating System Authentication Enabled at Installation

9 Administering External Users and Roles on Windows

• 9.1 Oracle Administration Assistant for Windows
• • 9.1.1 Managing a Remote Computer
  • 9.1.2 Adding a Computer and Saving Your Configuration
  • 9.1.3 Granting Administrator Privileges for All Databases on a Computer
  • 9.1.4 Granting Operator Privileges for All Databases on a Computer
  • 9.1.5 Connecting to a Database
  • • 9.1.5.1 Troubleshooting Connection Problems
  • 9.1.6 Viewing Database Authentication Parameter Settings
  • 9.1.7 Creating an External Operating System User
  • 9.1.8 Creating a Local Database Role
  • 9.1.9 Creating an External Operating System Role
  • 9.1.10 Granting Administrator Privileges for a Single Database
  • 9.1.11 Granting Operator Privileges for a Single Database
• 9.2 Manually Administering External Users and Roles
• • 9.2.1 Manually Creating an External Operating System User
  • • 9.2.1.1 External User Authentication Tasks on the Oracle Database Server
    • 9.2.1.2 External User Authentication Tasks on the Client Computer
  • 9.2.2 Manually Granting Administrator and Operator Privileges for Databases
  • • 9.2.2.1 SYSDBA/SYSOPER Authentication Tasks on the Oracle Database Server
    • 9.2.2.2 SYSDBA/SYSOPER Authentication Tasks on the Client Computer
  • 9.2.3 Manually Creating an External Role
  • • 9.2.3.1 External Role Authorization Tasks on the Oracle Database Server
    • 9.2.3.2 External Role Authorization Tasks on the Client Computer
  • 9.2.4 Manually Migrating Users

10 Storing Oracle Wallets in the Windows Registry

• 10.1 Storing Private Keys and Trust Points
• 10.2 Storing User's Profile
• 10.3 Registry Parameters for Wallet Storage
• • 10.3.1 Oracle Wallet Manager
  • • 10.3.1.1 Sharing Wallets and sqlnet.ora Files Among Multiple Databases

11 Oracle PKI Integration with Windows

• 11.1 Oracle Public Key Infrastructure
• 11.2 Windows Public Key Infrastructure
• • 11.2.1 Microsoft Certificate Stores
  • 11.2.2 Microsoft Certificate Services
  • 11.2.3 Using Microsoft Certificate Stores with Oracle PKI Applications

12 Using Oracle Database with Microsoft Active Directory

• 12.1 Microsoft Active Directory Support
• • 12.1.1 About Microsoft Active Directory
  • 12.1.2 Accessing Active Directory
• 12.2 Oracle Components That Integrate with Active Directory
• • 12.2.1 Directory Naming
  • 12.2.2 Automatic Discovery of Directory Servers
  • 12.2.3 Integration with Windows Tools
  • 12.2.4 User Interface Extensions for Oracle Net Directory Naming
  • 12.2.5 Enhancement of Directory Object Type Descriptions
  • 12.2.6 Integration with Windows Login Credentials
  • 12.2.7 Oracle Directory Objects in Active Directory
• 12.3 Requirements for Using Oracle Database with Active Directory
• • 12.3.1 Directory Naming Software Requirements
  • 12.3.2 Oracle Schema Objects Creation
  • 12.3.3 Oracle Context Creation
• 12.4 Configuring Oracle Database to Use Active Directory
• 12.5 Testing Connectivity
• • 12.5.1 Testing Connectivity from Client Computers
  • 12.5.2 Testing Connectivity from Microsoft Tools
• 12.6 Access Control List Management for Oracle Directory Objects
• • 12.6.1 Security Groups
  • • 12.6.1.1 OracleDBCreators
    • 12.6.1.2 OracleNetAdmins
  • 12.6.2 Adding and Deleting Security Group Members

13 Oracle Database Specifications for Windows

• 13.1 Initialization Parameter File Overview
• • 13.1.1 Location of the Initialization Parameter File
  • 13.1.2 Editing The Initialization Parameter File
  • 13.1.3 Database Configuration Assistant Renames init.ora
• 13.2 Sample File
• 13.3 SGA_MAX_SIZE Parameter
• 13.4 Initialization Parameters Without Windows-Specific Values
• 13.5 Displaying Initialization Parameter Values
• 13.6 Uneditable Database Initialization Parameters
• 13.7 Calculating Database Limits

14 Configuration Parameters and the Registry

• 14.1 About Configuration Parameters
• 14.2 Registry Overview
• 14.3 Registry Parameters
• • 14.3.1 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
  • • 14.3.1.1 MSHELP_TOOLS
    • 14.3.1.2 NLS_LANG
    • 14.3.1.3 ORA_CWD
    • 14.3.1.4 ORA_SID_AUTOSTART
    • 14.3.1.5 ORA_SID_PFILE
    • 14.3.1.6 ORA_SID_SHUTDOWN
    • 14.3.1.7 ORA_SID_SHUTDOWN_TIMEOUT
    • 14.3.1.8 ORA_SID_SHUTDOWNTYPE
    • 14.3.1.9 ORA_TZFILE
    • 14.3.1.10 ORACLE_AFFINITY
    • 14.3.1.11 ORACLE_BASE
    • 14.3.1.12 ORACLE_GROUP_NAME
    • 14.3.1.13 ORACLE_HOME
    • 14.3.1.14 ORACLE_HOME_KEY
    • 14.3.1.15 ORACLE_HOME_NAME
    • 14.3.1.16 ORACLE_PRIORITY
    • 14.3.1.17 ORACLE_SID
    • 14.3.1.18 OSAUTH_ENFORCE_STRICT
    • 14.3.1.19 OSAUTH_PREFIX_DOMAIN
    • 14.3.1.20 OSAUTH_X509_NAME
    • 14.3.1.21 RDBMS_ARCHIVE
    • 14.3.1.22 RDBMS_CONTROL
    • 14.3.1.23 SQLPATH
  • 14.3.2 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
  • • 14.3.2.1 INST_LOC
    • 14.3.2.2 OO4O
  • 14.3.3 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
  • • 14.3.3.1 Parameters for Oracle Counters for Windows Performance Monitor
    • 14.3.3.2 Parameters for Oracle Database Services
• 14.4 Oracle Real Application Clusters Registry Parameters
• • 14.4.1 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
• 14.5 Managing Registry Parameters with regedt32
• • 14.5.1 Modifying a Parameter Value with regedt32
  • 14.5.2 Adding a Registry Parameter with regedt32
• 14.6 Managing Registry Parameters with Oracle Administration Assistant for Windows
• • 14.6.1 Starting Oracle Administration Assistant for Windows
  • 14.6.2 Adding Oracle Home Parameters
  • 14.6.3 Editing Oracle Home Parameters
  • 14.6.4 Deleting Oracle Home Parameters
• 14.7 Modifying Oracle Counters for Windows Performance Monitor Parameters
• • 14.7.1 Using operfcfg
  • 14.7.2 Using Oracle Administration Assistant for Windows

15 Developing Applications for Windows

• 15.1 Finding Information on Application Development for Windows
• • 15.1.1 Java Enhancements
  • 15.1.2 XML Support
  • 15.1.3 Support for Internet Applications
  • 15.1.4 Application Wizards
  • 15.1.5 Oracle COM/COM+ Integration Feature
  • 15.1.6 Oracle Objects for OLE
  • 15.1.7 ODP.NET
  • 15.1.8 Oracle Services For Microsoft Transaction Server
  • 15.1.9 Pro*C/C++ and Pro*COBOL Applications
  • 15.1.10 OLE DB
• 15.2 Developing Windows Applications
• • 15.2.1 Developing Internet Applications
• 15.3 Building External Procedures
• • 15.3.1 External Procedures Overview
  • 15.3.2 Installing and Configuring
  • • 15.3.2.1 Installing Oracle Database
    • 15.3.2.2 Configuring Oracle Net Services
  • 15.3.3 Writing an External Procedure
  • 15.3.4 Building a DLL
  • 15.3.5 Registering an External Procedure
  • 15.3.6 Executing an External Procedure
• 15.4 Debugging External Procedures
• • 15.4.1 Using Package DEBUG_EXTPROC
• 15.5 Accessing Text Files with UTL_FILE
• 15.6 Accessing Web Data with Intercartridge Exchange
• • 15.6.1 Configuring Intercartridge Exchange
  • 15.6.2 Using Intercartridge Exchange
  • • 15.6.2.1 Packaged Function UTL_HTTP.REQUEST
    • 15.6.2.2 Packaged Function UTL_HTTP.REQUEST_PIECES
  • 15.6.3 UTL_HTTP Exception Conditions
  • • 15.6.3.1 UTL_HTTP.REQUEST
    • 15.6.3.2 UTL_HTTP.REQUEST_PIECES
  • 15.6.4 Exception Conditions and Error Messages

A Getting Started with Your Documentation

B Storing Tablespaces on Raw Partitions

• B.1 Raw Partition Overview
• • B.1.1 Physical Disk
  • B.1.2 Logical Partition
  • B.1.3 Physical Disk and Logical Partition Considerations
  • B.1.4 Compatibility Issues
• B.2 Creating a Tablespace in a Raw Partition
• B.3 Configuring Disks for Automatic Storage Management

C Oracle Net Services Configuration on Windows

• C.1 Configuring Oracle Database to Communicate with ASM
• C.2 Understanding Oracle Net Services Registry Parameters and Subkeys
• • C.2.1 Oracle Net Service Subkeys
• C.3 Listener Requirements
• C.4 Understanding Optional Configuration Parameters
• • C.4.1 LOCAL
  • C.4.2 TNS_ADMIN
  • C.4.3 USE_SHARED_SOCKET
• C.5 Advanced Network Configuration
• • C.5.1 Configuring Authentication Method
  • C.5.2 Configuring Security for Named Pipes Protocol
  • C.5.3 Modifying Configuration of External Procedures for Higher Security

D Error Messages on Windows

• D.1 ORA-09275: CONNECT INTERNAL No Longer Supported
• D.2 OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
• • D.2.1 File I/O Errors: OSD-04000 to OSD-04099
  • D.2.2 Memory Errors: OSD-04100 to OSD-04199
  • D.2.3 Process Errors: OSD-04200 to OSD-04299
  • D.2.4 Loader Errors: OSD-04300 to OSD-04399
  • D.2.5 Semaphore Errors: OSD-04400 to OSD-04499
  • D.2.6 Miscellaneous Errors: OSD-04500 to OSD-04599
• D.3 DIM-00000 to DIM-00039: ORADIM Command Syntax Errors
• D.4 Database Connection Issues

E Oracle Database Windows/UNIX Differences

• E.1 Automatic Startup and Shutdown
• E.2 Background Processing and Batch Jobs
• E.3 Diagnostic and Tuning Utilities
• E.4 Direct Writes to Disk
• E.5 Dynamic Link Libraries (DLLs)
• E.6 Hot Backups
• E.7 Initialization Parameters: Multiple Database Writers
• E.8 Install Accounts and Groups
• E.9 Installation
• E.10 Memory Resources
• E.11 Microsoft Transaction Server
• E.12 Multiple Oracle Homes and OFA
• E.13 Processes and Threads
• E.14 Raw Partitions
• E.15 Services

Glossary