listener log file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: listener log file

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    listener log file

    hi

    oracle 8.1.7 - linux

    my listener log file was 200mb and so i made a backup of that listener file and deleted the listener file.

    The backup copy is there


    now when will be the new listener log file created.

    thanks in advance

    Gajanan

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: listener log file

    Originally posted by gajananpkini
    hi

    oracle 8.1.7 - linux

    my listener log file was 200mb and so i made a backup of that listener file and deleted the listener file.

    The backup copy is there


    now when will be the new listener log file created.

    thanks in advance

    Gajanan
    New file will not be created if you have used "mv" command to take back up as Oracle process writes to logfile based on the inode information rather than file name. New file will not be created as long as old file (inode) exists. So, you better use "compress" command to take back up so that new file will be created.
    -nagarjuna

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    Thanks nagarjuna

    I have not used mv command

    in linux

    i did cp listener.log listener_old.log

    and then did rm -Rf listener.log


    [oracle@ORACLEAS log]$ ls -lt
    total 481012
    -rw-r--r-- 1 oracle oinstall 491849133 Dec 19 19:45 listener_old.log

    so when will be the new log file created

  4. #4
    Join Date
    May 2001
    Posts
    736
    Stop and start the listener.

  5. #5
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Like Akhadar says, the file will be created when you stop and start the listener. In future if you want to rotate the listener log without bouncing the listener:

    Code:
    cp -p listener.log listener.log.old
    cat /dev/null > listener.log

  6. #6
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    thanks for the answer

    I cant stop and start the listener

    New listener log file is not created with enteries.

    if i do NOW cat /dev/null > listener.log

    IS THAT Ok or wait

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You don't have to stop and start the listener. Just stop the logging and turn it back on. Off the top of my head, it's something like "set logstatus off" then "set logstatus on". Check the docs.
    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."

  8. #8
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    Thanks marist

    I have executed that entry -

    [oracle@ORACLEAS log]$ lsnrctl

    LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 20-DEC-2004 04:54:18

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> set LOG_STATUS on
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    LISTENER parameter "log_status" set to ON
    The command completed successfully

    Thanks

    still no entries in that log file

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    You don't have to stop and start the listener. Just stop the logging and turn it back on. Off the top of my head, it's something like "set logstatus off" then "set logstatus on". Check the docs.
    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."

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