Products | Versions |
---|---|
TIBCO Runtime Agent (TRA) | - |
Not Applicable | - |
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 -->Create Domain -->Database URL.
In the case of an existing domain run DomainUtility from Admin and Client machines to update the Database URL. Run
DomainUtility -->Server Settings -->Database 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/<version>/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])