1/28

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Accessing Documentation
• Related Documents
• Conventions

Changes in This Release for Oracle Database Platform Guide

• Changes in Oracle Database 12c Release 1 (12.1)

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 Services for Microsoft Transaction Server
  • Oracle Fail Safe Integration with Windows
• Other Sources of Information

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
  • Starting Windows Tools
• Using the Oracle Home User Control Tool
• Using SQL*Loader
  • Windows Processing Options
    • Default (No Processing Option) or "str terminator_string"
  • Control File Conventions
• 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
• Optional Windows Diagnostic and Tuning Utilities

3 Supporting Oracle Home User on Windows

• Managing Oracle Home User
• Using Oracle Home User for Oracle Single-Instance Database and Oracle Database Client
• Using Oracle Home User for Oracle RAC Database
• Using Oracle Home User for Oracle Grid Infrastructure
• Using Oracle Home User in Case of Multiple Oracle Home
• 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

• Overview of the Naming Conventions for Oracle Database
• Overview of Database Creation on Windows Using Oracle Database Configuration Assistant
• 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
    • Creating Oracle Wallets in a File System for Oracle Database Services
  • Starting an Oracle Database Instance
  • Putting 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
• 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
  • Configuring the Windows Firewall Postinstallation
  • 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
• 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
  • 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
  • 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
  • Reading Event Viewer
  • Managing 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 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
  • About 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 Oracle Administration Assistant for Windows
  • Managing a Remote Computer
  • Adding a Computer and Saving Your Configuration
  • Granting Administrator Privileges for All Databases on a Computer
  • Granting Operator Privileges for All Databases on a Computer
  • Connecting to a Database
    • Troubleshooting Connection Problems
  • Viewing Database Authentication Parameter Settings
  • Creating an External Operating System User
  • Creating a Local Database Role
  • Creating an External Operating System Role
  • Granting Administrator Privileges for a Single Database
  • Granting Operator Privileges for a Single Database
• 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
    • 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

• Initialization Parameter File Overview
  • About the Location of the Initialization Parameter File
  • About Editing The Initialization Parameter File
  • About 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
• 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
• About Managing Registry Parameters with Oracle Administration Assistant for Windows
  • Starting Oracle Administration Assistant for Windows
  • Adding Oracle Home Parameters
  • Editing Oracle Home Parameters
  • Deleting Oracle Home Parameters

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 Provider for OLE DB
  • About Oracle ODBC Driver
  • About Pro*C/C++ and Pro*COBOL Applications
• 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
  • 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
• Installation
• Memory Resources
• Microsoft Transaction Server
• Multiple Oracle Homes and OFA
• Oracle Home User and Oracle User
• Processes and Threads
• Raw Partitions
• Services

Glossary

Index