Skip Headers
Oracle® Database Platform Guide
11g Release 1 (11.1) for Microsoft Windows
Part Number B32010-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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
Oracle RAC 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 Oracle8
i
Release 8.1.3 and Later Multiple Oracle Homes
Starting Database Tools on Windows Vista
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
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
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
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 11
g
Release 1 (11.1) Database
Migrating an Oracle Database 10
g
Release 2 (10.2) or Earlier 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
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
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
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
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
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
Configuring an OracleContext in Microsoft Windows 2003 Active Directory
Configuring Active Directory
Register Schema Management Library
Start Microsoft Management Console (MMC)
Add Active Directory Schema Snap-in
Check Schema Permissions
Grant Schema Write Privilege
Extending the Schema
Enable Anonymous Bind Operations
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_ENFORCE_STRICT
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 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
XML Support
Support for Internet Applications
Application Wizards
Oracle COM/COM+ Integration Feature
Oracle Objects for OLE
ODP.NET
Oracle Services For Microsoft Transaction Server
Pro*C/C++ and Pro*COBOL Applications
OLE DB
Developing Windows Applications
Developing Internet 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 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