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
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection 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.


1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.