- 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