PRKP-1001 CRS-0215 怎么了

Yong Huang · 发表于 2010-6-27 05:13

原帖由 hdydmichael 于 2010-6-26 07:45 发表
没办法了，只有删除再添加了。

现在正常了

Solving a problem this way means you don't care about the root cause. It's OK if you're in a hurry and users are waiting for you. But if you have plenty of time, you must try to find the cause, or the same problem may happen again.

In your case, you didn't even say whether you tried sqlplus. If sqlplus doesn't work, it should clearly give a meaningful error. If sqlplus works but srvctl does not, in 10g, you can check imon logs under
$DB_ORACLE_HOME/log/`hostname -s`/racg

Yong Huang

just_dba · 发表于 2010-6-28 22:43

啥日志也没,ALERT.LOG,CRS LOG都没...咋分析嘛

MicroJoey · 发表于 2010-7-2 21:42

原帖由 hdydmichael 于 2010-6-26 21:45 发表
没办法了，只有删除再添加了。

现在正常了

[oracle@rac2 ~]$ srvctl remove instance -d rac -i rac1
Remove instance rac1 from the database rac? (y/[n]) y
[oracle@rac2 ~]$ srvctl remove instance -d rac -i rac2
Remove instance rac2 from the database rac? (y/[n]) y
[oracle@rac2 ~]$ srvctl remove database -d rac
Remove the database rac? (y/[n]) y
[oracle@rac2 ~]$

[oracle@rac2 ~]$ srvctl add database -d westhope -o /u01/app/oracle/product/10.2.0/db_1
[oracle@rac2 ~]$ srvctl add instance -d westhope -i westhope1 -n rac1
[oracle@rac2 ~]$ srvctl add instance -d westhope -i westhope2 -n rac2
[oracle@rac2 ~]$ srvctl modify instance -d westhope -i westhope1 -s +ASM1
[oracle@rac2 ~]$ srvctl modify instance -d westhope -i westhope2 -s +ASM2

如果是这样能解决，是不是OCR 有错误导致的；
可以恢复OCR，进行解决。

hdydmichael · 发表于 2010-7-6 09:24

原帖由 Yong Huang 于 2010-6-27 05:13 发表

Solving a problem this way means you don't care about the root cause. It's OK if you're in a hurry and users are waiting for you. But if you have plenty of time, you must try to find the cause, or the same problem may happen again.

In your case, you didn't even say whether you tried sqlplus. If sqlplus doesn't work, it should clearly give a meaningful error. If sqlplus works but srvctl does not, in 10g, you can check imon logs under
$DB_ORACLE_HOME/log/`hostname -s`/racg

Yong Huang

看你说的这个日志，果真搞定了。
用sqlplus可以启动，是因为用的参数名字叫 spfileorcl ，
用srvcgtl不可以启动，是因为ocr里面的叫spfile

srvctl modify database -d orcl -s /u01/app/oracle/oradata/orcl/spfileorcl