Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12571: TNS:packet writer failure - Occurs only the first time

712734Mar 10 2010 — edited Mar 12 2010
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 10 2010
5 comments
2,241 views