Skip Headers
Oracle® Database Platform Guide
10
g
Release 1 (10.1) for 64-Bit Windows
Part No. B13831-01
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Structure
Related Documents
Conventions
What's New in Oracle Database for Windows
Oracle Database 10
g
Release 1 (10.1)
New Features
Oracle9
i
Release 2 (9.2.0.2) New Feature
Oracle9
i
Release 2 (9.2) New Features
Oracle9
i
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
2.2.1.1
Starting Tools from Oracle8 Release 8.0.4 and Later 8.0.
x
Multiple Oracle Homes
2.2.1.2
Starting Tools from Oracle8
i
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
2.3.1.1
Default (No Processing Option) or "str terminator_string"
2.3.1.2
"FIX
n
"
2.3.1.3
"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
4.2.1.1
File Permissions Set by Oracle Universal Installer
4.2.1.2
File Permissions Set by Database Configuration Assistant
4.2.1.3
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
inter
Media on Windows
4.4.1
Upgrading Oracle
inter
Media from an Earlier Release
4.4.2
Configuring Oracle
inter
Media Audio, Video, Image, and Locator
4.4.3
Configuring Oracle
inter
Media 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
9.1.5.1
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
9.2.1.1
External User Authentication Tasks on the Oracle Database Server
9.2.1.2
External User Authentication Tasks on the Client Computer
9.2.2
Manually Granting Administrator and Operator Privileges for Databases
9.2.2.1
SYSDBA/SYSOPER Authentication Tasks on the Oracle Database Server
9.2.2.2
SYSDBA/SYSOPER Authentication Tasks on the Client Computer
9.2.3
Manually Creating an External Role
9.2.3.1
External Role Authorization Tasks on the Oracle Database Server
9.2.3.2
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
10.3.1.1
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 Microsoft 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 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
12.6.1.1
OracleDBCreators
12.6.1.2
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.1
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME
14.3.1.1
MSHELP_TOOLS
14.3.1.2
NLS_LANG
14.3.1.3
ORA_CWD
14.3.1.4
ORA_SID_AUTOSTART
14.3.1.5
ORA_SID_PFILE
14.3.1.6
ORA_SID_SHUTDOWN
14.3.1.7
ORA_SID_SHUTDOWN_TIMEOUT
14.3.1.8
ORA_SID_SHUTDOWNTYPE
14.3.1.9
ORA_TZFILE
14.3.1.10
ORACLE_AFFINITY
14.3.1.11
ORACLE_BASE
14.3.1.12
ORACLE_GROUP_NAME
14.3.1.13
ORACLE_HOME
14.3.1.14
ORACLE_HOME_KEY
14.3.1.15
ORACLE_HOME_NAME
14.3.1.16
ORACLE_PRIORITY
14.3.1.17
ORACLE_SID
14.3.1.18
OSAUTH_PREFIX_DOMAIN
14.3.1.19
OSAUTH_X509_NAME
14.3.1.20
RDBMS_ARCHIVE
14.3.1.21
RDBMS_CONTROL
14.3.1.22
SQLPATH
14.3.2
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
14.3.2.1
INST_LOC
14.3.2.2
OO4O
14.3.3
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
14.3.3.1
Parameters for Oracle Counters for Windows Performance Monitor
14.3.3.2
Parameters for Oracle Database Services
14.4
Oracle Real Application Clusters Registry Parameters
14.4.1
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OCR
14.5
Modifying a Registry Value with regedt32
14.6
Adding a Registry Parameter with regedt32
14.7
Adding or Modifying Registry Parameters with Oracle Administration Assistant for Windows
14.7.1
Starting Oracle Administration Assistant for Windows
14.7.2
Adding Oracle Home Parameters
14.7.3
Editing Oracle Home Parameters
14.7.4
Deleting Oracle Home Parameters
14.8
Modifying Oracle Counters for Windows Performance Monitor Parameters
14.8.1
Using operfcfg
14.8.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
15.3.2.1
Installing Oracle Database
15.3.2.2
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
15.6.2.1
Packaged Function UTL_HTTP.REQUEST
15.6.2.2
Packaged Function UTL_HTTP.REQUEST_PIECES
15.6.3
UTL_HTTP Exception Conditions
15.6.3.1
UTL_HTTP.REQUEST
15.6.3.2
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.3.1
LOCAL
C.3.2
TNS_ADMIN
C.3.3
USE_SHARED_SOCKET
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 10
g
Release 1 (10.1) Database
G.7.3
Migrating an Oracle9
i
or Older Database
G.8
Application Migration
G.9
Oracle Database for 64-bit Windows Documentation
Glossary
Index
