This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,987 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

LSNRCLT status errors

orclrunner
orclrunner Member Posts: 546
edited Oct 30, 2014 5:54PM in General Database Discussions

Oracle 11gR2

Oracle Linux 5.10

I started the Listener.

[[email protected] ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-OCT-2014 13:32:29

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

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dub-ImrORA2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dub-ImrORA2)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dub-ImrORA2.americas.epicor.net)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                29-OCT-2014 13:32:29
Uptime                    0 days 0 hr. 0 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dub-ImrORA2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dub-ImrORA2)(PORT=1521)))
The listener supports no services
The command completed successfully

The dbconsole is up and running.

[[email protected] ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://dub-ImrORA2.americas.epicor.net:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 

When I try to connect to OEM in my browser it says the Listener and dbconsole staus is unavaiable.

oem.png

When I check the status of the Listener I get errors:

[[email protected] ~]$ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-OCT-2014 13:35:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dub-ImrORA2.americas.epicor.net)(PORT=1521)))
TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed


I ran Telnet on the server and port 1521 and it is accepting connections. But I get timeout errors when trying to connect from SQLPLUS on the laptop.

Any suggestions?

Tagged:

Best Answer

  • orclrunner
    orclrunner Member Posts: 546
    Answer ✓

    I found the problem - /etc/resolv.conf file.

    Had a nameserver that is no longer available - went offline during the power outage and is not coming back.

    I pinged all of the nameservers, all but one was reachable. Once I commented out the bad nameserver eveything worked normally.

Answers

This discussion has been closed.