Resolution:
Description:
============
Connection from domainutility to oracle DB server is refused with below error:

Error: [tibcosoftwareinc][Oracle JDBC Driver]ORA-12505 Connection Refused,the specified SID is not recognized by oracle server

Environment:
===========
All OS
TIBCO Administrator 5.x.x
TIBCO Runtime Agent 5.x.x

Symptoms:
========
In domain utlity when we provide the database URL as:

jdbc:tibcosoftwareinc:oracle://servername:1521;sid=orcl.na.tibco.com

the connection is refused by the domainutility.

Cause:
=====
The issue depends on what is being used in the database URL i.e., Oracle SERVICENAME or Oracle SID. In Oracle server under tnsnames.ora there exists the  following structure for a particular database instance ORCL:

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.na.tibco.com)

Here SID will be ORCL and Service_name is orcl.na.tibco.com.

Resolution:
==========
If using the service name (orcl.na.tibco.com) in the datbase URL, in that case the URL shoul look like:

jdbc:tibcosoftwareinc:oracle://smunola-dt:1521;servicename=orcl.na.tibco.com

and

if we use the SID (ORCL) in database URL, in that case the URL shoul look like:

jdbc:tibcosoftwareinc:oracle://smunola-dt:1521;SID=orcl

If a wrong combination such as servicename=orcl or sid=orcl.na.tibco.com is used, in that case the error will occur.

Domain Utility Error- [tibcosoftwareinc][Oracle JDBC Driver]ORA-12505 Connection Refused, the specified SID is not recognized by oracle server