Naula - Don't worry about it. You've given me something to look for the next time. I'd rather learn from someone else's problems. :-)
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, June 03, 2003 5:25 AM To: Multiple recipients of list ORACLE-L Hi All, Sorry I feel *really* stupid about this but here goes. The database was picking up the wrong init.ora (the one it was picking up had the archiving parameter set to false) I've deleted all the old versions of the init.ora so this should n't happen again. Thanks for all the help and suggestions - the next time I'll use v$parameter rather than the init.ora to verify the settings. N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bonnie :->Finke :->Sent: 02 June 2003 20:15 :->To: Multiple recipients of list ORACLE-L :->Subject: RE: cannot allocate new log :-> :-> :->Check the disk capacity for the archive log destination. :-> :->Bonnie Finke :-> :-> :-> :->-----Original Message----- :->Cullen :->Sent: Monday, June 02, 2003 9:20 AM :->To: Multiple recipients of list ORACLE-L :-> :-> :-> :->Hi All, :-> :->I keep getting a cannot allocate new log in the alert log. :->This freezes the :->entire application and I am unable to connect to oracle in :->order to do a :->statspack snap shot. :-> :->This is an upgrade to Version 8.1.7.4 set up on a WK2000 :->(NEW) Server with 2 :->gigs of memory. :-> :->We are writing to 3 separate disks :-> :->Our D&E drives are RAID 0+1. The log files (including :->application logs) are :->written to these drives :->The F drive is raid 5 - this is where our data resides. (No :->logs are written :->to the F drive) :-> :->Currently we have 4 groups of redo log files :-> :-> group 1 ('d:\oracle\oradata\gda\gda_11.log', :-> 'e:\oracle\oradata\gda\gda_12.log') :->size 20M reuse, :-> group 2 ('d:\oracle\oradata\gda\gda_21.log', :-> 'e:\oracle\oradata\gda\gda_22.log') :->size 20M reuse, :-> group 3 ('d:\oracle\oradata\gda\gda_31.log', :-> 'e:\oracle\oradata\gda\gda_32.log') :->size 20M reuse, :-> group 4 ('d:\oracle\oradata\gda\gda_41.log', :-> 'e:\oracle\oradata\gda\gda_42.log') :->size 20M reuse :-> :->and we archive to e:\oracle\arc\gda :-> :->These are our log settings from the init.ora :->log_buffer = 131072 :->log_checkpoint_interval = 100000000 :->log_checkpoint_timeout = 0 :-> :->I have the performance monitor running the whole time and :->when this happens :->the CPU, DISK QUE LENGTH all look normal. :->I have read the archive files regarding this error but :->thought that the :->above set-up was sufficient. :->Can anybody *please* give me some idea of what other areas I :->should be :->looking at in order to prevent the error from occurring. :->Would writing smaller files help? Disk space is not an issue. :-> :->Thanks - all advice appreciated, :-> :->N. :->(developer/part-time DBA) :-> :->___________________________________ :->Nuala Cullen :->Catlogic :->30 Park Gate :->Milton Park :->Abingdon :->Oxfordshire :->OX14 4SH :-> :->Phone: +44 (0) 1235 838151 :->Fax: +44 (0) 1235 838160 :->Direct Line: +44 (0) 1235 838147 :->___________________________________ :-> :-> :->-- :->Please see the official ORACLE-L FAQ: http://www.orafaq.net :->-- :->Author: Bonnie Finke :-> 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: Nuala Cullen 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: DENNIS WILLIAMS 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).
