免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12
最近访问板块 发新帖
楼主: asker8848

[GG] GoldenGate 注册 crs 资源后,启动出错 [复制链接]

论坛徽章:
0
发表于 2013-10-12 13:43 |显示全部楼层
本帖最后由 asker8848 于 2013-10-12 14:44 编辑
www_xylove 发表于 2013-10-11 23:06
vi  racgvip  找到 FAIL_WHEN_DEFAULTGW_NOT_FOUND -eq 1  ,把1改为0
试试看吧

您好!
修改了两个节点的 $CRS_HOME/bin/racgvip 文件,将 FAIL_WHEN_DEFAULTGW_NOT_FOUND 参数的值由1改为0,重新创建 ggatevip资源,启动还是报一样的错误。
请问是怎么回事呢?
FAIL_WHEN_DEFAULTGW_NOT_FOUND 这个参数是配置默认网关是否找到的?我的RAC两节点的eth0(公用网卡)和eth1(私用网卡)都设置到网关IP的,分别是 192.168.123.1、10.0.0.1

论坛徽章:
0
发表于 2013-10-15 14:56 |显示全部楼层
www_xylove 发表于 2013-10-11 23:06
vi  racgvip  找到 FAIL_WHEN_DEFAULTGW_NOT_FOUND -eq 1  ,把1改为0
试试看吧

-----
试过,还是不行。。我的RAC数据库是由 10.2.0.1.0 升级到 10.2.0.3.0 的。
测试在升级前的 10.2.0.1.0 版本中,创建GoldenGate的crs资源  ggatevip ,是可以成功启动online的。
但在 升级后的   10.2.0.3.0 RAC环境,创建GoldenGate的crs资源  ggatevip ,启动时,crsd.log 报下面的错误了:

2013-10-15 14:35:17.696: [    CRSD][1501669696]0SM: rE2Ec: 4
2013-10-15 14:35:17.696: [  CRSRES][1539459392]0StopResource: setting CLI values
2013-10-15 14:35:18.086: [    CRSD][1539459392]0SM:dE2Ec: all E2E cmds done. 0
2013-10-15 14:40:40.496: [  CRSRES][1539459392]0Resource Registered: ggsvip
2013-10-15 14:41:24.078: [  CRSRES][1510074688]0Attempting to start `ggsvip` on member `dbs`
2013-10-15 14:41:24.301: [  CRSRES][1510074688][ALERT]0`ggsvip` on member `dbs` has experienced an unrecoverable failure.
2013-10-15 14:41:24.301: [  CRSRES][1510074688]0Human intervention required to resume its availability.
----
不知是什么原因导致的。我将 10.2.0.1.0 中的$CRS_HOME/bin 中 的 crs_profile、crs_register、crs_setperm 程序文件复制到升级后的 10.2.0.3.0 RAC环境中,重新创建 ggatevip 资源,启动还是报上面的错误。。。
真不知道是什么原因导致的,请问有谁可以帮我看看,是啥原因导致的吗?感谢!

论坛徽章:
7
天蝎座
日期:2013-08-16 23:19:32丑牛
日期:2014-01-08 09:20:14寅虎
日期:2014-01-11 11:03:44午马
日期:2014-04-28 11:02:40天秤座
日期:2014-05-16 23:24:24摩羯座
日期:2014-07-20 10:46:04卯兔
日期:2014-08-08 15:21:41
发表于 2013-10-15 21:52 |显示全部楼层
这个就有点是疑难杂症了,建议你到Metalink里申请二级SR,交由oracle suppor处理。

论坛徽章:
0
发表于 2013-10-15 22:05 |显示全部楼层
本帖最后由 asker8848 于 2013-10-15 22:14 编辑
www_xylove 发表于 2013-10-15 21:52
这个就有点是疑难杂症了,建议你到Metalink里申请二级SR,交由oracle suppor处理。

----
www_xylove,现在旧版本的RAC 10.2.0.1.0 中创建启动 ggatevip 资源成功online了,但启动以下命令创建的 GoldenGate_app 资源报错:
[oracle@dbp tmp]$ $CRS_HOME/bin/crs_profile -create GoldenGate_app \
-t application \
-r ggatevip \
-a /u01/ggs/GoldenGate_action.scr \
-o ci=10

[oracle@dbp tmp]$ $CRS_HOME/bin/crs_register GoldenGate_app

[root@dbp tmp]# /oracle/product/crs/bin/crs_setperm GoldenGate_app -o root
[root@dbp tmp]# /oracle/product/crs/bin/crs_setperm GoldenGate_app -u userracle:r-x

GoldenGate_app 启动报如下错误:

