碰到 ORA-00600 问题

 现象描述：修改processes参数,为什么SHUTDOWN后,数据库起不来了

 log文件：

   

ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], []

ORA-27302: failure occurred at: skgpwreset1 ORA-27303: additional information: invalid shared ctx

ORA-27146: post/wait initialization failed

ORA-27300: OS system dependent operation:semget failed with status: 28

ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates

 在metalink查询，如下解释与解决办法： 

 

SymptomsGetting ORA-600 [OSDEP_INTERNAL]
Accompanied by the following errors
ORA-27302:Failure occured at: skgpwreset1
ORA-27303:additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation: segment failed with error 28
ORA-27301: OS system Failure message: No space left on device
ORA-27302: failure occured at: sskgpsemsper

Cause
The functions in the trace file generated point to the semaphore settings .
Smmns is set too low.

Solutionset semmns 32767
Arrange to make the changes persistent as per the Operating system then restart the server and check if the changes are persistent.
eg: Linux /etc/sysctl.conf

sem = semmsl semmns semopm semmni
kernel.sem = 256 32768 100 228


文档里只给出了linux的解决方法，但出错的机器是SOLARIS操作系统，本人对sun的服务器不熟悉，只好建议重建spfile，先用一initSID.ora启动到nomount状态下，修改回原proceses的值，然后重启。

总结：在修改参数前，备份一下spfile文件，恢复也是很快的