Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

6

主题
发表于 2015-3-8 15:30:53 | 查看: 2120| 回复: 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
...
...
...

log与参考资料.rar

613.77 KB, 下载次数: 637

发表于 2015-3-8 15:33:40
自己先顶一下。

回复 显示全部楼层 道具 举报

发表于 2015-3-9 09:16:19
没有人吗?

回复 显示全部楼层 道具 举报

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

回复 显示全部楼层 道具 举报

发表于 2015-3-24 21:59:23
我没有做过类似操作, 但似乎你可以参考这份文档:
http://www.oracle.com/technetwor ... -xag-bp-1915977.pdf

回复 显示全部楼层 道具 举报

发表于 2015-5-5 15:41:52
本帖最后由 hanghangyang 于 2015-5-5 15:48 编辑
Liu Maclean(刘相兵 发表于 2015-3-24 21:59
我没有做过类似操作, 但似乎你可以参考这份文档:
http://www.oracle.com/technetwork/products/clusterwa ...


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

回复 显示全部楼层 道具 举报

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


确实是版本不支持,你上面给的PDF中,确实要求GI11.2.0.3.+版本的,我的GI与数据库版本号一致。

回复 显示全部楼层 道具 举报

您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-1-24 20:01 , Processed in 0.075760 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569