You experienced
a system crash and had to recreate the Oracle user. When you try to startup the
instance you get:
ORA-27154:
post/wait create failed
ORA-27300: OS system dependent
operation:semget failed with status:
17
ORA-27301: OS failure message: File
exists
ORA-27302: failure occurred at: sskgpcreate
The system
crash left the shared memory and semaphores owned by the crashed Oracle
instance on the system. These have to be
removed before enough resources are available to bring the Oracle instance.
You need to
remove stray shared memory segments and semaphores.
To get a
list of shared memory and semaphore id's:
% ipcs -a
To delete
shared memory:
% ipcrm -m
To delete
semaphores:
% ipcrm -s
Once you
have removed those owned by Oracle and the dba group you are able to startup
the database.
