hanghangyang 发表于 2015-3-8 15:30:53

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

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

双节点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文件夹)

如下:

#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'
#crsctl setperm resource mycorp-oragg-vip -u user:oracle:r-x
#crsctl setperm resource mycorp-oragg-vip -u user:grid:r-x
#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
#crsctl status resource mycorp-oragg-vip
NAME=mycorp-oragg-vip
TYPE=app.appvip.type
TARGET=ONLINE
STATE=ONLINE on 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)'"
#crsctl setperm resource ggate -o oracle
#su - oracle
$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.
$


-----alertnode1.log-----------------------------------------------------
2015-03-08 14:53:06.436
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
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: S(0xb55ec30): set Properties ( oracle,0xb507cf8)
2015-03-08 14:50:06.107: processMessage called
2015-03-08 14:50:06.107: Container [ Name: UI_START
        CLIENT:
        TextMessage[]
        CLIENT_PRIMARY_GROUP:
        TextMessage
        LOCALE:
        TextMessage
        QUEUE_TAG:
        TextMessage
        RESOURCE:
        TextMessage
]
2015-03-08 14:50:06.107: Sending message to PE. ctx= 0xb563e30
2015-03-08 14:50:06.107: [  CRSCCL]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]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]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] Agfw Proxy Server received the message: RESOURCE_START ID 4098:2323
2015-03-08 14:50:06.113: [    AGFW] Creating the resource: ggate 1 1
2015-03-08 14:50:06.114: [    AGFW] Initializing the resource ggate 1 1 for type cluster_resource
2015-03-08 14:50:06.114: [    AGFW] SR: acl = owner:oracle:rwx,pgrp:root:r-x,other::r--
2015-03-08 14:50:06.114: [    AGFW] 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] Starting the HB for agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:50:06.120: Container [ Name: ORDER
        MESSAGE:
        TextMessage
        MSGTYPE:
        TextMessage
        OBJID:
        TextMessage
        WAIT:
        TextMessage
]
2015-03-08 14:53:06.436: [    AGFW]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] 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] Agfw Proxy Server sending the last reply to PE for message:RESOURCE_START ID 4098:2323
2015-03-08 14:53:06.437: [  CRSCCL]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]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]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] Agfw Proxy Server received the message: RESOURCE_CLEAN ID 4100:2487
2015-03-08 14:53:06.440: [    AGFW] 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] Starting the HB for agent: /u01/app/grid/product/11.2.0/gd_1/bin/scriptagent_oracle
2015-03-08 14:53:06.446: [    AGFW] Could not forward message 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] 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]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: Container [ Name: ORDER
        MESSAGE:
        TextMessage
        MSGTYPE:
        TextMessage
        OBJID:
        TextMessage
        WAIT:
        TextMessage
]
2015-03-08 14:53:06.448: Container [ Name: ORDER
        MESSAGE:
        TextMessage
        MSGTYPE:
        TextMessage
        OBJID:
        TextMessage
        WAIT:
        TextMessage
]
2015-03-08 14:56:06.713: [    AGFW]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] 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] Agfw Proxy Server sending the last reply to PE for message:RESOURCE_CLEAN ID 4100:2487
...
...
...

hanghangyang 发表于 2015-3-8 15:33:40

自己先顶一下。

hanghangyang 发表于 2015-3-9 09:16:19

没有人吗?

hanghangyang 发表于 2015-3-10 11:34:05

...............

Liu Maclean(刘相兵 发表于 2015-3-24 21:59:23

我没有做过类似操作, 但似乎你可以参考这份文档:
http://www.oracle.com/technetwork/products/clusterware/overview/ogg-xag-bp-1915977.pdf

hanghangyang 发表于 2015-5-5 15:41:52

本帖最后由 hanghangyang 于 2015-5-5 15:48 编辑

Liu Maclean(刘相兵 发表于 2015-3-24 21:59 static/image/common/back.gif
我没有做过类似操作, 但似乎你可以参考这份文档:
http://www.oracle.com/technetwork/products/clusterwa ...

可能是版本有问题,上面的是基础版本,后来在11.2.0.4的RAC上,GG版本12.1.2.1.0,做同样的测试没有问题。

hanghangyang 发表于 2015-5-5 15:49:10

Liu Maclean(刘相兵 发表于 2015-3-24 21:59 static/image/common/back.gif
我没有做过类似操作, 但似乎你可以参考这份文档:
http://www.oracle.com/technetwork/products/clusterwa ...

确实是版本不支持,你上面给的PDF中,确实要求GI11.2.0.3.+版本的,我的GI与数据库版本号一致。
页: [1]
查看完整版本: 集群环境中配置GoldenGate过程中,启动GG资源时失败,如下。