ORA-12505 TNS-12505 TNS:listener does not currently know of SID given in connect descriptor

This error is received when the listener received a request to establish a connection to a database or other service but the connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for…

Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514

This post details how to resolve listener connection issues when DB & listener are started but still connect fails with following errors:- ORA-12505 TNS:listener could not resolve SID given in connect descriptor TNS-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor TNS-12514 TNS:listener could…