Oracle数据库数据恢复、性能优化

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

5

积分

1

好友

2

主题
1#
发表于 2013-8-30 16:57:19 | 查看: 5205| 回复: 2
OS:Red Hat Enterprise Linux Server release 5.4
Grid Infrastructure:11203
oracle software: 11203
准备为实验环境进行升级 从11203升级到11204
在升级grid的时候遇到问题

在图形界面升级
setup 4:node selection 中 点击next出现问题,报错为
[INS-41705] One or more nodes that are part of the cluster are down.

details:
Cause - One or more nodes that are part of the cluster cannot be reached  Action - Ensure that all the nodes selected that are part of the cluster are up.

查看资源状态
[root@rac1 soft]# /u01/app/grid/product/11.2.0/bin/crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DG1.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.DG2.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.DG3.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.DG4.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac1        
ora.fxz1.db    ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2  


[root@rac1 bin]# ./crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online


[root@rac2 bin]# ./crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

[root@rac2 bin]# ./srvctl status server -n rac1,rac2
Server name: rac1
Server state: ONLINE
Server name: rac2
Server state: ONLINE
请问如何解决改问题


截图.jpg (69.6 KB, 下载次数: 204)

错误截图

错误截图

2#
发表于 2013-8-30 22:24:41
追加检查
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n rac1,rac2 -rolling -src_crshome /u01/app/grid/product/11.2.0 -dest_crshome /u01/app/grid/product/11.2.0.4 -dest_version 11.2.0.3.0 -fixup -fixupdir /home/grid/fixup -verbose

Performing pre-checks for cluster services setup

Checking node reachability...
PRVF-6006 : Unable to reach any of the nodes
PRKC-1071 : Nodes "rac2,rac1" did not respond to ping in "3" seconds,
PRKN-1035 : Host "rac2" is unreachable
PRKN-1035 : Host "rac1" is unreachable

回复 只看该作者 道具 举报

3#
发表于 2013-8-30 22:27:52
[root@rac1 grid]# /etc/init.d/ip6tables
Usage: /etc/init.d/ip6tables {start|stop|restart|condrestart|status|panic|save}
[root@rac1 grid]# /etc/init.d/ip6tables status
Firewall is stopped.
[root@rac1 grid]# ping rac2
PING rac2 (192.168.1.32) 56(84) bytes of data.
64 bytes from rac2 (192.168.1.32): icmp_seq=1 ttl=64 time=12.7 ms
^C
--- rac2 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 12.710/12.710/12.710/0.000 ms
[root@rac1 grid]# ping rac2-priv
PING rac2-priv (192.168.2.32) 56(84) bytes of data.
64 bytes from rac2-priv (192.168.2.32): icmp_seq=1 ttl=64 time=0.544 ms
64 bytes from rac2-priv (192.168.2.32): icmp_seq=2 ttl=64 time=0.896 ms
^C
--- rac2-priv ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.544/0.720/0.896/0.176 ms

[root@rac2 ~]# /etc/init.d/iptables status
Firewall is stopped.
[root@rac2 ~]# /etc/init.d/ip6tables status
Firewall is stopped.
[root@rac2 ~]# ping rac1
PING rac1 (192.168.1.31) 56(84) bytes of data.
64 bytes from rac1 (192.168.1.31): icmp_seq=1 ttl=64 time=0.773 ms
^C
--- rac1 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.773/0.773/0.773/0.000 ms
[root@rac2 ~]# ping rac1-priv
PING rac1-priv (192.168.2.31) 56(84) bytes of data.
64 bytes from rac1-priv (192.168.2.31): icmp_seq=1 ttl=64 time=1.04 ms
64 bytes from rac1-priv (192.168.2.31): icmp_seq=2 ttl=64 time=0.992 ms
^C
--- rac1-priv ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1001ms
rtt min/avg/max/mdev = 0.992/1.020/1.049/0.042 ms

回复 只看该作者 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-17 20:16 , Processed in 0.049766 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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