4 Replies Latest reply: Aug 6, 2010 2:57 AM by P.Forstmann RSS

    Oracle 10g listener service_register

    tbrinkmann
      Hi all,
      some days ago I migrate a production instance to my local workstation by using rman full backup/restore to restore some tables....
      After finish my restores I delete the instance on my workstation and from now on I have a listener behave that I don't understand.

      I created a new empty database with new listener.ora.
      By starting the listener he registered a service named like the delete production database.
      ---> 06-AUG-2010 09:22:27 * service_register * boracn * 0

      listener.ora
      -----------
      # listener.ora Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
      )
      )

      LISTENER_PCB01389 =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PCB01389.gkdruhr.de)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      )
      SUBSCRIBE_FOR_NODE_DOWN_EVENT_Listener=OFF
      ----------------------

      logfile............
      --------
      /opt/oracle/product/10.2.0/db_1/network/log/tail -f listener.log

      TNSLSNR for Linux: Version 10.2.0.5.0 - Production on 06-AUG-2010 09:22:17

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

      System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
      Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
      Trace information written to /opt/oracle/product/10.2.0/db_1/network/trace/listener.trc
      Trace level is currently 0

      Started with pid=25509
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PCB01389.gkdruhr.de)(PORT=1521)))

      TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
      06-AUG-2010 09:22:17 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=PCB01389)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870592)) * status * 0
      06-AUG-2010 09:22:27 * service_register * orastattest * 0
      06-AUG-2010 09:22:27 * service_register * boracn * 0
      No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PCB01389.gkdruhr.de)(PORT=1521)))
      06-AUG-2010 09:22:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=PCB01389)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870592)) * stop * 0
      ----
      Does anyone can tell me where the listener checkout this information. ?
      *T                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
        • 1. Re: Oracle 10g listener service_register
          Fahd.Mirza
          plz post the result of


          lsnrctl status

          lsnrctl services

          from the command prompt

          regards
          • 2. Re: Oracle 10g listener service_register
            tbrinkmann
            Re.
            the lsnrctl service... shows many the old database..
            Where does the listner get the services configuration ?
            .....thanks Till

            -------


            lsnrctl status
            LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 06-AUG-2010 09:45:52

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

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            STATUS of the LISTENER

            Alias LISTENER
            Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
            Start Date 06-AUG-2010 09:44:39
            Uptime 0 days 0 hr. 1 min. 13 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
            Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PCB01389.gkdruhr.de)(PORT=1521)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "boracn" has 1 instance(s).
            Instance "boracn", status READY, has 1 handler(s) for this service...
            Service "boracn_XPT" has 1 instance(s).
            Instance "boracn", status READY, has 1 handler(s) for this service...
            Service "orastattest" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            Service "orastattestXDB" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            Service "orastattest_XPT" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            The command completed successfully
            ---------
            lsnrctl services

            LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 06-AUG-2010 09:46:19

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

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0
            LOCAL SERVER
            Service "boracn" has 1 instance(s).
            Instance "boracn", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
            LOCAL SERVER
            Service "boracn_XPT" has 1 instance(s).
            Instance "boracn", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
            LOCAL SERVER
            Service "orastattest" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
            LOCAL SERVER
            Service "orastattestXDB" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
            DISPATCHER <machine: PCB01389, pid: 22873>
            (ADDRESS=(PROTOCOL=tcp)(HOST=PCB01389.gkdruhr.de)(PORT=5388))
            Service "orastattest_XPT" has 1 instance(s).
            Instance "orastattest", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
            LOCAL SERVER
            The command completed successfully
            --------
            • 3. Re: Oracle 10g listener service_register
              P.Forstmann
              In your case it is not the listener that is registering services for database instances but database instances registering to local listener running on same host with port 1521: that is the default behavior for a 10g database and a 10g listener and is called dynamic registration.

              It seems also that you have 2 listeners on your machine:
              - the default one named LISTENER
              - and another one defined in listener.ora named LISTENER_PCB01389

              By default running LSNRCTL will only deal with the default one.

              Edited by: P. Forstmann on 6 août 2010 09:55
              • 4. Re: Oracle 10g listener service_register
                tbrinkmann
                ohhhh body ....I'm sorry... yes you are right...a local instance of the deleted product database on my workstation was running....
                stupid dba :-)
                -----
                ps -ef | grep smon
                oracle 22611 1 0 08:12 ? 00:00:00 ora_smon_boracn
                oracle 22863 1 0 08:14 ? 00:00:00 ora_smon_orastattest
                oracle 25930 25483 0 09:55 pts/3 00:00:00 grep smon

                kill -9 22611

                sorry thanks for the help...
                *T

                Edited by: tbrinkmann on Aug 6, 2010 12:59 AM