Oracle 9i - Database Getting started

Contents......Page 3
Send Us Your Comments......Page 11
Preface......Page 13
Organization......Page 14
Related Documentation......Page 16
Conventions......Page 17
Documentation Accessibility......Page 22
Oracle9i Release 2 (9.2) New Features......Page 23
Oracle9i Release 1 (9.0.1) New Features......Page 24
1 Introduction......Page 27
Task Mapping......Page 28
2 Oracle9i Windows/UNIX Differences......Page 31
Diagnostic and Tuning Utilities......Page 32
Dynamic Link Libraries (DLLs)......Page 33
Initialization Parameters: Multiple Database Writers......Page 34
Memory Resources......Page 35
Multiple Oracle Homes and OFA......Page 36
Raw Partitions......Page 37
Services......Page 38
3 Using Oracle9i on Windows 2000......Page 39
How to Perform Common Tasks in Windows NT and Windows 2000......Page 40
DNS Domain Name......Page 41
Services Autostart......Page 42
4 Oracle9i Architecture on Windows......Page 45
Thread-Based Architecture......Page 46
Raw File Support......Page 49
Support for Very Large Memory (VLM) Configurations......Page 50
4 GB RAM Tuning (4GT)......Page 52
Oracle9i Integration with Windows......Page 53
Active Directory......Page 54
ORACLEMTSRecoveryService......Page 55
Oracle Fail Safe......Page 56
Other Sources of Information......Page 57
5 Database Tools Overview......Page 59
Database Tools and Operating System Compatibility......Page 60
Preferred Database Tools......Page 63
Starting Database Tools......Page 64
Starting Database Tools from the Start Menu......Page 65
Starting Database Tools from the Command Line......Page 68
From the Start Menu or Command Line......Page 70
From a Web Browser......Page 71
Starting Windows Tools......Page 74
Default (No Processing Option) or "str terminator_string"......Page 75
Case Study Files......Page 76
Control File Conventions......Page 77
Event Viewer......Page 78
Oracle Performance Monitor for Windows NT......Page 79
Task Manager......Page 80
User Manager......Page 81
Optional Windows Diagnostic and Tuning Utilities......Page 82
6 Multiple Oracle Homes and Optimal Flexible Architecture......Page 83
Multiple Oracle Homes Overview......Page 84
Oracle8 Releases Before 8.0.4......Page 85
Oracle8i Release 8.1.5 to Oracle9i Release 2 (9.2)......Page 86
Oracle Home Environments in Oracle8 Releases 8.0.4 and Later 8.0.x......Page 87
Oracle Home Environments in Oracle8i Releases 8.1.3, 8.1.4, and 8.1.5......Page 88
Changing the Value of PATH......Page 89
At the System Level on Windows 98......Page 90
At the Command Prompt......Page 91
ORACLE_HOME......Page 92
Consequences of Setting ORACLE_HOME......Page 93
Optimal Flexible Architecture Overview......Page 94
Benefits of an OFA-Compliant Database......Page 95
Characteristics of an OFA-Compliant Database......Page 96
Database Filename Extensions......Page 97
Changing ORACLE_BASE at the System Level on Windows NT:......Page 98
ADMIN Directory......Page 99
OFA and Multiple Oracle Home Configurations......Page 100
Installing a Default OFA Database: Example......Page 101
Installing a Nondefault OFA Database: Example 1......Page 102
Installing a Nondefault OFA Database: Example 2......Page 103
Disk Striping......Page 105
Directory Naming......Page 106
Support for Symbolic Links on Windows NT......Page 107
7 Oracle9i Services on Windows......Page 109
Oracle9i Services Available on Windows......Page 110
Using Oracle9i Services......Page 114
8 Oracle9i Default Accounts and Passwords......Page 115
Overview......Page 116
Unlocking and Changing Passwords......Page 117
Reviewing Accounts and Passwords......Page 118
9 Configuration Parameters and the Registry......Page 121
Registry Overview......Page 122
Registry Parameters......Page 123
ORA_SID_AUTOSTART......Page 124
ORA_TZFILE......Page 125
ORACLE_HOME......Page 126
RDBMS_ARCHIVE......Page 127
OO4O......Page 128
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services......Page 129
Parameters for Oracle Performance Monitor for Windows NT......Page 130
Parameters for Oracle Services......Page 131
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\CM......Page 132
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9I\IPC......Page 133
Modifying a Registry Value with regedt32......Page 134
Adding a Registry Parameter with regedt32......Page 136
Adding or Modifying Registry Parameters with Oracle Administration Assistant for Windows NT......Page 137
Starting Oracle Administration Assistant for Windows NT......Page 138
Adding Oracle Home Parameters......Page 140
Editing Oracle Home Parameters......Page 141
Modifying Oracle Performance Monitor for Windows NT Parameters......Page 142
Using OPERFCFG Utility......Page 143
Using Oracle Administration Assistant for Windows NT......Page 144
10 Developing Applications for Windows......Page 145
Application Wizards......Page 146
OLE DB......Page 147
Developing Windows Applications......Page 148
Developing Internet Applications......Page 149
External Procedures Overview......Page 151
Configuring Oracle Net Services......Page 152
Task 2: Writing an External Procedure......Page 153
Task 3: Building a DLL......Page 154
Task 4: Registering an External Procedure......Page 155
Task 5: Executing an External Procedure......Page 156
Using Package DEBUG_EXTPROC......Page 157
Accessing Web Data with Intercartridge Exchange......Page 158
Configuring Intercartridge Exchange......Page 159
Using Intercartridge Exchange......Page 160
Packaged Function UTL_HTTP.REQUEST_PIECES......Page 161
UTL_HTTP Exception Conditions......Page 162
Exception Conditions and Error Messages......Page 163
A Error Messages......Page 165
OSD-04000 to OSD-04599: Windows NT-Specific Oracle Messages......Page 166
File I/O Errors: OSD-04000 to OSD-04099......Page 170
Memory Errors: OSD-04100 to OSD-04199......Page 174
Process Errors: OSD-04200 to OSD-04299......Page 176
Semaphore Errors: OSD-04400 to OSD-04499......Page 180
Miscellaneous Errors: OSD-04500 to OSD-04599......Page 181
DIM-00000 to DIM-00039: ORADIM Command Syntax Errors......Page 183
Database Connection Issues......Page 190
B Getting Started with Your Documentation......Page 193
Glossary......Page 195
Index......Page 205