ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27302: failure occurred at: skgpwinit6

ORA-27302: failure occurred at: skgpwinit6

原创 Linux操作系统 作者:zwunixdb 时间:2013-10-16 21:23:41 0 删除 编辑
平台: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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-10-08

  • 博文量
    9
  • 访问量
    29903