D How to Complete Preinstallation Tasks Manually

D.1.1 Minimum Parameter Settings for Installation

During installation, you can generate and run the Fixup script to check and set the kernel parameter values required for successful installation of the database. This script updates required kernel packages if necessary to minimum values.

If you cannot use the fixup script, then review the following table to set the values manually. Verify that the kernel parameters shown in the following table are set to values greater than or equal to the minimum value shown.

D.1.2 Requirements for Shared Memory Resources

The resource control project.max-shm-memory enables you to set the maximum shared memory for a project.

The following table shows the installation minimum settings for project.max-shm-memory:

D.1.3 Checking Shared Memory Resource Controls

Use the prctl command to make runtime interrogations of and modifications to the resource controls associated with an active process, task, or project on the system.

To view the current value of project.max-shm-memory set for a project and system-wide, enter the following command:

# prctl -n project.max-shm-memory -i project default

Where default is the project ID obtained by running the id -p command.

For example, to change the setting for project.max-shm-memory to 6 GB for the project default without a system reboot, enter the following command:

prctl -n project.max-shm-memory -v 6gb -r -i project default

http://docs.oracle.com/cd/E23824_01/index.html

D.1.4 Displaying and Changing Kernel Parameter Values

Use the following procedure to display the current value specified for resource controls, and to change them if necessary:

1. To display the current values of the resource control, enter the following commands:

   $ id -p // to verify the project id
   uid=100(oracle) gid=100(dba) projid=1 (group.dba)
   $ prctl -n project.max-shm-memory -i project group.dba
   $ prctl -n project.max-sem-ids -i project group.dba
   

2. If you must change any of the current values, then:

   1. To modify the value of max-shm-memory to 6 GB:

      # prctl -n project.max-shm-memory -v 6gb -r -i project group.dba
      

   2. To modify the value of max-sem-ids to 256:

      # prctl -n project.max-sem-ids -v 256 -r -i project group.dba
      

Use the following procedure to modify the resource control project settings, so that they persist after a system restart:

1. By default, Oracle instances are run as the oracle user of the dba group. A project with the name group.dba is created to serve as the default project for the oracle user. Run the command id to verify the default project for the oracle user:

   # su - oracle
   $ id -p
   uid=100(oracle) gid=100(dba) projid=100(group.dba)
   $ exit
   

2. To set the maximum shared memory size to 2 GB, run the projmod command:

   # projmod -sK "project.max-shm-memory=(privileged,2G,deny)" group.dba
   

   Alternatively, add the resource control value project.max-shm-memory=(privileged,2147483648,deny) to the last field of the project entries for the Oracle project.

3. After these steps are complete, check the values for the /etc/project file using the following command:

   # cat /etc/project
   

   The output should be similar to the following:

   system:0::::
   user.root:1::::
   noproject:2::::
   default:3::::
   group.staff:10::::
   group.dba:100:Oracle default project ::: project.max-shm-memory=(privileged,2147483648,deny)
   

4. To verify that the resource control is active, check process ownership, and run the commands id and prctl:

   # su - oracle
   $ id -p
   uid=100(oracle) gid=100(dba) projid=100(group.dba)
   $ prctl -n project.max-shm-memory -i process $$
   process: 5754: -bash
   NAME                    PRIVILEGE     VALUE     FLAG     ACTION    RECIPIENT
   project.max-shm-memory  privileged    2.00GB     -       deny 
   

   Note:

   The value for the maximum shared memory depends on the SGA requierments and should be set to a value greater than the SGA size.

   For more information, see the Oracle Solaris Tunable Parameters Reference Manual.