Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Accessing Documentation
  • Related Documents
  • Conventions
• Changes in This Release for Oracle Database Administrator’s Reference Guide
  • Changes in Oracle Database Release 19c
    • Desupported Features for Oracle Database 19c
    • Deprecation of Oracle Fail Safe
• 1 Oracle Database Architecture on Windows
  • Overview of Oracle Database on Windows Architecture
    • Oracle Automatic Storage Management
    • Oracle Automatic Storage Management File Access Control
      • Creation of New User Groups and Users for Separation of Database Administration Duties
      • About Disk Group User Replacement
      • About Changing File Access Control While the File is Open
    • Thread-Based Architecture
    • File I/O Enhancements
  • Overview of Oracle Database Scalability on Windows
    • Large User Populations
  • Oracle Database Integration with Windows
    • Oracle PKI Integration with Windows
    • Oracle Fail Safe Integration with Windows
    • Oracle Services for Microsoft Transaction Server
• 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 Multiple Oracle Homes
    • Running Tools with Windows User Account Control
    • Starting Database Tools from the Start Menu
    • Starting Database Tools from the Command Line
      • About Archiving Redo Log Files
    • Starting Windows Tools
  • Using the Oracle Home User Control Tool
  • Using Windows Tools
    • Using Event Viewer to Monitor a Database
    • Using Microsoft Management Console to Administer a Database
    • 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
  • Using SQL*Loader
    • Windows Processing Options
    • Control File Conventions
• 3 Supporting Oracle Home User on Windows
  • Managing Oracle Home User
  • Using Oracle Home User for an Oracle Database and Oracle Database Client
  • Using Oracle Home User for Multiple Oracle Homes
  • Using Oracle Home User During Oracle Database Upgrade
  • Converting from Single-Instance Oracle Database to Oracle Real Application Clusters
• 4 Postinstallation Database Creation on Windows
  • About Oracle Database Naming Conventions
  • About Using Oracle Database Configuration Assistant on Windows
  • Overview of Database Creation Tasks on Windows Using Command-Line Tools
    • About Exporting an Existing Database
      • Exporting All Data from an Existing Database
    • Deleting Database Files
    • Modifying the Initialization Parameter File
    • About Creating and Starting an Oracle Database Service
      • Creating and Starting an Oracle Database Service
      • Access to Oracle Wallets in a File System for Oracle Database Services
    • Starting an Oracle Database Instance
    • Adding the CREATE DATABASE Statement in a Script
    • Running the CREATE DATABASE Script
    • About Importing a Database
    • Updating ORACLE_SID in the Registry
    • Creating the ORACLE_SID Parameter
    • Backing Up the New Database
  • About Administering an Oracle Database Instance Using ORADIM
    • Creating an Instance Using ORADIM
    • Starting an Instance and Services Using ORADIM
    • Stopping an Instance and Services Using ORADIM
    • Editing an Instance Using ORADIM
    • Deleting an Instance Using ORADIM
    • Manipulating ACLs Using ORADIM
    • Manipulating Family Settings to Initialization Parameters using ORADIM
  • About Administering an Oracle Database Instance Using Microsoft Management Console Snapin
  • Overview of Database Migration from a 32-Bit Windows Computer
    • Backing Up a 32-Bit Oracle Database
    • Migration Considerations
    • Migrating an Oracle Database 11g Release 2 (11.2) or Earlier Database
• 5 Postinstallation Configuration Tasks on Windows
  • Overview of Windows Firewall
    • About Oracle Executables Requiring Windows Firewall Exceptions
      • Configuring Windows Firewall Exceptions for Successful Connections to Oracle Software
      • Overview of Different Executables Added to the Windows Firewall Exception List
        • About Firewall Exceptions for Oracle Database
        • About Firewall Exceptions for Oracle Database Examples
        • About Firewall Exceptions for Oracle Gateways
        • About Firewall Exceptions for Oracle Clusterware and Oracle ASM
        • About Firewall Exceptions for Other Oracle Products
    • Configuring the Windows Firewall
      • About Backing Up a Database
    • Troubleshooting Windows Firewall Exceptions
  • About the Need to Reset Passwords for Default Accounts
  • About Windows Authenticated Users
  • Overview of NTFS File System and Windows Registry Permissions
    • Setting File Permissions
      • About Default File Permissions Set by Oracle Universal Installer
      • About File Permissions Set by Oracle Database Configuration Assistant
      • About File Permissions Set by Oracle Database Upgrade Assistant
      • About Setting Permissions for Oracle Wallets
      • About Setting File System ACLs Manually
    • Setting Permissions for Windows Registry Entries
    • Setting Permissions for Windows Service Entries
    • Setting NTFS File System Security
    • Setting Windows Registry Security
  • Overview of ReFS File System
    • Setting File Permissions
  • About Configuring External Job Support for the Scheduler on Windows
  • About Oracle Multimedia on Windows
    • Configuring Oracle Multimedia on Windows
  • About Oracle Text on Windows
  • About Oracle Spatial and Graph on Windows
    • Configuring Oracle Spatial and Graph on Windows Automatically
  • About Advanced Replication on Windows
    • About Checking Tablespace and Rollback Segment Requirements
    • Adding and Modifying Initialization Parameters
    • Monitoring Data Dictionary Tables
