2 Replies Latest reply: Jan 18, 2013 12:13 AM by Harsh_v RSS

    Get Error "* service_update * orcl * 0"  in listener.log file

    Harsh_v
      Hi all,



      I found error "* service_update * orcl * 0 ".please suggest why this issue has come and how remove it.
      [oracle@CHN-WEB-1 ~]$ tail -f /u01/app/oracle/product/10.2.0/network/log/listener.log
      18-JAN-2013 10:16:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32879)) * establish * orcl * 0
      18-JAN-2013 10:16:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32880)) * establish * orcl * 0
      18-JAN-2013 10:16:32 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlplus)(HOST=CHN-WEB-1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32884)) * establish * orcl * 0
      18-JAN-2013 10:16:34 * service_update * orcl * 0                                                                                                                                                           <==== Error
      18-JAN-2013 10:17:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32888)) * establish * orcl * 0
      18-JAN-2013 10:17:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32889)) * establish * orcl * 0
      18-JAN-2013 10:17:01 * service_update * orcl * 0                                                                                                                                                           <==== Error
      18-JAN-2013 10:17:04 * service_update * orcl * 0                                                                                                                                                           <==== Error
      18-JAN-2013 10:17:40 * service_update * orcl * 0                                                                                                                                                           <==== Error
      18-JAN-2013 10:17:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=CHN-WEB-1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
      18-JAN-2013 10:18:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22138)) * establish * orcl * 0
      18-JAN-2013 10:18:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22139)) * establish * orcl * 0
      18-JAN-2013 10:19:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22154)) * establish * orcl * 0
      18-JAN-2013 10:19:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22155)) * establish * orcl * 0
      18-JAN-2013 10:20:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22161)) * establish * orcl * 0
      18-JAN-2013 10:20:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22160)) * establish * orcl * 0
      18-JAN-2013 10:20:01 * service_update * orcl * 0                                                                                                                                                           <==== Error
      18-JAN-2013 10:20:04 * service_update * orcl * 0                                                                                                                                                           <==== Error
        • 1. Re: Get Error "* service_update * orcl * 0"  in listener.log file
          sb92075
          Harshit -{A&amp;amp;amp;gt; wrote:
          Hi all,



          I found error "* service_update * orcl * 0 ".please suggest why this issue has come and how remove it.
          [oracle@CHN-WEB-1 ~]$ tail -f /u01/app/oracle/product/10.2.0/network/log/listener.log
          18-JAN-2013 10:16:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32879)) * establish * orcl * 0
          18-JAN-2013 10:16:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32880)) * establish * orcl * 0
          18-JAN-2013 10:16:32 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlplus)(HOST=CHN-WEB-1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32884)) * establish * orcl * 0
          18-JAN-2013 10:16:34 * service_update * orcl * 0                                                                                                                                                           <==== Error
          18-JAN-2013 10:17:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32888)) * establish * orcl * 0
          18-JAN-2013 10:17:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=32889)) * establish * orcl * 0
          18-JAN-2013 10:17:01 * service_update * orcl * 0                                                                                                                                                           <==== Error
          18-JAN-2013 10:17:04 * service_update * orcl * 0                                                                                                                                                           <==== Error
          18-JAN-2013 10:17:40 * service_update * orcl * 0                                                                                                                                                           <==== Error
          18-JAN-2013 10:17:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=CHN-WEB-1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
          18-JAN-2013 10:18:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22138)) * establish * orcl * 0
          18-JAN-2013 10:18:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22139)) * establish * orcl * 0
          18-JAN-2013 10:19:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22154)) * establish * orcl * 0
          18-JAN-2013 10:19:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22155)) * establish * orcl * 0
          18-JAN-2013 10:20:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22161)) * establish * orcl * 0
          18-JAN-2013 10:20:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=sqlldr)(HOST=CHN-WEB-1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.40.8.219)(PORT=22160)) * establish * orcl * 0
          18-JAN-2013 10:20:01 * service_update * orcl * 0                                                                                                                                                           <==== Error
          18-JAN-2013 10:20:04 * service_update * orcl * 0                                                                                                                                                           <==== Error
          every database registers itself with the listener once every 60 seconds.