花費一天一夜解決RAC故障(一)
安裝完RAC出現的問題【問題解決】
具體環境:
資料庫版本是10.2.0.1 作業系統是:2.6.9-55.0.0.0.2.ELhugemem
出錯的原因:
我在虛機上安裝的,起初安裝完畢沒有報任何錯誤.由於安裝完畢後,機器巨慢,我就強制將機器重啟後,隨後出現下面問題.
資料庫執行狀態:
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dbvdb.db application ONLINE UNKNOWN rac1
ora....b1.inst application ONLINE OFFLINE
ora....b2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE UNKNOWN rac1
ora....C1.lsnr application ONLINE UNKNOWN rac1
ora.rac1.gsd application ONLINE UNKNOWN rac1
ora.rac1.ons application ONLINE UNKNOWN rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE UNKNOWN rac2
ora....C2.lsnr application ONLINE UNKNOWN rac2
ora.rac2.gsd application ONLINE UNKNOWN rac2
ora.rac2.ons application ONLINE UNKNOWN rac2
ora.rac2.vip application ONLINE ONLINE rac2
服務GSD,ONS,LISTENER起不來
rac1-> srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is not running on node: rac1
Listener is not running on node: rac1
ONS daemon is not running on node: rac1
發現ASM也沒起來
rac1-> srvctl status asm -n rac1
ASM instance +ASM1 is not running on node rac1.
叢集件不能正常啟動
[root@rac1 ~]# /u01/oracle/product/10.2.0/crs_1/bin/cluvfy stage -post crsinst -n rac1,rac2
Performing post-checks for cluster services setup
Checking node reachability...
Node reachability check passed from node "rac1".
Checking user equivalence...
User equivalence check failed for user "root".
Check failed on nodes:
rac2,rac1
ERROR:
User equivalence unavailable on all the nodes.
Verification cannot proceed.
Post-check for cluster services setup was unsuccessful on all the nodes.
節點1的CRS正常
rac1-> crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
節點2的CRS不能正常啟動!
網路檢查:
rac1-> ping 192.168.0.4 //RAC2的主機地址 狀態OK//
PING 192.168.0.4 (192.168.0.4) 56(84) bytes of data.
64 bytes from 192.168.0.4: icmp_seq=0 ttl=64 time=2.03 ms
64 bytes from 192.168.0.4: icmp_seq=1 ttl=64 time=0.736 ms
--- 192.168.0.4 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1002ms
rtt min/avg/max/mdev = 0.736/1.387/2.038/0.651 ms, pipe 2
rac1-> ping 192.168.0.32 //RAC2的私有地址 狀態OK//
PING 192.168.0.32 (192.168.0.32) 56(84) bytes of data.
64 bytes from 192.168.0.32: icmp_seq=0 ttl=64 time=5.69 ms
64 bytes from 192.168.0.32: icmp_seq=1 ttl=64 time=0.124 ms
--- 192.168.0.32 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1005ms
rtt min/avg/max/mdev = 0.124/2.907/5.691/2.784 ms, pipe 2
rac1-> ping 10.10.10.32 //RAC2的VIP 狀態OK//
PING 10.10.10.32 (10.10.10.32) 56(84) bytes of data.
64 bytes from 10.10.10.32: icmp_seq=0 ttl=64 time=2.96 ms
64 bytes from 10.10.10.32: icmp_seq=1 ttl=64 time=0.000 ms
--- 10.10.10.32 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1004ms
rtt min/avg/max/mdev = 0.000/1.482/2.964/1.482 ms, pipe 2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8334342/viewspace-373137/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 花費一天一夜解決RAC故障(三)
- 花費一天一夜解決RAC故障(二)
- TSM故障問題解決一則
- 解決儲存硬碟故障一則硬碟
- NFS故障解決NFS
- 解決技術債務的花費:每行程式碼3.61美金行程
- Rownum分頁故障解決一例
- 從一次故障解決想到的
- 一次ASM環境故障解決ASM
- 【故障處理】一次RAC故障處理過程
- 故障解決法(摘抄)
- ORA-03232故障解決一例
- 求救!弄了一天JiveJdon,還是未解決
- 11gR2 RAC使用SCAN故障切換問題的解決方案
- 《Oracle RAC配置與優化》第一天Oracle優化
- 一次網路丟包故障的解決
- [Oracle]--Library cache lock 故障解決一例Oracle
- solaris單使用者解決故障一例
- 【故障解決】OGG-00446 錯誤解決
- ORA-00904故障分析與解決一例
- 【故障解決】enq: PS - contentionENQ
- metalink登陸故障解決!
- 【故障解決】IPCS和IPCRM使用
- 一夜爆火的現象級產品ChatGPT,是AI突破還是曇花乍現?ChatGPTAI
- ES6核心,值得駐足花一天時間來學習
- 【故障解決】ORA-06502錯誤解決
- 保證金解凍費 假冒APP騙財花樣多KDYAPP
- 常見硬碟故障大全 硬碟故障解決辦法大全硬碟
- Mysql 獲取當月和上個月第一天和最後一天的解決方案MySql
- Oracle 11gR2 RAC HAIP特性相關的故障的判斷及解決方法OracleAI
- ORACLE 10G rac故障處理一例Oracle 10g
- 常見印表機故障的一般解決辦法
- 一次library cache pin故障的解決過程
- ORA-04031 故障解決案例詳細分析一則
- Processes引數設定引起的故障解決一例
- 故障解析丨一次死鎖問題的解決
- DNS 引起經典RAC故障DNS
- RAC故障診斷指令碼指令碼