Deployment Planning Guide > Server Clustering Planning >
Configuring Oracle Real Application Clusters (RAC)
You can obtain high-availability for Oracle 9i database servers by configuring them in an Oracle Real Application Cluster (RAC). There are several configuration requirements:
- The cluster can contain only two database servers.
- One of the database servers must be configured as active, the other passive (Active/Passive Cluster).
For a full description of Oracle Real Application Clusters and how to configure them, refer to Oracle documentation. Configuring a Real Application Cluster requires the following steps:
- Setting up the database client
- Setting up the database server
- Setting up the database listener
Setting Up the Database Client
Use this procedure to set up a database client. To set up the database client
1 Verify that the TNS entry in tnsnames.ora contains the listener addresses for the primary and secondary instances.
- Set other parameters as follows:
ORAC_AP =
(DESCRIPTION =
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = orac1)(PORT = 3000))
(ADDRESS = (PROTOCOL = TCP)(HOST = orac2)(PORT = 3000))
(CONNECT_DATA =
(SERVICE_NAME = qarac)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
(RETRIES = 8)
(DELAY = 15)
)
)
)
Setting Up the Database Servers
Perform this procedure on each of the database servers. To set up the database server
- Add the following line to init.ora:
active_instance_count = 1
This enables the primary/secondary instance feature.
- Restart the database server.
Setting Up the Database Listener
Use this procedure to set up the database listener. To set up the database listener
- Use a text editor to open listener.ora.
- Delete the sid_list_listener entries:
sid_list_listener=
(sid_desc=
(oracle_
home=/private/system/db)
(sid_name=db1))
This forces the database listener to obtain information from dynamic service registration.
- Verify the modified listener.ora file contains only the following entries:
listener=
(description=
(address=
(protocol=tcp)
(host=db1-server)
(port=1521)))
- Restart the database listener.
|