shmat:operating system error

[Balakumar M]

Hi All,
In one of our server, When we run the database script the system through's shmat:operating system error, Could any one help me to solve this issue. Its very urgent.
OS is hpux 10.20
Waiting for u r help

[A. Clay Stephenson · Accepted solution]

Hi,

Since you didn't mention the database (Oracle X?) and the specific OS errno, I can only guess. You also didn't mention memory, amount of swap, machine type, number of CPU's. So again, I'm guessing. Go into SAM->Kernel Configuration->Configurable Parameters.

There are 3 shared memory parameters which may need to be increased: 1) shmmax - 1073741824
2) shmmni -> about 1024; 3) shmseg -> about 512

Look at the help associated with each of these. Adjust them and generate a new kernel and reboot.

Hope this fixes you, Clay