Oracle Database 11g R2 Step-by-Step Installation Guide

✍ Scribed by Sideris Courseware Corp

• Publisher: Sideris Courseware Corporation June
• Year: 2011
• Tongue: English
• Leaves: 224
• Category: Library

✦ Synopsis

A major prerequisite for the usage and deployment of Oracle database technology is a successful installation. The purpose of this Oracle 11g training course module is to offer a step-by-step guide for the configuration of a Linux or Microsoft Windows server to host an Oracle database Enterprise Edition installation. Especially in a Linux environment installation of the database requires careful preparation, configuration and sometimes troubleshooting in order to succeed. This course includes practical tips learned from many real-world installations which can assist you to achieve a successful installation in your environment. We will explore both a standalone database installation and also a grid infrastructure installation. Major objectives covered within this guide book include: - Configuration of the Linux and Microsoft Windows operating systems in anticipation of a database installation; Performing a Desktop Class installation of the Oracle 11g R2 Enterprise Edition database; - Performing a Server Class installation of the Oracle 11g R2 Enterprise Edition database; - Addressing configuration and setup issues using the FixUp utility; - Verification of a valid database installation; Database administrator and technical support interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH; - Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations; - Preparing a host system for ASM storage management; - Partitioning and configuration of storage devices for ASM storage on both Linux and MS Windows servers; While this course module applies specifically to the installation of the Enterprise Edition of the Oracle database, it covers basic topics which apply to any Oracle software installation. Therefore, this material is also useful for the installation of other Oracle products such as the Oracle Database Client, specialized options for a database server installation, and so on

✦ Table of Contents

Contents......Page 3
Send Us Your Comments......Page 11
1 Oracle HTTP Server Overview......Page 23
Oracle HTTP Server Features......Page 24
Oracle HTTP Server Modules......Page 25
Oracle HTTP Server Support......Page 27
Starting Oracle HTTP Server......Page 28
Restarting Oracle HTTP Server......Page 29
2 Oracle HTTP Server Concepts......Page 31
Configuration Files Syntax......Page 32
Classes of Directives......Page 33
......Page 34
......Page 35
......Page 36
About .htaccess Files......Page 37
3 Specifying Server and File Locations......Page 39
UseCanonicalName......Page 40
ServerAlias......Page 41
DocumentRoot......Page 42
ScoreBoardFile......Page 43
ServerRoot......Page 44
4 Managing Server Processes......Page 45
Running Oracle HTTP Server as Root......Page 46
Additional Security Considerations......Page 47
User......Page 48
MaxClients......Page 49
MinSpareServers......Page 50
Getting Information about Processes......Page 51
5 Managing the Network Connection......Page 53
Specifying Listener Ports and Addresses......Page 54
Listen......Page 55
TimeOut......Page 56
MaxKeepAliveRequests......Page 57
Configuring Reverse Proxies and Load Balancers......Page 58
6 Configuring and Using Server Logs......Page 61
Configuring Oracle HTTP Server......Page 62
Specifying Log Formats......Page 65
Specifying Log Level......Page 66
CustomLog......Page 67
Piped Log......Page 68
Transfer Log......Page 69
7 Oracle HTTP Server Modules......Page 71
List of Modules......Page 72
mod_auth......Page 73
mod_cern_meta......Page 74
mod_certheaders......Page 75
mod_digest......Page 78
mod_example......Page 79
mod_include......Page 80
mod_log_referer......Page 81
mod_negotiation......Page 82
Benefits of mod_onsint......Page 83
Implementation Differences for mod_onsint......Page 84
mod_perl......Page 85
Using Perl to Access the Database......Page 86
Using SQL NCHAR Datatypes......Page 87
mod_plsql......Page 89
Creating a DAD......Page 90
plsql.conf......Page 91
Configuration Parameters......Page 92
plsql.conf......Page 94
DAD Parameters......Page 96
cache.conf......Page 119
mod_rewrite Rules Processing......Page 123
RewriteLogLevel......Page 125
RewriteBase......Page 126
Rewrite Rules Hints......Page 127
Redirection Examples......Page 128
mod_status......Page 129
mod_vhost_alias......Page 130
8 Managing Security......Page 131
About Oracle HTTP Server Security......Page 132
Resources Protected......Page 133
Host-based Access Control......Page 134
Access Control for Virtual Hosts......Page 135
Controlling Access by IP Address......Page 136
Controlling Access by Network or Netmask......Page 137
Controlling Access with Environment Variables......Page 138
Using mod_auth to Authenticate Users......Page 139
Enabling SSL......Page 140
Using mod_ossl......Page 142
Using mod_ossl Directives......Page 143
Using mod_proxy Directives......Page 160
Using mod_ossl Directives to Configure Client Authentication......Page 162
Using the iasobf Utility......Page 163
9 Frequently Asked Questions......Page 165
Using Oracle HTTP Server as Cache......Page 166
Applying Apache Security patches to Oracle HTTP Server......Page 167
Creating Application Name Space that Works Across Firewalls and Clusters......Page 168
Protecting Web Site From Hackers......Page 169
A Oracle HTTP Server Configuration Files......Page 171
Global Environment......Page 172
Virtual Hosts......Page 173
dms.conf......Page 174
plsql.conf......Page 175
ssl.conf......Page 176
opmn.xml......Page 177
B Third Party Licenses......Page 179
The Apache Software License......Page 180
Apache SOAP License......Page 181
Definitions......Page 183
Perl Kit Readme......Page 187
mod_perl 1.26 License......Page 188
Preamble......Page 189
Definitions......Page 190
mod_dav......Page 193
FastCGI Developer’s Kit License......Page 195
Module mod_fastcgi License......Page 196
The Jaxen Software License......Page 198
Expat License......Page 200
The SAXPath License......Page 201
Glossary......Page 203
Index......Page 213