oracle 오류

ORA-12560 : TNS : protocol adapter error

 

- 공유메모리관련 시스템 충돌 문제

ORA-27154 on Database Startup After System Crash

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.