Symptoms
While testing connectivity to a data source profile, you see the following error:
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 provided is incorrect, or the listener definition and mapping have a different name (SID).
Resolution
Contact your database administrator to obtain the proper SID for the database you are trying to connect.