How to Set the Oracle Database Kernel Parameters

The default project is modified to contain the resources required for Oracle Database as the RGM uses the default project for running the data service. If you want to use a specific SRM project for running Oracle Database, you must create that project and configure the system resources in that project using the same procedure. Specify the project name instead of default. When you configure the resource group or resource for the Oracle Database server, specify that project name in the corresponding property of the resource group or resource.

1. Display the settings for the default project.

   phys-X# prctl -i project default

2. If no kernel parameters are set, or if any kernel parameters are not set to the minimum required value for Oracle Database as shown in the following table, set the parameter.

   phys-X# projmod -s -K "parameter=(priv,value,deny)" default

   Oracle Database Kernel Parameter Minimum Required Value process.max-sem-nsems 256 project.max-sem-ids 100 project.max-shm-ids 100 project.max-shm-memory 4294967295

   See the installation guide for your version of Oracle Database for more information about these parameters.

3. Verify the new settings.

   phys-X# prctl -i project default

4. Set the noexec_user_stack parameter.

   Open the /etc/system file and manually add the following entry.

   set noexec_user_stack=1