RE: Altering dymanic SGA parameters and ORA-00376

Yes, I have seen it. Never did find a cause, and the theory I developed was one my unix sys admin did not like. Were there errors in the trace files about forking a process?  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
krish.hariharan_at_quasardb.com
Sent: Thursday, December 06, 2007 10:14 AM To: peter.mclarty_at_pacificdbms.com.au; 'oracle-l' Subject: RE: Altering dymanic SGA parameters and ORA-00376  

I am unable to locate the bug number associated with a similar error I saw in the recent past, I will post that when I can locate it. Basically, if I remember this correct the database instance crashes (10.2.0.3 I believe) if you resize when the sga_target is a multiple of 4G. I think the circumstances were  

1. SGA_TARGET 12G
2. DB_CACHE_SIZE was increased

Regards

-Krish  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter McLarty
Sent: Thursday, December 06, 2007 7:58 AM To: oracle-l
Subject: Altering dymanic SGA parameters and ORA-00376  

Hi

I am sure this is a totally dumb question but does anyone know if changing parameters dynamically for SGA settings like increasing shared_pool_size can cause a DB to crash and show many problem datafiles with ORA-00376.

I am thinking SAN failure of some sort, we relocated the database to another set of LUNS from a different SAN and did datafile recovery and all is good, but just trying to isolate the causes, alert log shows a read error on an index datafile just seconds before it had the alter for the SGA parameters and then crash.

Interestingly it had to use 4 archivelogs to conduct the recovery which cover about 20 minutes prior to the crash.

Some hypothesis to consider ,based on the above information is what I am looking for.
It is Solaris 10 and its Sun Storage but i don't have available the models, the server is a T2200, 16 VCPU's

Or if someone has had a similar experience and what you found out We are going to try and do a root cause analysis tomorrow if no issues are present when the users hit it again

1am here and I am off to bed

All help appreciated

Cheers

-- 
Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Pacific DBMS Pty Ltd 

 


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


--
http://www.freelists.org/webpage/oracle-l