1 Reply Latest reply: Jul 29, 2012 8:29 AM by 940856 RSS

    listener not showing the instance for informix.

    940856
      Hi All,

      I am using oracle gateway 11g and here I just discovered that the one of the database listener not showing the instance for the informix gatways, though it has already configured. whereas on other database , the listner is showing the instances for informix database. it was running fine few days back though.
      would appriciate , if you coule let me know that why it suddenly stop responding ?
      ----------------- OK Listener ----------------------------
      ptmsap> lsnrctl status LISTENER_PTMSAP
      
      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-JUL-2012 05:07:07
      
      Copyright (c) 1991, 2011, Oracle.  All rights reserved.
      
      Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=10.222.68.34)(Port=1621))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER_PTMSAP
      Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      Start Date                19-JUL-2012 10:25:25
      Uptime                    9 days 18 hr. 41 min. 41 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   /db/ptmsap11/oracle/product/11.2.0/network/admin/listener.ora
      Listener Log File         /db/ptmsap11/oracle/diag/tnslsnr/tbx4new/listener_ptmsap/alert/log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.222.68.34)(PORT=1621)))
      Services Summary...
      Service "MSCARD4" has 1 instance(s).
        Instance "MSCARD4", status UNKNOWN, has 1 handler(s) for this service...
      Service "as400" has 1 instance(s).
        Instance "as400", status UNKNOWN, has 1 handler(s) for this service...
      Service "db2test" has 1 instance(s).
        Instance "db2test", status UNKNOWN, has 1 handler(s) for this service...
      Service "ptmsap" has 1 instance(s).
        Instance "ptmsap", status UNKNOWN, has 1 handler(s) for this service...
      Service "tg4ifmx" has 1 instance(s).
        Instance "tg4ifmx", status UNKNOWN, has 1 handler(s) for this service...
      Service "tg4trai" has 1 instance(s).
        Instance "tg4trai", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully
      
      
       LISTENER_PTMSAP =
        (ADDRESS_LIST =
              (ADDRESS =
                (PROTOCOL = TCP)
                (Host = host_ip)
                (Port = 1621)
              )
        )
      SID_LIST_LISTENER_PTMSAP =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = ptmsap)
            (ORACLE_HOME = /db/ptmsap11/oracle/product/11.2.0)
            (PRESPAWN_MAX = 10)
          )
         (SID_DESC=
           (SID_NAME=tg4ifmx)
           (ORACLE_HOME=/db/ptmsap11/oracle/product/11.2.0)
           (PROGRAM=dg4ifmx)
         )
         (SID_DESC=
            (SID_NAME=tg4trai)
            (ORACLE_HOME=/db/ptmsap11/oracle/product/11.2.0)
            (PROGRAM=dg4ifmx)
           )
         (SID_DESC=
           (SID_NAME=db2test)
           (ORACLE_HOME=/db/ptmsap11/oracle/product/11.2.0)
           (PROGRAM=dg4db2)
         )
         (SID_DESC=
           (SID_NAME=as400)
           (ORACLE_HOME=/db/ptmsap11/oracle/product/11.2.0)
           (ENV="LD_LIBRARY_PATH=/db/ptmsap11/oracle/product/11.2.0/dg4db2/driver/lib:/db/ptmsap11/oracle/product/11.2.0/lib")
           (PROGRAM=dg4db2)
         )
        (SID_DESC=
          (SID_NAME=MSCARD4)
          (ORACLE_HOME=/db/ptmsap11/oracle/product/11.2.0)
          (PROGRAM=dg4odbc)
          (ENVS=LD_LIBRARY_PATH=/opt/minisoft:/db/ptmsap11/oracle/product/11.2.0)
        )
      )
      
      
      
       
      
      
      +++++++ Not OK Listener++++++++++++++++++
      
       LISTENER_SMI =
        (ADDRESS_LIST =
              (ADDRESS =
                (PROTOCOL = TCP)
                (Host = host_ip)
                (Port = 1821)
              )
        )
      SID_LIST_LISTENER_SMI =
        (SID_LIST =
           (SID_DESC=
           (SID_NAME=SMICAN)
           (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
           (ENV="LD_LIBRARY_PATH=/pdsdev/ptmqa/oracle/product/11.2.0/db/dg4db2/driver/lib:/pdsdev/ptmqa/oracle/product/11.2.0/db/lib")
           (PROGRAM=dg4db2)
         )
              (SID_DESC=
              (SID_NAME=SMIINTL)
              (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
              (ENV="LD_LIBRARY_PATH=/pdsdev/ptmqa/oracle/product/11.2.0/db/dg4db2/driver/lib:/pdsdev/ptmqa/oracle/product/11.2.0/db/lib")
              (PROGRAM=dg4db2)
              )
              (SID_DESC=
              (SID_NAME=SMIMEL)
              (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
              (ENV="LD_LIBRARY_PATH=/pdsdev/ptmqa/oracle/product/11.2.0/db/dg4db2/driver/lib:/pdsdev/ptmqa/oracle/product/11.2.0/db/lib")
              (PROGRAM=dg4db2)
              )
              (SID_DESC=
              (SID_NAME=SMIMRKTS)
              (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
              (ENV="LD_LIBRARY_PATH=/pdsdev/ptmqa/oracle/product/11.2.0/db/dg4db2/driver/lib:/pdsdev/ptmqa/oracle/product/11.2.0/db/lib")
              (PROGRAM=dg4db2)
              )
        )
       LISTENER_PTMQA11 =
        (ADDRESS_LIST =
              (ADDRESS =
                (PROTOCOL = TCP)
                (Host = host_ip)
                (Port = 1521)
              )
        )
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = ptmqa11)
            (ORACLE_HOME = /pdsdev/ptmqa/oracle/product/11.2.0/db)
            (PRESPAWN_MAX = 10)
          )
         (SID_DESC=
           (SID_NAME=tg4ifmx)
           (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
           (PROGRAM=dg4ifmx)
         )
         (SID_DESC=
            (SID_NAME=tg4trai)
            (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
            (PROGRAM=dg4ifmx)
           )
         (SID_DESC=
           (SID_NAME=db2test)
           (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
           (PROGRAM=dg4db2)
         )
         (SID_DESC=
           (SID_NAME=as400)
           (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
           (ENV="LD_LIBRARY_PATH=/pdsdev/ptmqa/oracle/product/11.2.0/db/dg4db2/driver/lib:/pdsdev/ptmqa/oracle/product/11.2.0/db/lib)
           (PROGRAM=dg4db2)
         )
        (SID_DESC=
          (SID_NAME=MSCARD4)
          (ORACLE_HOME=/pdsdev/ptmqa/oracle/product/11.2.0/db)
          (PROGRAM=dg4odbc)
          (ENVS=LD_LIBRARY_PATH=/opt/minisoft:/pdsdev/ptmqa/oracle/product/11.2.0/db)
        )
      )
      Regards

      Edited by: 937853 on Jul 29, 2012 2:10 AM