{"id":2677,"date":"2013-12-30T23:41:59","date_gmt":"2013-12-30T15:41:59","guid":{"rendered":"http:\/\/rmohan.com\/?p=2677"},"modified":"2013-12-30T23:43:00","modified_gmt":"2013-12-30T15:43:00","slug":"tns-12541-tns-12560-tns-00511-linux-error-111","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2677","title":{"rendered":"TNS-12541 TNS-12560 TNS-00511 Linux Error: 111"},"content":{"rendered":"<p> [oracle@localhost ~]$ lsnrctl<\/p>\n<p>LSNRCTL for Linux: Version 10.2.0.1.0 &#8211; Production on 18-JAN-2012 22:45:15<\/p>\n<p>Copyright (c) 1991, 2005, Oracle.  All rights reserved.<\/p>\n<p>Welcome to LSNRCTL, type &#8220;help&#8221; for information.<\/p>\n<p>LSNRCTL> reload<br \/>\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))<br \/>\nTNS-12541: TNS:no listener<br \/>\n TNS-12560: TNS:protocol adapter error<br \/>\n  TNS-00511: No listener<br \/>\n   Linux Error: 111: Connection refused<br \/>\nLSNRCTL> service<br \/>\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))<br \/>\nTNS-12541: TNS:no listener<br \/>\n TNS-12560: TNS:protocol adapter error<br \/>\n  TNS-00511: No listener<br \/>\n   Linux Error: 111: Connection refused<\/p>\n<p>This problem is related with IP address. To solve, just follow the following simple steps:-<\/p>\n<p>[oracle@localhost ~]$ su &#8211; root<br \/>\nPassword:<br \/>\n[root@localhost ~]# vi \/etc\/hosts        (copy &#038; paste the below line)<\/p>\n<p>127.0.0.1       localhost.localdomain   localhost<\/p>\n<p>[root@localhost ~]# su &#8211; oracle<br \/>\n[oracle@localhost ~]$ lsnrctl start<\/p>\n<p>LSNRCTL for Linux: Version 10.2.0.1.0 &#8211; Production on 18-JAN-2012 22:51:23<\/p>\n<p>Copyright (c) 1991, 2005, Oracle.  All rights reserved.<\/p>\n<p>Starting \/u01\/oracle\/product\/10.2.0\/db_1\/bin\/tnslsnr: please wait&#8230;<\/p>\n<p>TNSLSNR for Linux: Version 10.2.0.1.0 &#8211; Production<br \/>\nSystem parameter file is \/u01\/oracle\/product\/10.2.0\/db_1\/network\/admin\/listener.ora<br \/>\nLog messages written to \/u01\/oracle\/product\/10.2.0\/db_1\/network\/log\/listener.log<br \/>\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))<\/p>\n<p>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))<br \/>\nSTATUS of the LISTENER<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nAlias                     LISTENER<br \/>\nVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 &#8211; Production<br \/>\nStart Date                18-JAN-2012 22:51:24<br \/>\nUptime                    0 days 0 hr. 0 min. 0 sec<br \/>\nTrace Level               off<br \/>\nSecurity                  ON: Local OS Authentication<br \/>\nSNMP                      OFF<br \/>\nListener Parameter File   \/u01\/oracle\/product\/10.2.0\/db_1\/network\/admin\/listener.ora<br \/>\nListener Log File         \/u01\/oracle\/product\/10.2.0\/db_1\/network\/log\/listener.log<br \/>\nListening Endpoints Summary&#8230;<br \/>\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))<br \/>\nServices Summary&#8230;<br \/>\nService &#8220;PLSExtProc&#8221; has 1 instance(s).<br \/>\n  Instance &#8220;PLSExtProc&#8221;, status UNKNOWN, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;orcl&#8221; has 1 instance(s).<br \/>\n  Instance &#8220;orcl&#8221;, status UNKNOWN, has 1 handler(s) for this service&#8230;<br \/>\nThe command completed successfully<\/p>\n<p>[oracle@localhost ~]$<\/p>\n<p> HOW TO UNISTALL ORACLE COMPLETELY FROM LINUX REDHAT OR CENTOS.<br \/>\nSimply run the following commands:<\/p>\n<p>[root@localhost ~]# rm -f \/etc\/oraInst.loc<\/p>\n<p>[root@localhost ~]# rm -f \/etc\/oratab<\/p>\n<p>[root@localhost ~]# rm -R -f \/etc\/oracle <\/p>\n","protected":false},"excerpt":{"rendered":"<p> [oracle@localhost ~]$ lsnrctl<\/p>\n<p>LSNRCTL for Linux: Version 10.2.0.1.0 &#8211; Production on 18-JAN-2012 22:45:15<\/p>\n<p>Copyright (c) 1991, 2005, Oracle. All rights reserved.<\/p>\n<p>Welcome to LSNRCTL, type &#8220;help&#8221; for information.<\/p>\n<p>LSNRCTL> reload Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused LSNRCTL> service Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2677"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2677"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2677\/revisions"}],"predecessor-version":[{"id":2679,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2677\/revisions\/2679"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}