Re: alertlog naming

Are you working with archive log?
I saw this behavior when there was a problem in writing to an archive log and the arch process stopped.

I think that instead of renaming you should copy the file and then deleting all lines from it.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, February 25, 2003 3:59 PM

>
> Hi,
>
>
> On one of our customers site (WINDOWS) we have databases that have
alertlogs
> with the name <sid>ALRT.LOG<sid>ALRT.LOG (double the normal name) and
oracle
> keeps on writing to it.
> I thought if a file is renamed oracle will create a new alertlog when
> needed. I have a php script that reads the alrtlogs and reports the
errors
> in web browser and than renames the current alertlog to
> <sid>ALRT.LOG.yyyymmdd
> Can it be that when there is writing action in the file oracle will get
> confused and screw up the renaming bit? (I thought windows did not allow
> changing filenames of open files)
>
> One of the databases on this customers site every now and than hangs with
no
> messages in the alert logs and does not allow any connections anymore(No
> errors reported back to client). This database needs to be up and running
> asap so when it happens we don't get much time to investigate and restart
> the service. We can still connect with svrmgrl and internal (wasn't this
> supposed to go in 8.1.7). What would be the best course of action to
quickly
> gather the releavnt data next time this happens.
> Has anybody seen this before and knows the solution?
>
> W2K
> Oracle 8.1.7.0.0 EE
>
> Jacob A. van Zanen
> Oracle DBA
> Quant Systems Europe b.v.
> Tel : +31 (0) 251 - 268 268
> Mobile: +31 (0) 6 51308813
> Fax: +31 (0) 251 - 268 269
> E-mail: mailto:jack_at_quantsystems.nl
> Visit our web site at http://www.quantsystems.nl/
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).