ORA-27302: failure occurred at: skgpwinit6

平台：AIX 6100-05-05-1112

数据库版本：grid  11.2.0.3.6

                        oracle 11.2.0.3.6

实例：4个单实例

问题：

根据新规划，在单机添加新实例过程中，原来的4个单实例出现访问问题，根据后台日志，显示的基本类似，如下：

Wed Oct 16 18:31:12 2013

Errors in file /oracle/app/oracle/diag/rdbms/cshsc/cshsc/trace/cshsc_j000_10290734.trc:

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Not owner

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid = 1000 (oinstall), current egid = 1100 (asmadmin)

Process J000 died, see its trace file

kkjcre1p: unable to spawn jobq slave process 

该问题之前遇到过，上次的情形是升级数据库补丁的时候出现；同时参考过MOS的解析，最初定位为$ORACLE_HOME/bin/oracle的权限错误。正确的权限应为   -rwsr-s--x

但是，实际上检查环境里的相应的文件的权限，权限正确。

观察ASM日志，发现四个实例都发生和ASM断开通信的报错提示，并生成了包含关键信息的trc文件：

Wed Oct 16 15:01:56 2013

NOTE: client cssp:cssp registered, osid 4063602, mbr 0x1

Wed Oct 16 16:03:20 2013

NOTE: client cssp:cssp deregistered

Wed Oct 16 16:03:28 2013

Starting background process ASMB

Wed Oct 16 16:03:29 2013

ASMB started with pid=28, OS id=591588 

Wed Oct 16 16:03:29 2013

NOTE: client +ASM:+ASM registered, osid 57475746, mbr 0x1

Wed Oct 16 16:03:37 2013

NOTE: client cssp:cssp registered, osid 47841924, mbr 0x5

Wed Oct 16 16:08:34 2013

NOTE: ASMB process exiting due to lack of ASM file activity for 305 seconds

Wed Oct 16 16:16:45 2013

NOTE: client cssp:cssp deregistered

Wed Oct 16 16:21:22 2013

NOTE: ASM client cxcsdb:cxcsdb disconnected unexpectedly.

NOTE: check client alert log.

NOTE: Trace records dumped in trace file /oracle/app/11.2.0/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_54395000.trc

Wed Oct 16 16:21:52 2013

Starting background process ASMB

Wed Oct 16 16:21:52 2013

ASMB started with pid=28, OS id=13567860 

Wed Oct 16 16:21:53 2013

NOTE: client +ASM:+ASM registered, osid 13043412, mbr 0x1

Wed Oct 16 16:22:00 2013

NOTE: client cxcsdb:cxcsdb registered, osid 9242558, mbr 0x3

Wed Oct 16 16:26:59 2013

NOTE: ASMB process exiting due to lack of ASM file activity for 305 seconds

Wed Oct 16 17:53:38 2013

Starting background process ASMB

Wed Oct 16 17:53:38 2013

ASMB started with pid=29, OS id=45417082 

Wed Oct 16 17:53:38 2013

NOTE: client +ASM:+ASM registered, osid 49742562, mbr 0x1

Wed Oct 16 17:58:39 2013

NOTE: ASMB process exiting due to lack of ASM file activity for 301 seconds

Wed Oct 16 18:59:33 2013

NOTE: ASM client cscmdb:cscmdb disconnected unexpectedly.

NOTE: check client alert log.

NOTE: Trace records dumped in trace file /oracle/app/11.2.0/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_11208526.trc

Wed Oct 16 19:01:07 2013

NOTE: ASM client csmddb:csmddb disconnected unexpectedly.

NOTE: check client alert log.

NOTE: Trace records dumped in trace file /oracle/app/11.2.0/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_9111380.trc

Wed Oct 16 19:02:13 2013

Starting background process ASMB

Wed Oct 16 19:02:13 2013

ASMB started with pid=25, OS id=13109146 

Wed Oct 16 19:02:13 2013

NOTE: client +ASM:+ASM registered, osid 55312934, mbr 0x1

Wed Oct 16 19:02:18 2013

NOTE: client csmddb:csmddb registered, osid 7407456, mbr 0x2

Wed Oct 16 19:03:16 2013

NOTE: ASM client cshsc:cshsc disconnected unexpectedly.

NOTE: check client alert log.

NOTE: Trace records dumped in trace file /oracle/app/11.2.0/grid/diag/asm/+asm/+ASM/trace/+ASM_ora_56688718.trc

Wed Oct 16 19:03:48 2013

NOTE: client cxcsdb:cxcsdb deregistered

Wed Oct 16 19:05:04 2013

NOTE: client cscmdb:cscmdb registered, osid 46924106, mbr 0x0

Wed Oct 16 19:06:18 2013

NOTE: client cshsc:cshsc registered, osid 49676378, mbr 0x3

Wed Oct 16 19:07:20 2013

NOTE: client cxcsdb:cxcsdb registered, osid 55575276, mbr 0x4

Wed Oct 16 19:12:19 2013

NOTE: ASMB process exiting due to lack of ASM file activity for 305 seconds

Wed Oct 16 19:56:39 2013

Starting background process ASMB

最后，重启后解决上述实例的问题。

在晚上21:00后再次执行同样操作，ASM日志没有发生类似的报错，奇怪了，执行的是同样的增加实例的操作。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29225845/viewspace-774510/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29225845/viewspace-774510/