Symptoms
While testing connectivity to a Data Source Profile, you see the following issue:
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Cause
The database name you supplied was incorrect and/or the listener definition and mapping contains a different name (SID).
Resolution
Contact your database administrator to obtain the proper SID for the database you are trying to connect to.