Friday, 25 November 2016

ORA-27102: out of memory

While try to bring up the database getting below error

SQL> startup
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
DB version: 11.2.0.4
Server:Solaries 10

For further details in alert log below massage appear

WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000002340000000

Cause: Oracle is trying to create a 151Gb shared memory segment, but operating system responded with an invalid argument (EINVAL) error message. As the alert log suggested, “fix shm parameters in /etc/system” and showed “creating segment of size .
Once convert the Hex value(
0x0000002340000000)  into decimal it is 151 GB approx.



To know the current allocated memory is 

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

Currently 125 GB is allocated to the database.To bring up the database or resolve the issue ,
we need to  increase it either equal to 151 GB or more.
We have decided to make it 200Gb to avoid same issue in future.
To change it temporary ,means changed will lost after server reboot.

# prctl -n project.max-shm-memory -r -v 200G -i project 3
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
        privileged       200GB      -   deny                                 -
        system          16.0EB    max   deny     
this change is temporary.
To make the change permanently to the server for the database.
# projmod -s -K "project.max-shm-memory=(priv,200g,deny)" 'default' 
 NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
        privileged       200GB      -   deny                                 -
        system          16.0EB    max   deny     

No comments:

Post a Comment