Saturday, April 13, 2013

Listener Error: TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-APR-2013 21:04:45

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

1) Remove unrequired/not configured line from listener.ora in the above error following is the line (/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora)

(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

2) run below command to reload listener.ora 

lsnrctl reload

3)run below command to start listener

lsnrctl start

4) check listener status using 

 lsnrctl status


No comments:

Post a Comment

Other Posts