RE: cannot allocate new log --> Problem Solved

Having multiple tnsnames.ora, and multiple init.ora always create unanticipated problems.

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Tuesday, June 03, 2003 7:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: cannot allocate new log --> Problem Solved
>
>
> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>
>

DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).