Oracle9i Administrator's Reference for UNIX Systems AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris

• Publisher: Oracle press
• Year: 2002
• Tongue: English
• Leaves: 226
• Category: Library

✦ Table of Contents

Send Us Your Comments......Page 13
Terminology......Page 15
Command Syntax......Page 16
Accessing Installed Documentation......Page 17
Related Documentation......Page 18
Oracle Services and Support......Page 19
1 Administering Oracle9i......Page 23
Oracle9i Environment Variables......Page 24
UNIX Environment Variables......Page 27
Local bin Directory......Page 30
Setting the System Time......Page 31
LD_PRELOAD Environment Variable for Loading Shared Libraries (HP Only)......Page 32
Relinking Executables......Page 33
System Global Area......Page 34
Determining the Size of the SGA......Page 35
Intimate Shared Memory (Solaris Only)......Page 36
Shared Memory on AIX......Page 37
Database Limits......Page 38
Operating System Accounts and Groups......Page 39
OSDBA, OSOPER, and ORAINVENTORY Groups......Page 40
Security for Database Files......Page 41
Running the orapwd Utility......Page 42
Customizing the Initialization File......Page 43
Oracle HTTP Server......Page 46
Demonstration Files......Page 47
SQLLoader Demonstrations......Page 48
PL/SQL Kernel Demonstrations......Page 49
PL/SQL Precompiler Demonstrations......Page 51
Administering SQLLoader......Page 52
Removing Newline Characters......Page 53
2 Tuning for Oracle9i on UNIX......Page 55
Types of Performance Bottlenecks......Page 56
Common Tools......Page 57
AIX System Management Interface Tool......Page 61
AIX Performance Toolbox......Page 62
HP Performance Analysis Tools......Page 64
Allocate Sufficient Swap Space......Page 65
Control Paging......Page 66
Tuning Disk I/O......Page 67
Choose the Appropriate File System Type......Page 68
Tuning UNIX Kernel Parameters......Page 69
Using Raw Devices/Volumes......Page 70
Guidelines for Using Raw Devices/Volumes......Page 71
Raw Device Setup......Page 72
Alert Files......Page 73
3 Administering SQLPlus and iSQLPlus......Page 75
Using the PRODUCT_USER_PROFILE Table......Page 76
Using EMP and DEPT Tables......Page 77
Installing the SQLPlus Command-Line Help......Page 78
Removing the SQLPlus Command-Line Help......Page 79
Disabling and Re-enabling iSQLPlus......Page 80
Editing the iSQLPlus Configuration File......Page 81
Configuring Oracle HTTP Server Authentication for iSQLPlus......Page 82
Adding Usernames and Passwords to a Password File......Page 83
Configuring the Oracle HTTP Server to Use a New Password File......Page 84
Restricting Database Access from iSQLPlus......Page 85
Running Operating System Commands from SQLPlus......Page 87
Hiding Your Password......Page 88
4 Using Oracle Precompilers and the Oracle Call Interface......Page 91
Relinking Precompiler Executables......Page 92
Issues Common to All Precompilers......Page 93
Client Shared Library......Page 94
Support for 32-Bit and 64-Bit Client Applications (AIX, HP, and Solaris 64-Bit Only)......Page 96
ProC/C++ Demonstration Programs......Page 98
ProC/C++ User Program......Page 99
Merant Server Express COBOL Compiler......Page 100
ProCOBOL Demonstration Programs......Page 102
FORMAT Precompiler Option......Page 104
ProFORTRAN Demonstration Programs......Page 105
SQLModule for Ada (Solaris 32-Bit and AIX Only)......Page 106
SQLModule for Ada Demonstration Programs......Page 107
OCI Demonstration Programs......Page 108
OCI User Programs......Page 109
Custom Make Files......Page 110
Multi-threaded Applications......Page 111
Using Signal Handlers......Page 112
XA Functionality......Page 114
5 Configuring Oracle Net Services......Page 115
Location of Oracle Net Services Configuration Files......Page 116
Adapters Utility......Page 117
IPC Protocol Support......Page 119
TCP/IP Protocol Support......Page 120
Setting Up the Listener for TCP/IP or TCP/IP with SSL......Page 121
Configure the Master Agent......Page 122
Verify the Location of the SNMP Daemon in the start_peer Script......Page 123
Start the SNMP Components......Page 124
Calling 32-Bit External Procedures from PL/SQL (AIX, HP, and Solaris 64-Bit Only)......Page 125
A Tuning for Oracle9i on AIX......Page 127
Controlling Buffer-Cache Paging Activity......Page 128
Tuning the AIX File Buffer Cache......Page 129
Tuning the MINPERM and MAXPERM Parameters......Page 130
Controlling Paging......Page 131
I/O Buffers and SQLLoader......Page 132
AIX Logical Volume Manager......Page 133
Other Considerations......Page 134
Using Journaled File Systems Compared to Using Raw Partitions......Page 135
Moving from a Journaled File System to Raw Devices......Page 136
Using Asynchronous I/O......Page 137
I/O Slaves......Page 139
Using Write Behind......Page 140
Tuning Disk I/O Pacing......Page 141
VSD Cache Buffers......Page 142
Changing Process Running Time Slice......Page 143
Using Processor Binding on SMP Systems......Page 144
Processor Binding in a Networked Client and Server Environment......Page 145
UDP Tuning......Page 146
Backing Up Raw Devices......Page 147
Resilvering with Oracle9i......Page 148
B Tuning for Oracle9i on HP......Page 149
HP SCHED_NOAGE Scheduling Policy......Page 150
Enabling SCHED_NOAGE for Oracle9i......Page 151
MLOCK Privilege......Page 152
Implementing Asynchronous I/O......Page 153
Asynchronous Flag in SGA......Page 155
C Tuning for Oracle9i on Linux......Page 157
Extended Buffer Cache Support......Page 158
Asynchronous I/O Support......Page 159
D Tuning for Oracle9i on Tru64......Page 161
Enabling Oracle9i Directed Placement Optimizations......Page 162
Disabling Oracle Directed Placement Optimizations......Page 163
Tru64 UNIX System Parameters......Page 164
Supporting Mixed CPU Systems......Page 165
Requirements......Page 166
Enabling UDP IPC......Page 167
CLUSTER_INTERCONNECTS Initialization Parameter (Formerly TRU64_IPC_NET)......Page 168
aio_task_max_num Parameter......Page 170
Single Instance Requirements......Page 171
Multiple Instance Requirements (Oracle9i Real Application Clusters)......Page 172
Disabling Direct I/O Support......Page 173
Preventing File Fragmentation......Page 174
Setting Up Raw Devices......Page 175
Spike Optimization Tool......Page 178
Using Spike......Page 179
E Running Oracle interMedia, Oracle Text, and Oracle Spatial Demonstrations......Page 185
Oracle interMedia Audio, Image, and Video Services......Page 186
Clipboard......Page 187
Oracle Spatial......Page 188
F Oracle Cluster Management Software for Linux......Page 189
Overview......Page 190
Cluster Manager......Page 191
Starting the Watchdog Daemon......Page 193
Configuring the Cluster Manager......Page 194
Starting the Cluster Manager......Page 196
Configuring Timing for Cluster Reconfiguration......Page 197
Watchdog Daemon and Cluster Manager Starting Options......Page 199
G Optimal Flexible Architecture......Page 201
Characteristics of an OFA-Compliant Database......Page 202
Mount Point Syntax......Page 204
Home Directory Syntax......Page 205
Naming Subdirectories......Page 206
Naming Database Files......Page 207
Separate Segments With Different Requirements......Page 208
Exploiting the OFA Structure for Oracle Files......Page 209
OFA File Mapping......Page 210
File Mapping for a Multiple-Instance OFA Database......Page 211
Oracle Home Directory......Page 213
Examples of Product Subdirectories......Page 214
File Naming Conventions in the admin Directory......Page 215
Filename Extensions......Page 216
Index......Page 219