• 6 Administering a Database on Windows
  • About Ways to Manage Oracle Database Services
    • Overview of 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
    • Connecting to a Database Using SYSDBA Privileges
    • About Verifying a Remote Database Using Encrypted Passwords
  • About Archiving Redo Log Files
• 7 Monitoring a Database on Windows
  • Overview of Database Monitoring Tools
  • About Event Viewer
    • Using Event Viewer
    • Managing Event Viewer
    • Reading Event Viewer
  • About Trace Files
  • About Alert Logs
  • Viewing Oracle Database Thread Information
• 8 Tuning Windows to Optimize Oracle Database
  • Overview of Windows Tuning
  • Overview of Large Page Support
    • Granting Lock Pages in Memory Privilege
    • Enabling Large Page Support
  • About Reducing Priority of Foreground Applications on Server Console
  • About Configuring Windows Server to Be an Application Server
  • About Disabling Unnecessary Services
  • About the Necessity to Remove Unused Network Protocols
  • About the Necessity to Reset Network Protocol Bind Order
  • Setting the Order of Multiple Network Interface Cards
  • Overview of the Latest Reliable Windows Server Service Pack
  • Overview of Hardware or Operating System Striping
    • About Multiple Striped Volumes for Sequential and Random Access
  • About Multiplex Windows Server Virtual Memory Paging File
  • Closing All Unnecessary Foreground Applications
• 9 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
  • About Installing and Uninstalling the Oracle VSS Writer Service
  • About Backing Up a Database
    • About Component-Based Backups
    • About Backing Up a Database in ARCHIVELOG Mode
      • Making Component-Based Backups of an ARCHIVELOG Database
      • Making Volume-Based Backups of an ARCHIVELOG Database
    • About Backing Up a Database in NOARCHIVELOG Mode
      • Making Component-Based Backups of a NOARCHIVELOG Database
      • Making Volume-Based Backups of a NOARCHIVELOG Database
  • About Restoring and Recovering a Database
    • About Restoring and Recovering a Database in ARCHIVELOG Mode
      • Restoring the Server Parameter File
      • Recovering from the Loss of All Control Files
      • Recovering Tablespaces or Data Files
      • 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
  • About Integrating VSS with Third-Party Requester Applications
    • Running Writer Control Commands
    • Controlling Commands for Database or All Tablespaces Component
  • About Duplicating a Database
    • Creating a Nonstandby Database from Shadow Copies
    • Creating a Standby Database From Shadow Copies
• 10 Authenticating Database Users with Windows
  • Overview of Windows Native Authentication
  • About Windows Authentication Protocols
  • About User Authentication and Role Authorization Methods
    • About Using Authentication and Authorization Methods
  • Overview of Operating System Authentication Enabled at Installation
• 11 Administering External Users and Roles on Windows
  • Overview of Manually Administering External Users and Roles
    • About Manually Creating an External Operating System User
      • Performing External User Authentication Tasks on the Oracle Database Server
      • Performing External User Authentication Tasks on the Client Computer
    • Overview of Manually Granting Administrator, Operator, and Task-Specific Privileges for Databases
      • Running System Privilege Authentication Tasks on the Oracle Database Server
      • Running System Privilege Authentication Tasks on the Client Computer
    • Managing New Users and User Groups
    • Overview of Manually Creating an External Role
      • Performing External Role Authorization Tasks on the Oracle Database Server
      • Performing External Role Authorization Tasks on the Client Computer
    • About Manually Migrating Users
• 12 Storing Oracle Wallets in the Windows Registry
  • About Storing Private Keys and Trust Points
  • About Storing User's Profile
  • About Registry Parameters for Wallet Storage
    • About Oracle Wallet Manager
      • About Sharing Wallets and sqlnet.ora Files Among Multiple Databases
• 13 Oracle PKI Integration with Windows
  • About Oracle Public Key Infrastructure
  • About Windows Public Key Infrastructure
    • About Microsoft Certificate Stores
    • About Microsoft Certificate Services
    • Using Microsoft Certificate Stores with Oracle PKI Applications
