0 积分	0 好友	6 主题

发消息

集群环境中配置GoldenGate过程中，启动GG资源时失败，如下。

1^#

发表于 2015-3-8 15:30:53 | 查看: 6946| 回复: 6

刘总，帮看看哪里出问题了，非常感谢。

双节点RAC环境，数据库版本11.2.0.1.0，集群版本11.2.0.1.0。

在做Oracle GoldenGate high availability using Oracle Clusterware配置过程中vip资源成功添加且成功start，gg resource也能成功添加，但是在start gg resource时报错.
（GoldenGate是安装在ACFS文件系统上的，附加里面的是参考资料和log文件夹）

如下：

[14:47:46 root@node1 ~]#appvipcfg create -network=1 -ip=192.168.56.88 -vipname=mycorp-oragg-vip -user=root
Production Copyright 2007, 2008, Oracle.All rights reserved
2015-03-08 14:47:48: Skipping type creation
2015-03-08 14:47:48: Create the Resource
2015-03-08 14:47:48: Executing cmd: /u01/app/grid/product/11.2.0/gd_1/bin/crsctl add resource mycorp-oragg-vip -type app.appvip.type -attr USR_ORA_VIP=192.168.56.88,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,user:root:r-x'
[14:47:49 root@node1 ~]#crsctl setperm resource mycorp-oragg-vip -u user:oracle:r-x
[14:47:55 root@node1 ~]#crsctl setperm resource mycorp-oragg-vip -u user:grid:r-x
[14:48:00 root@node1 ~]#crsctl start resource mycorp-oragg-vip
CRS-2672: Attempting to start 'mycorp-oragg-vip' on 'node1'
CRS-2676: Start of 'mycorp-oragg-vip' on 'node1' succeeded
[14:48:07 root@node1 ~]#crsctl status resource mycorp-oragg-vip
NAME=mycorp-oragg-vip
TYPE=app.appvip.type
TARGET=ONLINE
STATE=ONLINE on node1

[14:48:12 root@node1 ~]#crsctl add resource ggate -type cluster_resource -attr "ACTION_SCRIPT=/u01/app/ogg/ggdir/goldengate_action.scr,CHECK_INTERVAL=30, START_DEPENDENCIES='hard(mycorp-oragg-vip,ora.asm) pullup(mycorp-oragg-vip)', STOP_DEPENDENCIES='hard(mycorp-oragg-vip)'"
[14:49:19 root@node1 ~]#crsctl setperm resource ggate -o oracle
[14:49:30 root@node1 ~]#su - oracle
[14:50:01 oracle@node1 ~]$crsctl start resource ggate
CRS-2672: Attempting to start 'ggate' on 'node1'
CRS-2674: Start of 'ggate' on 'node1' failed
CRS-2679: Attempting to clean 'ggate' on 'node1'
CRS-2678: 'ggate' on 'node1' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-5802: Unable to start the agent process
CRS-4000: Command Start failed, or completed with errors.
[14:56:06 oracle@node1 ~]$

-----alertnode1.log-----------------------------------------------------
2015-03-08 14:53:06.436
[crsd(4071)]CRS-5828:Could not start agent '/u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle'. Details at (:CRSAGF00130:) in /u01/app/grid/product/11.2.0/gd_1/log/node1/crsd/crsd.log.
2015-03-08 14:56:06.713
[crsd(4071)]CRS-5828:Could not start agent '/u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle'. Details at (:CRSAGF00130:) in /u01/app/grid/product/11.2.0/gd_1/log/node1/crsd/crsd.log.

