ORACLE CRS 狀態 UNKNOWN 變為offline
CRS: Resource in UNKNOWN state and SRVCTL Cannot Start the Resource
Information in this document applies to any platform.
When the resource state is UNKNOWN, srvctl cannot start or stop the resource. It fails with the following errors:
After the failed srvctl command, the crsd.log will show an error:
Even running srvctl status on the resource can error:
These errors are all due to the resource state of UNKNOWN.
Any CRS resource can be in an UNKNOWN state, including vip, gsd, database, or instances. The following uses an instance resource as an example.
1. Find the proper name for your instance resource. To find it, do "crs_stat -u | grep inst", this will give the names of all instance resources in the OCR.
Pick the instance associated with the node and database in question.
For example, for a database named prod and instance named prod1, the resource name will be "ora.prod.prod1.inst".
2. Before you go any further, make sure that you have a recent backup of your OCR.
You can check on your OCR automatic backups with the command "ocrconfig -showbackup":
If no backup exists, then create one using ocrconfig -export, following the instructions in the documentation:
3. Restore the instance resource to OFFLINE with this command:
crs_stop [instance resource name]
eg:
4. Check that instance status is now OFFLINE instead of UNKNOWN
5. If the instance status is OFFLINE, then you can try again to start it with srvctl.
6. If the startup fails again, then open a SR and provide Oracle Support with the following information:
a) Gather a trace by using the following script.
(Replace "ora.prod.prod1.inst" with the name of your actual instance resource; replace prod with the name of your database and prod1 with the name of your instance).
The trace log will be found in /tmp/trace1.out.
b) latest crsd.log from this node
c) the resource log for this instance from $CRS_HOME/log/<>/racg
d) ls -l of $ORACLE_HOME/log/<>/racg
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1Information in this document applies to any platform.
Goal
A resource status is showing as UNKNOWN in crs_stat -t output :$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....d1.inst application ONLINE UNKNOWN <<<ora....d2.inst application ONLINE ONLINE stella2
ora.prod.db application ONLINE ONLINE stella2
ora....od1.srv application OFFLINE OFFLINE
...
Name Type Target State Host
------------------------------------------------------------
ora....d1.inst application ONLINE UNKNOWN <<<ora....d2.inst application ONLINE ONLINE stella2
ora.prod.db application ONLINE ONLINE stella2
ora....od1.srv application OFFLINE OFFLINE
...
When the resource state is UNKNOWN, srvctl cannot start or stop the resource. It fails with the following errors:
$ srvctl start instance -d prod-i prod1
PRKP-1001 : Error starting instance prod1 on node oradb1
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.prod.prod1.inst' has placement error.
PRKP-1001 : Error starting instance prod1 on node oradb1
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.prod.prod1.inst' has placement error.
After the failed srvctl command, the crsd.log will show an error:
Human intervention required to resume its availability.
Even running srvctl status on the resource can error:
$ srvctl status database -d prod
PRKO-2015 : Error in checking condition of instance on node: oradb1
PRKO-2015 : Error in checking condition of instance on node: oradb2
PRKO-2015 : Error in checking condition of instance on node: oradb1
PRKO-2015 : Error in checking condition of instance on node: oradb2
These errors are all due to the resource state of UNKNOWN.
Solution
The UNKNOWN state can often be resolved by bringing the resource offline using crs_stop.Note: crs_stop and crs_start are NOT supported for use on ora.* resources, unless you are explicitly instructed to use them by an Oracle support analyst, or following this note's steps EXACTLY.
Improper use of crs_stop and crs_start can corrupt your OCR.
Improper use of crs_stop and crs_start can corrupt your OCR.
Any CRS resource can be in an UNKNOWN state, including vip, gsd, database, or instances. The following uses an instance resource as an example.
1. Find the proper name for your instance resource. To find it, do "crs_stat -u | grep inst", this will give the names of all instance resources in the OCR.
$ crs_stat -u | grep inst
NAME=ora.V102.V1021.inst
NAME=ora.V102.V1022.inst
NAME=ora.prod.prod1.inst
NAME=ora.prod.prod2.inst
NAME=ora.V102.V1021.inst
NAME=ora.V102.V1022.inst
NAME=ora.prod.prod1.inst
NAME=ora.prod.prod2.inst
Pick the instance associated with the node and database in question.
For example, for a database named prod and instance named prod1, the resource name will be "ora.prod.prod1.inst".
2. Before you go any further, make sure that you have a recent backup of your OCR.
You can check on your OCR automatic backups with the command "ocrconfig -showbackup":
$ ocrconfig -showbackup
oradb1 2009/06/19 07:35:28 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/19 03:35:26 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/18 23:35:25 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/18 03:35:20 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/02 07:01:26 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/19 07:35:28 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/19 03:35:26 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/18 23:35:25 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/18 03:35:20 /u01/app/oracle/product/10gR2/crs/cdata/temp
oradb1 2009/06/02 07:01:26 /u01/app/oracle/product/10gR2/crs/cdata/temp
If no backup exists, then create one using ocrconfig -export, following the instructions in the documentation:
3. Restore the instance resource to OFFLINE with this command:
crs_stop [instance resource name]
eg:
$ crs_stop ora.prod.prod1.inst
Note: if the instance is online then this command will stop it.
4. Check that instance status is now OFFLINE instead of UNKNOWN
$ crs_stat -u ora.prod.prod1.inst
NAME=ora.prod.prod1.inst
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.prod.prod1.inst
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
5. If the instance status is OFFLINE, then you can try again to start it with srvctl.
6. If the startup fails again, then open a SR and provide Oracle Support with the following information:
a) Gather a trace by using the following script.
script. /tmp/trace1.out
env
crs_stat -u ora.prod.prod1.inst
crs_stop ora.prod.prod1.inst
crs_stat -u ora.prod.prod1.inst
export SRVM_TRACE=TRUE
srvctl start instance -d prod -i prod1
export SRVM_TRACE=
crs_stat -u ora.prod.prod1.inst
exit
env
crs_stat -u ora.prod.prod1.inst
crs_stop ora.prod.prod1.inst
crs_stat -u ora.prod.prod1.inst
export SRVM_TRACE=TRUE
srvctl start instance -d prod -i prod1
export SRVM_TRACE=
crs_stat -u ora.prod.prod1.inst
exit
(Replace "ora.prod.prod1.inst" with the name of your actual instance resource; replace prod with the name of your database and prod1 with the name of your instance).
The trace log will be found in /tmp/trace1.out.
b) latest crsd.log from this node
c) the resource log for this instance from $CRS_HOME/log/<>/racg
d) ls -l of $ORACLE_HOME/log/<>/racg
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-710137/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle10g crs 服務狀態offline, unknownOracle
- crs命令用法及offline, unknown 狀態處理
- 【轉】crs命令用法及offline, unknown 狀態處理
- CRS-0223 及crs 出現offline , unknown 狀態處理
- oracle crs監聽狀態為offline處理過程Oracle
- 解決crs_stat狀態為UNKNOWN問題
- oracle 10g change crs status unknown to offlineOracle 10g
- RAC10g下crs狀態為unknown的解決辦法
- RAC crs_stat unknown資源狀態處理(ZT)
- 處理crs_stat -t狀態unknown一例
- oracle 10g cluster 如何替換ocr 主檔案 (crs offline狀態)Oracle 10g
- 解決因ocr資源狀態為unknown導致CRS-0223
- oracle監聽器啟動lsnrctl status例程的狀態為unknownOracle
- Oracle10g RAC 兩個監聽狀態為offline 問題處理Oracle
- crs_stat -v 檢視crs 各application 配置狀態資訊APP
- mysql較為重要的狀態變數MySql變數
- RAC中unknown 狀態的處理方式
- Oracle10g RAC 服務的狀態是UNKNOWN解決方法Oracle
- 用crs_unregister命令登出crs中offline的資源
- Oracle10g 監聽註冊問題 - Ready及Unknown狀態Oracle
- 解決crs_stat -t看到資源為UNKNOWN的情況
- oracle日誌狀態為STALE案例分析Oracle
- PostgreSQL狀態變遷SQL
- 狀態變化模式模式
- [ZT]crs_stop -all 命令後遇到 UNKNOWN
- Oracle資料庫表空間READ ONLY、READ WRITE、ONLINE、OFFLINE狀態對應CHECKPOINT的變化Oracle資料庫
- oracle 10g cluster 如何替換ocr主檔案 (crs online狀態)Oracle 10g
- vip offline的解決 CRS_1006 CRS_0215
- 滑鼠移到元素上指標變為不可用狀態指標
- 【轉】vip offline的解決 CRS_1006 CRS_0215
- React專題:可變狀態React
- 10g RAC 服務的狀態是UNKNOWN解決方法
- 用設計模式去掉沒必要的狀態變數 —— 狀態模式設計模式變數
- win10怎麼把狀態列變透明_win10狀態列變透明方法Win10
- CRS: Resource in UNKNOWN state and srvctl Cannot Start/Stop Resource_845709.1
- ORACLE RAC UNKNOWNOracle
- 將Oracle standby 資料庫convert 為snapshort 狀態Oracle資料庫
- ORACLE VM建立SERVER POOLS後狀態為ERR的解決OracleServer