On Apr 29, 5:26=A0pm, Adam Sandler <cor...@[EMAIL PROTECTED]
> wrote:
> Hello,
>
> Today the database shutdown and I received error codes 01034 and
> 27101. =A0When I tried to restart and connect I got 00821. =A0The 00821
> was due to the specified value of sga_target was too small. =A0To get
> the database started, I created a pfile from the spfile, edited the
> pfile's sga_target line (specified more space; went from 320M to
> 640M), created a spfile from the pfile and started the database back
> up.
>
> I was able to start the database but now I want to put the sga_target
> back to the value where it has been for years. =A0When I did this from a
> command line it failed:
>
> alter system set sga_target=3D320M scope=3Dboth;
>
> ORA-02097: parameter cannot be modified because the specified value is
> invalid
> ORA-00827 could not shrink sga_target to specified value
>
> I'm stumped here... how can I set sga_target to a smaller value than
> the current setting? =A0Suggestions are greatly appreciated.
>
> Thanks!
Please state exact version. What is your sga_max_size?
00827, 00000, "could not shrink sga_target to specified value"
// *Cause: Attempted to shrink the SGA to the specified value but did
not
// succeed because the SGA components could not be shrunk as
they
// were already at their minimum sizes.
// *Action: Do not set sga_target to a value below the current value
without
// first shrinking the individual SGA components.
Do you know what your other init parameters were for years?
jg
--
@[EMAIL PROTECTED]
is bogus.
=93So when he died, I was basically locked out of my own Web site.=94
Apparantly UCAN't.
http://www.signonsandiego.com/news/business/20080429-999=
9-1b29ucan.html
|
