Use this procedure to enable console failover when using
Oracle RAC
Before you begin
Basic database setup for Oracle RAC is the same as setup for
other Oracle databases. Install the console using those settings.
After the console is installed, use these procedures to implement
failover.
About this task
To enable Oracle RAC failover to work with Build Forge,
there is additional configuration required. There are two methods
available:
Both methods require that you specify SERVICE_NAME, which represents
the cluster as a whole. This is different than non-RAC configurations,
where SERVICE_NAME is typically the same as the SID.
Procedure
- SCAN method
- Edit buildforge.conf. Add the db_url parameter
to buildforge.conf and use the JDBC connection string as the parameter.
Note that the service must be set up in Oracle (mysvc.mycorp.com)
and have multiple nodes. Line breaks are included for clarity. Do
not break the lines in buildforge.conf.
db_hostname myoracledbhost.mycompany.com
db_url jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=myoracledbhost.mycompany.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mysvc.mycorp.com)))
db_tcp_port 1521
db_database orclrac
db_username
db_password
db_type odbc
db_provider oracle
- Update buildforge.conf in all locations.
- Explicit Connection strings method In the example,
the following names are used:
- Service name: myorasvc.mycorp.com
- Node names: clusnode-1vip, clusnode-2vip, clusnode-3vip, clusnode-4vip
- Edit tsnames.ora.
myorasvc.mycorp.com=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-1vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-2vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-3vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-4vip)(PORT=1521))
(LOAD_BALANCE=yes)(FAILOVER=ON)
(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME=myorasvc.mycorp.com)
(failover_mode=(type=select)
(method=basic)(retries=180)(delay=5)))
)
- Edit buildforge.conf Set the db_url parameter
to the JDBC connection string. Line breaks are included for clarity.
Do not break the lines in buildforge.conf.
db_url jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-1vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-2vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-3vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=clusnode-4vip)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=myorasvc.mycorp.com)))
- Update buildforge.conf in all locations.