Entries in listener log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Entries in listener log

  1. #1
    Join Date
    Sep 2001
    Posts
    200
    I see these in my listener log.
    everything on the right ending in 1 is SID. What does service_ update mean.

    27-MAR-2002 15:06:32 * service_update * rman1 * 0
    27-MAR-2002 15:06:34 * service_update * build1 * 0
    27-MAR-2002 15:10:02 * (CONNECT_DATA=(SID=rman1)(CID=(PROGRAM=)(HOST=ccsp1)(USER
    =oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.99)(PORT=65481)) * establi
    sh * rman1 * 0
    27-MAR-2002 15:12:41 * service_update * cert1 * 0
    27-MAR-2002 15:15:09 * service_update * train1 * 0
    27-MAR-2002 15:16:21 * service_update * demo1 * 0
    27-MAR-2002 15:16:32 * service_update * rman1 * 0
    27-MAR-2002 15:16:35 * service_update * build1 * 0
    27-MAR-2002 15:22:41 * service_update * cert1 * 0
    27-MAR-2002 15:25:09 * service_update * train1 * 0
    27-MAR-2002 15:26:22 * service_update * demo1 * 0
    27-MAR-2002 15:26:30 * (CONNECT_DATA=(SID=demo1)(CID=(PROGRAM=)(HOST=criticalcar
    e1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.246)(PORT=33656))
    * establish * demo1 * 0
    27-MAR-2002 15:26:33 * service_update * rman1 * 0
    27-MAR-2002 15:26:35 * service_update * build1 * 0
    27-MAR-2002 15:32:42 * service_update * cert1 * 0
    27-MAR-2002 15:32:58 * log_status * 0
    27-MAR-2002 15:35:10 * service_update * train1 * 0
    clinical1:/u01/oracle/product/8.1.6/network/log$
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Try to do following:

    > lsnrctl
    >> services
    listener should show to u like :
    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    Services Summary...
    ora_sid has 2 service handler(s)
    DEDICATED SERVER established:32 refused:0
    LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
    D000
    (ADDRESS=(PROTOCOL=tcp)(HOST=hhhhhh)(PORT=1049))
    Presentation: oracle.aurora.server.SGiopServer
    The command completed successfully

    every 10 (20..) sec listener check witch services still alive and loging this information
    on listener.log

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width