When starting the TIBCO activeMatrix database adapter throws an exception:

"ORA-12505 Connection refused, the specified SID (<SID_NAME>) was not recognized by the Oracle server."

The following can be the causes of this error:
1) Incorrect SID name or Oracle Listener has not been configured for the specified SID.
2) The listener is configured for Service Name, not the SID.

Product: TIBCO Adapter for ActiveDatabase Version: All Supported versions Database: Oracle OS: All Supported Operating Systems

To resolve this exception follow the resolutions below.

1). Confirm with the Oracle Database Administrator the correct SID. Use the "tnsping" command to check the DB status.

2). Modify the connection URL to use the Service Name instead of the SID. If the listener is configured for Service Name then use the following: 

To verify the service name or SID check the tnsnames.ora file located at "\app\username\product\11.2.0\dbhome_1\network\admin\tnsnames.ora".
         
The connection URL for Oracle DataDirect Driver
----------------------------------------------------------------------------------
            For SID: jdbc:tibcosoftwareinc:oracle://<host>:<port>;SID=<SID>
            For Service Name: jdbc:tibcosoftwareinc:oracle://<host>:<port>;ServiceName=<ServiceName>

When starting an adapter it throws an error "ORA-12505 Connection refused, the specified SID(xx) was not recognized by the Oracle server".