1 2 Previous Next 20 Replies Latest reply: Jan 24, 2014 7:15 PM by himmy RSS

    listener error

    b40c1b16-6ffd-4d0b-b97a-ac65a0416239

      [oracle@dba admin]$ cat listener.ora

      #Listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora

      # Generated by Oracle configuration tools.

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

          )

        )

      SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=orcl) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

      SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=prac) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

      SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=mac) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

       

       

      ADR_BASE_LISTENER = /u01/app/oracle

       

       

       

       

       

       

       

       

      [oracle@dba admin]$ cat tnsnames.ora

      #tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

       

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

          )

        )

       

       

      MAC =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = mac)

          )

        )

       

       

      PRAC =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = prac)

          )

        )

       

       

       

       

       

       

       

       

       

       

       

       

      [oracle@dba admin]$ lsnrctl start listener

       

       

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-JAN-2014 12:41:48

       

       

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

       

       

      Starting /u01/app/oracle/product/11.2.0/dbhome_2/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/dbhome_2/network/admin/listener.ora

      Log messages written to /u01/app/oracle/diag/tnslsnr/dba/listener/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dba.oracle.com)(PORT=1521)))

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dba.oracle.com)(PORT=1521)))

      STATUS of the LISTENER

      ------------------------

      Alias                     listener

      Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      Start Date                24-JAN-2014 12:41:48

      Uptime                    0 days 0 hr. 0 min. 0 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora

      Listener Log File         /u01/app/oracle/diag/tnslsnr/dba/listener/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dba.oracle.com)(PORT=1521)))

      Services Summary...

      Service "mac" has 1 instance(s).

        Instance "mac", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully

       

       

       

       

       

       

       

       

      [oracle@dba admin]$ lsnrctl status listener

       

       

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-JAN-2014 12:42:19

       

       

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

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dba.oracle.com)(PORT=1521)))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

        TNS-00511: No listener

         Linux Error: 111: Connection refused

        1 2 Previous Next