[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


ORA-12537: TNS:connection closed exception with ASP.NET

Posted on 2009-12-22
Medium Priority
Last Modified: 2012-05-08
i am getting this weired error, I am using SQLDataSource. I am getting this error somertimes only.
ORA-12537: TNS:connection closed
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-12537: TNS:connection closed

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OracleException (0x80131938): ORA-12537: TNS:connection closed
   System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +190
   System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +988
   System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) +25
   System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) +138
   System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +19
   DevExpress.Web.ASPxClasses.Internal.DataHelper.PerformSelect() +149
   DevExpress.Web.ASPxGridView.GridViewDataHelper.PerformSelect() +119
   DevExpress.Web.ASPxClasses.Internal.DataContainer.PerformSelect() +112
   DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.DataBindCore() +15
   DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.DataBind() +104
   DevExpress.Web.ASPxGridView.ASPxGridView.DataBind() +248
   DevExpress.Web.ASPxClasses.Internal.DataHelperBase.EnsureDataBound(Boolean ensureChildControls) +89
   DevExpress.Web.ASPxClasses.Internal.DataContainer.EnsureDataBound() +120
   DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.OnPreRender(EventArgs e) +22
   System.Web.UI.Control.PreRenderRecursiveInternal() +80
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842
Why it is failing sometimes only.
Question by:jyothsna1803
  • 3
  • 2
LVL 12

Expert Comment

ID: 26105903
This could be due to a variety of reasons...Has anything changed with respect to the configuration of the oracle server??

Do check the below link and see whether any of the reasons is related to your case..

LVL 12

Expert Comment

ID: 26105933
Please check this also...Is it happening from the same client machine or different machines???


Author Comment

ID: 26106607
it is happening with few pages only. So i am not sure exactly what is the problem.
That to it is happening sporadically. Seems it is happening with DEVX Grid, not sure.. It is happening on the server and i don't see this issue in Development.
LVL 12

Accepted Solution

Pra4444 earned 1500 total points
ID: 26106635
Is it happening from any client machines??? Has there been any recent changes to the sqlnet.ora file?? Whats the version of database you are running???

Author Closing Comment

ID: 31669026
This is a server issue.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question