Home » RDBMS Server » Networking and Gateways » TNS-12537 TNS:connection closed (11.2.0.3, Windows 2008 R2)
TNS-12537 TNS:connection closed [message #597196] Tue, 01 October 2013 09:43 Go to next message
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
Re: TNS-12537 TNS:connection closed [message #597198 is a reply to message #597196] Tue, 01 October 2013 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
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
Re: TNS-12537 TNS:connection closed [message #597219 is a reply to message #597196] Tue, 01 October 2013 12:29 Go to previous messageGo to next message
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


Re: TNS-12537 TNS:connection closed [message #597220 is a reply to message #597219] Tue, 01 October 2013 12:48 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
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

Re: TNS-12537 TNS:connection closed [message #597221 is a reply to message #597220] Tue, 01 October 2013 12:54 Go to previous messageGo to next message
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

Re: TNS-12537 TNS:connection closed [message #597223 is a reply to message #597221] Tue, 01 October 2013 12:55 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
Hmmm, above looks OK.
Are OS Services for both the listener & the database started & running now?
Re: TNS-12537 TNS:connection closed [message #597268 is a reply to message #597223] Wed, 02 October 2013 07:20 Go to previous messageGo to next message
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

icon4.gif  Re: TNS-12537 TNS:connection closed [message #597269 is a reply to message #597268] Wed, 02 October 2013 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
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.



Re: TNS-12537 TNS:connection closed [message #597270 is a reply to message #597269] Wed, 02 October 2013 08:01 Go to previous messageGo to next message
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:\>
icon2.gif  Re: TNS-12537 TNS:connection closed [message #597272 is a reply to message #597270] Wed, 02 October 2013 08:13 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Stop it, stop the service and restart it.

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


Current Time: Fri Oct 24 22:54:54 CDT 2014

Total time taken to generate the page: 0.10633 seconds