OraFAQ Forum: Networking and Gateways » TNS-12537: TNS:connection closed on client side

Home » RDBMS Server » Networking and Gateways » TNS-12537: TNS:connection closed on client side (oracle 9.2.0.5.0, OS centos 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-12537: TNS:connection closed on client side [message #488981]

Wed, 12 January 2011 10:35

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

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488982 is a reply to message #488981]

Wed, 12 January 2011 10:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When was last time SQL*Net worked from client?
What changed since then?

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488986 is a reply to message #488981]

Wed, 12 January 2011 11:54

John Watson
Messages: 8964
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.

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488989 is a reply to message #488981]

Wed, 12 January 2011 13:00

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

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488990 is a reply to message #488989]

Wed, 12 January 2011 13:12

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488991 is a reply to message #488989]

Wed, 12 January 2011 13:15

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You can ignore my advice if you want. Not my problem!

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488992 is a reply to message #488991]

Wed, 12 January 2011 14:04

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

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488993 is a reply to message #488992]

Wed, 12 January 2011 14:09

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #488994 is a reply to message #488992]

Wed, 12 January 2011 15:08

John Watson
Messages: 8964
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.

Report message to a moderator

Re: TNS-12537: TNS:connection closed on client side [message #489074 is a reply to message #488994]

Thu, 13 January 2011 03:27

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:39:27 CST 2025