• 14 Using Oracle Database with Microsoft Active Directory
  • Overview of Microsoft Active Directory Support
    • About Microsoft Active Directory
    • About Accessing Active Directory
  • Overview of Oracle Components That Integrate with Active Directory
    • About Directory Naming
    • About Automatic Discovery of Directory Servers
    • About Integration with Windows Tools
    • About User Interface Extensions for Oracle Net Directory Naming
    • About Enhancement of Directory Object Type Descriptions
    • About Integration with Windows Login Credentials
    • Overview of Oracle Directory Objects in Active Directory
  • Overview of Requirements for Using Oracle Database with Active Directory
    • Creating Oracle Schema Objects
    • Creating an OracleContext
      • Running Oracle Network Configuration Assistant
    • About Directory Naming Software Requirements
  • Configuring Client Computers and Oracle Database to Use Active Directory
  • About Testing Connectivity
    • Testing Connectivity from Client Computers
    • Testing Connectivity from Microsoft Tools
  • Overview of Access Control List Management for Oracle Directory Objects
    • Overview of Security Groups
      • About OracleDBCreators
      • About OracleNetAdmins
      • About Oracle Net Services Objects
    • Setting ACLs on Net Service Entries
    • Adding and Deleting Security Group Members
• 15 Oracle Database Specifications for Windows
  • Overview of Initialization Parameter File
    • About the Location of the Initialization Parameter File
    • About Editing The Initialization Parameter File
    • About Oracle Database Configuration Assistant Renaming init.ora
  • Using Sample File for Database Creation
  • About SGA_MAX_SIZE Parameter
  • Overview of Initialization Parameters Without Windows-Specific Values
  • Displaying Initialization Parameter Values
  • About Unmodifiable Database Initialization Parameters
  • About Calculating Database Limits
• 16 Configuration Parameters and the Registry
  • About Configuration Parameters
  • Registry Overview
  • Registry Parameters Overview
    • About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOMENAME
      • 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_USER
      • ORACLE_HOMENAME
      • ORACLE_PRRITY
      • ORACLE_SID
      • OSAUTH_PREFIX_DOMAIN
      • RDBMS_ARCHIVE
      • RDBMS_CONTROL
      • SQLPATH
    • About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
      • INST_LOC
    • About HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
      • Parameters for Oracle Database Services
  • Overview of Oracle RAC Registry Parameters
    • About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
  • Managing Registry Parameters with regedit
    • Modifying a Parameter Value with regedit
    • Adding a Registry Parameter with regedit
• 17 Developing Applications for Windows
  • About Finding Information on Application Development for Windows
    • About Java Enhancements
    • About ODP.NET
    • About Oracle Developer Tools for Visual Studio
    • About Oracle Providers for ASP.NET
    • About XML Support
    • About Support for Internet Applications
    • About Oracle Services for Microsoft Transaction Server
    • About Oracle ODBC Driver
    • About Pro*C/C++ and Pro*COBOL Applications
  • 32-bit to 64-bit Application Migration
  • About Building External Procedures
    • External Procedures Overview
    • Installing and Configuring Oracle Database and Oracle Net Services
      • 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
  • Overview of Multithreaded Agent Architecture
  • About Debugging External Procedures
    • Using Package DEBUG_EXTPROC
  • About Accessing Text Files with UTL_FILE
• A Storing Tablespaces on Raw Partitions
  • Raw Partition Overview
    • About Physical Disk
    • About Logical Partition
    • About Physical Disk and Logical Partition Considerations
    • About Compatibility Issues
  • Configuring Disks for Oracle Automatic Storage Management
• B Oracle Net Services Configuration on Windows
  • About Configuring Oracle Database to Communicate with Oracle ASM
  • About Modifying Oracle Net Services Registry Parameters and Subkeys
    • About Oracle Net Service Subkeys
  • About Listener Requirements
    • Running Oracle Net Services
  • Overview of Optional Configuration Parameters
    • About LOCAL Parameter
    • About TNS_ADMIN Parameter
    • About USE_SHARED_SOCKET Parameter
  • Overview of Advanced Network Configuration
    • About Configuring Authentication Method
    • About Configuring Security for Named Pipes Protocol
    • Modifying Configuration of External Procedures for Higher Security
• C Running Windows Services
  • About Windows Services for Oracle Database
    • About Running Windows Services in Oracle Home
    • Additional Privileges Required by Oracle Database Services
    • Granting Additional Operating System Privileges Manually
• D Error Messages on Windows
  • ORA-09275: CONNECT INTERNAL No Longer Supported
  • ORA-15252 to ORA-15266: User Replacement Failure on Windows
  • ORA-15301 to ORA-15302: Failure to Modify Ownership, Group, and Permission of Opened Files
  • 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-00228: ORADIM Command Syntax Errors
  • Database Connection Issues
• E Oracle Database Differences on Windows and UNIX
  • 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
  • Installation Accounts and Groups
  • Oracle Database Installation
  • Memory Resources
  • Microsoft Transaction Server
  • Multiple Oracle Homes and OFA
  • Oracle Home User and Oracle User
  • Raw Partitions
  • Windows Services
• Index