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

On Jul 14, 12:34 pm, l..._at_tech-trans.com wrote:
> On 7$B7n(B15$BF|(B, $B>e8a(B12$B;~(B07$BJ,(B, bdbafh <bdb..._at_gmail.com> wrote:
> > On Jul 14, 11:57 am, l..._at_tech-trans.com wrote:
>
> > > Hi!,
>
> > > I tuned the SGA_MAX to 3G. Then, the database could not startup!
> > > How can I do now! Help!
>
> > > Ming
>
> > If that is Oracle XE (you have posted regarding that edition on other
> > posts) that value is not permitted.
> > Its covered in the docs.
>
> > You might want to post OS and database server software environment
> > information if you want an answer that is other than an uninformed
> > guess.
>
> > -bdbafh
>
> It is Oracle 10g database server with patch 10.2.0.2.0 under Windows
> envrionment. I have learned create spfile from pfile. However, it
> did not work! Thx!
>
> Ming

If you have a good copy of the init.ora (pfile) file (named correctly of course), place the file in the same folder location as the spfile. Fix the init.ora file so that it does not specify memory settings that when combined exceed 2GB, then rename the current spfile to something else. The database instance will automatically read the init.ora if the spfile is not found where expected, when it is started. Once the database is up, execute a command to create a new spfile from the pfile.

Always keep a good up to date init.ora (pfile).

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Jul 14 2008 - 13:17:18 CDT