Oracle RAC啟動失敗(DNS故障)
問題:
資料庫啟動報錯:ORA-00119、ORA-00132等
環境:
DB:Oracle 11.2.0.4.0
OS:Redhat 6.5
問題現象:
啟動資料庫報錯:
[grid@rac01 ~]$ srvctl start database -d cjcdb
PRCR-1079 : Failed to start resource ora.cjcdb.db CRS-5017: The resource action "ora.cjcdb.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132: syntax error or unresolved network name 'rac-scan.cjc.com:1521' . For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac02/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-5017: The resource action "ora.cjcdb.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132: syntax error or unresolved network name 'rac-scan.cjc.com:1521' . For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac01/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.cjcdb.db' on 'rac02' failed CRS-2674: Start of 'ora.cjcdb.db' on 'rac01' failed CRS-2632: There are no more servers to try to place resource 'ora.cjcdb.db' on that would satisfy its placement policy
其中remote_listener引數值為:rac-scan.cjc.com:1521
懷疑DNS解析SCAN失敗
登入到rac01執行nslookup rac-scan.cjc.com
[root@rac01 bin]# nslookup rac-scan.cjc.com ;; connection timed out; trying next origin ;; connection timed out; no servers could be reached
檢視resolv.conf配置資訊被清空了,實際上每次伺服器重啟網路卡resolv.conf配置都會被自動清空
[root@rac01 bin]# cat /etc/resolv.conf # Generated by NetworkManager nameserver 8.8.8.8
檢查網路卡配置檔案裡沒有指定90的DNS,手動新增90DNS。
[root@rac02 bin]# cd /etc/sysconfig/network-scripts/ [root@rac02 network-scripts]# vim ifcfg-eth0 DNS1="192.168.31.90"
重新新增resolv.conf配置資訊
[root@rac01 bin]# vim /etc/resolv.conf # Generated by NetworkManager nameserver 8.8.8.8 domain cjc.com nameserver 192.168.31.90 options rotate options timeout:2 options attempts:5
可以正常解析了
[root@rac01 bin]# nslookup rac-scan.cjc.com Server:192.168.31.90 Address:192.168.31.90#53 Name:rac-scan.cjc.com Address: 192.168.31.60 Name:rac-scan.cjc.com Address: 192.168.31.70 Name:rac-scan.cjc.com Address: 192.168.31.50
啟動資料
[root@rac01 bin]# ./srvctl start instance -d cjcdb -i cjcdb1 [root@rac01 bin]# ./srvctl start instance -d cjcdb -i cjcdb2
檢查例項狀態
[root@rac01 bin]# ./srvctl status database -d cjcdb Instance cjcdb1 is running on node rac01 Instance cjcdb2 is running on node rac02
歡迎關注我的微信公眾號"IT小Chen",共同學習,共同成長!!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29785807/viewspace-2699664/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC常見啟動失敗故障分析Oracle
- Oracle RAC啟動失敗-軟連結惹的禍Oracle
- RAC節點啟動失敗--ASM無法連線ASM
- 虛擬機器搭建rac ASM盤啟動失敗虛擬機ASM
- Oracle DG同步失敗故障處理(二)Oracle
- Oracle RAC自啟動Oracle
- sqlplus啟動失敗SQL
- tomcat 啟動失敗Tomcat
- docker啟動失敗Docker
- MySQL啟動失敗MySql
- easyswoole啟動失敗
- 19c RAC因profile.xml檔案丟失節點1啟動失敗XML
- ORACLE ADG 最大可用模式下例項啟動失敗分析Oracle模式
- Win7 Nginx啟動失敗 cmd命令失敗Win7Nginx
- 【RAC啟動故障】ORA-21561: OID generation failedAI
- dota2啟動失敗 初始化vulkan失敗
- Linux使用Ambari啟動服務啟動失敗Linux
- 【故障】workstation-001-snapshot失敗
- Oracle 10g RAC故障處理Oracle 10g
- 私有IP丟失造成Oracle 12C RAC叢集節點不能啟動Oracle
- Hadoop 啟動namenode節點失敗Hadoop
- 問題一:Kibaba 啟動失敗
- sqlserver服務啟動失敗-1067SQLServer
- dbsnmp啟動失敗解決方法
- Oracle RAC的自定義service自啟動Oracle
- DNS解析失敗了怎麼辦DNS
- Oracle RAC日常運維-DATA磁碟組故障Oracle運維
- Oracle 12c叢集啟動故障Oracle
- mongodb啟動失敗問題解決MongoDB
- mysql(mariadb)啟動失敗解決方法MySql
- hbase啟動失敗問題解決
- Oracle RAC+ADG新增資料檔案失敗處理(db_create_file_dest)Oracle
- sql server 重新啟動計算機失敗SQLServer計算機
- SpringBoot專案引入Elasticsearch時啟動失敗Spring BootElasticsearch
- Oracle RAC啟動因CTSS導致的異常Oracle
- ORACLE OMS啟動失敗之BEA-300040 I/O error while writing node manager statusOracleErrorWhile
- namenode單節點啟動成功後自動消失/格式化失敗/fsimage載入失敗
- rac二節點例項redo故障無法啟動修復