Web Server IIS Oracle Error

Netsol-NOS
Netsol-NOS used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
jtriftsMI and Automation

Commented:
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?

Author

Commented:
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
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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.

Author

Commented:
Dear Slightwv,

Let me check and will get back to you today.

THanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial