Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database for Windows

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
  • Support for Very Large Memory (VLM) Configurations
  • Windows 4 GB RAM Tuning (4GT)
  • Large User Populations
• Oracle Database Integration with Windows
  • Oracle PKI Integration with Windows
  • Oracle Services for Microsoft Transaction Server
  • Oracle Fail Safe 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
  • Running Tools with Windows User Account Control
  • 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"
  • 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
• Optional Windows Diagnostic and Tuning Utilities

3 Postinstallation Database Creation on Windows

• Naming Conventions for Oracle Database
• Creating a Database on Windows Using Database Configuration Assistant
• Creating a Database on Windows Using Command-Line Tools
  • Exporting an Existing Database
  • Deleting Database Files
  • Modifying the Initialization Parameter File
  • Creating and Starting an Oracle Database Service
  • Starting an Oracle Database Instance
  • Putting the CREATE DATABASE Statement in a Script
  • 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 11g Release 2 (11.2)
  • Migrating an Oracle Database 10g Release 2 (10.2) or Earlier Database

4 Postinstallation Configuration Tasks on Windows

• Windows Firewall
  • Oracle Executables Requiring Firewall Exceptions
    • Firewall Exceptions for Oracle Database
    • Firewall Exceptions for Oracle Database Examples
    • Firewall Exceptions for Oracle Gateways
    • Firewall Exceptions for Oracle Clusterware and Oracle ASM
    • Firewall Exceptions for Other Oracle Products
  • 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
• Configuring Oracle Multimedia on Windows
• 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
• Accessing Database Files on Remote Computers
• Archiving Redo Log Files

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 Performing Database Backup and Recovery with VSS

• Overview of Database Backup and Recovery with VSS
  • Purpose of Database Backup and Recovery with VSS
  • Scope of This Chapter
  • Basic Concepts of Database Backup and Recovery with VSS
    • Component-Based Shadow Copies
    • Volume-Based Shadow Copies
    • Oracle VSS Backup Types
  • Basic Steps of Backup and Recovery with VSS
• Installing and Uninstalling the Oracle VSS Writer Service
• Backing Up a Database
  • About Component-Based Backups
  • Backing Up a Database in ARCHIVELOG Mode
    • Making Component-Based Backups of an ARCHIVELOG Database
    • Making Volume-Based Backups of an ARCHIVELOG Database
  • Backing Up a Database in NOARCHIVELOG Mode
    • Making Component-Based Backups of a NOARCHIVELOG Database
    • Making Volume-Based Backups of a NOARCHIVELOG Database
• Restoring and Recovering a Database
  • Restoring and Recovering a Database in ARCHIVELOG Mode
    • Restoring the Server Parameter File
    • Recovering from the Loss of All Control Files
    • Recovering Tablespaces or Datafiles
    • Recovering All Tablespaces
    • Performing Disaster Recovery
  • Restoring a Database in NOARCHIVELOG Mode
    • Restoring Component-Based Backups of a NOARCHIVELOG Database
    • Restoring Volume-Based Backups of a NOARCHIVELOG Database
• Integrating VSS with Third-Party Requester Applications
  • Writer Control Commands
  • Control Commands for Database or All Tablespaces Component
• Duplicating a Database
  • Creating a Nonstandby Database from Shadow Copies
  • Creating a Standby Database From Shadow Copies

9 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

10 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/SYSASM Authentication Tasks on the Oracle Database Server
    • SYSDBA/SYSOPER/SYSASM 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

11 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

12 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

13 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
  • Creating an OracleContext
    • Network Configuration Assistant (NetCA)
  • Oracle Schema Objects 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
    • NetService Objects
  • Setting ACLs on NetService Entries
  • Adding and Deleting Security Group Members

14 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

15 Configuration Parameters and the Registry

• About Configuration Parameters
• Registry Overview
• Registry Parameters
  • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
    • MSHELP_TOOLS
    • NLS_LANG and Other Globalization Parameters
    • 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
    • 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 RAC Registry Parameters
  • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
• Managing Registry Parameters with regedit
  • Modifying a Parameter Value with regedit
  • Adding a Registry Parameter with regedit
• 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

16 Developing Applications for Windows

• Finding Information on Application Development for Windows
  • Java Enhancements
  • ODP.NET
  • Oracle Developer Tools for Visual Studio
  • Oracle Providers for ASP.NET
  • XML Support
  • Support for Internet Applications
  • Oracle Services For Microsoft Transaction Server
  • Oracle Objects for OLE
  • Oracle Provider for OLE DB
  • Oracle COM Automation Feature
  • Pro*C/C++ and Pro*COBOL Applications
• 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
  • Restricting Library-Related Privileges to Trusted Users Only
  • 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 Raw Partition and a Mount Point
• 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