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!

SGA_MAX_SIZE is incorrectly sized in production database

idreesJan 29 2014 — edited Jan 29 2014

Dear all,

i am using oracle 10g r2 on windows server 2003.i have increased my production database sga_max_size to 4 gb and  i think our server dosent have that much RAM,

alter database set sga_max_size=4000M scope=spfile;

SQL> shutdown immediate;

here it doesnt shutdown and get hanged.

i open another sqlplus and issue the follwoing

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup open

ORA-27100: shared memory realm already exists

SQL>

how to fix it.

thanks
This post has been answered by idrees on Jan 29 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2014
Added on Jan 29 2014
#general-database-discussions
5 comments
188 views