After Upgrade : Adapter connection is not working

Hi experts,

We had done migration from 9.9 to 10.5. One of our adapter connection got failed and throwing an error.
The confusion part is , we are not sure before migration that adapter is enabled or not. Is it possible to find that adapter is enabled or disabled before migration.

Error :

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource com.tele2.dbconnectors.sd.changeMonitor.dbconnectors:CHANGE_MONITOR_STUB.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection com.tele2.dbconnectors.sd.changeMonitor.dbconnectors:CHANGE_MONITOR_STUB: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I don’t see a way unless you have a pre-upgrade copy of the package, but here are some indirect ways -

Namespace - Can you navigate to the folder namespace in the backend and see the timestamp on the internal file for the connection?

DB Logs - This message usually happens when the Listener is stopped on the DB side (or incorrect SID, which seems unlikely in your case). You can look for a timestamp in the DB logs to see if this Listener was stopped any time recently.

Connection History - Else if the DB is online, you can get the DBA to check when was the last time the user configured in this connection, actually connected to the DB.

KM

1 Like