------ crsd.log---------------------------------------------------------------------------
2015-03-08 14:50:06.095: [UiServer][2602625936] S(0xb55ec30): set Properties ( oracle,0xb507cf8)
2015-03-08 14:50:06.107: [UiServer][2604727184] processMessage called
2015-03-08 14:50:06.107: [UiServer][2604727184] Container [ Name: UI_START
      CLIENT:
      TextMessage[]
      CLIENT_PRIMARY_GROUP:
      TextMessage[oinstall]
      LOCALE:
      TextMessage[AMERICAN_AMERICA.AL32UTF8]
      QUEUE_TAG:
      TextMessage[1]
      RESOURCE:
      TextMessage[ggate]
]
2015-03-08 14:50:06.107: [UiServer][2604727184] Sending message to PE. ctx= 0xb563e30
2015-03-08 14:50:06.107: [  CRSCCL][2648820624]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 109 msglen = 1010 clschdr.size_clscmsgh= 1098 src= (1, 4294769510) dest= (2, 4294763810)
2015-03-08 14:50:06.113: [  CRSCCL][2659310480]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 125 msglen = 4479 clschdr.size_clscmsgh= 4567 src= (2, 4294763810) dest= (1, 4294769510)
2015-03-08 14:50:06.113: [  CRSCCL][2659310480]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 126 msglen = 786 clschdr.size_clscmsgh= 874 src= (2, 4294763810) dest= (1, 4294769510)
2015-03-08 14:50:06.113: [ AGFW][2619435920] Agfw Proxy Server received the message: RESOURCE_START[ggate 1 1] ID 4098:2323
2015-03-08 14:50:06.113: [ AGFW][2619435920] Creating the resource: ggate 1 1
2015-03-08 14:50:06.114: [ AGFW][2619435920] Initializing the resource ggate 1 1 for type cluster_resource
2015-03-08 14:50:06.114: [ AGFW][2619435920] SR: acl = owner:oracle:rwx,pgrp:root:r-x,other::r--
2015-03-08 14:50:06.114: [ AGFW][2619435920] Starting the agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent with user id: oracle and incarnation:3
2015-03-08 14:50:06.120: [ AGFW][2619435920] Starting the HB [Interval =  30000, misscount = 6kill allowed=1] for agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:50:06.120: [UiServer][2604727184] Container [ Name: ORDER
      MESSAGE:
      TextMessage[CRS-2672: Attempting to start 'ggate' on 'node1']
      MSGTYPE:
      TextMessage[3]
      OBJID:
      TextMessage[ggate]
      WAIT:
      TextMessage[0]
]
2015-03-08 14:53:06.436: [ AGFW][2619435920]Created alert : (:CRSAGF00130:) :  Failed to start the agent /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:53:06.436: [ AGFW][2619435920] Can not stop the agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle because pid is not initialized
2015-03-08 14:53:06.436: [ AGFW][2619435920] Agfw Proxy Server sending the last reply to PE for message:RESOURCE_START[ggate 1 1] ID 4098:2323
2015-03-08 14:53:06.437: [  CRSCCL][2648820624]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 110 msglen = 1726 clschdr.size_clscmsgh= 1814 src= (1, 4294769510) dest= (2, 4294763810)
2015-03-08 14:53:06.440: [  CRSCCL][2659310480]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 127 msglen = 782 clschdr.size_clscmsgh= 870 src= (2, 4294763810) dest= (1, 4294769510)
2015-03-08 14:53:06.440: [  CRSCCL][2659310480]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 128 msglen = 2121 clschdr.size_clscmsgh= 2209 src= (2, 4294763810) dest= (1, 4294769510)
2015-03-08 14:53:06.440: [ AGFW][2619435920] Agfw Proxy Server received the message: RESOURCE_CLEAN[ggate 1 1] ID 4100:2487
2015-03-08 14:53:06.440: [ AGFW][2619435920] Starting the agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent with user id: oracle and incarnation:5
2015-03-08 14:53:06.446: [ AGFW][2619435920] Starting the HB [Interval =  30000, misscount = 6kill allowed=1] for agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:53:06.446: [ AGFW][2619435920] Could not forward message [RESOURCE_CLEAN[ggate 1 1] ID 4100:2487] to agent. /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle is not running
2015-03-08 14:53:06.446: [ AGFW][2619435920] Starting of the agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent with user id oracle is already in progress.
2015-03-08 14:53:06.446: [  CRSCCL][2659310480]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 129 msglen = 786 clschdr.size_clscmsgh= 874 src= (2, 4294763810) dest= (1, 4294769510)
2015-03-08 14:53:06.448: [UiServer][2604727184] Container [ Name: ORDER
      MESSAGE:
      TextMessage[CRS-2674: Start of 'ggate' on 'node1' failed]
      MSGTYPE:
      TextMessage[1]
      OBJID:
      TextMessage[ggate]
      WAIT:
      TextMessage[0]
]
2015-03-08 14:53:06.448: [UiServer][2604727184] Container [ Name: ORDER
      MESSAGE:
      TextMessage[CRS-2679: Attempting to clean 'ggate' on 'node1']
      MSGTYPE:
      TextMessage[3]
      OBJID:
      TextMessage[ggate]
      WAIT:
      TextMessage[0]
]
2015-03-08 14:56:06.713: [ AGFW][2619435920]Created alert : (:CRSAGF00130:) :  Failed to start the agent /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:56:06.713: [ AGFW][2619435920] Can not stop the agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle because pid is not initialized
2015-03-08 14:56:06.714: [ AGFW][2619435920] Agfw Proxy Server sending the last reply to PE for message:RESOURCE_CLEAN[ggate 1 1] ID 4100:2487
...
...
...