Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database for Windows

• Windows Server 2008 and Windows Server 2008 R2 Support
• Oracle Database 10g Release 2 (10.2) New Features
• Oracle Database 10g Release 1 (10.1) New Features

1 Oracle Database Architecture on Windows

• Oracle Database on Windows Architecture
  • Automatic Storage Management
  • Thread-Based Architecture
  • File I/O Enhancements
  • Raw File Support
• Oracle Database Scalability on Windows
• Oracle Database Integration with Windows
  • Oracle PKI Integration with Windows
  • Oracle Services for Microsoft Transaction Server
  • Oracle Fail Safe Integration with Windows
  • Oracle Real Application Clusters Integration with Windows
• Other Sources of Information

2 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 Oracle8i Release 8.1.3 and Later Multiple Oracle Homes
  • Starting Database Tools on Windows Server 2008 and Windows Server 2008 R2
  • Starting Database Tools from the Start Menu
  • Starting Database Tools from the Command Line
  • 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

3 Postinstallation Database Creation on Windows

• Naming Conventions for Oracle Database
• Accessing Data Files and Log Files on Remote Computers
• Creating a Database on Windows Using Database Configuration Assistant
• Creating a Database on Windows Using Command-Line Tools
  • Creating Directories
  • Exporting an Existing Database
  • Deleting Database Files
  • Modifying the Initialization Parameter File
  • Starting an Oracle Database Instance
  • Creating and Starting an Oracle Database 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 Database Instance
  • Creating an Instance
  • Starting an Instance and Services
  • Stopping an Instance and Services
  • Editing an Instance
  • Deleting an Instance
• Database Migration from a 32-bit Windows Computer
  • Backing Up a 32-Bit Oracle Database
  • Migrating an Oracle Database 10g Release 2 (10.2) Database
  • Migrating an Oracle Database 10g Release 1 (10.1) or Older Database

4 Postinstallation Configuration Tasks on Windows

• Windows Firewall
  • Oracle Executables Requiring Firewall Exceptions
  • Configuring the Windows Firewall
  • Troubleshooting Windows Firewall Exceptions
• Resetting Passwords for Default Accounts
• 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
• Configuring External Job Support for the Scheduler on Windows
• Oracle interMedia on Windows
  • Upgrading Oracle interMedia from an Earlier Release
  • Configuring Oracle interMedia Audio, Video, Image, and Locator
  • Configuring Oracle interMedia Demos
• Configuring Oracle Text on Windows
• Configuring Oracle Spatial on Windows
• Configuring Advanced Replication on Windows
  • Checking Tablespace and Rollback Segment Requirements
  • Adding and Modifying Initialization Parameters
  • Monitoring Data Dictionary Tables

5 Administering a Database on Windows

• Managing Oracle Database Services
  • Oracle Database Service Naming Conventions for Multiple Oracle Homes
  • Starting Oracle Database Services
  • Stopping Oracle Database Services
  • Auto-starting Oracle Database 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
• Automatically Encrypted Database Passwords
• Creating Control, Data, and Log Files on Remote Computers
• Archiving Redo Log Files
  • Changing Archive Mode to ARCHIVELOG
  • Enabling Automatic Archiving

6 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 Database Performance Objects
  • Oracle Counters for Windows Performance Monitor Troubleshooting Information
• Using Event Viewer
  • Reading Event Viewer
  • Managing Event Viewer
• Trace Files
• Alert Logs
• Viewing Threads

7 Tuning Windows to Optimize Oracle Database

• Windows Tuning Overview
• Large Page Support
• 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
• Setting the Order of Multiple Network Interface Cards
• 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

8 Authenticating Database Users with Windows

• Windows Native Authentication Overview
• Windows Authentication Protocols
• User Authentication and Role Authorization Methods
  • Authentication and Authorization Methods To Use
• Operating System Authentication Enabled at Installation

9 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 Operating System User
  • Creating a Local Database Role
  • Creating an External Operating System 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 Operating System User
    • External User Authentication Tasks on the Oracle Database Server
    • External User Authentication Tasks on the Client Computer
  • Manually Granting Administrator and Operator Privileges for Databases
    • SYSDBA/SYSOPER Authentication Tasks on the Oracle Database Server
    • SYSDBA/SYSOPER Authentication Tasks on the Client Computer
  • Manually Creating an External Role
    • External Role Authorization Tasks on the Oracle Database Server
    • External Role Authorization Tasks on the Client Computer
  • Manually Migrating Users

