Memory Settings for Oracle installation on Solaris

Before installing oracle on Solaris, we need to set some kernal parameters

These parameters are stored in /etc/system

set noexec_user_stack=1
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semmni=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=10737418240
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

NOTE: These settings will only take effect after bouncing the node

Solaris 10 onwards, we can also create a project and assign them to OS users. These parameters will be saved in /etc/project

Syntax for creating the projects

#projadd -U oracle -K “project.max-shm-memory=(priv,10G,deny)” group.dba
#projmod -sK “project.max-sem-ids=(privileged,100,deny)” group.dba
#projmod -sK “process.max-sem-nsems=(privileged,256,deny)” group.dba
#projmod -sK “project.max-shm-ids=(privileged,100,deny)” group.dba

For editing the project parameters

#projmod -sK “project.max-shm-memory=(priv,20G,deny)” group.dba

Once the project created, add entry in /etc/user_attr to assign the project to oracle OS user

oracle::::project=group.dba

Advertisements
This entry was posted in Oracle Kernel Parameters, Unix OS and tagged . Bookmark the permalink.

One Response to Memory Settings for Oracle installation on Solaris

  1. nayyares says:

    Hi, thanks nice post, specially the projadd thingy, because official installation guide is missing this step and i got stuck with it.

    finally your post helped me out!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s