Resolution:
Description:
============
Configuring Oracle RAC's Database URL with Admin Domain using using the DomainUtility.

Environment:
===========
TIBCO Runtime Agent(TRA) 5.7.x ,TIBCO Administrator 5.7.x .
  
Resolution:
==========
You need to use DomainUtility.

When creating a new domain then run  DomainUtility --&gtCreate Domain --&gtDatabase URL.

In the case of an existing domain run DomainUtility from Admin and Client machines to update the Database URL. Run
  DomainUtility --&gtServer Settings --&gtDatabase Configuration -- > Database URL.

The following are examples of Database URL syntax for different JDBC Drivers for Oracle DB:

1). For Oracle Thin Drivers:
---------------------------------

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=[port]))
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=[port]))
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=[port])))
(CONNECT_DATA=(SERVICE_NAME=[service])(SERVER=DEDICATED)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))

OR

url="jdbc:oracle:thin:@(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=[CluseraliasIP])(PORT=1521))  (CONNECT_DATA=(SERVICE_NAME=[service])))"

2). For Oracle Thick Drivers:
-----------------------------
url="jdbc:oracle:oci:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=[ip])(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=[service])))"

OR

url="jdbc:oracle:oci:@(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=[CluseraliasIP] )(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=[service])))"
        
NOTE: For more details on configuring  Oracle Thin and Thick JDBC driver please refer Oracle RAC documentation.    

3). For TIBCO DataDirect Drivers:
----------------------------------
For more details on the syntax for specifying alternate servers with TIBCO DataDirect Drivers , refer to page 202 in $TIBCO_HOME/tpcl/&ltversion>/jdbc/books/jdbc/Jdbcref/jdbcref.pdf.

The following example is with one alternate server:

jdbc:tibcosoftwareinc:oracle://[MachineName]:1521;SID=[SID_NAME];AlternateServers=([AlternateMachine]:1521;SID=[SID_NAME])

Configuring Oracle RAC's Database URL with Admin Domain using the DomainUtility.