- Issue prctl $$ command as oracle and root user and ensure that proj.max-shm-mem variable shows the value you need. Else update the /etc/system with the following and reboot the system:
 - set shmsys:shminfo_shmmax=0xb40000000
 - If you do not want to reboot the system, make sure you update the project for both root user and oracle user with prcl commands given below.
 - For additional info : http://ritukamboj.blogspot.com/2011/03/out-of-memory-error.html
 - Create a project named oracle using following command:
- projadd oracle
 
 - Verify that project was created
- projects -l
 
 - Associate this project with oracle user:
- Edit /etc/user_attr file and add the following line
- oracle::::project=oracle (four colon)
 
 
 - Verify that project oracle is associated with oracle user:
- login as oracle user and issue id -p. It should show oracle as project for oracle user.
 
 - Check the existing value of shared memory variable for this project:
- prctl -n project.max-shm-memory -i project oracle
 
 - To set it to a different value:
- To set the value dynamically for the given session...will be lost after reboot
- prctl -n project.max-shm-memory -v 40G -r -i project oracle
 
 - To set it in /etc/project file so it is persistent across reboot
- # projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle
 
 
 
Friday, March 26, 2010
Out of memory error while create database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment