| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> alertlog naming
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). Received on Tue Feb 25 2003 - 07:59:02 CST
 |
 |