Resolution:
Description:
============
Configure Administrator when using Oracle Data Guard for HA.

Environment:
===========
Administrator 5.7 or higher


Symptoms:
========
Getting error in Domain Utility while creating an admin domain using DB backend.

java.lang.Exception: java.sql.SQLRecoverableException: IO Error: Unknown host specified

Cause:
=====
JDBC URL can not resolve the DB host.

Resolution:
==========
When using Oracle Data Guard for HA where the DB connection is set using net_service _name, the Administrator DB connection should be done using TNS (@SERVICE_NAME) instead of using SID (@&lthost>:&ltport>:&ltSID>).

The Administration domain can be created by using the DB URL as follows:

"jdbc:oracle:thin:@&ltTNS_Identifier>"

For that string to work, there should be a Java property set:

java.property.oracle.net.tns_admin=&ltlocation of tnsnames.ora>

Example:

java.property.oracle.net.tns_admin=C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

Added in the following:

&ltTIBCO_HOME>/tra/&ltversion>/bin/domainutility.tra file – used by domainutility
&ltTIBCO_HOME>/administrator/&ltversion>/template/tibcoadmintra.template - used for tibcoadmin_DOMAIN.tra
&ltTIBCO_HOME>/tra/&ltversion>/template/domainutility/hawkagenttra.template  - used for hawkagent_DOMAIN.tra
&ltTIBCO_HOME>/tra/&ltversion>/bin/AppManage.tra - used by AppManage
&ltTIBCO_HOME>/tra/&ltversion>/bin/domainutilitycmd.tra - used by domainutilitycmd

References:
==========

http://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#JJDBC08200
http://docs.oracle.com/cd/B28359_01/server.111/b28294/create_ps.htm#i63561
https://forums.oracle.com/forums/thread.jspa?threadID=541354
http://docs.oracle.com/cd/B28359_01/network.111/b28316/gettingstart.htm#i485122