PRKP-1001與CRS-0215解決方案

tianya_2011發表於2013-07-18
問題描述：
檢視RAC狀態，發現例項和資料庫資源處於offline.
[oracle@rac1 bin]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora.rac10g.db  application    ONLINE    OFFLINE               
ora....g1.inst application    ONLINE    OFFLINE               
ora....g2.inst application    ONLINE    OFFLINE               
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2

手工啟動例項報如下錯誤:
[oracle@rac1 bin]$ srvctl start instance -d rac10g -i rac10g1
PRKP-1001 : Error starting instance rac10g1 on node rac1
CRS-0215: Could not start resource 'ora.rac10g.rac10g1.inst'.

解決方法：
[oracle@rac1 bin]$ export ORACLE_SID=+ASM1
[oracle@rac1 bin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 21 15:16:44 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

透過檢視v$asm_diskgroup，發現ASM盤都沒有MOUNT，手動MOUNT.
SQL> select name,state from v$asm_diskgroup; 
NAME                           STATE
------------------------------ -----------
DATA                           DISMOUNTED

SQL> alter diskgroup DATA mount;
Diskgroup altered.

[oracle@rac1 bin]$ export ORACLE_SID=rac10g1
[oracle@rac1 bin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 21 15:18:51 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area  444596224 bytes
Fixed Size                  2021440 bytes
Variable Size             142608320 bytes
Database Buffers          297795584 bytes
Redo Buffers                2170880 bytes
Database mounted.
Database opened.

[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2
[oracle@rac2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 21 16:09:15 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select name,state from v$asm_diskgroup; 
NAME                           STATE
------------------------------ -----------
DATA                           DISMOUNTED

SQL> alter diskgroup DATA mount;
Diskgroup altered.

[oracle@rac2 dbs]$ export ORACLE_SID=rac10g2
[oracle@rac2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 21 16:10:13 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area  444596224 bytes
Fixed Size                  2021440 bytes
Variable Size             134219712 bytes
Database Buffers          306184192 bytes
Redo Buffers                2170880 bytes
Database mounted.
Database opened.

檢視RAC的狀態：
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME    STATUS
---------------- ------------
rac10g2          OPEN
rac10g1          OPEN

[oracle@rac1 dbs]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora.rac10g.db  application    ONLINE    ONLINE    rac2        
ora....g1.inst application    ONLINE    ONLINE    rac1        
ora....g2.inst application    ONLINE    ONLINE    rac2        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2

所有資源已正常啟動。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25373498/viewspace-769005/，如需轉載，請註明出處，否則將追究法律責任。

相關文章