Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot allocate new log --> Problem Solved

RE: cannot allocate new log --> Problem Solved

From: Nuala Cullen <ncullen_at_catlogic.com>
Date: Tue, 03 Jun 2003 02:24:38 -0800
Message-ID: <F001.005A8A57.20030603022438@fatcity.com>

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: root_at_fatcity.com [mailto:root_at_fatcity.com]On 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: bfinke_at_globitech.com
:->
:->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).
:->
:->

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuala Cullen
  INET: ncullen_at_catlogic.com

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 Jun 03 2003 - 05:24:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US