I knew you weren't crazy, Rachel. :)
So far this "feature" hasn't worked for me. I have been moving
the alert.log and let Oracle create a new one since 8.0.5 and now
on 8.1.7 when I was unware of this "feature". Now that I read about
it I am troubled. Oh I am on Solaris 7 and 8 BTW.
Hmmm... I am pondering whether I should modify my script or not.
>>> [EMAIL PROTECTED] 07/11/01 09:05AM >>>
Okay folks, I *knew* I wasn't crazy! thanks to Anita for finding the post
that Bruce sent to the list, that had the metalink doc in it
There was also a bug filed on it (which was closed as "not a bug") bug#
1388186
It was filed for Solaris so this might just mean that the "feature" is
Solaris specific, since people here are saying that they haven't seen it on
other platforms.
We are on Solaris, but our scripts are written such that we don't rename the
alert log so I haven't been able to prove it one way or another.
Rachel
Note:122401.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 18-OCT-2000
Last Revision Date: 14-MAY-2001
Problem Description
-------------------
The Oracle background processes has an open file descriptor on the
alert.log.
When the database is up and running it continually holds this file
descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to
8.1.7.
This poses the question: What if the database is up and the alert.log
gets too large. Do I have to shutdown the database to release the open file
descriptor on the alert.log, then deal with the large alert.log?
Solution Description
--------------------
You are able to copy the alert.log while the database is up and running.
1) Create an empty file:
(example: touch nullfile.log)
2) Replace the old alert.log with the new empty file:
(example: mv nullfile.log alert<sid>.log)
The running database experiences no affects when doing this.
Explanation
-----------
Having the continual open file descriptor on the alert.log is intended
behaviour for the database.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Richard Ji
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
