Home » Server Options » RAC & Failsafe » listener is down: TNS-12543: TNS:destination host unreachable (Oracle 11.2.0.4.1,linux 2.6)
listener is down: TNS-12543: TNS:destination host unreachable [message #619625] Wed, 23 July 2014 14:32 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi ,

I found the following in grid control.
The listener is down: TNS-12543: TNS:destination host unreachable .

listener name is LISTENER_SCAN1

usir01.com:POSTIDF2:/home/oracle>ps -ef|grep lsnr
oracle     730 24924  0 22:24 pts/1    00:00:00 grep lsnr
oracle    7754     1  0 18:38 ?        00:00:00 /opt/app/oracle/db11/bin/tnslsnr LSNADMIN -inherit
oracle    7756     1  0 18:38 ?        00:00:03 /opt/app/oracle_grid/product/11.2.0.4/bin/tnslsnr LSNRMAN -inherit
oracle    7809     1  0 18:38 ?        00:00:00 /opt/app/oracle_grid/product/11.2.0.4/bin/tnslsnr LISTENER -inherit
oracle    7866     1  0 18:38 ?        00:00:01 /opt/app/oracle_grid/product/11.2.0.4/bin/tnslsnr LISTENER_SCAN1 -inherit


usir01.com:PA0001C:/home/oracle>lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JUL-2014 22:25:09

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

TNS-01101: Could not find service name LISTENER_SCAN1


usir01.com:PA0001C:/home/oracle>lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JUL-2014 22:25:36

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LSNADMIN
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                23-JUL-2014 18:38:34
Uptime                    0 days 3 hr. 47 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/app/oracle/db11/network/admin/listener.ora
Listener Log File         /opt/app/oracle/db11/log/diag/tnslsnr/usir01/lsnadmin/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.189.76.60)(PORT=1527)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.176.204.60)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.176.204.61)(PORT=1521)))
Services Summary...
Service "BA0001C" has 1 instance(s).
  Instance "BA0001C", status UNKNOWN, has 1 handler(s) for this service...
Service "PA0001C" has 1 instance(s).
  Instance "PA0001C", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
usir01.com:


Can you help me to fix this error?

Regards,
Srini

[Updated on: Wed, 23 July 2014 14:32]

Report message to a moderator

Re: listener is down: TNS-12543: TNS:destination host unreachable [message #619631 is a reply to message #619625] Wed, 23 July 2014 15:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have messed up your listening configuration by running listeners off both the RDBMS home and the GI home. If you do not know what you are doing, that is a bad idea. You need to decide what node listeners and how many SCAN listeners you want to run (probably three SCAN listeners and one node listener per node) and off what home you want to run them (probably all off the GI home) and whether to place them under GI control (probably a good idea) and configure accordingly.
Re: listener is down: TNS-12543: TNS:destination host unreachable [message #619634 is a reply to message #619631] Wed, 23 July 2014 15:08 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi John,

Now what should i do to resolve this listerner error?

Regards,
Srini
Re: listener is down: TNS-12543: TNS:destination host unreachable [message #619636 is a reply to message #619634] Wed, 23 July 2014 15:11 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have messed up your listener configuration, and need to document what you actually want.

Apart from that, I do not know what error you have. You have not said that anyone is having problems connecting, so presumably no error at all. Some odd message in Grid Control is not an "error", you know.
Re: listener is down: TNS-12543: TNS:destination host unreachable [message #619646 is a reply to message #619636] Wed, 23 July 2014 17:29 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thanks John for your suggestion.I will check if anyone is facing this error in application or databases side
if not i will consider to be a false alert.

Regards,
Srini

[Updated on: Wed, 23 July 2014 17:31]

Report message to a moderator

Previous Topic: Drop database in standalone database
Next Topic: Drop RAC database
Goto Forum:
  


Current Time: Fri Mar 29 08:43:07 CDT 2024