Oracle9i Database Getting Started

Foch C.B., Kennedy M., Rolhenberg T.

This manual is your primary source of introductory and reference information for Oracle9i for Windows for both client and server. Differences between product versions are noted where appropriate.This manual describes only the features of Oracle9i Enterprise Edition, Oracle9i Standard Edition, and Oracle9i Personal Edition software that apply to the Windows 95, Windows 98, Windows NT, and Windows 2000 operating systems.This manual is intended for:■ Database administrators■ Network administrators■ Security specialists■ Developers who use the Oracle9/ database To use this document, you need:■ Windows NT or Windows 2000 installed and tested on your computer system■ Knowledge of object-relational database management concepts”

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 13
Preface……Page 15
Organization……Page 16
Related Documentation……Page 17
Conventions……Page 18
Documentation Accessibility……Page 24
1 Introduction……Page 25
Task Mapping……Page 26
2 Oracle9i Windows/UNIX Differences……Page 29
Diagnostic and Tuning Utilities……Page 30
Dynamic Link Libraries (DLLs)……Page 31
Install Accounts and Groups……Page 32
Microsoft Transaction Server……Page 33
Processes and Threads……Page 34
Raw Partitions……Page 35
Services……Page 36
3 Using Oracle9i on Windows 2000……Page 37
How to Perform Common Tasks in Windows NT and Windows 2000……Page 38
Microsoft Management Console……Page 39
Services Autostart……Page 40
4 Oracle9i Architecture on Windows……Page 41
Thread-Based Architecture……Page 42
Raw File Support……Page 45
Large User Populations……Page 46
Active Directory……Page 47
Oracle Services for Microsoft Transaction Server……Page 48
Oracle Real Application Clusters Guard……Page 49
Other Sources of Information……Page 50
5 Database Tools Overview……Page 51
Database Tools and Operating System Compatibility……Page 52
Preferred Database Tools……Page 55
Starting Database Tools……Page 56
Starting Tools from Oracle8i Release 8.1.3 and Later Multiple Oracle Homes……Page 57
Starting Database Tools from the Start Menu……Page 58
Starting Database Tools from the Command Line……Page 60
From the Start Menu or Command Line……Page 62
From a Web Browser……Page 63
Starting Windows Tools……Page 65
Default (No Processing Option) or “str terminator_string”……Page 66
“VAR n”……Page 67
Control File Conventions……Page 68
Event Viewer……Page 69
Oracle Performance Monitor for Windows NT……Page 70
Registry Editor……Page 71
User Manager……Page 72
Optional Windows Diagnostic and Tuning Utilities……Page 73
6 Multiple Oracle Homes and Optimal Flexible Architecture……Page 75
Multiple Oracle Homes Overview……Page 76
Oracle8 Releases Before 8.0.4……Page 77
Oracle8i Release 8.1.5 to Oracle9i Release 1 (9.0.1)……Page 78
Oracle Home Environments in Oracle8 Releases 8.0.4 and Later 8.0.x……Page 79
Oracle Home Environments in Oracle8i Releases 8.1.3, 8.1.4, and 8.1.5……Page 80
Changing the Value of PATH……Page 81
At the System Level on Windows 95 or 98……Page 82
At the MS-DOS Command Prompt……Page 83
ORACLE_HOME……Page 84
Consequences of Setting ORACLE_HOME……Page 85
Optimal Flexible Architecture Overview……Page 86
Benefits of an OFA-Compliant Database……Page 87
Characteristics of an OFA-Compliant Database……Page 88
Database Filename Extensions……Page 89
Changing ORACLE_BASE at the System Level on Windows NT:……Page 90
ADMIN Directory……Page 91
OFA and Multiple Oracle Home Configurations……Page 92
Installing a Default OFA Database: Example……Page 93
Installing a Nondefault OFA Database: Example 1……Page 94
Installing a Nondefault OFA Database: Example 2……Page 95
Disk Striping……Page 97
Directory Naming……Page 98
Support for Symbolic Links on Windows NT……Page 99
7 Oracle9i Services on Windows……Page 101
Oracle9i Services Available on Windows……Page 102
Using Oracle9i Services……Page 106
8 Oracle9i Default Accounts and Passwords……Page 107
Overview……Page 108
Unlocking and Changing Passwords……Page 109
Reviewing Accounts and Passwords……Page 110
9 Configuration Parameters and the Registry……Page 113
Registry Overview……Page 114
Registry Parameters……Page 115
ORA_SID_AUTOSTART……Page 116
ORA_TZFILE……Page 117
ORACLE_HOME……Page 118
RDBMS_ARCHIVE……Page 119
HKEY_LOCAL_MACHINESOFTWAREORACLEALL_HOMES……Page 120
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices……Page 121
Parameters for Oracle Performance Monitor for Windows NT……Page 122
Parameters for Oracle Services……Page 123
HKEY_LOCAL_MACHINESOFTWAREORACLEOSD9ICM……Page 124
Parameter Data Types and Default Values……Page 125
Modifying a Registry Value with regedt32……Page 126
Adding a Registry Parameter with regedt32……Page 127
Starting the Oracle Administration Assistant for Windows NT……Page 129
Adding Oracle Home Parameters……Page 130
Editing Oracle Home Parameters……Page 131
Using the OPERFCFG Utility……Page 132
Using the Oracle Administration Assistant for Windows NT……Page 133
10 Developing Applications for Windows……Page 135
Support for Internet Applications……Page 136
OLE DB……Page 137
Developing Windows Applications……Page 138
Developing Internet Applications……Page 139
External Procedures Overview……Page 141
Installing the Oracle9i Database……Page 142
Task 2: Writing an External Procedure……Page 143
Task 3: Building a DLL……Page 144
Task 4: Registering an External Procedure……Page 145
Task 5: Executing an External Procedure……Page 146
Using Package DEBUG_EXTPROC……Page 147
Configuring Intercartridge Exchange……Page 148
Packaged Function UTL_HTTP.REQUEST……Page 150
Packaged Function UTL_HTTP.REQUEST_PIECES……Page 151
Exception Conditions and Error Messages……Page 152
A Error Messages……Page 155
OSD-04000 to OSD-04599: Windows NT-Specific Oracle Messages……Page 156
File I/O Errors: OSD-04000 to OSD-04099……Page 160
Memory Errors: OSD-04100 to OSD-04199……Page 164
Process Errors: OSD-04200 to OSD-04299……Page 166
Semaphore Errors: OSD-04400 to OSD-04499……Page 170
Miscellaneous Errors: OSD-04500 to OSD-04599……Page 171
DIM-00000 to DIM-00039: ORADIM Command Syntax Errors……Page 173
Database Connection Issues……Page 180
B Getting Started with Your Documentation……Page 183
Glossary……Page 185
Index……Page 195