查看: 2622|回复: 7

[升级] oracle rac升级问题

[复制链接]
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
发表于 2010-9-13 22:34 | 显示全部楼层 |阅读模式
我有一个四个节点的rac.
linux+oracle (10.2.0.1) rac

crs和oracle软件我都已经安装好啦。。一切都很正常。。。
下面我就对crs和oracle做了升级。升级过程也没有问题(版本10.2.0.4)

但是下面开始建asm实例的时候就有问题。。
用dbca和srvctl来创建都只能起两个asm实例。。。是任意两个。。只要起了两个。。其它两个就起不来。

这个版本的安装和升级以前做过没有碰见过。。。


大家有没有碰见这种问题的啊??
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
 楼主| 发表于 2010-9-13 22:40 | 显示全部楼层
手动建asm实例:
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl add asm -n node1test -i +ASM1  -o /opt/ora10g/product/10.2.0/db_1/
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl add asm -n node2test -i +ASM2  -o /opt/ora10g/product/10.2.0/db_1/
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl add asm -n node3test -i +ASM3  -o /opt/ora10g/product/10.2.0/db_1/
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl add asm -n node4test -i +ASM4  -o /opt/ora10g/product/10.2.0/db_1/
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    OFFLINE   OFFLINE
ora....ST.lsnr application    ONLINE    ONLINE    node1test
ora....est.gsd application    ONLINE    ONLINE    node1test
ora....est.ons application    ONLINE    ONLINE    node1test
ora....est.vip application    ONLINE    ONLINE    node1test
ora....SM2.asm application    OFFLINE   OFFLINE
ora....ST.lsnr application    ONLINE    ONLINE    node2test
ora....est.gsd application    ONLINE    ONLINE    node2test
ora....est.ons application    ONLINE    ONLINE    node2test
ora....est.vip application    ONLINE    ONLINE    node2test
ora....SM3.asm application    OFFLINE   OFFLINE
ora....ST.lsnr application    ONLINE    ONLINE    node3test
ora....est.gsd application    ONLINE    ONLINE    node3test
ora....est.ons application    ONLINE    ONLINE    node3test
ora....est.vip application    ONLINE    ONLINE    node3test
ora....SM4.asm application    OFFLINE   OFFLINE
ora....ST.lsnr application    ONLINE    ONLINE    node4test
ora....est.gsd application    ONLINE    ONLINE    node4test
ora....est.ons application    ONLINE    ONLINE    node4test
ora....est.vip application    ONLINE    ONLINE    node4test

使用道具 举报

回复
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
 楼主| 发表于 2010-9-13 22:42 | 显示全部楼层
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl start asm -n node1test
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl start asm -n node2test
[node1test][oracle][/opt/ora10g/product/10.2.0/crs_1/bin]#./srvctl start asm -n node3test


当我起第三个asm实例的时候就卡在这边。。。

使用道具 举报

回复
论坛徽章:
98
2009日食纪念
日期:2009-07-22 09:30:002010新春纪念徽章
日期:2010-03-01 11:05:012010年世界杯参赛球队:美国
日期:2010-05-02 21:32:232010数据库技术大会纪念徽章
日期:2010-05-13 09:34:23ITPUB季度 技术新星
日期:2010-05-17 15:53:17数据库板块每日发贴之星
日期:2010-05-24 01:01:072010年世界杯参赛球队:意大利
日期:2010-05-31 20:55:432010年世界杯参赛球队:巴拉圭
日期:2010-07-03 13:06:582010世博会纪念徽章
日期:2010-08-18 23:53:44ITPUB9周年纪念徽章
日期:2010-10-08 09:28:51
发表于 2010-9-14 13:15 | 显示全部楼层
具体的报错呢?

使用道具 举报

回复
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
 楼主| 发表于 2010-9-14 13:23 | 显示全部楼层
crs.log:

