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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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).
