Oracle on Solaris 10 : Fixing the 'ORA-27102: out of memory'

When creating database using DBCA on solaris 11 sparc 64-bit getting error.


'ORA-27102: out of memory'


Environment:


Database Oracle 12c
O/S          Solaris 11.3 Sparc 64-bit


Solution

% id -p
uid=59008(oracle) gid=10001(dba) projid=3(default)

% prctl -n project.max-shm-memory -i project 3
project: 3: default
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      7.84GB      -   deny                                 -
        system          16.0EB    max   deny               

% prctl -n project.max-shm-memory -r -v 10G -i project 3

% prctl -n project.max-shm-memory -i project 3
project: 3: default
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      10.0GB      -   deny                                 -
        system          16.0EB    max   deny                                 -







Finally make sure the project is created with projects -l or cat /etc/project commands.