creating a file solved the problem(actually renamed the alertlog back to original name) and it wasn't such a big deal. I am just wondering why two databases with similar setup and exact same versions on the same machine do not have the same problems. Creating a workaround for this database is not my first choice as this is a script that runs of a remote server and is standard for all UNIX databases. But if all else fails................................
Thx Jack -----Original Message----- Sent: Wednesday, October 09, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Not seen this before but trying creating a new alert log file using touch if unix or a simple output (something like type nonexistantfile > alrtSID.log) if using dos. See if the same problem occurs. At least then you can narrow it down to a definite problem recreating the alert log file which you can look into further and you will have a workaround. If you've already done this what was the outcome? BTW - you do not need to shutdown the database to be able to rename the alert log file successfully - Oracle *should* create the file if it needs to output messages and cannot find an existing file. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] "Enabling Competitive Advantage for Barclays in IT and Business Processing" -----Original Message----- Sent: 09 October 2002 10:39 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH ---------------------------------------------------------------------- Hi All, We have a database running 7.3.4.5 and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have three databases of which two will simply create a new alert log and startup (including the test instance on which we tried it). The third one will not start up and give above error. All databases are shutdown the same way. Has anybody seen this behaviour before and found a reason/solution for it? Jacob A. van Zanen Oracle DBA ==================== Quant Systems Europe BV Zuiderkade 7 1948NG Beverwijk Tel. :0251 268268 ==================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Bishop Lewis 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.com -- 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).
