As we are working on the series of listener errors. Now we are going to work on “ORA-12514“.

Let’a have look on the steps which we use to resolve this issue.

Cause: “The listener received a request to establish a connection to a database or other service. 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 the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.”

Make sure you have a valid service name in your tnsnames.ora file. You can use the following command to find out valid service name.

select value from v$parameter where name='service_names';

Update your tnsnames.ora file using valid service name:




(ADDRESS = (PROTOCOL = TCP)(HOST = <validhost>)(PORT = <validport>))




(SERVICE_NAME = <service_name>)



Check TNS:

# tnsping TEST


sqlplus user@TEST

Note: If you are using client and tnsping is not working then check your client have installed that features or not. Usually, you will get the tnsping.exe file under bin folder if this features installed.

Today’s thought

Work hard, be kind, and amazing things will happen.— Conan O’Brien

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp


About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.