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:
TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <validhost>)(PORT = <validport>)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <service_name>) ) )
Check TNS:
# tnsping TEST or 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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
