Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle VB.NET
I am getting this error when i am trying to connect to Oracle.
 
And Another error occurred when i am running my project through vb.net 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
Edited 15-Feb-13 23:51pm
v2

1 solution

Rate this: bad
good
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.
 
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.
  Permalink  
Comments
Dishant Khoyani at 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 at 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
0 OriginalGriff 319
1 _Amy 310
2 Nirav Prabtani 263
3 Sergey Alexandrovich Kryukov 210
4 Richard MacCutchan 125
0 OriginalGriff 7,889
1 Sergey Alexandrovich Kryukov 7,006
2 Maciej Los 4,014
3 Peter Leow 3,708
4 CHill60 2,762


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 16 Feb 2013
Copyright © CodeProject, 1999-2014
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