| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: alertlog naming
Jack,
I've seen the same result (alert log funny file name) when I rename the file also doing oracle log maintenace. I'm guessing the same thing you are - that the rename hits at the same time that a write operation is happening. a subsequent rename works fine.
For you second problem, I would leave the database in it's stuck state, connect internal and run the "wait state" queries to see what's going on. these queries are the ones outlined in the Oracle Performance Tuning 101 book written by our friends Kirti, Gaja and John. It will quickly tell you what is happening in your database - it sounds like maybe an init.ora param needs to be adjusted (just a Wild Assed Guess).
If you don't have the book - buy it.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, February 25, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
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).
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 - 09:04:23 CST
 |
 |