Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Administrator’s Reference Guide
- 1 Oracle Database Architecture on Windows
- 2 Database Tools on Windows
- 3 Supporting Oracle Home User on Windows
-
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
- Deleting Database Files
- Modifying the Initialization Parameter File
- About Creating and Starting an Oracle Database Service
- 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
- 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 Oracle Executables Requiring Windows Firewall Exceptions
- Configuring the Windows Firewall
- 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
- Overview of ReFS File System
- About Configuring External Job Support for the Scheduler on Windows
- About Oracle Multimedia on Windows
- About Oracle Text on Windows
- About Oracle Spatial and Graph on Windows
- About Advanced Replication on Windows
-
Overview of Windows Firewall
- 6 Administering a Database on Windows
- 7 Monitoring a Database on Windows
-
8
Tuning Windows to Optimize Oracle Database
- Overview of Windows Tuning
- Overview of 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 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
- 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 Integrating VSS with Third-Party Requester Applications
- About Duplicating a Database
- 10 Authenticating Database Users with Windows
-
11
Administering External Users and Roles on Windows
- Overview of Manually Administering External Users and Roles
- 12 Storing Oracle Wallets in the Windows Registry
- 13 Oracle PKI Integration with Windows
-
14
Using Oracle Database with Microsoft Active Directory
- Overview of Microsoft Active Directory Support
-
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
- Configuring Client Computers and Oracle Database to Use Active Directory
- About Testing Connectivity
- 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
-
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
- About HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
-
About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOMENAME
- Overview of Oracle RAC Registry Parameters
- Managing Registry Parameters 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
- Overview of Multithreaded Agent Architecture
- About Debugging External Procedures
- About Accessing Text Files with UTL_FILE
-
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
- 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
- Glossary
- Index