This discussion is archived
2 Replies Latest reply: Jan 17, 2013 10:13 PM by Harsh_v RSS

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

Harsh_v Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points