Oracle® Database Platform Guide for Microsoft Windows
Oracle® Database Platform Guide for Microsoft Windows
Preface
“Preface”
Audience
“Audience”
Documentation Accessibility
“Documentation Accessibility”
Accessibility of Code Examples in Documentation
“Accessibility of Code Examples in Documentation”
Accessibility of Links to External Web Sites in Documentation
“Accessibility of Links to External Web Sites in Documentation”
Deaf/Hard of Hearing Access to Oracle Support Services
“Deaf/Hard of Hearing Access to Oracle Support Services”
Related Documents
“Related Documents”
Conventions
“Conventions”
What's New in Oracle Database for Windows
“What's New in Oracle Database for Windows”
Secure Database Services
“Secure Database Services”
Active Directory Security Enhancements
“Active Directory Security Enhancements”
Volume Shadow Copy Service (VSS) Writer
“Volume Shadow Copy Service (VSS) Writer”
Windows Operating System Support
“Windows Operating System Support”
Support for Online Patching
“Support for Online Patching”
Oracle Database Architecture on Windows
“Oracle Database Architecture on Windows”
Oracle Database on Windows Architecture
“Oracle Database on Windows Architecture”
Automatic Storage Management
“Automatic Storage Management”
Thread-Based Architecture
“Thread-Based Architecture”
Oracle Database Architecture on Windows
“Oracle Database Architecture on Windows”
Oracle Database Threads
“Oracle Database Threads”
File I/O Enhancements
“File I/O Enhancements”
Raw File Support
“Raw File Support”
Oracle Database Scalability on Windows
“Oracle Database Scalability on Windows”
Support for Very Large Memory (VLM) Configurations
“Support for Very Large Memory (VLM) Configurations”
VLM Instance Tuning
“VLM Instance Tuning”
Windows 4 GB RAM Tuning (4GT)
“Windows 4 GB RAM Tuning (4GT)”
Large User Populations
“Large User Populations”
Oracle Database Integration with Windows
“Oracle Database Integration with Windows”
Oracle PKI Integration with Windows
“Oracle PKI Integration with Windows”
Oracle Services for Microsoft Transaction Server
“Oracle Services for Microsoft Transaction Server”
Oracle Fail Safe Integration with Windows
“Oracle Fail Safe Integration with Windows”
Other Sources of Information
“Other Sources of Information”
Database Tools on Windows
“Database Tools on Windows”
Choosing a Database Tool
“Choosing a Database Tool”
Database Tools and Operating System Compatibility
“Database Tools and Operating System Compatibility”
Preferred Database Tools
“Preferred Database Tools”
Preferred Database Tools
“Preferred Database Tools”
Starting Database Tools
“Starting Database Tools”
Starting Database Tools in Multiple Oracle Homes
“Starting Database Tools in Multiple Oracle Homes”
Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes
“Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes”
Running Tools with Windows User Account Control
“Running Tools with Windows User Account Control”
Starting Database Tools from the Start Menu
“Starting Database Tools from the Start Menu”
Starting Database Tools from the Start Menu
“Starting Database Tools from the Start Menu”
Starting Database Tools from the Command Line
“Starting Database Tools from the Command Line”
Starting Database Tools from the Command Line
“Starting Database Tools from the Command Line”
Starting Windows Tools
“Starting Windows Tools”
Starting Windows Tools
“Starting Windows Tools”
Using SQL*Loader
“Using SQL*Loader”
Windows Processing Options
“Windows Processing Options”
Default (No Processing Option) or "str terminator_string"
“Default (No Processing Option) or "str terminator_string"”
Control File Conventions
“Control File Conventions”
Default Sizes of Native Data types
“Default Sizes of Native Data types”
Note
“Note”
Using Windows Tools
“Using Windows Tools”
Using Event Viewer to Monitor a Database
“Using Event Viewer to Monitor a Database”
Using Microsoft Management Console to Administer a Database
“Using Microsoft Management Console to Administer a Database”
Using Oracle Counters for Windows Performance Monitor
“Using Oracle Counters for Windows Performance Monitor”
Using Registry Editor to Modify Configuration Information
“Using Registry Editor to Modify Configuration Information”
Using Task Manager to Monitor Applications and Processes
“Using Task Manager to Monitor Applications and Processes”
Using Local Users and Groups to Manage Users and Groups
“Using Local Users and Groups to Manage Users and Groups”
Optional Windows Diagnostic and Tuning Utilities
“Optional Windows Diagnostic and Tuning Utilities”
Postinstallation Database Creation on Windows
“Postinstallation Database Creation on Windows”
Naming Conventions for Oracle Database
“Naming Conventions for Oracle Database”
Creating a Database on Windows Using Database Configuration Assistant
“Creating a Database on Windows Using Database Configuration Assistant”
Creating a Database on Windows Using Command-Line Tools
“Creating a Database on Windows Using Command-Line Tools”
Manual Database Creation Tasks
“Manual Database Creation Tasks”
Note 1
“Note 1”
Note 2
“Note 2”
Exporting an Existing Database
“Exporting an Existing Database”
Deleting Database Files
“Deleting Database Files”
Modifying the Initialization Parameter File
“Modifying the Initialization Parameter File”
Creating and Starting an Oracle Database Service
“Creating and Starting an Oracle Database Service”
Starting an Oracle Database Instance
“Starting an Oracle Database Instance”
Putting the CREATE DATABASE Statement in a Script
“Putting the CREATE DATABASE Statement in a Script”
Running the CREATE DATABASE Script
“Running the CREATE DATABASE Script”
Importing a Database
“Importing a Database”
Updating ORACLE_SID in the Registry
“Updating ORACLE_SID in the Registry”
Backing Up the New Database
“Backing Up the New Database”
Using ORADIM to Administer an Oracle Database Instance
“Using ORADIM to Administer an Oracle Database Instance”
Creating an Instance
“Creating an Instance”
Starting an Instance and Services
“Starting an Instance and Services”
Stopping an Instance and Services
“Stopping an Instance and Services”
Editing an Instance
“Editing an Instance”
Deleting an Instance
“Deleting an Instance”
Database Migration from a 32-bit Windows Computer
“Database Migration from a 32-bit Windows Computer”
Backing Up a 32-Bit Oracle Database
“Backing Up a 32-Bit Oracle Database”
Migrating an Oracle Database 11g Release 2 (11.2)
“Migrating an Oracle Database 11g Release 2 (11.2)”
Migrating an Oracle Database 10g Release 2 (10.2) or Earlier Database
“Migrating an Oracle Database 10g Release 2 (10.2) or Earlier Database”
Postinstallation Configuration Tasks on Windows
“Postinstallation Configuration Tasks on Windows”
Windows Firewall
“Windows Firewall”
Oracle Executables Requiring Firewall Exceptions
“Oracle Executables Requiring Firewall Exceptions”
Firewall Exceptions for Oracle Database
“Firewall Exceptions for Oracle Database”
Firewall Exceptions for Oracle Database Examples
“Firewall Exceptions for Oracle Database Examples”
Firewall Exceptions for Oracle Gateways
“Firewall Exceptions for Oracle Gateways”
Oracle Executables Requiring Windows Firewall Exceptions
“Oracle Executables Requiring Windows Firewall Exceptions”
Firewall Exceptions for Oracle Clusterware and Oracle ASM
“Firewall Exceptions for Oracle Clusterware and Oracle ASM”
Firewall Exceptions for Other Oracle Products
“Firewall Exceptions for Other Oracle Products”
Other Oracle Software Products Requiring Windows Firewall Exceptions
“Other Oracle Software Products Requiring Windows Firewall Exceptions”
Configuring the Windows Firewall
“Configuring the Windows Firewall”
Troubleshooting Windows Firewall Exceptions
“Troubleshooting Windows Firewall Exceptions”
Resetting Passwords for Default Accounts
“Resetting Passwords for Default Accounts”
NTFS File System and Windows Registry Permissions
“NTFS File System and Windows Registry Permissions”
File Permissions
“File Permissions”
File Permissions Set by Oracle Universal Installer
“File Permissions Set by Oracle Universal Installer”
File Permissions Set by Database Configuration Assistant
“File Permissions Set by Database Configuration Assistant”
File Permissions Set by Database Upgrade Assistant
“File Permissions Set by Database Upgrade Assistant”
Setting NTFS File System Security
“Setting NTFS File System Security”
Setting Windows Registry Security
“Setting Windows Registry Security”
Configuring External Job Support for the Scheduler on Windows
“Configuring External Job Support for the Scheduler on Windows”
Configuring Oracle Multimedia on Windows
“Configuring Oracle Multimedia on Windows”
Configuring Oracle Text on Windows
“Configuring Oracle Text on Windows”
Upgrading Oracle Text from a Previous Release
“Upgrading Oracle Text from a Previous Release”
Configuring Oracle Text Using Database Configuration Assistant
“Configuring Oracle Text Using Database Configuration Assistant”
Configuring Oracle Spatial on Windows
“Configuring Oracle Spatial on Windows”
Configuring Advanced Replication on Windows
“Configuring Advanced Replication on Windows”
Checking Tablespace and Rollback Segment Requirements
“Checking Tablespace and Rollback Segment Requirements”
Advanced Replication Tablespace/Rollback Segment Requirements
“Advanced Replication Tablespace/Rollback Segment Requirements”
Note
“Note”
Adding and Modifying Initialization Parameters
“Adding and Modifying Initialization Parameters”
Advanced Replication Initialization Parameters
“Advanced Replication Initialization Parameters”
Note
“Note”
Monitoring Data Dictionary Tables
“Monitoring Data Dictionary Tables”
Administering a Database on Windows
“Administering a Database on Windows”
Managing Oracle Database Services
“Managing Oracle Database Services”
Oracle Database Service Naming Conventions for Multiple Oracle Homes
“Oracle Database Service Naming Conventions for Multiple Oracle Homes”
Starting Oracle Database Services
“Starting Oracle Database Services”
Control Panel
“Control Panel”
Command Prompt
“Command Prompt”
Oracle Administration Assistant for Windows
“Oracle Administration Assistant for Windows”
Stopping Oracle Database Services
“Stopping Oracle Database Services”
Control Panel
“Control Panel”
Command Prompt
“Command Prompt”
Oracle Administration Assistant for Windows
“Oracle Administration Assistant for Windows”
Auto-starting Oracle Database Services
“Auto-starting Oracle Database Services”
Control Panel
“Control Panel”
Oracle Administration Assistant for Windows
“Oracle Administration Assistant for Windows”
Starting and Shutting Down a Database with SQL*Plus
“Starting and Shutting Down a Database with SQL*Plus”
Starting and Shutting Down a Database Using Services
“Starting and Shutting Down a Database Using Services”
Oracle Administration Assistant for Windows
“Oracle Administration Assistant for Windows”
Setting Registry Parameters
“Setting Registry Parameters”
Starting or Stopping OracleServiceSID from the Control Panel
“Starting or Stopping OracleServiceSID from the Control Panel”
Starting Multiple Instances
“Starting Multiple Instances”
Creating and Populating Password Files
“Creating and Populating Password Files”
Viewing and Hiding the Password File
“Viewing and Hiding the Password File”
Command Prompt
“Command Prompt”
Windows Explorer
“Windows Explorer”
Connecting Remotely to the Database as SYS
“Connecting Remotely to the Database as SYS”
Automatically Encrypted Database Passwords
“Automatically Encrypted Database Passwords”
Accessing Database Files on Remote Computers
“Accessing Database Files on Remote Computers”
Archiving Redo Log Files
“Archiving Redo Log Files”
Monitoring a Database on Windows
“Monitoring a Database on Windows”
Database Monitoring Overview
“Database Monitoring Overview”
Database Monitoring Tools
“Database Monitoring Tools”
Using Oracle Counters for Windows Performance Monitor
“Using Oracle Counters for Windows Performance Monitor”
Registry Information
“Registry Information”
Accessing Oracle Counters for Windows Performance Monitor
“Accessing Oracle Counters for Windows Performance Monitor”
Modifying Views
“Modifying Views”
Understanding Oracle Database Performance Objects
“Understanding Oracle Database Performance Objects”
Oracle Database Buffer Cache
“Oracle Database Buffer Cache”
Oracle Database Redo Log Buffer
“Oracle Database Redo Log Buffer”
Oracle Database Data Dictionary Cache
“Oracle Database Data Dictionary Cache”
Oracle Database Library Cache
“Oracle Database Library Cache”
Oracle Database Datafiles
“Oracle Database Datafiles”
Oracle Database DBWR stats1
“Oracle Database DBWR stats1”
Oracle Database DBWR stats2
“Oracle Database DBWR stats2”
Oracle Database Dynamic Space Management
“Oracle Database Dynamic Space Management”
Oracle Database Free List
“Oracle Database Free List”
Oracle Database Sorts
“Oracle Database Sorts”
Oracle Counters for Windows Performance Monitor Troubleshooting Information
“Oracle Counters for Windows Performance Monitor Troubleshooting Information”
Using Event Viewer
“Using Event Viewer”
Application View Window
“Application View Window”
Application View Definitions
“Application View Definitions”
Event Viewer Icons
“Event Viewer Icons”
Reading Event Viewer
“Reading Event Viewer”
Event Detail Dialog
“Event Detail Dialog”
Managing Event Viewer
“Managing Event Viewer”
Trace Files
“Trace Files”
Alert Logs
“Alert Logs”
Viewing Threads
“Viewing Threads”
Tuning Windows to Optimize Oracle Database
“Tuning Windows to Optimize Oracle Database”
Windows Tuning Overview
“Windows Tuning Overview”
Large Page Support
“Large Page Support”
Reduce Priority of Foreground Applications on Server Console
“Reduce Priority of Foreground Applications on Server Console”
Configure Windows Server to Be an Application Server
“Configure Windows Server to Be an Application Server”
Windows Server Memory Shares
“Windows Server Memory Shares”
Disable Unnecessary Services
“Disable Unnecessary Services”
Remove Unused Network Protocols
“Remove Unused Network Protocols”
Reset Network Protocol Bind Order
“Reset Network Protocol Bind Order”
Setting the Order of Multiple Network Interface Cards
“Setting the Order of Multiple Network Interface Cards”
Apply Latest Reliable Windows Server Service Pack
“Apply Latest Reliable Windows Server Service Pack”
Use Hardware or Operating System Striping
“Use Hardware or Operating System Striping”
RAID Levels in Oracle Database Installations
“RAID Levels in Oracle Database Installations”
Note
“Note”
Note
“Note”
Disk Striping
“Disk Striping”
Disk Mirroring
“Disk Mirroring”
Disk Striping + Mirroring
“Disk Striping + Mirroring”
Distributed Data Guarding
“Distributed Data Guarding”
Multiple Striped Volumes for Sequential and Random Access
“Multiple Striped Volumes for Sequential and Random Access”
Multiplex Windows Server Virtual Memory Paging File
“Multiplex Windows Server Virtual Memory Paging File”
General Page File Sizing Tip
“General Page File Sizing Tip”
Close All Unnecessary Foreground Applications
“Close All Unnecessary Foreground Applications”
Performing Database Backup and Recovery with VSS
“Performing Database Backup and Recovery with VSS”
Overview of Database Backup and Recovery with VSS
“Overview of Database Backup and Recovery with VSS”
Purpose of Database Backup and Recovery with VSS
“Purpose of Database Backup and Recovery with VSS”
Scope of This Chapter
“Scope of This Chapter”
Basic Concepts of Database Backup and Recovery with VSS
“Basic Concepts of Database Backup and Recovery with VSS”
Component-Based Shadow Copies
“Component-Based Shadow Copies”
Volume-Based Shadow Copies
“Volume-Based Shadow Copies”
Oracle VSS Backup Types
“Oracle VSS Backup Types”
Basic Steps of Backup and Recovery with VSS
“Basic Steps of Backup and Recovery with VSS”
Installing and Uninstalling the Oracle VSS Writer Service
“Installing and Uninstalling the Oracle VSS Writer Service”
Oracle VSS Writer Options
“Oracle VSS Writer Options”
Installing Oracle VSS Writer
“Installing Oracle VSS Writer”
Backing Up a Database
“Backing Up a Database”
Oracle VSS Writer Component Hierarchy
“Oracle VSS Writer Component Hierarchy”
About Component-Based Backups
“About Component-Based Backups”
Components Backed Up by the Oracle VSS Writer
“Components Backed Up by the Oracle VSS Writer”
Backing Up a Database in ARCHIVELOG Mode
“Backing Up a Database in ARCHIVELOG Mode”
Making Component-Based Backups of an ARCHIVELOG Database
“Making Component-Based Backups of an ARCHIVELOG Database”
Making Volume-Based Backups of an ARCHIVELOG Database
“Making Volume-Based Backups of an ARCHIVELOG Database”
Backing Up a Database in NOARCHIVELOG Mode
“Backing Up a Database in NOARCHIVELOG Mode”
Making Component-Based Backups of a NOARCHIVELOG Database
“Making Component-Based Backups of a NOARCHIVELOG Database”
Making Volume-Based Backups of a NOARCHIVELOG Database
“Making Volume-Based Backups of a NOARCHIVELOG Database”
Restoring and Recovering a Database
“Restoring and Recovering a Database”
Restoring and Recovering a Database in ARCHIVELOG Mode
“Restoring and Recovering a Database in ARCHIVELOG Mode”
Components Usable in a Restore Operation
“Components Usable in a Restore Operation”
Restoring the Server Parameter File
“Restoring the Server Parameter File”
Recovering from the Loss of All Control Files
“Recovering from the Loss of All Control Files”
Recovering Tablespaces or Datafiles
“Recovering Tablespaces or Datafiles”
Recovering All Tablespaces
“Recovering All Tablespaces”
Performing Disaster Recovery
“Performing Disaster Recovery”
Restoring a Database in NOARCHIVELOG Mode
“Restoring a Database in NOARCHIVELOG Mode”
Restoring Component-Based Backups of a NOARCHIVELOG Database
“Restoring Component-Based Backups of a NOARCHIVELOG Database”
Restoring Volume-Based Backups of a NOARCHIVELOG Database
“Restoring Volume-Based Backups of a NOARCHIVELOG Database”
Integrating VSS with Third-Party Requester Applications
“Integrating VSS with Third-Party Requester Applications”
Writer Control Commands
“Writer Control Commands”
Control Commands for Database or All Tablespaces Component
“Control Commands for Database or All Tablespaces Component”
Duplicating a Database
“Duplicating a Database”
Creating a Nonstandby Database from Shadow Copies
“Creating a Nonstandby Database from Shadow Copies”
Creating a Standby Database From Shadow Copies
“Creating a Standby Database From Shadow Copies”
Authenticating Database Users with Windows
“Authenticating Database Users with Windows”
Windows Native Authentication Overview
“Windows Native Authentication Overview”
Windows Authentication Protocols
“Windows Authentication Protocols”
User Authentication and Role Authorization Methods
“User Authentication and Role Authorization Methods”
User Authentication and Role Authorization Defined
“User Authentication and Role Authorization Defined”
Basic Features of User Authentication and Role Authorization
“Basic Features of User Authentication and Role Authorization”
Authentication and Authorization Methods To Use
“Authentication and Authorization Methods To Use”
User Authentication and Role Authorization Methods
“User Authentication and Role Authorization Methods”
Operating System Authentication Enabled at Installation
“Operating System Authentication Enabled at Installation”
Administering External Users and Roles on Windows
“Administering External Users and Roles on Windows”
Oracle Administration Assistant for Windows
“Oracle Administration Assistant for Windows”
Managing a Remote Computer
“Managing a Remote Computer”
Adding a Computer and Saving Your Configuration
“Adding a Computer and Saving Your Configuration”
Granting Administrator Privileges for All Databases on a Computer
“Granting Administrator Privileges for All Databases on a Computer”
Granting Operator Privileges for All Databases on a Computer
“Granting Operator Privileges for All Databases on a Computer”
Connecting to a Database
“Connecting to a Database”
Troubleshooting Connection Problems
“Troubleshooting Connection Problems”
Viewing Database Authentication Parameter Settings
“Viewing Database Authentication Parameter Settings”
Creating an External Operating System User
“Creating an External Operating System User”
Creating a Local Database Role
“Creating a Local Database Role”
Creating an External Operating System Role
“Creating an External Operating System Role”
Granting Administrator Privileges for a Single Database
“Granting Administrator Privileges for a Single Database”
Granting Operator Privileges for a Single Database
“Granting Operator Privileges for a Single Database”
Manually Administering External Users and Roles
“Manually Administering External Users and Roles”
Manually Creating an External Operating System User
“Manually Creating an External Operating System User”
External User Authentication Tasks on the Oracle Database Server
“External User Authentication Tasks on the Oracle Database Server”
External User Authentication Tasks on the Client Computer
“External User Authentication Tasks on the Client Computer”
Manually Granting Administrator and Operator Privileges for Databases
“Manually Granting Administrator and Operator Privileges for Databases”
Windows Local Groups with SYSDBA, SYSOPER, and SYSASM Privileges
“Windows Local Groups with SYSDBA, SYSOPER, and SYSASM Privileges”
Note
“Note”
SYSDBA/SYSOPER/SYSASM Authentication Tasks on the Oracle Database Server
“SYSDBA/SYSOPER/SYSASM Authentication Tasks on the Oracle Database Server”
SYSDBA/SYSOPER/SYSASM Authentication Tasks on the Client Computer
“SYSDBA/SYSOPER/SYSASM Authentication Tasks on the Client Computer”
Manually Creating an External Role
“Manually Creating an External Role”
External Role Authorization Tasks on the Oracle Database Server
“External Role Authorization Tasks on the Oracle Database Server”
External Role Authorization Tasks on the Client Computer
“External Role Authorization Tasks on the Client Computer”
Manually Migrating Users
“Manually Migrating Users”
Storing Oracle Wallets in the Windows Registry
“Storing Oracle Wallets in the Windows Registry”
Storing Private Keys and Trust Points
“Storing Private Keys and Trust Points”
Storing User's Profile
“Storing User's Profile”
Registry Parameters for Wallet Storage
“Registry Parameters for Wallet Storage”
Oracle Wallet Manager
“Oracle Wallet Manager”
Sharing Wallets and sqlnet.ora Files Among Multiple Databases
“Sharing Wallets and sqlnet.ora Files Among Multiple Databases”
Oracle PKI Integration with Windows
“Oracle PKI Integration with Windows”
Oracle Public Key Infrastructure
“Oracle Public Key Infrastructure”
Windows Public Key Infrastructure
“Windows Public Key Infrastructure”
Microsoft Certificate Stores
“Microsoft Certificate Stores”
Microsoft Certificate Services
“Microsoft Certificate Services”
Using Microsoft Certificate Stores with Oracle PKI Applications
“Using Microsoft Certificate Stores with Oracle PKI Applications”
Using Oracle Database with Microsoft Active Directory
“Using Oracle Database with Microsoft Active Directory”
Microsoft Active Directory Support
“Microsoft Active Directory Support”
About Microsoft Active Directory
“About Microsoft Active Directory”
Accessing Active Directory
“Accessing Active Directory”
Oracle Components That Integrate with Active Directory
“Oracle Components That Integrate with Active Directory”
Directory Naming
“Directory Naming”
Automatic Discovery of Directory Servers
“Automatic Discovery of Directory Servers”
Integration with Windows Tools
“Integration with Windows Tools”
User Interface Extensions for Oracle Net Directory Naming
“User Interface Extensions for Oracle Net Directory Naming”
Enhancement of Directory Object Type Descriptions
“Enhancement of Directory Object Type Descriptions”
Integration with Windows Login Credentials
“Integration with Windows Login Credentials”
Configuration on machines that require authenticated name lookups
“Configuration on machines that require authenticated name lookups”
Oracle Directory Objects in Active Directory
“Oracle Directory Objects in Active Directory”
Oracle Directory Objects in Active Directory Users and Computers
“Oracle Directory Objects in Active Directory Users and Computers”
Oracle Directory Objects
“Oracle Directory Objects”
Requirements for Using Oracle Database with Active Directory
“Requirements for Using Oracle Database with Active Directory”
Directory Naming Software Requirements
“Directory Naming Software Requirements”
Creating an OracleContext
“Creating an OracleContext”
Network Configuration Assistant (NetCA)
“Network Configuration Assistant (NetCA)”
Oracle Schema Objects Creation
“Oracle Schema Objects Creation”
Display Specifiers Not Created
“Display Specifiers Not Created”
Configuring Oracle Database to Use Active Directory
“Configuring Oracle Database to Use Active Directory”
Testing Connectivity
“Testing Connectivity”
Testing Connectivity from Client Computers
“Testing Connectivity from Client Computers”
Testing Connectivity from Microsoft Tools
“Testing Connectivity from Microsoft Tools”
Access Control List Management for Oracle Directory Objects
“Access Control List Management for Oracle Directory Objects”
Security Groups
“Security Groups”
OracleDBCreators
“OracleDBCreators”
OracleNetAdmins
“OracleNetAdmins”
NetService Objects
“NetService Objects”
Setting ACLs on NetService Entries
“Setting ACLs on NetService Entries”
Adding and Deleting Security Group Members
“Adding and Deleting Security Group Members”
Oracle Database Specifications for Windows
“Oracle Database Specifications for Windows”
Initialization Parameter File Overview
“Initialization Parameter File Overview”
Location of the Initialization Parameter File
“Location of the Initialization Parameter File”
Editing The Initialization Parameter File
“Editing The Initialization Parameter File”
Database Configuration Assistant Renames init.ora
“Database Configuration Assistant Renames init.ora”
Sample File
“Sample File”
SGA_MAX_SIZE Parameter
“SGA_MAX_SIZE Parameter”
Initialization Parameters Without Windows-Specific Values
“Initialization Parameters Without Windows-Specific Values”
Initialization Parameters Without Windows-Specific Values
“Initialization Parameters Without Windows-Specific Values”
Displaying Initialization Parameter Values
“Displaying Initialization Parameter Values”
Uneditable Database Initialization Parameters
“Uneditable Database Initialization Parameters”
Uneditable Database Initialization Parameters
“Uneditable Database Initialization Parameters”
Note
“Note”
Calculating Database Limits
“Calculating Database Limits”
Block Size Guidelines
“Block Size Guidelines”
Maximum Number of Files for Each Database
“Maximum Number of Files for Each Database”
Maximum File Sizes
“Maximum File Sizes”
Shadow Process Memory
“Shadow Process Memory”
Configuration Parameters and the Registry
“Configuration Parameters and the Registry”
About Configuration Parameters
“About Configuration Parameters”
Registry Overview
“Registry Overview”
Registry Parameters
“Registry Parameters”
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
“HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME”
MSHELP_TOOLS
“MSHELP_TOOLS”
NLS_LANG and Other Globalization Parameters
“NLS_LANG and Other Globalization Parameters”
ORA_CWD
“ORA_CWD”
ORA_SID_AUTOSTART
“ORA_SID_AUTOSTART”
ORA_SID_PFILE
“ORA_SID_PFILE”
ORA_SID_SHUTDOWN
“ORA_SID_SHUTDOWN”
ORA_SID_SHUTDOWN_TIMEOUT
“ORA_SID_SHUTDOWN_TIMEOUT”
ORA_SID_SHUTDOWNTYPE
“ORA_SID_SHUTDOWNTYPE”
ORA_TZFILE
“ORA_TZFILE”
ORACLE_AFFINITY
“ORACLE_AFFINITY”
ORACLE_BASE
“ORACLE_BASE”
ORACLE_GROUP_NAME
“ORACLE_GROUP_NAME”
ORACLE_HOME
“ORACLE_HOME”
ORACLE_HOME_KEY
“ORACLE_HOME_KEY”
ORACLE_HOME_NAME
“ORACLE_HOME_NAME”
ORACLE_PRIORITY
“ORACLE_PRIORITY”
ORACLE_SID
“ORACLE_SID”
OSAUTH_ENFORCE_STRICT
“OSAUTH_ENFORCE_STRICT”
OSAUTH_PREFIX_DOMAIN
“OSAUTH_PREFIX_DOMAIN”
RDBMS_ARCHIVE
“RDBMS_ARCHIVE”
RDBMS_CONTROL
“RDBMS_CONTROL”
SQLPATH
“SQLPATH”
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
“HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE”
INST_LOC
“INST_LOC”
OO4O
“OO4O”
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
“HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services”
Parameters for Oracle Counters for Windows Performance Monitor
“Parameters for Oracle Counters for Windows Performance Monitor”
Parameters for Oracle Database Services
“Parameters for Oracle Database Services”
Oracle RAC Registry Parameters
“Oracle RAC Registry Parameters”
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
“HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR”
Managing Registry Parameters with regedit
“Managing Registry Parameters with regedit”
Modifying a Parameter Value with regedit
“Modifying a Parameter Value with regedit”
Adding a Registry Parameter with regedit
“Adding a Registry Parameter with regedit”
Managing Registry Parameters with Oracle Administration Assistant for Windows
“Managing Registry Parameters with Oracle Administration Assistant for Windows”
Starting Oracle Administration Assistant for Windows
“Starting Oracle Administration Assistant for Windows”
Adding Oracle Home Parameters
“Adding Oracle Home Parameters”
Editing Oracle Home Parameters
“Editing Oracle Home Parameters”
Deleting Oracle Home Parameters
“Deleting Oracle Home Parameters”
Modifying Oracle Counters for Windows Performance Monitor Parameters
“Modifying Oracle Counters for Windows Performance Monitor Parameters”
Using operfcfg
“Using operfcfg”
Using Oracle Administration Assistant for Windows
“Using Oracle Administration Assistant for Windows”
Developing Applications for Windows
“Developing Applications for Windows”
Finding Information on Application Development for Windows
“Finding Information on Application Development for Windows”
Java Enhancements
“Java Enhancements”
ODP.NET
“ODP.NET”
Oracle Developer Tools for Visual Studio
“Oracle Developer Tools for Visual Studio”
Oracle Providers for ASP.NET
“Oracle Providers for ASP.NET”
XML Support
“XML Support”
Support for Internet Applications
“Support for Internet Applications”
Oracle Services For Microsoft Transaction Server
“Oracle Services For Microsoft Transaction Server”
Oracle Objects for OLE
“Oracle Objects for OLE”
Oracle Provider for OLE DB
“Oracle Provider for OLE DB”
Oracle COM Automation Feature
“Oracle COM Automation Feature”
Pro*C/C++ and Pro*COBOL Applications
“Pro*C/C++ and Pro*COBOL Applications”
Building External Procedures
“Building External Procedures”
External Procedures Overview
“External Procedures Overview”
Installing and Configuring
“Installing and Configuring”
Installing Oracle Database
“Installing Oracle Database”
Configuring Oracle Net Services
“Configuring Oracle Net Services”
Writing an External Procedure
“Writing an External Procedure”
Building a DLL
“Building a DLL”
Registering an External Procedure
“Registering an External Procedure”
Executing an External Procedure
“Executing an External Procedure”
Multithreaded Agent Architecture
“Multithreaded Agent Architecture”
Debugging External Procedures
“Debugging External Procedures”
Using Package DEBUG_EXTPROC
“Using Package DEBUG_EXTPROC”
Accessing Text Files with UTL_FILE
“Accessing Text Files with UTL_FILE”
Accessing Web Data with Intercartridge Exchange
“Accessing Web Data with Intercartridge Exchange”
Configuring Intercartridge Exchange
“Configuring Intercartridge Exchange”
Using Intercartridge Exchange
“Using Intercartridge Exchange”
Packaged Function UTL_HTTP.REQUEST
“Packaged Function UTL_HTTP.REQUEST”
Packaged Function UTL_HTTP.REQUEST_PIECES
“Packaged Function UTL_HTTP.REQUEST_PIECES”
UTL_HTTP Exception Conditions
“UTL_HTTP Exception Conditions”
UTL_HTTP.REQUEST
“UTL_HTTP.REQUEST”
UTL_HTTP.REQUEST_PIECES
“UTL_HTTP.REQUEST_PIECES”
Exception Conditions and Error Messages
“Exception Conditions and Error Messages”
Getting Started with Your Documentation
“Getting Started with Your Documentation”
Storing Tablespaces on Raw Partitions
“Storing Tablespaces on Raw Partitions”
Raw Partition Overview
“Raw Partition Overview”
Physical Disk
“Physical Disk”
Logical Partition
“Logical Partition”
Physical Disk and Logical Partition Considerations
“Physical Disk and Logical Partition Considerations”
Compatibility Issues
“Compatibility Issues”
Creating a Raw Partition and a Mount Point
“Creating a Raw Partition and a Mount Point”
Creating a Tablespace in a Raw Partition
“Creating a Tablespace in a Raw Partition”
Configuring Disks for Automatic Storage Management
“Configuring Disks for Automatic Storage Management”
Oracle Net Services Configuration on Windows
“Oracle Net Services Configuration on Windows”
Configuring Oracle Database to Communicate with ASM
“Configuring Oracle Database to Communicate with ASM”
Understanding Oracle Net Services Registry Parameters and Subkeys
“Understanding Oracle Net Services Registry Parameters and Subkeys”
Oracle Net Service Subkeys
“Oracle Net Service Subkeys”
Service Subkey Parameters
“Service Subkey Parameters”
Listener Requirements
“Listener Requirements”
Understanding Optional Configuration Parameters
“Understanding Optional Configuration Parameters”
LOCAL
“LOCAL”
TNS_ADMIN
“TNS_ADMIN”
USE_SHARED_SOCKET
“USE_SHARED_SOCKET”
Advanced Network Configuration
“Advanced Network Configuration”
Configuring Authentication Method
“Configuring Authentication Method”
Configuring Security for Named Pipes Protocol
“Configuring Security for Named Pipes Protocol”
Modifying Configuration of External Procedures for Higher Security
“Modifying Configuration of External Procedures for Higher Security”
Error Messages on Windows
“Error Messages on Windows”
ORA-09275: CONNECT INTERNAL No Longer Supported
“ORA-09275: CONNECT INTERNAL No Longer Supported”
OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
“OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages”
File I/O Errors: OSD-04000 to OSD-04099
“File I/O Errors: OSD-04000 to OSD-04099”
Memory Errors: OSD-04100 to OSD-04199
“Memory Errors: OSD-04100 to OSD-04199”
Process Errors: OSD-04200 to OSD-04299
“Process Errors: OSD-04200 to OSD-04299”
Loader Errors: OSD-04300 to OSD-04399
“Loader Errors: OSD-04300 to OSD-04399”
Semaphore Errors: OSD-04400 to OSD-04499
“Semaphore Errors: OSD-04400 to OSD-04499”
Miscellaneous Errors: OSD-04500 to OSD-04599
“Miscellaneous Errors: OSD-04500 to OSD-04599”
DIM-00000 to DIM-00039: ORADIM Command Syntax Errors
“DIM-00000 to DIM-00039: ORADIM Command Syntax Errors”
Database Connection Issues
“Database Connection Issues”
Oracle Database Windows/UNIX Differences
“Oracle Database Windows/UNIX Differences”
Automatic Startup and Shutdown
“Automatic Startup and Shutdown”
Background Processing and Batch Jobs
“Background Processing and Batch Jobs”
Diagnostic and Tuning Utilities
“Diagnostic and Tuning Utilities”
Direct Writes to Disk
“Direct Writes to Disk”
Dynamic Link Libraries (DLLs)
“Dynamic Link Libraries (DLLs)”
Hot Backups
“Hot Backups”
Initialization Parameters: Multiple Database Writers
“Initialization Parameters: Multiple Database Writers”
Install Accounts and Groups
“Install Accounts and Groups”
Installation
“Installation”
Memory Resources
“Memory Resources”
Microsoft Transaction Server
“Microsoft Transaction Server”
Multiple Oracle Homes and OFA
“Multiple Oracle Homes and OFA”
Processes and Threads
“Processes and Threads”
Raw Partitions
“Raw Partitions”
Services
“Services”
Glossary
“Glossary”
alert log
“alert log”
authenticate
“authenticate”
authorization
“authorization”
backup
“backup”
certificate authority
“certificate authority”
COM
“COM”
component-based shadow copies
“component-based shadow copies”
connect descriptor
“connect descriptor”
connect identifier
“connect identifier”
connect string
“connect string”
control files
“control files”
credentials
“credentials”
data dictionary
“data dictionary”
database alias
“database alias”
decryption
“decryption”
digital certificates
“digital certificates”
digital signature
“digital signature”
DLL
“DLL”
downgrade
“downgrade”
dynamic link library
“dynamic link library”
encryption
“encryption”
enterprise domains
“enterprise domains”
enterprise role
“enterprise role”
enterprise user
“enterprise user”
external procedures
“external procedures”
external role
“external role”
external routine
“external routine”
external user
“external user”
external user
“external user”
global groups
“global groups”
global role
“global role”
Globalization Support
“Globalization Support”
HOME_NAME
“HOME_NAME”
init.ora
“init.ora”
initialization parameter file
“initialization parameter file”
instance
“instance”
instantiate
“instantiate”
latch
“latch”
LDAP
“LDAP”
Lightweight Directory Access Protocol (LDAP)
“Lightweight Directory Access Protocol (LDAP)”
listener
“listener”
listener.ora
“listener.ora”
local groups
“local groups”
local roles
“local roles”
Microsoft Management Console
“Microsoft Management Console”
Microsoft Transaction Server
“Microsoft Transaction Server”
migrate
“migrate”
mount
“mount”
MTS
“MTS”
multiple Oracle homes
“multiple Oracle homes”
net service name
“net service name”
network listener
“network listener”
network service
“network service”
obfuscated
“obfuscated”
OCI
“OCI”
OFA
“OFA”
Optimal Flexible Architecture
“Optimal Flexible Architecture”
ORACLE_BASE
“ORACLE_BASE”
Oracle Call Interface
“Oracle Call Interface”
ORACLE_HOME
“ORACLE_HOME”
Oracle Internet Directory
“Oracle Internet Directory”
Oracle Net
“Oracle Net”
Oracle Net Services
“Oracle Net Services”
Oracle PKI
“Oracle PKI”
Oracle Protocol Support
“Oracle Protocol Support”
Oracle services
“Oracle services”
Oracle VSS writer
“Oracle VSS writer”
PL/SQL
“PL/SQL”
precompiler
“precompiler”
private keys
“private keys”
privilege
“privilege”
process
“process”
provider
“provider”
public key
“public key”
public key cryptography
“public key cryptography”
quota
“quota”
raw partitions
“raw partitions”
recovery
“recovery”
redo log buffer
“redo log buffer”
redo log files
“redo log files”
registry
“registry”
remote computer
“remote computer”
remote database
“remote database”
requester
“requester”
replication
“replication”
role
“role”
schema
“schema”
services
“services”
service name
“service name”
SGA
“SGA”
shadow copy
“shadow copy”
shadow copy set
“shadow copy set”
Shared Server Process
“Shared Server Process”
SID
“SID”
snap-ins
“snap-ins”
snapshot
“snapshot”
starter database
“starter database”
SYSDBA
“SYSDBA”
SYSOPER
“SYSOPER”
System Global Area
“System Global Area”
system identifier
“system identifier”
SYSTEM
“SYSTEM”
tablespace
“tablespace”
thread
“thread”
tnsnames.ora
“tnsnames.ora”
trace file
“trace file”
trust points
“trust points”
universal groups
“universal groups”
upgrade
“upgrade”
username
“username”
view
“view”
volume-based shadow copies
“volume-based shadow copies”
Volume Shadow Copy Service (VSS)
“Volume Shadow Copy Service (VSS)”
Windows global groups
“Windows global groups”
Windows local groups
“Windows local groups”
writer
“writer”