Home » SQL & PL/SQL » Client Tools » PL/SQL Developer ORA-12514:TNS:listner doesnot Problem (9)
PL/SQL Developer ORA-12514:TNS:listner doesnot Problem [message #567370] Sun, 30 September 2012 02:38 Go to next message
syamexpress
Messages: 1
Registered: September 2012
Location: india
Junior Member
I am using PL/SQL Developer.

When i am trying to login with PL/SQL Developer i am getting the error

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

How to solve this one?

Screenshot attached.
  • Attachment: error.JPG
    (Size: 36.08KB, Downloaded 136 times)
Re: PL/SQL Developer ORA-12514:TNS:listner doesnot Problem [message #567373 is a reply to message #567370] Sun, 30 September 2012 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *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 service name for a service (usually a database service)
 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.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Please search before posting, this error is asked each and every week.
Please read OraFAQ Forum Guide.

Regards
Michel
Re: PL/SQL Developer ORA-12514:TNS:listner doesnot Problem [message #567380 is a reply to message #567373] Sun, 30 September 2012 09:17 Go to previous message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
One cause of this problem is when the Oracle database is down & needs to be started.
A remote client send a request to the Listener asking to be connected to a specific service.
If/when the listener does not know anything about that service, the listener responds with ORA-12514

post results from the following two OS commands:
lsnrctl status
lsnrctl service

Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

*This line contains valuable debugging details. So post this line and surrounding lines*

for additional debugging suggestions read the URL below:
http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
Previous Topic: How to automate the scripts
Next Topic: IO Error : The Network Adapter could not establish the connection
Goto Forum:
  


Current Time: Sun Apr 20 00:41:46 CDT 2014

Total time taken to generate the page: 0.14725 seconds