RE: Listener.log not been updated

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 26 Sep 2007 07:08:29 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8BFD@x6009a.umb.corp.umb.com>

If its 32 bit linux, there is likely to be a 4g OS limit on file size.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steeve Bisson Sent: Tuesday, September 25, 2007 8:20 PM To: oracle-l_at_freelists.org
Subject: Listener.log not been updated

I am on Linux x86 OEL4 using Oracle 10.2.0.3.

My listener.log is not been updated since the 30 May.

cd /opt/oracle/app/oracle/product/10.2.0/db_1/network/log [oracle_at_juk-prod log]$ ll
total 4203424
-rw-r--r-- 1 oracle oinstall 4294967428 May 30 21:49 listener.log

If I do status in lsnrctl:
Listener Parameter File /opt/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /opt/oracle/app/oracle/product/10.2.0/db_1/network/log/listener.log

Everything else seems fine. I connect to the database with no problem. Any idea why the listener would stop writing log?

To solve the problem, I did the following in lsnrctl: SET LOG_FILE list.log

Now I get information in list.log
[oracle_at_juk-prod log]$ ll
total 4222736
-rw-r--r-- 1 oracle oinstall 4294967428 May 30 21:49 listener.log
-rw-r--r-- 1 oracle oinstall 511462 Sep 16 19:41 list.log

Any idea why it would stop logging info once the log was at 4gig? I have 32GIG datafile on that machine.
Is there a thresholds where oracle stop to log, so it is possible to vi the log? Anyone has documentation on this? Or a link on that subject?

CONFIDENTIALITY CAUTION
This e-mail and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. DOCUMENT CONFIDENTIEL
Le présent courriel et tout fichier joint à celui-ci peuvent contenir des renseignements confidentiels ou privilégiés. Si cet envoi ne s'adresse pas à vous ou si vous l'avez reçu par erreur, vous devez l'effacer. Vous ne pouvez conserver, distribuer, communiquer ou utiliser les renseignements qu'il contient. Nous vous prions de nous signaler l'erreur par courriel. Merci de votre collaboration.

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 26 2007 - 07:08:29 CDT