Installation guide

Section 5.1:Setting Up an Oracle Service 83
5 Database Services
This chapter contains instructions for configuring Red Hat Linux Advanced Server to make database
services highly available.
Note
The following descriptions present example database configuration instruc-
tions. Be aware that differences may exist in newer versions of each database
product. Consequently, this information may not be directly applicable.
5.1 Setting Up an Oracle Service
A database service can serve highly-available data to a database application. The application can then
provide network access to database client systems, such as Web servers. If the service fails over, the
application accesses the shared database data through the new cluster system. A network-accessible
database service is usually assigned an IP address, which is failed over along with the service to main-
tain transparent access for clients.
This section provides an example of setting up a cluster service for an Oracle database. Although the
variables used in the service scripts depend on the specific Oracle configuration, the example may
aid in setting up a service for individual environments. See Section 5.2, Tuning Oracle Services for
information about improving service performance.
In the example that follows:
• The service includes one IP address for the Oracle clients to use.
• The service has two mounted file systems, one for the Oracle software (/u01) and the other for
the Oracle database (/u02), which were set up before the service was added.
• An Oracle administration account with the name
oracle was created on both cluster systems before
the service was added.
• Network access in this example is through Perl DBI proxy.
• The administration directory is on a shared disk that is used in conjunction with the Oracle service
(for example, /u01/app/oracle/admin/db1).
The Oracle service example uses five scripts that must be placed in /home/oracle and owned by
the Oracle administration account. The oracle script is used to start and stop the Oracle service.
Specify this script when you add the service. This script calls the other Oracle example scripts. The
startdb and stopdb scripts start and stop the database. The startdbi and stopdbi scripts