Ora Error 6413
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ora-06413 connection not open toad and policies of this site About Us Learn more about Stack Overflow ora 06413 connection not open oracle 10g the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation ora-06413 connection not open excel Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it ora-06413 connection not open in pl sql developer only takes a 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
Ora 06413 Connection Not Open C#
Edition. The setup was successful 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:l
Windows OS ORA-12154 ORA-6413 Oracle Windows 64 bit (x86) Technote (troubleshooting) Problem(Abstract) ORA-12154 or ORA-6413 error when attempting
Ora-06413 Connection Not Open Windows 8 64 Bit
to connect with 32-bit Oracle client on 64-bit Windows OS Cause Third ora-06413 connection not open visual studio Party (non-IBM) bug in Oracle client product. More Information: Cognos application is installed in path that contains ora-06413 microsoft odbc for oracle parenthesis (e.g. "C:\Program Files (x86)\..." . This is a known Oracle product issue bug #3807408. Please check http://forums.oracle.com/forums/thread.jspa?messageID=3455198 Environment Cognos software has been installed in a folder name which http://stackoverflow.com/questions/20673782/how-to-solve-ora-6413-connection-not-open-on-windows-7 contains brackets (e.g. "C:\Program Files (x86)\...) Typically this is most likely to be Windows 64-bit. Resolving the problem Solution 1: Upgrade/patch Oracle client software (located on the Cognos application server) to a version which contains the fix for Bug 3807408. TIP: At the time of writing this Technote, the following patches have been released on Windows: Windows http://www.ibm.com/support/docview.wss?uid=swg21370380 32-bit 9.2.0.7.0 Patch 6: Apply Patch 4928723 or later 10.2.0.1.0 Patch 4: Apply Patch 4923768 or later 10.2.0.2.0 Patch 5: Apply Patch 5383042 or later 10.2.0.3.0: Apply Patch 5337014 or later Windows 64-bit AMD64 and INTEL EM64T 10.2.0.1.0 Patch 4: Apply Patch 4923787 or later 10.2.0.2.0 Patch 5: Apply Patch 5388871 or later 10.2.0.3.0: Apply Patch 5337014 or later For all other versions on Windows please use SOLUTION 2 for now. Solution 2: Uninstall the Cognos product, and re-install in a location whose path does not contain a parenthesis. Related information THIRD PARTY - Oracle forum Thread - TOAD CONNECT PROBLE THIRD PARTY - Oracle Document 334528.1 1595127 - Controller cannot connect to Oracle database Document information More support for: Cognos Business Intelligence Install and Config Software version: 8.3, 8.4 Operating system(s): Windows Software edition: All Editions Reference #: 1370380 Modified date: 16 May 2012 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 Terms of use Accessibility
.NET Framework > Visual C# Question 0 Sign in to vote Dear All, I had encountered the following error code https://social.msdn.microsoft.com/Forums/vstudio/en-US/d578dfe3-5bc3-4bce-9b9e-85b2e9d2f5de/ora06413-connection-not-open?forum=csharpgeneral ex.Message = "ERROR [HY000] [Oracle][ODBC][Ora]ORA-06413: Connection not open.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [HY000] [Oracle][ODBC][Ora]ORA-06413: Connection not open. while running the code as below : try https://www.experts-exchange.com/questions/27542729/Windows-7-x64-Oracle-ODBC-Connection-Error.html { // Build a connection and SQL strings
string connectionString = @"DSN=EDC;UID=afpduser;PWD=afpduser;Integrated Security=no;"; // SQL String // Create connection object OdbcConnection conn = new OdbcConnection(connectionString); // Create command connection not object OdbcCommand cmd = new OdbcCommand(SQL); cmd.Connection = conn; // Open connection conn.Open(); // Call command's ExecuteReader OdbcDataReader reader = cmd.ExecuteReader(); // Read the reader and display results on the console string data = null; string result; while (reader.Read()) { data = ""; for (int i = 0; i < 20; i++) { if (reader.IsDBNull(i) == false) connection not open { result = reader.GetValue(i).ToString(); } else { result = "null"; } data = data + "'" + result + "', "; } data = data.Substring(0, data.Length - 2); SaveToAccessLotBased(data, eqpType); } // close reader and connection reader.Close(); conn.Close(); } catch (OdbcException ex) { myLog.WriteEntry("ODBCException Error 2: " + ex.Message + " " +DateTime.Now.ToString()); } } I had created the data source EDC using Oracle ODBC Driver and disable MTS Support. But I am still not able to resolve the problem. Can anyone please help ? I heard that there is another way of using dsnless connection to oracle. May I know how to do it ? Thanks Friday, February 17, 2006 9:49 AM Reply | Quote Answers 1 Sign in to vote Error: ORA 6413 Text: Connection not open.------------------------------------------------------------Cause: Unable to establish connection.Action: Use diagnostic procedures to ascertain exact problem.Solution Description--------------------You are starting the application from a directory with a special character in the name.A simple testcase:create a directory c:test(4)copy odbctst.exe to this directory and start it fromfor Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Windows 7 x64 Oracle ODBC Connection Error Want to Advertise Here? Solved Windows 7 x64 Oracle ODBC Connection Error Posted on 2012-01-18 Oracle Database Windows 7 2 Verified Solutions 7 Comments 6,399 Views Last Modified: 2012-06-27 I am trying to get some of my programs to work with my Windows 7 x64 computer. I have installed the oracle x32 driver and found out that I need to setup the driver on the x32 ODBC. Everything is working fine with the setup...when I test the connection it works. When I run one of my programs and it tries to connection to the Oracle server, I get the following error: Run-time error '-2147467259 (80004005)': [Oracle][ODBC][Ora]ORA-06413: Connection not open. Then if you go to the logs it says this: *********************************************************************** Fatal NI connect error 6413, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=PROD)(CID=(PROGRAM=C:\Program Files (x86)\Order_Tracker\Order_Tracker.exe)(HOST=JCONRAD04)(USER=jconrad)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.0.49)(PORT=1521))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.1.0.5.0 - Production Time: 18-JAN-2012 10:15:09 Tracing not turned on. Any ideas on how to fix the error? 0 Question by:itadminnek Facebook Twitter LinkedIn Google LVL 76 Active today Best Solution byslightwv (䄆 Netminder) Might I suggest the Instant Client with the ODBC add-on: http://www.oracle.com/technetwork/topics/winsoft-085727.html Go to Solution 7 Comments LVL 76 Overall: Level 76 Oracle Database 74 Windows 7 4 Message Active today Assisted Solution by:slightwv (䄆 Netminder)2012-01-18 The following is related to a different driver but I bet it is the same issue since 10.1 is an old driver. Try a newer Oracle ODBC driver. http://kb.globalscape.com/