Oracle problem at startup

[Former Member]

Hi,

When the system attempts to stop the database, it leaves in the stopdb log the next message:

ORA-00472: PMON process terminated with error

ORA-27300: OS system dependent operation:semctl failed with status: 22

ORA-27301: OS failure message: Invalid argument

ORA-27302: failure occurred at: sskgpwpost1

ORA-27303: additional information: semid = 31588352

We have the following data:

- Oracle 9.2

- Solarios 5.8

- Sga_max_size 3.273.628.280

- Parameters in the etc/system:

set shmsys:shminfo_shmmin=1

set shmsys:shminfo_shmmax=1073741824

set shmsys:shminfo_shmmni=256

set shmsys:shminfo_shmseg=200

set semsys:seminfo_semmap=256

set semsys:seminfo_semmni=4096

set semsys:seminfo_semmns=4096

set semsys:seminfo_semmnu=4096

set semsys:seminfo_semume=64

set semsys:seminfo_semmsl=2048

set semsys:seminfo_semopm=50

When I try startup the database I need to clean the semaphores and kill the oracle processes.

Could anybody help me?

[former_member204746 · Accepted solution]

upgrade to Oracle 9.2.0.8 or 10.2.0.2

on the web, other Oracle 8.1.7 users had similar problems and they were fixed with Oracle patches

[Former Member]

Thanks for your help, but we can't upgrade oracle now. Perhaps is more easy to increase the patch level.

Thanks and regards.