ORA-12571: TNS:packet writer failure - Occurs only the first time
712734Mar 10 2010 — edited Mar 12 2010Hi
We are using Oracle 9i database for an ASP.NET 2.0 application . ODP.NET (9.2.0.401) is used to connect to the Oracle DB.
The application is load balanced between two web servers. Web servers are Windows 2003 servers with SP2 , IIS V 6.0
I get the following error when i access the application using the load balanced url for the first time.
I get this ORA-12571: TNS:packet writer failure error only for the first time when i access the application using the url. It works fine if i access the SAME url after that.
An error has occurred in page http://Loadbalancedurl/AppName/Main.aspx
Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.main_mainscrn_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Oracle.DataAccess.Client.OracleException ORA-12571: TNS:packet writer failure at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
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)
How to solve TNS:packet writer failure that occurs while connecting to Oracle DB?
Thanks
Ashok