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!

MEMORY_TARGET greater than MEMORY_MAX_TARGET

767685Jul 22 2010 — edited Jul 22 2010

Hi,

I've tried to increase memory allocated for my db, getting the following error.

Enter user-name: sys/ as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
SQL> startup mount
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
SQL> startup force
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

I know that increasing or making MEMORY_MAX_TARGET equal to MEMORY_TARGET will solve this issue. But how to do it as database is not even starting in MOUNT stage.

Oracle 11g(11.1.0.6.0), winxp

I'll appreciate the suggestion

Thanks

Regards
John

This post has been answered by 657203 on Jul 22 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2010

Added on Jul 22 2010

#11g, #general-database-discussions

6 comments

10,179 views