Friday, March 26, 2010

Out of memory error while create database

  • 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.
  • 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

No comments:

Post a Comment