Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Platform Guide
- 1
Oracle Database Architecture on Windows
- 1.1 Overview of Oracle Database on Windows Architecture
- 1.2 Overview of Oracle Database Scalability on Windows
- 1.3 Oracle Database Integration with Windows
- 2
Database Tools on Windows
- 2.1 Choosing a Database Tool
- 2.2 Starting Database Tools
- 2.3 Using the Oracle Home User Control Tool
- 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 Registry Editor to Modify Configuration Information
- 2.4.4 Using Task Manager to Monitor Applications and Processes
- 2.4.5 Using Local Users and Groups to Manage Users and Groups
- 2.5 Using SQL*Loader
- 3
Supporting Oracle Home User on Windows
- 3.1 Managing Oracle Home User
- 3.2 Using Oracle Home User for an Oracle Database and Oracle Database Client
- 3.3 Using Oracle Home User for Multiple Oracle Homes
- 3.4 Using Oracle Home User During Oracle Database Upgrade
- 3.5 Converting from Single-Instance Oracle Database to Oracle Real Application Clusters
- 4
Postinstallation Database Creation on Windows
- 4.1 About Oracle Database Naming Conventions
- 4.2 About Using Oracle Database Configuration Assistant on Windows
- 4.3
Overview of Database Creation Tasks on Windows Using Command-Line Tools
- 4.3.1 About Exporting an Existing Database
- 4.3.2 Deleting Database Files
- 4.3.3 Modifying the Initialization Parameter File
- 4.3.4 About Creating and Starting an Oracle Database Service
- 4.3.5 Starting an Oracle Database Instance
- 4.3.6 Adding the CREATE DATABASE Statement in a Script
- 4.3.7 Running the CREATE DATABASE Script
- 4.3.8 About Importing a Database
- 4.3.9 Updating ORACLE_SID in the Registry
- 4.3.10 Creating the ORACLE_SID Parameter
- 4.3.11 Backing Up the New Database
- 4.4
About Administering an Oracle Database Instance Using ORADIM
- 4.4.1 Creating an Instance Using ORADIM
- 4.4.2 Starting an Instance and Services Using ORADIM
- 4.4.3 Stopping an Instance and Services Using ORADIM
- 4.4.4 Editing an Instance Using ORADIM
- 4.4.5 Deleting an Instance Using ORADIM
- 4.4.6 Manipulating ACLs Using ORADIM
- 4.4.7 Manipulating Family Settings to Initialization Parameters using ORADIM
- 4.5 About Administering an Oracle Database Instance Using Microsoft Management Console Snapin
- 4.6 Overview of Database Migration from a 32-Bit Windows Computer
- 5
Postinstallation Configuration Tasks on Windows
- 5.1
Overview of Windows Firewall
- 5.1.1
About Oracle Executables Requiring Windows Firewall Exceptions
- 5.1.1.1 Configuring Windows Firewall Exceptions for Successful Connections to Oracle Software
- 5.1.1.2
Overview of Different Executables Added to the Windows Firewall Exception List
- 5.1.1.2.1 About Firewall Exceptions for Oracle Database
- 5.1.1.2.2 About Firewall Exceptions for Oracle Database Examples
- 5.1.1.2.3 About Firewall Exceptions for Oracle Gateways
- 5.1.1.2.4 About Firewall Exceptions for Oracle Clusterware and Oracle ASM
- 5.1.1.2.5 About Firewall Exceptions for Other Oracle Products
- 5.1.2 Configuring the Windows Firewall
- 5.1.3 Troubleshooting Windows Firewall Exceptions
- 5.1.1
About Oracle Executables Requiring Windows Firewall Exceptions
- 5.2 About the Need to Reset Passwords for Default Accounts
- 5.3 About Windows Authenticated Users
- 5.4
Overview of NTFS File System and Windows Registry Permissions
- 5.4.1
Setting File Permissions
- 5.4.1.1 About Default File Permissions Set by Oracle Universal Installer
- 5.4.1.2 About File Permissions Set by Oracle Database Configuration Assistant
- 5.4.1.3 About File Permissions Set by Oracle Database Upgrade Assistant
- 5.4.1.4 About Setting Permissions for Oracle Wallets
- 5.4.1.5 About Setting File System ACLs Manually
- 5.4.2 Setting Permissions for Windows Registry Entries
- 5.4.3 Setting Permissions for Windows Service Entries
- 5.4.4 Setting NTFS File System Security
- 5.4.5 Setting Windows Registry Security
- 5.4.1
Setting File Permissions
- 5.5 Overview of ReFS File System
- 5.6 About Configuring External Job Support for the Scheduler on Windows
- 5.7 About Oracle Multimedia on Windows
- 5.8 About Oracle Text on Windows
- 5.9 About Oracle Spatial and Graph on Windows
- 5.10 About Advanced Replication on Windows
- 5.1
Overview of Windows Firewall
- 6
Administering a Database on Windows
- 6.1 About Ways to Manage Oracle Database Services
- 6.2 Starting and Shutting Down a Database with SQL*Plus
- 6.3 Starting and Shutting Down a Database Using Services
- 6.4 Starting Multiple Instances
- 6.5 Creating and Populating Password Files
- 6.6 Connecting Remotely to the Database
- 6.7 About Archiving Redo Log Files
- 7 Monitoring a Database on Windows
- 8
Tuning Windows to Optimize Oracle Database
- 8.1 Overview of Windows Tuning
- 8.2 Overview of Large Page Support
- 8.3 About Reducing Priority of Foreground Applications on Server Console
- 8.4 About Configuring Windows Server to Be an Application Server
- 8.5 About Disabling Unnecessary Services
- 8.6 About the Necessity to Remove Unused Network Protocols
- 8.7 About the Necessity to Reset Network Protocol Bind Order
- 8.8 Setting the Order of Multiple Network Interface Cards
- 8.9 Overview of the Latest Reliable Windows Server Service Pack
- 8.10 Overview of Hardware or Operating System Striping
- 8.11 About Multiplex Windows Server Virtual Memory Paging File
- 8.12 Closing All Unnecessary Foreground Applications
- 9
Performing Database Backup and Recovery with VSS
- 9.1 Overview of Database Backup and Recovery with VSS
- 9.2 Basic Concepts of Database Backup and Recovery with VSS
- 9.3 Basic Steps of Backup and Recovery with VSS
- 9.4 About Installing and Uninstalling the Oracle VSS Writer Service
- 9.5 About Backing Up a Database
- 9.6 About Restoring and Recovering a Database
- 9.7 About Integrating VSS with Third-Party Requester Applications
- 9.8 About Duplicating a Database
- 10 Authenticating Database Users with Windows
- 11
Administering External Users and Roles on Windows
- 11.1
Overview of Oracle Administration Assistant for Windows
- 11.1.1 Managing a Remote Computer
- 11.1.2 Adding a Computer and Saving Your Configuration
- 11.1.3 Granting Administrator Privileges for All Databases on a Computer
- 11.1.4 Granting Operator Privileges for All Databases on a Computer
- 11.1.5 Connecting to a Database
- 11.1.6 Viewing Database Authentication Parameter Settings
- 11.1.7 Creating an External Operating System User
- 11.1.8 Creating a Local Database Role
- 11.1.9 Creating an External Operating System Role
- 11.1.10 Granting Administrator Privileges for a Single Database
- 11.1.11 Granting Operator Privileges for a Single Database
- 11.2
Overview of Manually Administering External Users and Roles
- 11.2.1 About Manually Creating an External Operating System User
- 11.2.2 Overview of Manually Granting Administrator, Operator, and Task-Specific Privileges for Databases
- 11.2.3 Managing New Users and User Groups
- 11.2.4 Overview of Manually Creating an External Role
- 11.2.5 About Manually Migrating Users
- 11.1
Overview of Oracle Administration Assistant for Windows
- 12 Storing Oracle Wallets in the Windows Registry
- 13 Oracle PKI Integration with Windows
- 14
Using Oracle Database with Microsoft Active Directory
- 14.1 Overview of Microsoft Active Directory Support
- 14.2
Overview of Oracle Components That Integrate with Active Directory
- 14.2.1 About Directory Naming
- 14.2.2 About Automatic Discovery of Directory Servers
- 14.2.3 About Integration with Windows Tools
- 14.2.4 About User Interface Extensions for Oracle Net Directory Naming
- 14.2.5 About Enhancement of Directory Object Type Descriptions
- 14.2.6 About Integration with Windows Login Credentials
- 14.2.7 Overview of Oracle Directory Objects in Active Directory
- 14.3 Overview of Requirements for Using Oracle Database with Active Directory
- 14.4 Configuring Client Computers and Oracle Database to Use Active Directory
- 14.5 About Testing Connectivity
- 14.6 Overview of Access Control List Management for Oracle Directory Objects
- 15
Oracle Database Specifications for Windows
- 15.1 Overview of Initialization Parameter File
- 15.2 Using Sample File for Database Creation
- 15.3 About SGA_MAX_SIZE Parameter
- 15.4 Overview of Initialization Parameters Without Windows-Specific Values
- 15.5 Displaying Initialization Parameter Values
- 15.6 About Unmodifiable Database Initialization Parameters
- 15.7 About Calculating Database Limits
- 16
Configuration Parameters and the Registry
- 16.1 About Configuration Parameters
- 16.2 Registry Overview
- 16.3
Registry Parameters Overview
- 16.3.1
About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOMENAME
- 16.3.1.1 MSHELP_TOOLS
- 16.3.1.2 NLS_LANG and Other Globalization Parameters
- 16.3.1.3 ORA_CWD
- 16.3.1.4 ORA_SID_AUTOSTART
- 16.3.1.5 ORA_SID_PFILE
- 16.3.1.6 ORA_SID_SHUTDOWN
- 16.3.1.7 ORA_SID_SHUTDOWN_TIMEOUT
- 16.3.1.8 ORA_SID_SHUTDOWNTYPE
- 16.3.1.9 ORA_TZFILE
- 16.3.1.10 ORACLE_AFFINITY
- 16.3.1.11 ORACLE_BASE
- 16.3.1.12 ORACLE_GROUP_NAME
- 16.3.1.13 ORACLE_HOME
- 16.3.1.14 ORACLE_HOME_KEY
- 16.3.1.15 ORACLE_HOME_USER
- 16.3.1.16 ORACLE_HOMENAME
- 16.3.1.17 ORACLE_PRRITY
- 16.3.1.18 ORACLE_SID
- 16.3.1.19 OSAUTH_PREFIX_DOMAIN
- 16.3.1.20 RDBMS_ARCHIVE
- 16.3.1.21 RDBMS_CONTROL
- 16.3.1.22 SQLPATH
- 16.3.2 About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
- 16.3.3 About HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- 16.3.1
About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOMENAME
- 16.4 Overview of Oracle RAC Registry Parameters
- 16.5 About Managing Registry Parameters with Oracle Administration Assistant for Windows
- 16.6 Managing Registry Parameters with regedit
- 17
Developing Applications for Windows
- 17.1
About Finding Information on Application Development for Windows
- 17.1.1 About Java Enhancements
- 17.1.2 About ODP.NET
- 17.1.3 About Oracle Developer Tools for Visual Studio
- 17.1.4 About Oracle Providers for ASP.NET
- 17.1.5 About XML Support
- 17.1.6 About Support for Internet Applications
- 17.1.7 About Oracle Services for Microsoft Transaction Server
- 17.1.8 About Oracle ODBC Driver
- 17.1.9 About Pro*C/C++ and Pro*COBOL Applications
- 17.2 32-bit to 64-bit Application Migration
- 17.3
About Building External Procedures
- 17.3.1 External Procedures Overview
- 17.3.2 Installing and Configuring Oracle Database and Oracle Net Services
- 17.3.3 Writing an External Procedure
- 17.3.4 Building a DLL
- 17.3.5 Registering an External Procedure
- 17.3.6 Restricting Library-Related Privileges to Trusted Users Only
- 17.3.7 Executing an External Procedure
- 17.4 Overview of Multithreaded Agent Architecture
- 17.5 About Debugging External Procedures
- 17.6 About Accessing Text Files with UTL_FILE
- 17.1
About Finding Information on Application Development for Windows
- A Storing Tablespaces on Raw Partitions
- B Oracle Net Services Configuration on Windows
- C Running Windows Services
- D
Error Messages on Windows
- D.1 ORA-09275: CONNECT INTERNAL No Longer Supported
- D.2 ORA-15252 to ORA-15266: User Replacement Failure on Windows
- D.3 ORA-15301 to ORA-15302: Failure to Modify Ownership, Group, and Permission of Opened Files
- D.4 OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
- D.5 DIM-00000 to DIM-00228: ORADIM Command Syntax Errors
- D.6 Database Connection Issues
- E
Oracle Database Differences on Windows and UNIX
- 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 Installation Accounts and Groups
- E.9 Oracle Database Installation
- E.10 Memory Resources
- E.11 Microsoft Transaction Server
- E.12 Multiple Oracle Homes and OFA
- E.13 Oracle Home User and Oracle User
- E.14 Processes and Threads
- E.15 Raw Partitions
- E.16 Windows Services
- Glossary
- Index