Home > IT Answers > Oracle > Solution for ORA-6413 error showing connection not open
Shaz
255 pts.
 Solution for ORA-6413 error showing connection not open
ORA-6413, Oracle 10g, Oracle connectivity, Oracle error messages, VB.NET, Visual Basic .NET
vb.net,oracle 10g

Software/Hardware used:
ASKED: March 18, 2009  5:45 AM
UPDATED: November 5, 2011  6:58 PM
Answer Wiki:
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...
Last Wiki Answer Submitted:  November 5, 2011  6:58 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Shaz
 255 pts.
 

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.

Shaz
 255 pts.
 

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.

carlosdl
 63,535 pts.
 

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…..

Zobair
 20 pts.