10 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
    • Sharing Wallets and sqlnet.ora Files Among Multiple Databases

11 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

12 Using Oracle Database with Microsoft Active Directory

• Microsoft Active Directory Support
  • About Microsoft Active Directory
  • Accessing Active Directory
• Oracle Components That Integrate with Active Directory
  • Directory Naming
  • Automatic Discovery of Directory Servers
  • Integration with Windows Tools
  • User Interface Extensions for Oracle Net Directory Naming
  • Enhancement of Directory Object Type Descriptions
  • Integration with Windows Login Credentials
  • Oracle Directory Objects in Active Directory
• Requirements for Using Oracle Database with Active Directory
  • Directory Naming Software Requirements
  • Oracle Schema Objects Creation
  • Oracle Context Creation
• Configuring Oracle Database to Use Active Directory
• Testing Connectivity
  • Testing Connectivity from Client Computers
  • Testing Connectivity from Microsoft Tools
• Access Control List Management for Oracle Directory Objects
  • Security Groups
    • OracleDBCreators
    • OracleNetAdmins
  • Adding and Deleting Security Group Members

13 Oracle Database Specifications for Windows

• Initialization Parameter File Overview
  • Location of the Initialization Parameter File
  • Editing The Initialization Parameter File
  • Database Configuration Assistant Renames init.ora
• Sample File
• SGA_MAX_SIZE Parameter
• Initialization Parameters Without Windows-Specific Values
• Displaying Initialization Parameter Values
• Uneditable Database Initialization Parameters
• Calculating Database Limits

14 Configuration Parameters and the Registry

• About Configuration Parameters
• Registry Overview
• Registry Parameters
  • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
    • MSHELP_TOOLS
    • NLS_LANG
    • ORA_CWD
    • ORA_SID_AUTOSTART
    • ORA_SID_PFILE
    • ORA_SID_SHUTDOWN
    • ORA_SID_SHUTDOWN_TIMEOUT
    • ORA_SID_SHUTDOWNTYPE
    • ORA_TZFILE
    • ORACLE_AFFINITY
    • ORACLE_BASE
    • ORACLE_GROUP_NAME
    • ORACLE_HOME
    • ORACLE_HOME_KEY
    • ORACLE_HOME_NAME
    • ORACLE_PRIORITY
    • ORACLE_SID
    • OSAUTH_PREFIX_DOMAIN
    • OSAUTH_X509_NAME
    • RDBMS_ARCHIVE
    • RDBMS_CONTROL
    • SQLPATH
  • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    • INST_LOC
    • OO4O
  • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
    • Parameters for Oracle Counters for Windows Performance Monitor
    • Parameters for Oracle Database Services
• Oracle Real Application Clusters Registry Parameters
  • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
• Managing Registry Parameters with regedt
  • Modifying a Parameter Value with regedt
  • Adding a Registry Parameter with regedt
• Managing 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

15 Developing Applications for Windows

• Finding Information on Application Development for Windows
  • Java Enhancements
  • ODP.NET
  • XML Support
  • Support for Internet Applications
  • Oracle COM Automation Feature
  • Oracle Objects for OLE
  • Oracle Services For Microsoft Transaction Server
  • Pro*C/C++ and Pro*COBOL Applications
  • OLE DB
  • Oracle ODBC Driver
• Developing Windows Applications
• Application Migration
• Building External Procedures
  • External Procedures Overview
  • Installing and Configuring
    • Installing Oracle Database
    • Configuring Oracle Net Services
  • Writing an External Procedure
  • Building a DLL
  • Registering an External Procedure
  • Executing an External Procedure
• Multithreaded Agent Architecture
• Debugging External Procedures
  • Using Package DEBUG_EXTPROC
• Accessing Text Files with UTL_FILE
• 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
• Configuring Disks for Automatic Storage Management

C Oracle Net Services Configuration on Windows

• Configuring Oracle Database to Communicate with ASM
• 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 Database 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 Oracle Database 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

Glossary

Index