ASP.NET Oracle ODP connection problems

[Lea Miller]

I wonder if anyone can shed some light onto a intermittent problem I
have at the moment it is the good old ORA-03113 Error.


MESSAGE: ORA-03113: end-of-file on communication channel
DATE: 09/03/2004 09:10:24
SOURCE: Oracle Data Provider for .NET
FORM:
QUERYSTRING:
TARGETSITE: Void Page_Load(System.Object, System.EventArgs)
STACKTRACE: at IFAWeb.ChoiceMenu.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain()


How the system is connected is a Web server, with .NET Framework 1.0
connecting using ODP.NET via a Firewall and CMAN to an Oracle 9.i
database within multiple Accounts.

The connection string I use ( minus anything too relevant) is

User ID=[accountuserid];Data
Source=[DatabaseName];password=[accountPassword];Persist Security
Info=false


if anyone can help that would be great.

cheers L

 

[Paul Clement]

On 9 Mar 2004 07:32:16 -0800, (e-mail address removed) (Lea Miller) wrote:

¤ I wonder if anyone can shed some light onto a intermittent problem I
¤ have at the moment it is the good old ORA-03113 Error.
¤
¤
¤ MESSAGE: ORA-03113: end-of-file on communication channel
¤ DATE: 09/03/2004 09:10:24
¤ SOURCE: Oracle Data Provider for .NET
¤ FORM:
¤ QUERYSTRING:
¤ TARGETSITE: Void Page_Load(System.Object, System.EventArgs)
¤ STACKTRACE: at IFAWeb.ChoiceMenu.Page_Load(Object sender, EventArgs e)
¤ at System.Web.UI.Control.OnLoad(EventArgs e) at
¤ System.Web.UI.Control.LoadRecursive() at
¤ System.Web.UI.Page.ProcessRequestMain()
¤
¤
¤ How the system is connected is a Web server, with .NET Framework 1.0
¤ connecting using ODP.NET via a Firewall and CMAN to an Oracle 9.i
¤ database within multiple Accounts.
¤
¤ The connection string I use ( minus anything too relevant) is
¤
¤ User ID=[accountuserid];Data
¤ Source=[DatabaseName];password=[accountPassword];Persist Security
¤ Info=false
¤
¤
¤ if anyone can help that would be great.

You may want to check with Oracle's Metalink site (http://metalink.oracle.com/) or contact them
directly. I've seen a number of causes for this message (including limited swap space) and unless
the OLEDB, ODBC and Microsoft managed data provider Oracle work flawlessly I would expect a
configuration problem of some sort. Plus since you're using Oracle's managed provider you would
probably get better feedback there.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)