Link to home
Start Free TrialLog in
Avatar of Netsol-NOS
Netsol-NOS

asked on

Web Server IIS Oracle Error

Dear EE,

My Web server stuck and i restarted it. In event log below is the error i see.

1.      Message : ORA-03113: end-of-file on communication channel

Details:
Message: HandlingInstanceID: 12d6bbb6-8560-4a7d-9eb7-2a5ea0adfdd0
An exception of type 'Oracle.DataAccess.Client.OracleException' occurred and was caught.
----------------------------------------------------------------------------------------
10/16/2019 09:13:18
Type : Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342
Message : ORA-03113: end-of-file on communication channel
Process ID: 144215
Session ID: 554 Serial number: 15831
Source : Oracle Data Provider for .NET
Help link :
Errors : Oracle.DataAccess.Client.OracleErrorCollection
DataSource : NETSOLprod
Procedure : PAC_SER_ChangePOSStatus
Number : 3113
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean)
HResult : -2147467259
Stack Trace :    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
   at Pac.Persistence.Components.SNFService.ChangePOSStatusPO.ChangePOSStatus(String appNum, String status_cde, String Comment, String status_Type, IDbConnection connection)

2.      Message : Connection request timed out

Details:
Message: HandlingInstanceID: 256f2d64-e69d-43c7-82c8-eed1aab25b61
An exception of type 'Oracle.DataAccess.Client.OracleException' occurred and was caught.
----------------------------------------------------------------------------------------
10/16/2019 09:39:38
Type : Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342
Message : Connection request timed out
Source : Oracle Data Provider for .NET
Help link :
Errors : Oracle.DataAccess.Client.OracleErrorCollection
DataSource :
Procedure :
Number : -1000
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean)
HResult : -2147467259
Stack Trace :    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
   at Oracle.DataAccess.Client.OracleConnection.Open()
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at Pac.Persistence.Components.SNFService.SNFServicePO.ReadPOSPrivilages(String userName, IDbConnection connection)



Can you please help me, why this error occurs.

Thanks
Avatar of jtrifts
jtrifts
Flag of United Kingdom of Great Britain and Northern Ireland image
Message : Connection request timed out.

This is the cause of the failure.

Is this a new piece of code which fails or an existing piece of code which once worked, but now fails?
Avatar of Netsol-NOS
Netsol-NOS

ASKER

Dear Jtrifts,

Thanks for your quick reply.
We have identified that the cause of the failure is Connection request timed out.

But my question is why this happens.

DB server is fine. = Because there are two applications connected with the same DB, if somethings happens with DB both applications get disturbed. But here in my case, only IIS server (which is one of the two application) got this error.

Thanks
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)
99% of the time a connection timeout is caused by a firewall blocking the connection.  Since another app is connecting fine, I'm guessing this is not the issue.

The error number 1000 is number of open cursors exceeded not the normal timeout error number.  Check the app code to make sure it is properly disposing of objects.  The DBA should be able to monitor at the database level to see if this is the issue.

The first error a 3113 is next to impossible to troubleshoot.  It is a generic error that is usually something in the network dropping the connection.
Avatar of Netsol-NOS
Netsol-NOS

ASKER

Dear Slightwv,

Let me check and will get back to you today.

THanks
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.