Error 6413
Contents |
Windows, 32-bit client) Technote (troubleshooting) Problem(Abstract) When creating a data source to
Ora-06413 Connection Not Open Toad
an Oracle database on 64-bit Windows with a 32-bit Oracle ora 06413 connection not open oracle 10g client, an Oracle bug stops the connection from being successful. The following generic error message ora-06413 connection not open excel is returned by Cognos: "QE-DEF-0285 The logon failed" and "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" Symptom The
Ora 06413 Connection Not Open C#
following line should be seen within the sqlnet.log file: Fatal NI connect error 6413, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)(CID=(PROGRAM=C:\Program Files (x86)\cognos\bin\BmtMDProviderMain.exe)(HOST=host)(USER=user)))) Cause This is caused by a bug with the Oracle client. Oracle client cannot resolve third party software applications which have "special" characters in their install paths (which includes parentheses). Environment 64-bit
Ora 06413 Connection Not Open Windows 8 64 Bit
Windows, 32-bit Oracle client, installation path : Program Files (x86) Diagnosing the problem Perform a SQL Net trace to see whether the sqlnet.log file contains the error message noted above. Resolving the problem 1) Find the location of the application that is generating the error. Check the path to this location and see if it contains any parenthesis. If so, you must relocate the application to a directory without any parenthesis in the path. 2) Install patches to Oracle client install as per the link in the Related information section of this article. Related information Oracle forums Document information More support for: Cognos 8 Business Intelligence Install and Config Software version: 8.3, 8.4, 8.4.1 Operating system(s): Windows Software edition: All Editions Reference #: 1384623 Modified date: 2010-01-15 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a https://www-304.ibm.com/support/docview.wss?uid=swg21384623 minute: Sign up How to solve “ORA-6413: Connection not open.” on windows 7 up vote 1 down vote favorite I have an ASP .NET MVC 4 application whose database (Oracle 10g) is on a remote server. Now I want it to work with a local database server (on the same machine). I set up Oracle 10G Express Edition. The setup was successful http://stackoverflow.com/questions/20673782/how-to-solve-ora-6413-connection-not-open-on-windows-7 and I can access the database using SQL plus. But my application simply doesn't connect to it (Using Oracle.DataAccess.dll). I searched a lot on the internet and found out that it could be because there is a special character in the directory's path where Visual Studio 2010 is installed (Program Files (x86)). So I uninstalled it and installed it in another path with no special characters. Still the application just won't connect to the local oracle server. Just to test, I created another simple Console Application and wrote the code to connect to the local database in the Main() function and it successfully connected. The exact same code in the application doesn't work. The error that I get is: ORA-6413: Connection not open. Oracle.DataAccess.Client.OracleException was unhandled by user code Message=ORA-6413: Connection not open. Source=Oracle Data Provider for .NET DataSource="" Number=6413 Procedure="" StackTrace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open() at IBeam.Common.Repositories.SessionProvider.GetSessionFactory(String groupCode, String companyCode) in D:\Projects\IBeamNewRepo\IBeamCopy\Src\Trunk\IBeam.Common\Repositories\SessionProvider.cs:line 61 at IBeam.Common.Repositories.SessionProvider.GetSession() in D:\Projects\IBeamNewRepo\IBeamCopy\Src\Trunk\IBeam.Common\Repositories\SessionProvider.cs:line 191 at IBeam.Controllers.AccountController.Login(String url) in D:\Projects\IBeamNewRepo\IBeamCopy\Src\Trunk\IB
Unanswered Topics Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6 [Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open User Name Remember Me? Password http://p2p.wrox.com/beginning-vb-6/74214-microsoft-odbc-driver-oracle-oracle-ora-06413-connection-not-open.html Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET). Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Beginning VB 6 section of the Wrox connection not Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools connection not open Display Modes #1 (permalink) May 1st, 2009, 09:06 AM dpkbahuguna Friend of Wrox Join Date: Jan 2006 Location: Hardwar, Uttranchal, India. Posts: 180 Thanks: 1 Thanked 1 Time in 1 Post [Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open Hello Friends, i have made a program ..which is running fine but as i making the EXE of it ..and run this exe then I am getting this error.. enybody can tell me pls wht are the situations for coming such a errors. my source like: Private Sub OpenConnection() On Error GoTo lab 'CON.ConnectionString = "Provider=MSDAORA;User ID=kkb;Password=slider;Data Source=TallyNet;" CON.ConnectionString = "dsn=Mydsn;uid=XYZ;pwd=xyz" CON.CursorLocation = adUseClient CON.Open Exit Sub lab: MsgBox "Oracle Connection Couldn't be opened. (" & Err.Description & " )" End Sub its urgent.... thanks in advanced. __________________ DPK.. Last edited by dpkbahuguna; May 2nd, 2009 at 11:17 PM. #2 (permalink) May 2nd, 2009, 01:55 PM vb5prgrmr Authorized User Join Date: Mar 2009 Posts: 49 Thanks: 0 Thanked 8 Times in 8 Posts Check you connection string against what is published at http://www.connectionstrings.com/ Good Luck #3 (permalink) May 2nd, 2009, 11:19 PM dpkbahuguna Friend of Wrox Join Date: Jan 2006 Location