Find it

Friday, September 25, 2009

Oracle Kernel Parameters in Solaris 10

In case of Solaris9, edit shared memory and semaphore kernel parameters in /etc/system using the calculations and rules of thumb from the oracle install manual.

The following table identifies the now obsolete IPC tunable and their replacement resource controls.

In case of Solaris 10, the Solaris resource management facilities are used to set resource limits for Oracle rather than /etc/system parameters. The /etc/system should not be edited with resource limits, so only a single parameter should be added to /etc/system:

set noexec_user_stack=1

For Solaris10, add a project for the oracle user and set the recommended resource limits:

# projadd -U oracle
# projmod -s -K "project.max-sem-ids=(priv,100,deny)"
# projmod -s -K "project.max-sem-nsems=(priv,256,deny)"
# projmod -s -K "project.max-shm-memory=(priv,4294967295,deny)"
# projmod -s -K "project.max-shm-ids=(priv,100,deny)"

(To check the project settings: prctl -i project

- Reboot machine after changing /etc/system to put new settings into effect.

No comments:

Post a Comment