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
- Overview of Oracle Database Scalability on Windows
  - Large User Populations
- Oracle Database Integration with Windows
2 Database Tools on Windows
- Choosing a Database Tool
  - Database Tools and Operating System Compatibility
  - Preferred Database Tools
- Starting Database Tools
- Using the Oracle Home User Control Tool
- Using Windows Tools
- 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 Administering an Oracle Database Instance Using ORADIM
- About Administering an Oracle Database Instance Using Microsoft Management Console Snapin
- Overview of Database Migration from a 32-Bit Windows Computer
5 Postinstallation Configuration Tasks on Windows
- Overview of Windows Firewall
- About the Need to Reset Passwords for Default Accounts
- About Windows Authenticated Users
- Overview of NTFS File System and Windows Registry Permissions
- 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
6 Administering a Database on Windows
- About Ways to Manage 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
- 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
- Basic Steps of Backup and Recovery with VSS
- About Installing and Uninstalling the Oracle VSS Writer Service
- About Backing Up a Database
- About Restoring and Recovering a Database
  - About Restoring and Recovering a Database in ARCHIVELOG Mode
  - 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
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
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
- Overview of Requirements for Using Oracle Database with Active Directory
- 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
15 Oracle Database Specifications for Windows
- Overview of Initialization Parameter File
- 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
- 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
- 32-bit to 64-bit Application Migration
- About Building External Procedures
- 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
- 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
- Overview of Advanced Network Configuration
C Running Windows Services
- About Windows Services for Oracle Database
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
- 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