Monday, July 18, 2022

Database startup failed with ORA-27102: out of memory in Solaris


Database startup failed with  "ORA-27102: out of memory" in solaris. Even though we had enough memory in the server , value of project.max-shm-memory was low. Please follow below steps to increase the same.


How to Change project.max-shm-memory

$ prctl -n project.max-shm-memory -v 35gb -r -i project user.oraprod


How to check max-shm-memory of a current user?

$ prctl -n project.max-shm-memory -i process $$

process: 17844: -bash

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-shm-memory

        usage           11.6GB

        privileged      35.0GB      -   deny                                 -

        system          16.0EB    max   deny                                 -

No comments:

Post a Comment

How to Compile Forms , Reports & Custom.pll in R12.2

How to Compile Custom.pll   cd $AU_TOP/resource  cp CUSTOM.plx CUSTOM.plx_bkup  cp CUSTOM.pll CUSTOM.pll_bkup  frmcmp_batch module=CUSTOM.pl...