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

Home » RDBMS Server » Networking and Gateways » TNS-12537 TNS:connection closed (11.2.0.3, Windows 2008 R2)

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

TNS-12537 TNS:connection closed [message #597196]

Tue, 01 October 2013 09:43

ramamosn
Messages: 7
Registered: August 2013

Junior Member

I am getting the error TNS-12537. In the SQLnet.ora file, if no IP Address is listed everything works fine and the listener starts without any issue. But one of the Security requirements we have is, we need to list all the client IP address on the SQLNet.ora file. I checked the Windows Firewall services and it is disabled.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

M:\>tnsping proditg

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-
013 10:31:14

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

Used parameter files:
C:\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MCDBFOC
SPROD.global.corp)(PORT = 34433)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
ME = PRODITG)))
OK (30 msec)

M:\>lsnrctl status proditg

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-2013 10:3
:21

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MCDBFOCUSPROD.global.corp
(PORT=34433)))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

Hope someone can help me on this.

Thanks,
ramamosn

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597198 is a reply to message #597196]

Tue, 01 October 2013 09:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Why are you using non-default listener (LISTENER_PRODITG)?

No listener.ora file is required to start or use Oracle listener.
move, remove, rename, delete or otherwise eliminate listener.ora file then do as below

lsnrctl start
lsnrctl status
# wait 60+ seconds below proceeding
lsnrctl service

COPY the results from above then PASTE all back here

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597219 is a reply to message #597196]

Tue, 01 October 2013 12:29

ramamosn
Messages: 7
Registered: August 2013

Junior Member

Thank you for your reply.
I deleted the listener.ora from the path and now I am getting the same error TNS-12537.

M:\>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-2013 13:25
:56

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Log messages written to C:\Oracle\diag\tnslsnr\MCDBFOCUSPROD\listener\alert\log.
xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MCDBFOCUSPROD.global.corp)
(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-2013 13:26
:16

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>lsnrctl services

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-2013 13:26
:22

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597220 is a reply to message #597219]

Tue, 01 October 2013 12:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

these error are symptomatic of OS/Networking mis-configuration.

does hostname resolve to correct & valid IP#?

open Command Window & issue OS commands below

hostname
ping MCDBFOCUSPROD.global.corp
ping MCDBFOCUSPROD

COPY the results from above then PASTE all back here

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597221 is a reply to message #597220]

Tue, 01 October 2013 12:54

ramamosn
Messages: 7
Registered: August 2013

Junior Member

Thanks again for the quick reply.

M:\>hostname
MCDBFOCUSPROD

M:\>ping MCDBFOCUSPROD.global.corp

Pinging MCDBFOCUSPROD.global.corp [fe80::492e:f97a:25c3:8835%13] with 32 bytes of
data:
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms

Ping statistics for fe80::492e:f97a:25c3:8835%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

M:\>ping MCDBFOCUSPROD

Pinging MCDBFOCUSPROD.global.corp [fe80::492e:f97a:25c3:8835%13] with 32 bytes of
data:
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms
Reply from fe80::492e:f97a:25c3:8835%13: time<1ms

Ping statistics for fe80::492e:f97a:25c3:8835%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597223 is a reply to message #597221]

Tue, 01 October 2013 12:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Hmmm, above looks OK.
Are OS Services for both the listener & the database started & running now?

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597268 is a reply to message #597223]

Wed, 02 October 2013 07:20

ramamosn
Messages: 7
Registered: August 2013

Junior Member

Both the Oracle Services and listener started.

TNSnames.ora
PRODITG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MCDBFOCUSPROD.global.corp)(PORT = 34433))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRODITG)
)
)

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

M:\>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:09
:26

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb11g_home1TNSListener>, error 1060.
TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Log messages written to C:\Oracle\diag\tnslsnr\MCDBFOCUSPROD\listener\alert\log.
xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MCDBFOCUSPROD.global.corp)
(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:09
:45

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>lsnrctl services

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:09
:50

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597269 is a reply to message #597268]

Wed, 02 October 2013 07:35

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

M:\>lsnrctl start

You must execute this on MCDBFOCUSPROD.global.corp and with ORACLE_HOME and PATH set for with the listener home.

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597270 is a reply to message #597269]

Wed, 02 October 2013 08:01

ramamosn
Messages: 7
Registered: August 2013

Junior Member

Sorry to bother you. I am still getting error.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

M:\>SET ORACLE_HOME
ORACLE_HOME=C:\Oracle\product\11.2.0\dbhome_1

M:\>SET PATH
Path=C:\Oracle\product\11.2.0\dbhome_1\bin;C:\Oracle\product\11.2.0\dbhome_1\Net
work\Admin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\Sys
tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

M:\>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:57
:27

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Service OracleOraDb11g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

M:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:57
:36

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>
M:\>lsnrctl services

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 02-OCT-2013 08:58
:30

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed

M:\>

Report message to a moderator

Re: TNS-12537 TNS:connection closed [message #597272 is a reply to message #597270]

Wed, 02 October 2013 08:13

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Stop it, stop the service and restart it.

Report message to a moderator

Previous Topic:	not able to start lsnrctl
Next Topic:	Oracle Database question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:26:38 CDT 2025