Click here to Skip to main content
13,141,821 members (59,105 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I am getting this error when i am trying to connect to Oracle.

And Another error occurred when i am running my project through and trying to connect to oracle is :

"An error occurred creating the form. See Exception.InnerException for details. The error is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

I am getting this error number of times.
Can any one tell me the perfect solution of it ?

Please help me out ...
Thank you,
Posted 15-Feb-13 23:29pm
Updated 15-Feb-13 23:51pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

This form of the ORA-12541 error commonly happens when the database or the listener processes are in the middle of a startup, or when the database (mysid in your case) has not been registered with the listener.

Have a look at these to understand when and why such error occurs and how to handle it:
ORA-12514: TNS:listener does not currently know of service [^]
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [^]

More detail here:TNS:listener does not currently know of service requested in connect descriptor[^], it says:
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.

- 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.
Dishant Khoyani 22-Feb-13 5:41am
Mr. Sandeep i do agree with your solutions but in my oracle 10g Express edition i am getting the main error and the error is :

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

how do i resolve this ?
Sandeep Mewara 22-Feb-13 6:27am
Well, inner exception shares the main reason that you did in your question, and I shared the related links to help in resolving that.

Please try out.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170915.1 | Last Updated 16 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100