ORA 12505: The TNS Listener does not currently know of SID given in connect descriptor. Password Sync from IDM to Oracle accounts

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

After reseting the ADS account in the workstation, the same password is not synching with Oracle endpoints

Environment

Identity Manager 14.x

Cause

Checking the ADS accounts we can see that the password is synching with ADS, but not with Oracle.

From Provisioning Manager when trying to open the Oracle endpoint properties, we received an error message:

"ORA 12505: The TNS Listener does not currently know of SID given in connect descriptor"

Resolution

The URL attribute from Oracle endpoint properties has the SID, the last information, the SID was changed by Oracle DBA which caused the Connector Server to not be able to connect to Oracle endpoints anymore.

After fixing the SID, it was possible to open Oracle properties without error and also sync passwords with Oracle accounts.