ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

Applies to:
Oracle Net Services - Version: to - Release: 8.1.7 to 11.1
The reason of this error is mismatch in SERVICE_NAME value between Listener.ora and tnsnames.ora file.
There are two ways of registering you database with Listerner.
1.       Dynamic Registration.
2.       Static Registration.

Dynamic Resgistratioin:
Check SERVICE_NAME value by using
Sql> show parameter SERVICE_NAME;
This value will be registered with listener
$ lsnrctl services 

LSNRCTL for Solaris: Version - Production on 19-FEB-2008 11:39:26  
Copyright (c) 1991, 2004, Oracle.  All rights reserved.  


Services Summary...
Service "orcl.oracle.com" has 1 instance(s).   
  Instance "orcl", status READY, has 1 handler(s) for this service...    
      "DEDICATED" established:2 refused:0 state:ready  
         LOCAL SERVER  
The command completed successfully 
Make the value of SERVICE_NAME in tnsnames.ora same as orcl.oracle.com highlighted in yellow in listener services.
(SERVICE_NAME = orcl.oracle.com)

Static Registration:
If you are using static registration find the GLOBAL_DBNAME of database in listener.ora file and use it in your tnsnames.ora file.
So the value of SERVICE_NAME in tnsnames.ora will be same as orcl.oracle.com highlighted in yellow.
(SERVICE_NAME = orcl.oracle.com)

Now try again to connect using your corrected entry. To know more about configuring Listener.ora file Please see Quick Steps to Configure Tnsnames.ora and Listener.ora file

1 comment:

  1. I have been concentrating the bulk of my writing to business owners and stressing the importance
    of finding out about the PCI Security Standard and how advantageous it
    can be for their business. Years of development has led to these developers creating website security scanners
    that actually work. In truth, no one can accurately predict why someone will
    try hack into or infect your website.

    My web site - Relevant Website