[oracle@dbp tmp]$ crs_start GoldenGate_app
Attempting to start `ggatevip` on member `dbp`
Start of `ggatevip` on member `dbp` succeeded.
Attempting to start `GoldenGate_app` on member `dbp`
Start of `GoldenGate_app` on member `dbp` failed.
Attempting to stop `ggatevip` on member `dbp`
Stop of `ggatevip` on member `dbp` succeeded.
Attempting to start `ggatevip` on member `dbs`
Start of `ggatevip` on member `dbs` succeeded.
Attempting to start `GoldenGate_app` on member `dbs`
Start of `GoldenGate_app` on member `dbs` failed.
Attempting to stop `ggatevip` on member `dbs`
Stop of `ggatevip` on member `dbs` succeeded.
CRS-1006: No more members to consider

CRS-0215: Could not start resource 'GoldenGate_app'.

----
搜索网上CRS-1006 和 CRS-0215 说是没添加eth0的默认网关导致,但我已经在 eth0网卡中添加了网关地址 192.168.123.1的,
并且也使用命令 route add default gw 192.168.123.1 添加了默认网关地址,但启动 GoldenGate_app  还是报以上错误。

------------------ crsd.log 日志如下: ------------------
2013-10-15 21:44:34.704: [  OCRSRV][1240025408]th_select_handler: Failed to retrieve procctx from ht. constr = [-1409017072] retval lht [-27] Signal CV.
2013-10-15 21:44:59.181: [  CRSRES][1607170368]0startRunnable: setting CLI values
2013-10-15 21:44:59.186: [  CRSRES][1607170368]0Attempting to start `ggatevip` on member `dbp`
2013-10-15 21:45:04.308: [  CRSRES][1607170368]0Start of `ggatevip` on member `dbp` succeeded.
2013-10-15 21:45:04.427: [  CRSRES][1607170368]0startRunnable: setting CLI values
2013-10-15 21:45:04.695: [  CRSRES][1607170368]0Attempting to start `GoldenGate_app` on member `dbp`
2013-10-15 21:45:10.164: [  CRSAPP][1607170368]0StartResource error for GoldenGate_app error code = 1
2013-10-15 21:45:10.618: [  CRSRES][1607170368]0Start of `GoldenGate_app` on member `dbp` failed.
2013-10-15 21:45:10.619: [  CRSRES][1607170368]0StopResource: setting CLI values
2013-10-15 21:45:10.650: [  CRSRES][1607170368]0Attempting to stop `ggatevip` on member `dbp`
2013-10-15 21:45:10.710: [  CRSRES][1607170368]0Stop of `ggatevip` on member `dbp` succeeded.
2013-10-15 21:45:11.893: [  CRSRES][1607170368]0Attempting to start `ggatevip` on member `dbs`
2013-10-15 21:45:17.515: [  CRSRES][1607170368]0Start of `ggatevip` on member `dbs` succeeded.
2013-10-15 21:45:17.652: [  CRSRES][1607170368]0Attempting to start `GoldenGate_app` on member `dbs`
2013-10-15 21:45:23.120: [  CRSRES][1607170368]0Start of `GoldenGate_app` on member `dbs` failed.
2013-10-15 21:45:23.121: [  CRSRES][1607170368]0StopResource: setting CLI values
2013-10-15 21:45:24.126: [  CRSRES][1607170368]0Attempting to stop `ggatevip` on member `dbs`
2013-10-15 21:45:24.969: [  CRSRES][1607170368]0Stop of `ggatevip` on member `dbs` succeeded.
2013-10-15 21:45:25.007: [  CRSRES][1607170368]0CRS-1006: No more members to consider

2013-10-15 21:50:44.605: [  OCRSRV][1240025408]th_select_handler: Failed to retrieve procctx from ht. constr = [-1408718704] retval lht [-27] Signal CV.


------------------ ocssd.log 日志如下: ------------------
[    CSSD]2013-10-15 21:56:58.171 [1158240576] >TRACE:   clssgmClientConnectMsg: Connect from con(0x2aaaac08b600) proc(0x2aaaac06def0) pid() proto(10:2:1:1)
[    CSSD]2013-10-15 21:56:59.526 [1200200000] >TRACE:   clssnmPollingThread: node dbp (1) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:14.330 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:20.486 [1200200000] >TRACE:   clssnmPollingThread: node dbp (1) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:42.445 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:44.566 [1200200000] >TRACE:   clssnmPollingThread: node dbp (1) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:45.575 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:47.821 [1200200000] >TRACE:   clssnmPollingThread: node dbp (1) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:58.428 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
[    CSSD]2013-10-15 21:57:58.572 [1158240576] >TRACE:   clssgmClientConnectMsg: Connect from con(0x2aaaac08b600) proc(0x2aaaac06def0) pid() proto(10:2:1:1)
[    CSSD]2013-10-15 21:57:58.682 [1158240576] >TRACE:   clssgmClientConnectMsg: Connect from con(0x2aaaac06efa0) proc(0x2aaaac065aa0) pid() proto(10:2:1:1)
[    CSSD]2013-10-15 21:58:04.453 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
[    CSSD]2013-10-15 21:58:10.589 [1200200000] >TRACE:   clssnmPollingThread: node dbs (2) missed(2) checkin(s)
--------

能帮忙看看是啥回事吗?感谢!!!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP