Home » RDBMS Server » Networking and Gateways » TNS-12537: TNS:connection closed on client side (oracle 9.2.0.5.0, OS centos 5.3)
TNS-12537: TNS:connection closed on client side [message #488981] Wed, 12 January 2011 10:35 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
HI friends I am getting below error while tnsping from client

C:\Program Files\Microsoft Visual Studio 9.0\VC>tnsping xpcdev

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-JAN-2011 21:35:03

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.102)(PORT = 1524))) (C
xpcdev)))
TNS-12537: TNS:connection closed


on server side listener is up also I am able to tnsping without any error.

contents from sqlnet.ora

Quote:
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10i


I am getting below error on listener log file

Quote:
12-JAN-2011 10:04:56 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied


Please help me to fix this issue

Thanks
Ridhi
Re: TNS-12537: TNS:connection closed on client side [message #488982 is a reply to message #488981] Wed, 12 January 2011 10:59 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
When was last time SQL*Net worked from client?
What changed since then?
Re: TNS-12537: TNS:connection closed on client side [message #488986 is a reply to message #488981] Wed, 12 January 2011 11:54 Go to previous messageGo to next message
John Watson
Messages: 8398
Registered: January 2010
Location: Global Village
Senior Member
I would delete the tnsnames entry, and type it in again. The output from tnsping looks as though you have some bad characters in the CONNECT_DATA section.
Re: TNS-12537: TNS:connection closed on client side [message #488989 is a reply to message #488981] Wed, 12 January 2011 13:00 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
This is a fresh installation. After installation tns ping is not working from client. Where as on server side tnsping works and i am able to log in also.

tns entry looks correct. The tns entry is
(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.102)(PORT=1524)) (CONNECT_DATA= (SID=xpcdev)))


same tns works fine on server side.

Thanks
Ridhi
Re: TNS-12537: TNS:connection closed on client side [message #488990 is a reply to message #488989] Wed, 12 January 2011 13:12 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
>(oracle 9.2.0.5.0, OS centos 5.3)
>TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-JAN-2011 21:35:03

I'm confused.
What is OS name & version of DB Server?
What is OS name & version or remote client?

>This is a fresh installation.
Fresh installation of what software on which computer system?
Re: TNS-12537: TNS:connection closed on client side [message #488991 is a reply to message #488989] Wed, 12 January 2011 13:15 Go to previous messageGo to next message
John Watson
Messages: 8398
Registered: January 2010
Location: Global Village
Senior Member
You can ignore my advice if you want. Not my problem!
Re: TNS-12537: TNS:connection closed on client side [message #488992 is a reply to message #488991] Wed, 12 January 2011 14:04 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
os of db server is centos 5.3 and db version is 9.2.0.5

I tried with two diferent clients
1. os centos 5.3 client 9.2.0.5
2. os windows xp client 10g

both the times i faced same error.

I installed oracle apps 11.5.10 on centos 5.3.

@john

I did not ignore you advice. I am extremely sorry if i have hurt you in any way.

Thanks
Ridhi
Re: TNS-12537: TNS:connection closed on client side [message #488993 is a reply to message #488992] Wed, 12 January 2011 14:09 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.

Is any type of Operating System Virtualization installed on this system.

Does any Firewall exist between client & DB Server?
Re: TNS-12537: TNS:connection closed on client side [message #488994 is a reply to message #488992] Wed, 12 January 2011 15:08 Go to previous messageGo to next message
John Watson
Messages: 8398
Registered: January 2010
Location: Global Village
Senior Member
So deleting and re-typing the tnsnames entry made no difference? tnsping returned exactly the same result as before?
I would try again, this time removing all the white spaces and definitely do NOT use copy/paste.


Re: TNS-12537: TNS:connection closed on client side [message #489074 is a reply to message #488994] Thu, 13 January 2011 03:27 Go to previous message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi John

Really your suggestion worked...

Same thing I copied last time from a mail received and now I copied from the server. Might be some junk character was there invisible.

Thanks a lot.
Previous Topic: ORA-3136 freequently in oracle db alert log file
Next Topic: Is there any limitation for number of entries in tnsnames.ora
Goto Forum:
  


Current Time: Sun Oct 25 11:18:00 CDT 2020