Tuesday, 22 September 2015

ORA:06413 Connection not Open


  • This blog is for those who want to connect Visual Studio with Oracle Database 10g or lower upto 9i.
  • I seen there are lots of problem while connecting the Visual Studio with the Oracle 10g and 9i.
  • I would like to share that Oracle has already left the support for the same & so as the patch for connection.
  • Then instead of using Oracle 10g or 9i client for connection with Oracle Server use the client for which Oracle Corporation use to give support. 
  • I had the same problem , all code and path variable were  checked and  were perfect. But then also Client was not connecting to oracle 10g Server.
  • Even though from SQL PLUS  it was connected. 
  • Thereafter I just uninstalled Oracle 10g client and installed Oracle 11g R2 32-bit and placed tns file in ADMIN folder of OracleHome. 
  • I checked once again from VS 2010 and VS 2012 and executed code. The server was connected. 

For any query you may comment . Yours comments would be appreciated.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How To Pass An Array As A Parameter While Calling an ASP.NET Web API C#

Please visit my C# Corner Blog for this, where I have provided better efforts to make this concept more understandable - www.c-sharpcorner....

  • Bubble Sorting Algorithm in C#
    This article will teach you how use the bubble sort algorithm in c#.  Yes, this may sometimes be asked in interview also. First of all ...
  • Host WebPage on Google Drive
    This post will show you detailed information about how to host your webpage on google drive. It's really very simple job to host a w...
  • ORA:06413 Connection not Open
    This blog is for those who want to connect Visual Studio with Oracle Database 10g or lower upto 9i. I seen there are lots of problem whi...