ITPub博客

首页 > 数据库 > Oracle > PRKP-1001与CRS-0215解决方案

PRKP-1001与CRS-0215解决方案

原创 Oracle 作者:tianya_2011 时间:2013-07-18 09:46:01 0 删除 编辑
问题描述:
查看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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 双网卡bonding配置
请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    85
  • 访问量
    607793