Skip to Main Content

Database Software

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!

ORA 838 Specified value of MEMORY_TARGET is too small, needs to be at least

ChristianNov 10 2010 — edited Nov 17 2010
I upgraded my db from 11.2.0.1 to 11.2.0.2

I have 3 databases (all 2-node rac) in one home (new db_db2)

Two of three databases are running fine.

The third is not startable anymore.
ORA 838 Specified value of MEMORY_TARGET is too small, needs to be at least ....

But how ?
Startup nomount does not work - here appears this error.

The db is using an spfile, so I cant create a pfile to change the parameter memory_target....

How can I modify this parameter ?


Oracle 11.2.0.2, 2-node RAC, SLES11, Grid 11.2.0.2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2010
Added on Nov 10 2010
11 comments
2,404 views