473,837 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SOS! ORA-03114: not connected to ORACLE && MS's Bug??

ORA-03114: not connected to ORACLE && MS's Bug??

DataBase:Oracle 817
using OracleClient,ne t framework 1.1

I'm using ADO.Net in C# with Oracle 817.

and following is my public data access class.

using System.Data.Ora cleClient;
public class ComFun
{
static public IDataReader ComFun_ExeReade r(string Sql)
{
OracleConnectio n Conn=new
OracleConnectio n(Configuration Settings.AppSet tings["OracleConnecti onString"]
);
OracleCommand Cmd=new OracleCommand() ;
Cmd.CommandText =Sql;
Cmd.Connection= Conn;
Conn.Open();
OracleDataReade r
Reader=Cmd.Exec uteReader(Comma ndBehavior.Clos eConnection);
return Reader;
}

static public DataSet ComFun_ExeDatas et(string Sql)
{
OracleConnectio n Conn=new
OracleConnectio n(Configuration Settings.AppSet tings["OracleConnecti onString"]
);
OracleDataAdapt er Ad=new OracleDataAdapt er(Sql,Conn);
DataSet ds=new DataSet();
Conn.Open();
Ad.Fill(ds);
Conn.Close();
return ds;
}

static public Object ComFun_ExeScala r(string Sql)
{
OracleConnectio n Conn=new
OracleConnectio n(Configuration Settings.AppSet tings["OracleConnecti onString"]
);
OracleCommand Cmd=new OracleCommand() ;
Cmd.CommandText =Sql;
Cmd.Connection= Conn;
Conn.Open();
Object Obj=Cmd.Execute Scalar();
Conn.Close();
return Obj;
}
}
in other .cs files i always coding like this

string sql="select person_name,per son_age from person";
IDataReader Reader=ComFun.C omFun_ExeReader (sql);
DropList.DataSo urce=Reader;
DropList.DataTe xt.....="person _name";
DropList.DataBi nd();
Reader.Close(); Reader.Dispose( );
but sometimes returning the following exception "ORA-03114: not connected to
ORACLE". sometimes not.

Why?????

I find a article

http://www.dotnet247.com/247referenc...49/248580.aspx

And find this one !!!!!!!!!!!!!!
"
Michael Bachar
Hi,

I'm using ADO.Net in C# with Oracle9i Release 9.2.0.4.0
when loosing the connection with the Oracle database server the connections
doesn't recover and always returning the following exception even when the
connection has been restore:
"ORA-03114: not connected to ORACLE". I'm closing the connection properly in
that it will return to the connection pool. Here is an example code:

using(OracleCon nection conn = new OracleConnectio n(connectionStr ing))
{
conn.Open();
using(OracleCom mand cmd = new OracleCommand(s ql, conn))
{
object obj = cmd.ExecuteScal ar();
}
}

This should close the connection properly. In the MSDN it is mention that if
the connection pooler detect that the connection with the server has been
severed it will remove the connection from the connection pool. It appears
that this is not happening an I always get bad connections from the pool,
even after the connection with the database server has been restore. How can
I solve this? What is the proper way to recover from connection lost with
database server?

Thanks,
Michael.
!!!!!!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!!!!!!!!!!! !!!
Angel Saenz-Badillos[MS] (VIP)!!!!!!!!!! !
Michael,
I am sorry this one is my fault and it is a very bad
bug.!!!!!!!!!!! !!!!!!!!! The problem here
is that our pooler fails to understand that a 03114 exception means we
should not put the connection back in the pool. We have a QFE that fixes
this problem by discarding the connection in the following Oracle
exceptions. Please let me know if you know of any other exceptions that also
result in a connection no longer being valid.

oracle exceptions checked
case 18: // max sessions exceeded,
case 19: // max session licenses exceeded
case 24: // server is in single process mode
case 28: // session has been killed
case 436: // oracle isn't licensed
case 1012 //not logged on error
case 1033: // startup/shutdown in progress
case 1034: // oracle not available
case 1075: // currently logged on
case 3113: // end-of-file on communication channel
case 3114: // not connected to ORACLE
case 12154: // can't resolve service name
case 12xxx //any error starting with 12 thousand

To get the fix please contact PSS directly and request QFE 830173
"
???? Does It's MS's BUG?

And What should I Do?


Nov 16 '05 #1
0 5781

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

26
2656
sos
by: Goofy | last post by:
Hi all, i am trying to write php scripts using notepad but everytime i opened it, it automatically disappears after a few seconds. it is really frustruating. i cant write code. what can i do?
2
2081
by: Jon | last post by:
I am trying to create a 3 column template by adding a third column to my existing 2 colum one. Here'swthat I have div#mainClm{float:right;width:60%;margin:0px 10% 10% 0px;padding:0px 1% 0px 1%;border-left:dotted 1px #990000;} div#sideBar{margin:20px 0px 0px 1em;padding:0px;text-align:left;}
16
2360
by: cody | last post by:
Shouldn't if (this!=null) generate a compiler warning? in fact, it does not.
1
3243
by: Dhungu Dhumbak | last post by:
Dear All, SOS Please Help. I have a MS-SQL DB with 4 .ndf files. One (first) .ndf file is missing. somehow got deleted??. Is there any way can rebuild my DB. The .MDF and .LDF files are in tact. Please help asap. Dhumbak
31
7116
by: stéphane bard | last post by:
hello, my boss ask me to prefer windev to python. I have to argue - python work on multiple platform (linux, mac, windows) A good point but it didn't interest him. Because we want to choose a language for prototyping. So multi platform is not enough. - python and windev are fast to develop
10
2257
by: B. Williams | last post by:
I have an assignment that requires me to write a program that uses a class, a constructor, a switch, and store the records in a text file. The second requirement is to create a function called updatePower which will search through the file looking at the names and if a name is a match, will allow you to replace the integer stored for power. I have written the program and completed the first task, but I need some assistance on the secind....
161
7896
by: Peter Olcott | last post by:
According to Troelsen in "C# and the .NET Platform" "Boxing can be formally defined as the process of explicitly converting a value type into a corresponding reference type." I think that my biggest problem with this process is that the terms "value type" and "reference type" mean something entirely different than what they mean on every other platform in every other language. Normally a value type is the actual data itself stored in...
1
1865
by: Frank Rizzo | last post by:
I have an application (windows service) that in the beginning reads data rapidly into a collection of large object trees. Each object tree in the collection is about 100mb and typically there are 6-20 object trees in the collection. When the application starts and the data is being read in, I watch the memory generations via the Process Explorer (basically .NET CLR Memory perf counters). What I see is a bit confusing. Most of the...
9
4184
by: deerchao | last post by:
I'm developing a WinForms application. It slowly eats up memory, one client reported that it took 200MB or more, and finnaly crashed. I myself noticed it's common to use up 30MB memory, but if I minimize it (all the Forms will Hide, only a NotifyIcon is shown at the System Notification Area), the memory usage comes down to 8MB immediately. After that, even if I show the Forms again, it uses only 8MB memory. Do I have another way to...
6
1632
by: WT | last post by:
Hello, Using url rewritting and ajax.net, I tried to circumvent some potential problems with postback url using a code from a sample given by Scott. The idea is to use a control Adapter on htmlform to catch the attribute 'action' wich contains the url where the post will occur and replace it with a safe url. Unfortunately, it doesn't works, does something has changed with framework 3.5 used by vs2008 ? From the trace I put inside I can...
0
10877
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10626
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9402
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7806
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7001
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5670
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5849
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4474
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4041
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.