Listener refused connection

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.