2010-09-13 22:03:26.070: [  CRSRES][1495955776]0Start of `ora.node3test.gsd` on member `node3test` succeeded.
2010-09-13 22:03:27.088: [  CRSRES][1493854528]0Start of `ora.node3test.ons` on member `node3test` succeeded.
2010-09-13 22:08:56.385: [  CRSRES][1495955776]0StopResource: setting CLI values
2010-09-13 22:09:03.969: [  CRSRES][1491753280]0StopResource: setting CLI values
2010-09-13 22:09:12.285: [  CRSRES][1491753280]0startRunnable: setting CLI values
2010-09-13 22:09:14.406: [  CRSRES][1491753280]0StopResource: setting CLI values
2010-09-13 22:09:51.941: [  CRSRES][1491753280]0startRunnable: setting CLI values
2010-09-13 22:13:50.938: [  CRSRES][1491753280]0ora.node3test.ASM3.asm target set to OFFLINE before stop action
2010-09-13 22:13:50.939: [  CRSRES][1491753280]0StopResource: setting CLI values
2010-09-13 22:13:50.944: [  CRSEVT][1491753280]0CAAMonitorHandler :: 0:Action Script for resource 'ora.node3test.ASM3.asm' stdout redirection failed for `/opt/ora10g/product/10.2.0/crs_1/crs/log/stopBHzcbQ.stdout` : No such file or directory
2010-09-13 22:21:53.732: [  CRSRES][1491753280]0startRunnable: setting CLI values
2010-09-13 22:21:54.539: [  CRSEVT][1491753280]0CAAMonitorHandler :: 0:Action Script for resource 'ora.node3test.ASM3.asm' stdout redirection failed for `/opt/ora10g/product/10.2.0/crs_1/crs/log/startdQvRjR.stdout` : No such file or directory
2010-09-13 22:34:31.812: [  CRSRES][1493854528]0CRS-1002: Resource 'ora.node3test.ASM3.asm' is already running on member 'node3test'
2010-09-13 22:36:09.776: [  CRSRES][1491753280]0ora.node3test.ASM3.asm target set to OFFLINE before stop action
2010-09-13 22:36:09.776: [  CRSRES][1491753280]0StopResource: setting CLI values
2010-09-13 22:36:09.781: [  CRSEVT][1491753280]0CAAMonitorHandler :: 0:Action Script for resource 'ora.node3test.ASM3.asm' stdout redirection failed for `/opt/ora10g/product/10.2.0/crs_1/crs/log/stopDxtA25.stdout` : No such file or directory
2010-09-13 22:41:42.912: [  CRSRES][1491753280]0startRunnable: setting CLI values
2010-09-13 22:41:43.363: [  CRSEVT][1491753280]0CAAMonitorHandler :: 0:Action Script for resource 'ora.node3test.ASM3.asm' stdout redirection failed for `/opt/ora10g/product/10.2.0/crs_1/crs/log/start5MfL56.stdout` : No such file or directoryc

使用道具 举报

回复
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
 楼主| 发表于 2010-9-14 13:25 | 显示全部楼层
下面我是通过os重启查到的log:
   
Sep 13 21:34:38 node3test avahi-daemon[4133]: Registering new address record for 192.168.100.243 on eth2.
Sep 13 21:42:44 node3test avahi-daemon[4133]: Withdrawing address record for 192.168.100.243 on eth2.
Sep 13 21:42:45 node3test logger: Oracle CSSD graceful shutdown
Sep 13 21:43:57 node3test init: Re-reading inittab
Sep 13 21:44:07 node3test root: Oracle Cluster Ready Services starting by user request.
Sep 13 21:44:10 node3test root: Cluster Ready Services completed waiting on dependencies.
Sep 13 21:44:10 node3test init: Re-reading inittab
Sep 13 21:44:12 node3test logger: Cluster Ready Services completed waiting on dependencies.
Sep 13 21:44:12 node3test logger: Cluster Ready Services completed waiting on dependencies.
Sep 13 21:44:12 node3test logger: Running CRSD with TZ =
Sep 13 21:44:12 node3test logger: Cluster Ready Services completed waiting on dependencies.
Sep 13 21:44:12 node3test logger: Oracle CSS Family monitor starting.
Sep 13 21:44:14 node3test logger: Oracle CSS restart. 0, 1
Sep 13 21:44:27 node3test avahi-daemon[4133]: Registering new address record for 192.168.100.243 on eth2.
Sep 13 21:56:24 node3test avahi-daemon[4133]: Withdrawing address record for 192.168.100.243 on eth2.
Sep 13 22:00:51 node3test kernel: sd 1:0:2:0: reservation conflict
Sep 13 22:00:51 node3test kernel: sd 1:0:2:0: SCSI error: return code = 0x00000018
Sep 13 22:00:51 node3test kernel: end_request: I/O error, dev sdd, sector 48
Sep 13 22:00:52 node3test logger: Oracle CSSD failure 134.
Sep 13 22:01:48 node3test syslogd 1.4.1: restart.
Sep 13 22:01:48 node3test kernel: klogd 1.4.1, log source = /proc/kmsg started.
Sep 13 22:01:48 node3test kernel: Linux version 2.6.18-92.el5 (brewbuilder@ls20-bc2-13.build.redhat.com) (gcc version 4.1.2 20071124 (Red Hat 4.1.2-41)) #1 SMP Tue Apr 29 13:16:15 EDT 2008


