Re: Help! Tue SGA_MAX too large! Database cannot start!

From: <fitzjarrell_at_cox.net>
Date: Mon, 14 Jul 2008 09:53:41 -0700 (PDT)
Message-ID: <d4ee4ba4-c1b0-405e-a8e2-c6dc5f5efcfb@m36g2000hse.googlegroups.com>


Comments embedded.

On Jul 14, 10:57 am, l..._at_tech-trans.com wrote:
> Hi!,
>
>   I tuned the SGA_MAX to 3G.  

No, you've set sga_max_size to 3G. Had you actually tuned this value your database would have started, I expect.

> Then, the database could not startup!

How much RAM do you have installed on that Windows server? Is this a 64-bit version of Windows? And, if so, are you starting that Windows operating system with the proper switches to allow access to memory beyond 2G?

http://www.mydatabasesupport.com/forums/oracle-server/174755-2gb-limit-memory-oracle-windows-32-bit.html

http://www.brianmadden.com/content/article/The-4GB-Windows-Memory-Limit-What-does-it-really-mean-

> How can I do now!  Help!
>

Stop expecting a 32-bit operating system to behave as though it were 64-bit?

> Ming

David Fitzjarrell Received on Mon Jul 14 2008 - 11:53:41 CDT

Original text of this message