LISTENER LOG
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: LISTENER LOG

  1. #1
    Join Date
    Sep 2001
    Posts
    200
    I have PATROL that monitors some features on my database. It is creating a listener log almost every minute and its now in hundreds of megs.
    Questions;
    1/ Can I remove the listener.log (as you can you with the alert.SID.log) and it would generate a new one once needed?
    2/ should I re-direct the listener log location from within listener.ora file? Which is the better option. I would prfer the first but what do you think? Or is there a third?
    Thanks

    24-MAR-2002 03:36:17 * service_register * prod2 * 0
    24-MAR-2002 03:36:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ccsp2)(USER=ora
    OMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135290880)) * stat
    24-MAR-2002 03:37:39 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48588)) *
    ish * prod2 * 0
    24-MAR-2002 03:37:40 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48589)) *
    ish * prod2 * 0
    24-MAR-2002 03:38:01 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48596)) *
    ish * prod2 * 0
    24-MAR-2002 03:38:02 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48597)) *
    ish * prod2 * 0
    24-MAR-2002 03:38:03 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48598)) *
    ish * prod2 * 0
    24-MAR-2002 03:38:04 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    =patrol))) * (ADDRESS=(PROTOCOL=tcp)(HOST=134.192.240.101)(PORT=48600)) *
    ish * prod2 * 0
    24-MAR-2002 03:38:05 * (CONNECT_DATA=(SID=prod2)(CID=(PROGRAM=)(HOST=ccsp
    listener.log (2%)
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    The best option is:

    Stop the listener
    Drop,move or that you want the listener.log file
    Start the listener --> Oracle will generate a new one

    By this, the users are relative not affected, because only new connection will have problems.

    Cheers

    Angel

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If you don't want to interupt the listener process, you can use the following method.

    > lsnrctl set log_status off

    delete the log

    > lsnrctl set log_status on

    This will remove the file without having to stop/start the listener

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jan 2002
    Posts
    148
    Code:
    1/ Can I remove the listener.log (as you can you with the alert.SID.log) and it would generate a new one once needed?
    YES.

    Code:
    2/ should I re-direct the listener log location from within listener.ora file? Which is the better option. I would prfer the first but what do you think?
    Depends on situation.
    You can always change the log file directory by setting
    LOG_DIRECTORY in the listener.ora file.
    You can also change the LOG_DIRECTORY value dynamically using lsnrctl utility.
    Alway prefer LSNRCTL reload ( where ever applicable ) - this will not down the listener.

    Jr.


  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by jovery
    If you don't want to interupt the listener process, you can use the following method.

    > lsnrctl set log_status off

    delete the log

    > lsnrctl set log_status on

    This will remove the file without having to stop/start the listener

    Regards
    Very good remark Jim. I didnīt know this command. It doesn't appear with help in lsnrctl.

    Regards

    Angel

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Jr

    1/ Can I remove the listener.log (as you can you with the alert.SID.log) and it would generate a new one once needed?
    YES.
    Ah, kind of yes, kind of no.

    If you are on some Unix platforms, the listener will keep writing to the listener.log even though it is deleted. It will not generate a new listener.log until you bounce the listener.

    This is different than the alert.log in that the alert.log will generate a new file as soon as it needs to write something.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Sep 2001
    Posts
    200
    A million thanks to all of you out there.
    Life is what is happening today while you were planning tomorrow.

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