Re: listner.log cannot be generated

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 13 Feb 2001 13:28:31 -0800
Message-ID: <F001.002B3209.20010213133443@fatcity.com>

Under this scenrio when listener is up them removing lines is a better choice to clean log file.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 13 Feb 2001 13:01:22 -0800

I think, you removed the listener log file while the listener is up and running. When you removed the listener log, listener was having a file pointer open. Since the file pointer is not closed, the listener is still writing to the same node.

If you stop and start the listener, you would see the log file.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
"These are my opinions and usual disclaimers apply"

                     exu_at_nnng.com
                     Sent by:             To:     Multiple recipients of 
list ORACLE-L <ORACLE-L_at_fatcity.com>
                     root_at_fatcity.        cc:
                     com                  Subject:     listner.log cannot be

generated

Hi list,

About a month ago, I moved and compressed listener.log file to a different directory because
this file accumulated to a huge size over past year or two.

Since that point, nothing is able to write to listenr.log file even though i did
not change an writing permission
of this file and its parent directory. The file size is keeping 0 over one month
period. I do not know how to make
this file writeable.

I issued 'lsnrctl status command' to check the destination of this file:

Listener Parameter File
/u01/app/oracle/product/8.0.5/network/admin/listener.ora Listener Log File
/u01/app/oracle/product/8.0.5/network/log/listener.log Services Summary...

   extproc               has 1 service handler(s)
   idms          has 1 service handler(s)
   orac          has 3 service handler(s)
   tsp           has 1 service handler(s)
   vign          has 2 service handler(s)

The command completed successfully

Then I go to corresponding directory and find the size of this file is 0.

nnidb1:/export/home/oracle_at_orac> cd
/u01/app/oracle/product/8.0.5/network/log nnidb1:/u01/app/oracle/product/8.0.5/network/log_at_orac> ls -laF total 4488

drwxr-xr-x   4 oracle   dba          512 Jan 23 09:51 ./
drwxr-xr-x  16 oracle   dba          512 May 13  1999 ../
drwxr-xr-x   2 oracle   dba          512 Jan  5 10:09 2000/
drwxr-xr-x   2 oracle   dba          512 Jan  5 09:57 2001/


-rw-rw-rw-   1 oracle   dba            0 Jan  5 14:24 listener.log

-rw-rw-rw-   1 oracle   dba      2278569 Jan 23 09:55 sqlnet.log

Will someone in the list enlight me?

Thanks

Eveleen

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:

INET: exu_at_nnng.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:

INET: Riyaj_Shamsudeen_at_i2.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohammad Rafiq
INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message