Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing SGA Target with Oracle Offline

593025Jan 24 2008 — edited Jan 24 2008
Hello forum. If I'm not posting this on the right thread, please let me know.

I've completed an RMAN restore and in the process of running catupgrd.sql got a few memory errors at the end. Something akin to "couldn't allocate 414K for shared pool".

I logged into plsql after the restore and set the shared_pool_size to 256M. Upon restarting the instance, I get a message that sga_target is too small and that I need to increase it to 512M. It then disconnects me and kills the instance.

I'm curious, if oracle instances won't start, how can you change the init parameters? Is there a way to edit the parameters while the DB is offline? I did try to edit initSID.ora in dbs, but it's not recognizing the change to sga_target.

Thanks for your help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2008
Added on Jan 24 2008
#general-database-discussions
9 comments
5,140 views