因为报cssd的问题我看了一下对应的log:

[    CSSD]2010-09-13 21:42:44.569 [1167178048] >TRACE:   clssgmClientShutdown: waited 0 seconds on 5 IO capable clients
[    CSSD]2010-09-13 21:42:44.574 [1167178048] >TRACE:   clscsendx: (0xd13110) Physical connection (0xd09cf0) not active
[    CSSD]2010-09-13 21:42:44.575 [1167178048] >TRACE:   clssgmSendClient: Send failed rc 11, con (0xd13110), client (0xd13410), proc ((nil))
[    CSSD]2010-09-13 21:42:44.575 [1167178048] >WARNING: clssgmClientShutdown: graceful shutdown completed.
[    CSSD]2010-09-13 21:44:17.439 >USER:    Copyright 2010, Oracle version 10.2.0.4.0
[    CSSD]2010-09-13 21:44:17.439 >USER:    CSS daemon log for node node3test, number 3, in cluster crs
[  clsdmt]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=node3testDBG_CSSD))
[    CSSD]2010-09-13 21:44:17.492 [2203477232] >TRACE:   clssscmain: local-only set to false
[    CSSD]2010-09-13 21:44:17.515 [2203477232] >TRACE:   clssnmReadNodeInfo: added node 1 (node1test) to cluster
[    CSSD]2010-09-13 21:44:17.531 [2203477232] >TRACE:   clssnmReadNodeInfo: added node 2 (node2test) to cluster
[    CSSD]2010-09-13 21:44:17.547 [2203477232] >TRACE:   clssnmReadNodeInfo: added node 3 (node3test) to cluster
[    CSSD]2010-09-13 21:44:17.564 [2203477232] >TRACE:   clssnmReadNodeInfo: added node 4 (node4test) to cluster
[    CSSD]2010-09-13 21:44:17.576 [1133930816] >TRACE:   clssnm_skgxninit: Compatible vendor clusterware not in use
[    CSSD]2010-09-13 21:44:17.576 [1133930816] >TRACE:   clssnm_skgxnmon: skgxn init failed
[    CSSD]2010-09-13 21:44:17.584 [2203477232] >TRACE:   clssnmNMInitialize: misscount set to (60)
[    CSSD]2010-09-13 21:44:17.587 [2203477232] >TRACE:   clssnmNMInitialize: Network heartbeat thresholds are: impending reconfig 30000 ms, reconfig start (misscount) 60000 ms
[    CSSD]2010-09-13 21:44:17.598 [2203477232] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//dev/raw/raw2)
[    CSSD]2010-09-13 21:44:17.598 [1133930816] >TRACE:   clssnmvDPT: spawned for disk 0 (/dev/raw/raw2)
[    CSSD]2010-09-13 21:44:19.613 [1133930816] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//dev/raw/raw2)
[    CSSD]2010-09-13 21:44:19.620 [1144420672] >TRACE:   clssnmvKillBlockThread: spawned for disk 0 (/dev/raw/raw2) initial sleep interval (1000)ms
[    CSSD]2010-09-13 21:44:19.625 [2203477232] >TRACE:   clssnmFatalInit: fatal mode enabled
[    CSSD]2010-09-13 21:44:19.643 [1165400384] >TRACE:   clssnmClusterListener: Listening on (ADDRESS=(PROTOCOL=tcp)(HOST=node3test-priv)(PORT=49895))
[    CSSD]2010-09-13 21:44:19.643 [1165400384] >TRACE:   clssnmconnect: connecting to node(1), con(0x1670dbd0), flags 0x0003
[    CSSD]2010-09-13 21:44:19.644 [1165400384] >TRACE:   clssnmconnect: connecting to node(2), con(0x167107f0), flags 0x0003
[    CSSD]2010-09-13 21:44:19.644 [1165400384] >TRACE:   clssnmClusterListener: Probing node node4test (4), probcon(0x16713410)
[    CSSD]2010-09-13 21:44:19.680 [1133930816] >TRACE:   clssnmReadDskHeartbeat: node(1) is down. rcfg(10) wrtcnt(585) LATS(20382224) Disk lastSeqNo(585)
[    CSSD]2010-09-13 21:44:19.680 [1133930816] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(10) wrtcnt(316) LATS(20382224) Disk lastSeqNo(316)
[    CSSD]2010-09-13 21:44:19.680 [1133930816] >TRACE:   clssnmReadDskHeartbeat: node(4) is down. rcfg(10) wrtcnt(19471) LATS(20382224) Disk lastSeqNo(19471)
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: MSGSRC 2, type 6, node 2, flags 0x0003, con 0x167107f0, probe (nil)
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: node 2, node2test, con(0x167107f0), probcon((nil)), ninfcon(0x167107f0), node unique 1284385135, prev unique 0, msg unique 1284385135 node state 0
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: connected to node 2 (con 0x167107f0), ninfcon (0x167107f0), state (0), flag (1039)
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: MSGSRC 1, type 6, node 1, flags 0x0003, con 0x1670dbd0, probe (nil)
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: node 1, node1test, con(0x1670dbd0), probcon((nil)), ninfcon(0x1670dbd0), node unique 1284384866, prev unique 0, msg unique 1284384866 node state 0
[    CSSD]2010-09-13 21:44:19.682 [1165400384] >TRACE:   clssnmConnComplete: connected to node 1 (con 0x1670dbd0), ninfcon (0x1670dbd0), state (0), flag (1039)
[    CSSD]2010-09-13 21:44:19.683 [1165400384] >WARNING: clssnmeventhndlr: Receive failure during connect node 4 (node4test), con(0x16713410), probe(0x16713410), rc=10
[    CSSD]2010-09-13 21:44:19.683 [1165400384] >TRACE:   clssnmDiscHelper: node4test, node(4) connection failed, con (0x16713410), probe(0x16713410)
[    CSSD]2010-09-13 21:44:19.683 [1165400384] >TRACE:   clssnmConnComplete: MSGSRC 4, type 5, node 4, flags 0x0001, con 0x1674a570, probe (nil)

使用道具 举报

回复
论坛徽章:
114
授权会员
日期:2005-10-30 17:05:332013年新春福章
日期:2013-02-25 14:51:24奔驰
日期:2013-08-01 21:18:36宝马
日期:2013-12-04 21:52:282014年新春福章
日期:2014-02-18 16:41:11马上有车
日期:2014-02-18 16:41:11马上有车
日期:2014-02-19 11:55:14马上有房
日期:2014-02-19 11:55:14马上有钱
日期:2014-02-19 11:55:14马上有对象
日期:2014-02-19 11:55:14
发表于 2010-9-14 14:14 | 显示全部楼层
服务器时间同步做了吗?

使用道具 举报

回复
论坛徽章:
27
参与WIN7挑战赛纪念
日期:2009-11-06 16:05:25ITPUB元老
日期:2011-04-23 17:54:35ITPUB十周年纪念徽章
日期:2011-11-01 16:24:04奥迪
日期:2013-08-05 09:30:132015年新春福章
日期:2015-03-02 10:21:23弗兰奇
日期:2016-12-28 13:54:54
 楼主| 发表于 2010-9-14 14:56 | 显示全部楼层
我用ntp做了啊 。。
不过有时也有点差。。。

使用道具 举报

回复

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

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表