Oracle Database Platform Guide For Windows
User Manual:
Open the PDF directly: View PDF
Page Count: 272 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Preface
- What's New in Oracle Database for Windows
- 1 Oracle Database Architecture on Windows
- 2 Database Tools on Windows
- 2.1 Choosing a Database Tool
- 2.2 Starting Database Tools
- 2.3 Using SQL*Loader
- 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 Oracle Counters for Windows Performance Monitor
- 2.4.4 Using Registry Editor to Modify Configuration Information
- 2.4.5 Using Task Manager to Monitor Applications and Processes
- 2.4.6 Using Local Users and Groups to Manage Users and Groups
- 2.5 Optional Windows Diagnostic and Tuning Utilities
- 3 Postinstallation Database Creation on Windows
- 3.1 Naming Conventions for Oracle Database
- 3.2 Creating a Database on Windows Using Database Configuration Assistant
- 3.3 Creating a Database on Windows Using Command-Line Tools
- 3.3.1 Exporting an Existing Database
- 3.3.2 Deleting Database Files
- 3.3.3 Modifying the Initialization Parameter File
- 3.3.4 Creating and Starting an Oracle Database Service
- 3.3.5 Starting an Oracle Database Instance
- 3.3.6 Putting the CREATE DATABASE Statement in a Script
- 3.3.7 the CREATE DATABASE Script
- 3.3.8 Importing a Database
- 3.3.9 Updating ORACLE_SID in the Registry
- 3.3.10 Backing Up the New Database
- 3.4 Using ORADIM to Administer an Oracle Database Instance
- 3.5 Database Migration from a 32-bit Windows Computer
- 4 Postinstallation Configuration Tasks on Windows
- 4.1 Windows Firewall
- 4.2 Resetting Passwords for Default Accounts
- 4.3 NTFS File System and Windows Registry Permissions
- 4.4 Configuring External Job Support for the Scheduler on Windows
- 4.5 Configuring Oracle Multimedia on Windows
- 4.6 Configuring Oracle Text on Windows
- 4.7 Configuring Oracle Spatial on Windows
- 4.8 Configuring Advanced Replication on Windows
- 5 Administering a Database on Windows
- 5.1 Managing Oracle Database Services
- 5.2 Starting and Shutting Down a Database with SQL*Plus
- 5.3 Starting and Shutting Down a Database Using Services
- 5.4 Starting Multiple Instances
- 5.5 Creating and Populating Password Files
- 5.6 Connecting Remotely to the Database as SYS
- 5.7 Automatically Encrypted Database Passwords
- 5.8 Archiving Redo Log Files
- 6 Monitoring a Database on Windows
- 7 Tuning Windows to Optimize Oracle Database
- 7.1 Windows Tuning Overview
- 7.2 Large Page Support
- 7.3 Reduce Priority of Foreground Applications on Server Console
- 7.4 Configure Windows Server to Be an Application Server
- 7.5 Disable Unnecessary Services
- 7.6 Remove Unused Network Protocols
- 7.7 Reset Network Protocol Bind Order
- 7.8 Setting the Order of Multiple Network Interface Cards
- 7.9 Apply Latest Reliable Windows Server Service Pack
- 7.10 Use Hardware or Operating System Striping
- 7.11 Multiplex Windows Server Virtual Memory Paging File
- 7.12 Close All Unnecessary Foreground Applications
- 8 Performing Database Backup and Recovery with VSS
- 8.1 Overview of Database Backup and Recovery with VSS
- 8.2 Installing and Uninstalling the Oracle VSS Writer Service
- 8.3 Backing Up a Database
- 8.4 Restoring and Recovering a Database
- 8.5 Integrating VSS with Third-Party Requester Applications
- 8.6 Duplicating a Database
- 9 Authenticating Database Users with Windows
- 10 Administering External Users and Roles on Windows
- 10.1 Oracle Administration Assistant for Windows
- 10.1.1 Managing a Remote Computer
- 10.1.2 Adding a Computer and Saving Your Configuration
- 10.1.3 Granting Administrator Privileges for All Databases on a Computer
- 10.1.4 Granting Operator Privileges for All Databases on a Computer
- 10.1.5 Connecting to a Database
- 10.1.6 Viewing Database Authentication Parameter Settings
- 10.1.7 Creating an External Operating System User
- 10.1.8 Creating a Local Database Role
- 10.1.9 Creating an External Operating System Role
- 10.1.10 Granting Administrator Privileges for a Single Database
- 10.1.11 Granting Operator Privileges for a Single Database
- 10.2 Manually Administering External Users and Roles
- 10.1 Oracle Administration Assistant for Windows
- 11 Storing Oracle Wallets in the Windows Registry
- 12 Oracle PKI Integration with Windows
- 13 Using Oracle Database with Microsoft Active Directory
- 13.1 Microsoft Active Directory Support
- 13.2 Oracle Components That Integrate with Active Directory
- 13.2.1 Directory Naming
- 13.2.2 Automatic Discovery of Directory Servers
- 13.2.3 Integration with Windows Tools
- 13.2.4 User Interface Extensions for Oracle Net Directory Naming
- 13.2.5 Enhancement of Directory Object Type Descriptions
- 13.2.6 Integration with Windows Login Credentials
- 13.2.7 Oracle Directory Objects in Active Directory
- 13.3 Requirements for Using Oracle Database with Active Directory
- 13.4 Configuring Oracle Database to Use Active Directory
- 13.5 Testing Connectivity
- 13.6 Access Control List Management for Oracle Directory Objects
- 14 Oracle Database Specifications for Windows
- 15 Configuration Parameters and the Registry
- 15.1 About Configuration Parameters
- 15.2 Registry Overview
- 15.3 Registry Parameters
- 15.3.1 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
- 15.3.1.1 MSHELP_TOOLS
- 15.3.1.2 NLS_LANG and Other Globalization Parameters
- 15.3.1.3 ORA_CWD
- 15.3.1.4 ORA_SID_AUTOSTART
- 15.3.1.5 ORA_SID_PFILE
- 15.3.1.6 ORA_SID_SHUTDOWN
- 15.3.1.7 ORA_SID_SHUTDOWN_TIMEOUT
- 15.3.1.8 ORA_SID_SHUTDOWNTYPE
- 15.3.1.9 ORA_TZFILE
- 15.3.1.10 ORACLE_AFFINITY
- 15.3.1.11 ORACLE_BASE
- 15.3.1.12 ORACLE_GROUP_NAME
- 15.3.1.13 ORACLE_HOME
- 15.3.1.14 ORACLE_HOME_KEY
- 15.3.1.15 ORACLE_HOME_NAME
- 15.3.1.16 ORACLE_PRIORITY
- 15.3.1.17 ORACLE_SID
- 15.3.1.18 OSAUTH_PREFIX_DOMAIN
- 15.3.1.19 RDBMS_ARCHIVE
- 15.3.1.20 RDBMS_CONTROL
- 15.3.1.21 SQLPATH
- 15.3.2 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
- 15.3.3 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- 15.3.1 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
- 15.4 Oracle RAC Registry Parameters
- 15.5 Managing Registry Parameters with regedit
- 15.6 Managing Registry Parameters with Oracle Administration Assistant for Windows
- 15.7 Modifying Oracle Counters for Windows Performance Monitor Parameters
- 16 Developing Applications for Windows
- 16.1 Finding Information on Application Development for Windows
- 16.1.1 Java Enhancements
- 16.1.2 ODP.NET
- 16.1.3 Oracle Developer Tools for Visual Studio
- 16.1.4 Oracle Providers for ASP.NET
- 16.1.5 XML Support
- 16.1.6 Support for Internet Applications
- 16.1.7 Oracle Services For Microsoft Transaction Server
- 16.1.8 Oracle Objects for OLE
- 16.1.9 Oracle Provider for OLE DB
- 16.1.10 Oracle ODBC Driver
- 16.1.11 Oracle COM Automation Feature
- 16.1.12 Pro*C/C++ and Pro*COBOL Applications
- 16.2 Building External Procedures
- 16.3 Multithreaded Agent Architecture
- 16.4 Debugging External Procedures
- 16.5 Accessing Text Files with UTL_FILE
- 16.6 Accessing Web Data with Intercartridge Exchange
- B.1 Raw Partition Overview
- B.2 Creating a Raw Partition and a Mount Point
- B.3 Creating a Tablespace in a Raw Partition
- B.4 Configuring Disks for Automatic Storage Management
- C.1 Configuring Oracle Database to Communicate with ASM
- C.2 Understanding Oracle Net Services Registry Parameters and Subkeys
- C.3 Listener Requirements
- C.4 Understanding Optional Configuration Parameters
- C.5 Advanced Network Configuration
- D.1 ORA-09275: CONNECT INTERNAL No Longer Supported
- D.2 OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
- D.3 DIM-00000 to DIM-00039: ORADIM Command Syntax Errors
- D.4 Database Connection Issues
- 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 Install Accounts and Groups
- E.9 Installation
- E.10 Memory Resources
- E.11 Microsoft Transaction Server
- E.12 Multiple Oracle Homes and OFA
- E.13 Processes and Threads
- E.14 Raw Partitions
- E.15 Services
- 16.1 Finding Information on Application Development for Windows
- Glossary
- Index