Database Software

Hi:

I need your help.

When the automatic memory increase of BD more than 8 Gb, my BD RAC indicates failure.

Environment:

Oracle RAC 11.2.0.3 with 2 nodes.

O.S.: SunOS rac1 5.11 11.1 sun4v sparc sun4v

RAM: 32 Gb.

Oracle Grid Infrastructure 11.2.0.3

Oracle ASM 11.2.0.3

Oracle Database 11.2.0.3 Enterprise Edition with RAC option.

Symptom:

I created my DB RAC with MEMORY_TARGET = 1G.

I've been increasing the parameter to 8Gb without problems, however from the 9Gb, this error occurs:

*.memory_max_target=9g      

*.memory_target=4g

SQL> startup nomount;

ORACLE instance started.

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 32 bytes of shared memory ("shared

pool","X$KSMSD","KGLS^c51f85ea","kglHeapInitialize:temp")

Background:

These are the kernel parameters for the oracle account:

oracle@rac1:~$ prctl -n project.max-shm-memory -i project user.oracle

project: 100: user.oracle

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-shm-memory

        privileged     20.00GB      -   deny                                 -

        system          16.0EB    max   deny                                 -

oracle@rac1:~$ prctl -n project.max-sem-ids -i project user.oracle

project: 100: user.oracle

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-sem-ids

        privileged      16.0M       -   deny                                 -

        system          16.8M     max   deny                                 -

How I can fix this?

Thanks

David