Monday, June 23, 2014

Soalrs/Oracle: Out of memory to start up Oracle DB instance

SQL> startup
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument

# cat /etc/project

Create new project for user oracle
# projadd -U oracle -K "project.max-shm-memory=(priv,16GB,deny)" user.oracle

or Modify existing prjoect
# projmod -s -K "project.max-shm-memory=(priv,16GB,deny)" user.oracle
  user.oracle

Activate user.oracle
# newtask -v -p user.oracle

# prctl -i project user.oracle

Restart the database instance
$ prctl -i project user.oracle                                                                                                    
project: 100: user.oracle                                                                                                                              
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT                                                                           
project.max-contracts                                                                                                                                    
        privileged      10.0K       -   deny                                 -                                                                           
        system          2.15G     max   deny                                 -                                                                           
project.max-locked-memory                                                                                                                                
        usage           1.52GB                                                                                                                           
        system          16.0EB    max   deny                                 -                                                                           
project.max-port-ids                                                                                                                                     
        privileged      8.19K       -   deny                                 -                                                                           
        system          65.5K     max   deny                                 -                                                                           
project.max-shm-memory                                                                                                                                   
        privileged      16.0GB      -   deny                                 -                                                                           
        system          16.0EB    max   deny                                 -                                                                           
project.max-shm-ids                                                                                                                                      
        privileged        128       -   deny                                 -                                                                           
        system          16.8M     max   deny                                 -                                                                           
project.max-msg-ids                                                                                                                                      
        privileged        128       -   deny                                 -                                                                           
        system          16.8M     max   deny                                 -                                                                           
project.max-sem-ids                                                                                                                                      
        privileged        128       -   deny                                 -                                                                           
        system          16.8M     max   deny                                 -                                                                           
project.max-crypto-memory                                                                                                                                
        usage               0B                                                                                                                           
        privileged      15.7GB      -   deny                                 -                                                                           
        system          16.0EB    max   deny                                 -                                                                           
project.max-tasks                                                                                                                                        
        usage               1                                                                                                                            
        system          2.15G     max   deny                                 -                                                                           
project.max-processes                                                                                                                                    
        usage              20                                                                                                                            
        system          2.15G     max   deny                                 -                                                                           
project.max-lwps                                                                                                                                         
        usage              59                                                                                                                            
        system          2.15G     max   deny                                 -                                                                           
project.cpu-cap                                                                                                                                          
        usage               0
        system          4.29G     inf   deny                                 -
project.cpu-shares
        usage               1
        privileged          1       -   none                                 -
        system          65.5K     max   none                                 -
zone.max-lofi
        usage               0
        system          18.4E     max   deny                                 -
zone.max-swap
        usage           27.5GB
        system          16.0EB    max   deny                                 -
zone.max-locked-memory
        usage           15.7GB
        system          16.0EB    max   deny                                 -
zone.max-shm-memory
        system          16.0EB    max   deny                                 -
zone.max-shm-ids
        system          16.8M     max   deny                                 -
zone.max-sem-ids
        system          16.8M     max   deny                                 -
zone.max-msg-ids
        system          16.8M     max   deny                                 -
zone.max-processes
        usage             394
        system          2.15G     max   deny                                 -
zone.max-lwps
        usage           5.21K
        system          2.15G     max   deny                                 -
zone.cpu-cap
        usage               0
        system          4.29G     inf   deny                                 -
zone.cpu-shares
        usage               1
        privileged          1       -   none                                 -
        system          65.5K     max   none                                 -

No comments:

Post a Comment