10.2.0.4以後vip不會自動relocate back回原節點
srvctl relocate service -d -s -I;
crsctl relocate resource $resource_name;
solution 2:
srvctl start nodeapps -n <node name>;
like as:
crs1:
[resdb1:/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.resdb.db application ONLINE ONLINE resdb1
ora....b1.inst application ONLINE ONLINE resdb1
ora....b2.inst application ONLINE ONLINE resdb2
ora....B1.lsnr application OFFLINE OFFLINE
ora.resdb1.gsd application ONLINE ONLINE resdb1
ora.resdb1.ons application ONLINE ONLINE resdb1
ora.resdb1.vip application ONLINE ONLINE resdb1
ora....B2.lsnr application ONLINE ONLINE resdb2
ora.resdb2.gsd application ONLINE ONLINE resdb2
ora.resdb2.ons application ONLINE ONLINE resdb2
ora.resdb2.vip application ONLINE ONLINE resdb2
[resdb1:/oracle]$srvctl start nodeapps -n resdb1
[resdb1:/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.resdb.db application ONLINE ONLINE resdb1
ora....b1.inst application ONLINE ONLINE resdb1
ora....b2.inst application ONLINE ONLINE resdb2
ora....B1.lsnr application ONLINE ONLINE resdb1
ora.resdb1.gsd application ONLINE ONLINE resdb1
ora.resdb1.ons application ONLINE ONLINE resdb1
ora.resdb1.vip application ONLINE ONLINE resdb1
ora....B2.lsnr application ONLINE ONLINE resdb2
ora.resdb2.gsd application ONLINE ONLINE resdb2
ora.resdb2.ons application ONLINE ONLINE resdb2
ora.resdb2.vip application ONLINE ONLINE resdb2
crs2:
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gsioms01
ora....01.lsnr application ONLINE OFFLINE
ora....s01.gsd application ONLINE ONLINE gsioms01
ora....s01.ons application ONLINE ONLINE gsioms01
ora....s01.vip application ONLINE ONLINE gsioms02
ora....SM2.asm application ONLINE ONLINE gsioms02
ora....02.lsnr application ONLINE ONLINE gsioms02
ora....s02.gsd application ONLINE ONLINE gsioms02
ora....s02.ons application ONLINE ONLINE gsioms02
ora....s02.vip application ONLINE ONLINE gsioms02
ora.gssa.db application ONLINE ONLINE gsioms02
ora....a1.inst application ONLINE ONLINE gsioms01
ora....a2.inst application ONLINE ONLINE gsioms02
$
$
$ lsnrctl start LISTENER_GSIOMS01
LSNRCTL for HPUX: Version 10.2.0.5.0 - Production on 25-MAY-2016 04:32:4
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/product/ora10g/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 10.2.0.5.0 - Production
System parameter file is /oracle/product/ora10g/network/admin/listener.ora
Log messages written to /oracle/product/ora10g/network/log/listener_gsioms01.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gsioms01-vip)(PORT=1521)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
HPUX Error: 227: Can't assign requested address
Listener failed to start. See the error message(s) above...
$
$ srvctl start nodeapps -n gsioms01
CRS-0233: Resource or relatives are currently involved with another operation.
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gsioms01
ora....01.lsnr application ONLINE ONLINE gsioms01
ora....s01.gsd application ONLINE ONLINE gsioms01
ora....s01.ons application ONLINE ONLINE gsioms01
ora....s01.vip application ONLINE ONLINE gsioms01
ora....SM2.asm application ONLINE ONLINE gsioms02
ora....02.lsnr application ONLINE ONLINE gsioms02
ora....s02.gsd application ONLINE ONLINE gsioms02
ora....s02.ons application ONLINE ONLINE gsioms02
ora....s02.vip application ONLINE ONLINE gsioms02
ora.gssa.db application ONLINE ONLINE gsioms02
ora....a1.inst application ONLINE ONLINE gsioms01
ora....a2.inst application ONLINE ONLINE gsioms02
$
reference(from oracle support id):
Applies to:
Oracle Server – Enterprise Edition – Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Symptoms
Starting from 10.2.0.4 and 11.1, VIP does not fail-over back to the original node even after the public network problem is resolved. This behavior is the default behavior in 10.2.0.4 and 11.1 and is different from that of 10.2.0.3
Cause
This is actually the default default behavior in 10.2.0.4 and 11.1
In 10.2.0.3, on every instance check, the instance attempted to relocate the VIP back to the preferred node (original node), but that required stopping the VIP and then attempt to restart the VIP on the original node. If the public network on the original node is still down, then the attempt to relocate VIP to the original node will fail and the VIP will fail-over back to the secondary node. During this time, the VIP is not available, so starting from 10.2.0.4 and 11.1, the default behavior is that the instance check will not attempt to relocate the VIP back to the original node.
Solution
If the default behavior of 10.2.0.4 and 11.1 is not desired and if there is a need to have the VIP relocate back to the original node automatically when the public network problem is resolved, use the following workaround
Uncomment the line
ORA_RACG_VIP_FAILBACK=1 && export ORA_RACG_VIP_FAILBACK
in the racgwrap script in $ORACLE_HOME/bin
With the above workaround, VIP will relocate back to the original node when CRS performs the instance check, so in order for the VIP to relocate automatically, the node must have at least one instance running.
The instance needs to be restarted or CRS needs to be restarted to have the VIP start relocating back to the original node automatically if the change is being made on the existing cluster.
Relying on automatic relocation of VIP can take up to 10 minutes because the instance check is performed once every 10 minutes. Manually relocating the VIP is only way to guarantee quick relocation of VIP back to the original node.
To manually relocate the VIP, start the nodeapps by issuing
srvctl start nodeapps -n <node name>
Starting the nodeapps does not harm the online resources such as ons and gsd.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13750068/viewspace-2106370/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RAC】Oracle19.13之後的grid,節點重啟後不會自動驅動Oracle
- 關於 rac vip fail backAI
- 單節點10.2.0.4RAC安裝
- app直播原始碼,列表越界後自動彈回原樣的效果APP原始碼
- 直播軟體搭建,輸入框回車以後自動重新整理頁面
- 直播程式,Vue input輸入框回車以後自動重新整理頁面Vue
- 一節點啟動不起來(ocssd)CSS
- spark 叢集啟動後,worker 節點worker 程式一段時間後自動結束Spark
- window10怎麼關閉自動更新 win10自動更新以後就老開不開機Win10
- Redis鍵不會自動過期 - AblyRedis
- PG12.9-Repmgr5.1.0-vip-3節點部署
- XML節點自動生成簡單例項XML單例
- 剝開比原看程式碼02:比原啟動後去哪裡連線別的節點
- vip會員
- namenode單節點啟動成功後自動消失/格式化失敗/fsimage載入失敗
- MySQL Orchestrator自動導換+VIP切換MySql
- Activiti5.2 自動完成第一節點流程
- Service使用referred和avileable固定會話到一個節點,當機後會切換到另一個節點會話
- oracle cluster 10.2.0.1 for aix 6.1 升級到10.2.0.4會出現vip offline問題OracleAI
- 記:僅配置單vip連線串,當vip對應的節點down機情況下程式無法連線上正常節點的故障
- 閃回還原點restore pointREST
- PLSV指令Z軸回原點
- 課程回顧|以智慧之力,加速媒體生產全自動程式
- Oracle RAC 一個節點不能自動啟動 怪問題Oracle
- 移動Web前端,遊客點選商品的收藏按鈕,登入完成,回來之後,如何自動收藏Web前端
- python以後會取代php嗎PythonPHP
- 修改vip地址後,vip服務啟動不成功的處理過程
- 【PDB】pdb閃回,Oracle還原點Oracle
- 以'許可權系統'開篇不曉得會不會遭到鄙視
- 自研平臺功能節點
- 關於前滾(roll forward)和回滾(roll back)Forward
- idea設定了maven會自動變回C盤那個IdeaMaven
- 還原點和閃回資料庫資料庫
- Orace Flash Restore Point(閃回還原點)REST
- VSCode回車換行後自動調整程式碼格式VSCode
- 遮蔽ASP.NET按鈕自動回車後提交的問題ASP.NET
- 通過keepalived實現 MySQL VIP 自動切換MySql
- oracle 11.2.0.2 版本產生的私網地址不通會導致第2個節點自動重啟Oracle