jump to navigation

ORA-12537 TNS Connection Closed March 14, 2007

Posted by Muhammad Habib in Oracle Financials.

When i was trying to connect forms and reports builder to my Financials Server (Oracle Applications), i was getting the following error: ORA-12537.

I tried hard to resolve it, searched from google but could not succeed. Finally i analyzed that this parameter

tcp.validnode_checking = yes

in my sqlnet.ora file at the path:


was creating problem.

I commented this parameter by adding # sign at the start of this parameter. Now this parameter looks like this:

#tcp.validnode_checking = yes

Problem resolved.



1. John - March 15, 2007

Thanks Mr. Habib. my problem is also solved by your solution

2. Baksaki - April 26, 2007

Sehr beeindruckt, deinen Platz, Unterhaltfunktion surfend

3. Chandra Prakash - August 18, 2007

Thank Mr. Habib for your solution

4. roel pascual - November 17, 2007

thanks for the solution mr. habib

5. Biju Radhakrishnan - November 28, 2007


Thanks for the posting. We faced the same issue and tried your solution. But it dint work. Could you please confirm if we need to restart the Listner after making this change.


6. Muhammad Habib - November 28, 2007

There is no need i think. but if u still face this problem then rather restarting the listener, restart your system


7. Saima Ansari - March 17, 2008

i have restart the listener but the issue is still remain the same.Please privide me solution for that

8. Amir - March 28, 2008

Thanks for your postings. it’s the second time i get the right solution from your site. the first time was when I was installing the Oracle E-Business suite.
Hope I can participate in solving others’ problem soon.


9. Muhammad Habib - March 28, 2008

Thanks Amir

I need your prayers.


10. syafiq - March 1, 2010

how at oracle 8?

11. Akshaya - February 3, 2012

This problem sometimes occurred if the processes in init.ora are not sufficient specially in EBS arena.
Please increase the processes and set the sessions as twice the number of processes.
This requires a complete bounce of the whole instance.


12. Linnea - April 23, 2014

Last week I dreamed about a giant pan filled with bacon and there was clearly
a little kid sitting in the midst of it, eating it.

13. www.nowoczesne.waw.pl - October 19, 2014

Hi there, I would like to subscribe for this webpage to get most up-to-date updates,
therefore where can i do it please assist.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: