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!

softlink spfile

user8838095Jan 4 2017 — edited Jan 5 2017

Hi,

DB - 11.2.0.3.0

OS - Linux 2.6.18-164.el5 #1

Environment is two node RAC. spfile is created in shared location(softlink) for node1 and node2. We bounce the node1 instance for testing purpose(change memory related parameter in node1 in init file).

When i startup my node1 with the shared spfile its prompt for the below error.

SQL> STARTUP;

ORA-00844: Parameter not taking MEMORY_TARGET into account

ORA-00851: SGA_MAX_SIZE 4194304000 cannot be set to more than MEMORY_TARGET 1056964608.

How i can start the DB in node1 with the shared spfile ?

Thanks.

This post has been answered by Billy Verreynne on Jan 4 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2017

Added on Jan 4 2017

#general-database-discussions

9 comments

914 views