Kernel parameters required for SunSolaris to run the Oracle database

This article describes some kernel parameters that need to be set to run Oracle databases on SunSolaris. Sharedmemory: (shared memory segments)

This article describes some kernel parameters required to run Oracle databases on Sun Solaris. Some prerequisites shared memory: (shared memory segments)

This article describes some kernel parameters required to run Oracle databases on Sun Solaris.

Some prerequisites

Shared memory: (shared memory segments)

A memory area can be read by different processes. Oracle uses it to form SGA. Oracle uses the following three methods to create an SGA zone:

1. Use a single shared memory segment.

2. Use multiple consecutive shared memory segments.

3. Use multiple discontinuous shared memory segments.

The first method is preferred for Oracle. If the initialization succeeds, the initialization continues. If the initialization fails, the second method is used. If the initialization fails, the third method is used. If the initialization fails, the initialization fails and the Oracle Reports the error code.

Semaphore: (Semaphore)

It can be seen as a tag. There can be On and Off statuses. Oracle uses semaphores to control the access of server processes to the SGA zone.

Shared memory and semaphore are important resources for Oracle to run on Unix. If an Oracle instance cannot obtain the required resources, the instance will fail to start.

Parameters:

For the Solaris system running an Oracle instance, change some parameters about the shared memory in the/etc/system file so that the Oracle instance can run normally. If there are multiple instances, You need to recalculate some values according to the following method.

Shared Memory:

Shmmax

Meaning: This setting does not determine the actual amount of physical memory used by the Oracle database or operating system. It only determines the maximum amount of memory that can be used. This setting does not affect the kernel resources of the operating system. Max shared memory segment size (SHMMAX) bytes

Setting Method: 0.5 * physical memory

Example: Set shmsys: shminfo_shmmax = 10485760

Shmmin

Description: minimum size of shared memory.

Setting Method: generally set to 1.

Example: Set shmsys: shminfo_shmmin = 1:

Shmmni