Solution for ORA-6413 error showing connection not open

255 pts.
Tags:
Oracle 10g
Oracle connectivity
Oracle error messages
VB.NET
vb.net,oracle 10g

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you running a 32 bit Oracle client software on a 64 bit OS ?

It seems that this error is caused by a bug. The networking layer is unable to parse program locations that contain parenthesis in the path to the executable which is attempting to connect to Oracle, and 32 bit applications are installed in locations similar to “C:\Program Files (x86)\…” on 64 bit versions of Windows.

If that is the case, there are two solutions for this:

1) Use a version of the Oracle software that contains the fix for the bug (i.e. apply the latest available patch for the Oracle software)
2) Find the location of the application that is generating the error and relocate it to a directory without any parenthesis in the path.

Hi Carlos, in my case was exactly that…. I was getting the ORA-6413 Error when I was trying to connect to Oracle from .net using the Oracle Data Provider 10.02 (32bits version)…. on windows 64bits…

After a uninstall that Oracle Data Provider 10.02 and install the newest version 11 the problem was solved.

Thank you very much for your help…

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Shaz
    Hi, By reading the two solutions for that error,i came to know my software is working on 32bit x86,while trying to install x64,its not happening,how to know directory and change the parenthesis Plz let me know as iam new to vb.net. thanking u.
    255 pointsBadges:
    report
  • Shaz
    Hi, By reading the two solutions for that error,i came to know my software is working on 32bit x86,while trying to install x64,its not happening,how to know directory and change the parenthesis Plz let me know as iam new to vb.net. Thanking u.
    255 pointsBadges:
    report
  • carlosdl
    You could try compiling your program, then moving it to some other location, for example your disk root directory, and execute it from there. If that works, you might want to uninstall Visual Studio and re-install it choosing a different location, so you can run your programs from the IDE. But I would recommend to use the latest version available for the oracle software, and apply all available patches.
    69,365 pointsBadges:
    report
  • Shaz
    [...] After a little search on the Internet, I found a question about the exact same problem I have: the question for a “Solution for ORA-6413 error showing connection not open” [...]
    0 pointsBadges:
    report
  • Zobair
    i have installed oracle xe 10g in 64 bit os.....cant access oracle from application...it shows connection not open....need solution badly......help me for this problem.....
    20 pointsBadges:
    report
  • Shaz
    [...] installed in a directory that has brackets “()” in it (you may find a description here http://itknowledgeexchange.techtarget.com/itanswers/solution-for-ora-6413-error-showinh-connection-n...). If you check BDC Meta Man may be installed at: “C:Program Files (x86)BDC Meta Man”. The [...]
    0 pointsBadges:
    report
  • Shaz
    [...] installed in a directory that has brackets “()” in it (you may find a description here http://itknowledgeexchange.techtarget.com/itanswers/solution-for-ora-6413-error-showinh-connection-n...). If you check BDC Meta Man may be installed at: “C:Program Files (x86)BDC Meta Man”. The [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following