Skip Headers

Table of Contents Image Oracle9i Database Getting Started
Release 2 (9.2) for Windows

Part Number A95490-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Organization
Related Documentation
Conventions
Documentation Accessibility

What's New in Oracle9i for Windows

Oracle9i Release 2 (9.2) New Features
Oracle9i Release 1 (9.0.1) New Features

1 Introduction

Document Plan
Task Mapping

2 Oracle9i Windows/UNIX Differences

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
Install Accounts and Groups
Installation
Memory Resources
Microsoft Transaction Server
Multiple Oracle Homes and OFA
Processes and Threads
Raw Partitions
Services

3 Using Oracle9i on Windows 2000

How to Perform Common Tasks in Windows NT and Windows 2000
Other Differences Between Windows NT and Windows 2000
DNS Domain Name
Microsoft Management Console
Enterprise User Authentication
Raw Partitions
Services Autostart

4 Oracle9i Architecture on Windows

Oracle9i on Windows Architecture
Thread-Based Architecture
File I/O Enhancements
Raw File Support
Oracle9i Scalability on Windows
Support for Very Large Memory (VLM) Configurations
4 GB RAM Tuning (4GT)
Large User Populations
Oracle9i Integration with Windows
Oracle PKI Integration
Active Directory
Oracle Net Naming with Active Directory
ORACLEMTSRecoveryService
Oracle Fail Safe
Oracle Real Application Clusters Guard
Other Sources of Information

5 Database Tools Overview

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 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
Starting Database Tools from the Start Menu
Starting Database Tools from the Command Line
Starting Oracle Enterprise Manager Console
From the Start Menu or Command Line
From a Web Browser
Starting Windows Tools
Using SQL*Loader
Windows Processing Options
Default (No Processing Option) or "str terminator_string"
"FIX n"
"VAR n"
Case Study Files
Specifying the Bad File
Control File Conventions
Using Windows Tools
Event Viewer
Microsoft Management Console
Oracle Performance Monitor for Windows NT
Registry Editor
Task Manager
User Manager
Optional Windows Diagnostic and Tuning Utilities

6 Multiple Oracle Homes and Optimal Flexible Architecture

Introduction to Multiple Oracle Homes and OFA
Multiple Oracle Homes Overview
What Is an Oracle Home?
Benefit of Using Multiple Oracle Homes
Multiple Oracle Home Functionality in Different Releases
Oracle8 Releases Before 8.0.4
Oracle8 Releases 8.0.4 to 8.0.6
Oracle8i Release 8.1.3 to Oracle9i Release 2 (9.2)
Oracle8i Release 8.1.5 to Oracle9i Release 2 (9.2)
One-Listener Support of Multiple Oracle Homes
Multiple Oracle Home Environments
Oracle Home Environments in Oracle8 Releases 8.0.4 and Later 8.0.x
Oracle Home Environments in Oracle8i Releases 8.1.3, 8.1.4, and 8.1.5
Changing the Value of PATH
Using Oracle Home Selector
At the System Level on Windows NT
At the System Level on Windows 98
At the Command Prompt
Exiting Oracle Universal Installer After Entering Name and PATH
Setting Variables in the Environment or the Registry
ORACLE_HOME
Consequences of Setting ORACLE_HOME
TNS_ADMIN
Optimal Flexible Architecture Overview
Benefits of an OFA-Compliant Database
Characteristics of an OFA-Compliant Database
Differences Between Directory Trees by Release
Top-Level Oracle Directory
Database Filenames
Database Filename Extensions
OFA Directory Naming Conventions
ORACLE_BASE Directory
Changing ORACLE_BASE at the System Level on Windows NT:
Changing ORACLE_BASE at the System Level on Windows 98:
ORACLE_HOME Directory
ADMIN Directory
ORADATA Directory
DB_NAME Directory
OFA and Multiple Oracle Home Configurations
Specifying an ORACLE_HOME Directory
Installing a Default OFA Database: Example
Installing a Nondefault OFA Database: Example 1
Installing a Nondefault OFA Database: Example 2
Increasing Reliability and Performance
Disk Mirroring
Disk Striping
Using Raw Partitions for Tablespaces
Comparison Between OFA on Windows NT and UNIX
Directory Naming
ORACLE_BASE Directory
Support for Symbolic Links on Windows NT

7 Oracle9i Services on Windows

Introduction to Oracle9i Services
Oracle9i Services Available on Windows
Using Oracle9i Services

8 Oracle9i Default Accounts and Passwords

Overview
Unlocking and Changing Passwords
Granting Limited SYS Database Role Privileges
Reviewing Accounts and Passwords

9 Configuration Parameters and the Registry

About Configuration Parameters
Registry Overview
Registry Parameters
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID
MSHELP_TOOLS
NLS_LANG
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_NAME
ORACLE_PRIORITY
ORACLE_SID
RDBMS_ARCHIVE
OSAUTH_PREFIX_DOMAIN
OSAUTH_X509_NAME
RDBMS_CONTROL
SQLPATH
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
INST_LOC
OO4O
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES
DEFAULT_HOME
HOME_COUNTER
LAST_HOME
IDx
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
Parameters for Oracle Performance Monitor for Windows NT
Parameters for Oracle Services
Oracle Real Application Clusters Registry Parameters
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\CM
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\IPC
Parameter Data Types and Default Values
Modifying a Registry Value with regedt32
Adding a Registry Parameter with regedt32
Adding or Modifying Registry Parameters with Oracle Administration Assistant for Windows NT
Starting Oracle Administration Assistant for Windows NT
Adding Oracle Home Parameters
Editing Oracle Home Parameters
Deleting Oracle Home Parameters
Modifying Oracle Performance Monitor for Windows NT Parameters
Using OPERFCFG Utility
Using Oracle Administration Assistant for Windows NT

10 Developing Applications for Windows

Finding Information on Application Development for Windows
Java Enhancements
XML Support
Support for Internet Applications
Application Wizards
Oracle COM/COM+ Integration Feature
ORACLEMTSRecoveryService
Pro*C/C++ and Pro*COBOL Applications
OLE DB
Developing Windows Applications
Developing Internet Applications
Building External Procedures
External Procedures Overview
Task 1: Installing and Configuring
Installing Oracle9i Database
Configuring Oracle Net Services
Task 2: Writing an External Procedure
Task 3: Building a DLL
Task 4: Registering an External Procedure
Task 5: Executing an External Procedure
Debugging External Procedures
Using Package DEBUG_EXTPROC
Accessing Web Data with Intercartridge Exchange
Configuring Intercartridge Exchange
Using Intercartridge Exchange
Packaged Function UTL_HTTP.REQUEST
Packaged Function UTL_HTTP.REQUEST_PIECES
UTL_HTTP Exception Conditions
UTL_HTTP.REQUEST
UTL_HTTP.REQUEST_PIECES
Exception Conditions and Error Messages

A Error Messages

Logging Error Messages
ORA-09275: CONNECT INTERNAL No Longer Supported
OSD-04000 to OSD-04599: Windows NT-Specific Oracle 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-00039: ORADIM Command Syntax Errors
Database Connection Issues

B Getting Started with Your Documentation

Glossary

Index


Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback