Skip Headers

Oracle® Database Platform Guide
10g Release 1 (10.1) for Windows

Part Number B10113-02
Go to Documentation Home
Go to Book List
Book List
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to next page
View PDF


Title and Copyright Information

Send Us Your Comments


Documentation Accessibility
Related Documents

What's New in Oracle Database for Windows

Oracle Database 10g Release 1 (10.1) New Features
Oracle9i Release 2 ( New Feature
Oracle9i Release 2 (9.2) New Features
Oracle9i Release 1 (9.0.1) New Features

1 Oracle Database Architecture on Windows

1.1 Oracle Database on Windows Architecture
1.1.1 Thread-Based Architecture
1.1.2 File I/O Enhancements
1.1.3 Raw File Support
1.2 Oracle Database Scalability on Windows
1.2.1 Support for Very Large Memory (VLM) Configurations
1.2.2 4 GB RAM Tuning (4GT)
1.2.3 Large User Populations
1.3 Oracle Database Integration with Windows
1.3.1 Oracle PKI Integration with Windows
1.3.2 Oracle Services for Microsoft Transaction Server
1.3.3 Oracle Fail Safe Integration with Windows
1.3.4 Oracle Real Application Clusters Integration with Windows
1.4 Other Sources of Information

2 Database Tools on Windows

2.1 Choosing a Database Tool
2.1.1 Database Tools and Operating System Compatibility
2.1.2 Preferred Database Tools
2.2 Starting Database Tools
2.2.1 Starting Database Tools in Multiple Oracle Homes Starting Tools from Oracle8 Release 8.0.4 and Later 8.0.x Multiple Oracle Homes Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes
2.2.2 Starting Database Tools from the Start Menu
2.2.3 Starting Database Tools from the Command Line
2.2.4 Starting Windows Tools
2.3 Using SQL*Loader
2.3.1 Windows Processing Options Default (No Processing Option) or "str terminator_string" "FIX n" "VAR n"
2.3.2 Case Study Files
2.3.3 Specifying the Bad File
2.3.4 Control File Conventions
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.4.7 Using User Manager to Manage Users
2.5 Optional Windows Diagnostic and Tuning Utilities

3 Postinstallation Database Creation on Windows

3.1 Naming Conventions for Oracle Database
3.2 Accessing Data Files and Log Files on Remote Computers
3.3 Creating a Database on Windows Using Database Configuration Assistant
3.4 Creating a Database on Windows Using Command-Line Tools
3.4.1 Creating Directories
3.4.2 Exporting an Existing Database
3.4.3 Deleting Database Files
3.4.4 Modifying the Initialization Parameter File
3.4.5 Starting an Oracle Database Instance
3.4.6 Creating and Starting an Oracle Database Service
3.4.7 Putting the CREATE DATABASE Statement in a Script
3.4.8 Running the CREATE DATABASE Script
3.4.9 Importing a Database
3.4.10 Updating ORACLE_SID in the Registry
3.4.11 Backing Up the New Database
3.5 Using ORADIM to Administer an Oracle Database Instance
3.5.1 Creating an Instance
3.5.2 Starting an Instance and Services
3.5.3 Stopping an Instance and Services
3.5.4 Editing an Instance
3.5.5 Deleting an Instance

4 Postinstallation Configuration Tasks on Windows

4.1 Resetting Passwords for Default Accounts
4.2 NTFS File System and Windows Registry Permissions
4.2.1 File Permissions File Permissions Set by Oracle Universal Installer File Permissions Set by Database Configuration Assistant File Permissions Set by Database Upgrade Assistant
4.2.2 Setting NTFS File System Security
4.2.3 Setting Windows Registry Security
4.3 Configuring External Job Support for the Scheduler on Windows
4.4 Oracle interMedia on Windows
4.4.1 Upgrading Oracle interMedia from an Earlier Release
4.4.2 Configuring Oracle interMedia Audio, Video, Image, and Locator
4.4.3 Configuring Oracle interMedia Demos
4.5 Configuring Oracle Text on Windows
4.6 Configuring Oracle Spatial on Windows
4.7 Configuring Advanced Replication on Windows
4.7.1 Checking Tablespace and Rollback Segment Requirements
4.7.2 Adding and Modifying Initialization Parameters
4.7.3 Monitoring Data Dictionary Tables

5 Administering a Database on Windows

5.1 Managing Oracle Database Services
5.1.1 Oracle Database Service Naming Conventions for Multiple Oracle Homes
5.1.2 Starting Oracle Database Services
5.1.3 Stopping Oracle Database Services
5.1.4 Auto-starting 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.5.1 Viewing and Hiding the Password File
5.6 Connecting Remotely to the Database as SYS
5.7 Automatically Encrypted Database Passwords
5.8 Creating Control, Data, and Log Files on Remote Computers
5.9 Archiving Redo Log Files
5.9.1 Changing Archive Mode to ARCHIVELOG
5.9.2 Enabling Automatic Archiving
5.10 Backing Up an Oracle Database on Windows

6 Monitoring a Database on Windows

6.1 Database Monitoring Overview
6.2 Using Oracle Counters for Windows Performance Monitor
6.2.1 Registry Information
6.2.2 Accessing Oracle Counters for Windows Performance Monitor
6.2.3 Modifying Views
6.2.4 Understanding Oracle Database Performance Objects
6.2.5 Oracle Counters for Windows Performance Monitor Troubleshooting Information
6.3 Using Event Viewer
6.3.1 Reading Event Viewer
6.3.2 Managing Event Viewer
6.4 Trace Files
6.5 Alert Files
6.6 Viewing Threads

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.10.1 Multiple Striped Volumes for Sequential and Random Access
7.11 Multiplex Windows Server Virtual Memory Paging File
7.12 Close All Unnecessary Foreground Applications

8 Authenticating Database Users with Windows

8.1 Windows Native Authentication Overview
8.2 Windows Authentication Protocols
8.3 User Authentication and Role Authorization Methods
8.3.1 Authentication and Authorization Methods To Use
8.4 Operating System Authentication Enabled at Installation

9 Administering External Users and Roles on Windows

9.1 Oracle Administration Assistant for Windows
9.1.1 Managing a Remote Computer
9.1.2 Adding a Computer and Saving Your Configuration
9.1.3 Granting Administrator Privileges for All Databases on a Computer
9.1.4 Granting Operator Privileges for All Databases on a Computer
9.1.5 Connecting to a Database Troubleshooting Connection Problems
9.1.6 Viewing Database Authentication Parameter Settings
9.1.7 Creating an External Operating System User
9.1.8 Creating a Local Database Role
9.1.9 Creating an External Operating System Role
9.1.10 Granting Administrator Privileges for a Single Database
9.1.11 Granting Operator Privileges for a Single Database
9.2 Manually Administering External Users and Roles
9.2.1 Manually Creating an External Operating System User External User Authentication Tasks on the Oracle Database Server External User Authentication Tasks on the Client Computer
9.2.2 Manually Granting Administrator and Operator Privileges for Databases SYSDBA/SYSOPER Authentication Tasks on the Oracle Database Server SYSDBA/SYSOPER Authentication Tasks on the Client Computer
9.2.3 Manually Creating an External Role External Role Authorization Tasks on the Oracle Database Server External Role Authorization Tasks on the Client Computer
9.2.4 Manually Migrating Users

10 Storing Oracle Wallets in the Windows Registry

10.1 Storing Private Keys and Trust Points
10.2 Storing User's Profile
10.3 Registry Parameters for Wallet Storage
10.3.1 Oracle Wallet Manager Sharing Wallets and sqlnet.ora Files Among Multiple Databases

11 Oracle PKI Integration with Windows

11.1 Oracle Public Key Infrastructure
11.2 Windows Public Key Infrastructure
11.2.1 Microsoft Certificate Stores
11.2.2 Microsoft Certificate Services
11.2.3 Using Microsoft Certificate Stores with Oracle PKI Applications

12 Using Oracle Database with Microsoft Active Directory

12.1 Microsoft Active Directory Support
12.1.1 About Microsoft Active Directory
12.1.2 Accessing Active Directory
12.2 Oracle Components That Integrate with Active Directory
12.2.1 Directory Naming
12.2.2 Automatic Discovery of Directory Servers
12.2.3 Integration with Windows Tools
12.2.4 User Interface Extensions for Oracle Net Directory Naming
12.2.5 Enhancement of Directory Object Type Descriptions
12.2.6 Integration with Windows Login Credentials
12.2.7 Oracle Directory Objects in Active Directory
12.3 Requirements for Using Oracle Database with Active Directory
12.3.1 Directory Naming Software Requirements
12.3.2 Oracle Schema Objects Creation
12.3.3 Oracle Context Creation
12.4 Configuring Oracle Database to Use Active Directory
12.5 Testing Connectivity
12.5.1 Testing Connectivity from Client Computers
12.5.2 Testing Connectivity from Microsoft Tools
12.6 Access Control List Management for Oracle Directory Objects
12.6.1 Security Groups OracleDBCreators OracleNetAdmins
12.6.2 Adding and Deleting Security Group Members

13 Oracle Database Specifications for Windows

13.1 Initialization Parameter File Overview
13.1.1 Location of the Initialization Parameter File
13.1.2 Editing The Initialization Parameter File
13.1.3 Database Configuration Assistant Renames init.ora
13.2 Sample File
13.3 SGA_MAX_SIZE Parameter
13.4 Initialization Parameters Without Windows-Specific Values
13.5 Displaying Initialization Parameter Values
13.6 Uneditable Database Initialization Parameters
13.7 Calculating Database Limits

14 Configuration Parameters and the Registry

14.1 About Configuration Parameters
14.2 Registry Overview
14.3 Registry Parameters
14.3.3 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services Parameters for Oracle Counters for Windows Performance Monitor Parameters for Oracle Database Services
14.4 Oracle Real Application Clusters Registry Parameters
14.5 Managing Registry Parameters with regedt32
14.5.1 Modifying a Parameter Value with regedt32
14.5.2 Adding a Registry Parameter with regedt32
14.6 Managing Registry Parameters with Oracle Administration Assistant for Windows
14.6.1 Starting Oracle Administration Assistant for Windows
14.6.2 Adding Oracle Home Parameters
14.6.3 Editing Oracle Home Parameters
14.6.4 Deleting Oracle Home Parameters
14.7 Modifying Oracle Counters for Windows Performance Monitor Parameters
14.7.1 Using operfcfg
14.7.2 Using Oracle Administration Assistant for Windows

15 Developing Applications for Windows

15.1 Finding Information on Application Development for Windows
15.1.1 Java Enhancements
15.1.2 XML Support
15.1.3 Support for Internet Applications
15.1.4 Application Wizards
15.1.5 Oracle COM/COM+ Integration Feature
15.1.6 Oracle Objects for OLE
15.1.7 ODP.NET
15.1.8 Oracle Services For Microsoft Transaction Server
15.1.9 Pro*C/C++ and Pro*COBOL Applications
15.1.10 OLE DB
15.2 Developing Windows Applications
15.2.1 Developing Internet Applications
15.3 Building External Procedures
15.3.1 External Procedures Overview
15.3.2 Installing and Configuring Installing Oracle Database Configuring Oracle Net Services
15.3.3 Writing an External Procedure
15.3.4 Building a DLL
15.3.5 Registering an External Procedure
15.3.6 Executing an External Procedure
15.4 Debugging External Procedures
15.4.1 Using Package DEBUG_EXTPROC
15.5 Accessing Text Files with UTL_FILE
15.6 Accessing Web Data with Intercartridge Exchange
15.6.1 Configuring Intercartridge Exchange
15.6.2 Using Intercartridge Exchange Packaged Function UTL_HTTP.REQUEST Packaged Function UTL_HTTP.REQUEST_PIECES
15.6.4 Exception Conditions and Error Messages

A Getting Started with Your Documentation

B Storing Tablespaces on Raw Partitions

B.1 Raw Partition Overview
B.1.1 Physical Disk
B.1.2 Logical Partition
B.1.3 Physical Disk and Logical Partition Considerations
B.1.4 Compatibility Issues
B.2 Creating a Tablespace in a Raw Partition

C Oracle Net Services Configuration on Windows

C.1 Understanding Oracle Net Services Registry Parameters and Subkeys
C.1.1 Oracle Net Service Subkeys
C.2 Listener Requirements
C.3 Understanding Optional Configuration Parameters
C.4 Advanced Network Configuration
C.4.1 Configuring Authentication Method
C.4.2 Configuring Security for Named Pipes Protocol
C.4.3 Modifying Configuration of External Procedures for Higher Security

D Error Messages on Windows

D.1 ORA-09275: CONNECT INTERNAL No Longer Supported
D.2 OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
D.2.1 File I/O Errors: OSD-04000 to OSD-04099
D.2.2 Memory Errors: OSD-04100 to OSD-04199
D.2.3 Process Errors: OSD-04200 to OSD-04299
D.2.4 Loader Errors: OSD-04300 to OSD-04399
D.2.5 Semaphore Errors: OSD-04400 to OSD-04499
D.2.6 Miscellaneous Errors: OSD-04500 to OSD-04599
D.3 DIM-00000 to DIM-00039: ORADIM Command Syntax Errors
D.4 Database Connection Issues

E Using Oracle Database on Windows 2000

E.1 How to Perform Common Tasks in Windows NT and Windows 2000
E.2 Other Differences Between Windows NT and Windows 2000
E.2.1 No DNS Domain Name for Windows 2000 Computer
E.2.2 Microsoft Management Console Included in Windows 2000
E.2.3 Raw Partitions
E.2.4 Services Autostart

F Oracle Database Windows/UNIX Differences

F.1 Automatic Startup and Shutdown
F.2 Background Processing and Batch Jobs
F.3 Diagnostic and Tuning Utilities
F.4 Direct Writes to Disk
F.5 Dynamic Link Libraries (DLLs)
F.6 Hot Backups
F.7 Initialization Parameters: Multiple Database Writers
F.8 Install Accounts and Groups
F.9 Installation
F.10 Memory Resources
F.11 Microsoft Transaction Server
F.12 Multiple Oracle Homes and OFA
F.13 Processes and Threads
F.14 Raw Partitions
F.15 Services

G Oracle Database for 64-Bit Windows

G.1 Unsupported Features
G.2 Oracle Database Architecture on 64-Bit Windows
G.3 Database Tools for 64-Bit Windows
G.4 Backing Up and Recovering 64-Bit Database Files
G.5 Users and Roles for 64-Bit Windows
G.6 Large Page Support for 64-bit Windows
G.7 Database Migration from a 32-bit Windows Computer
G.7.1 Backing Up a 32-Bit Oracle Database
G.7.2 Migrating an Oracle Database 10g Release 1 (10.1) Database
G.7.3 Migrating an Oracle9i or Older Database
G.8 Application Migration
G.9 Oracle Database for 64-bit Windows Documentation