OCM_Session7_0_CRS-0223

 

在用DBCA删除后，重建创建racdb数据库，到存储选项这里，出现如下错误：

 

查看各服务状态

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....SM1.asm application    ONLINE    ONLINE    rac1        

ora....C1.lsnr application    ONLINE    UNKNOWN   rac1        

ora.rac1.gsd   application    ONLINE    UNKNOWN   rac1        

ora.rac1.ons   application    ONLINE    UNKNOWN   rac1        

ora.rac1.vip   application    ONLINE    ONLINE    rac1        

ora....SM2.asm application    ONLINE    UNKNOWN   rac2        

ora....C2.lsnr application    ONLINE    UNKNOWN   rac2        

ora.rac2.gsd   application    ONLINE    UNKNOWN   rac2        

ora.rac2.ons   application    ONLINE    UNKNOWN   rac2        

ora.rac2.vip   application    ONLINE    ONLINE    rac2   

发现有很多状态为UNKNOWN ，此时只能先全部关闭，然后重启

     

[oracle@rac1 ~]$   crs_stop -all

Attempting to stop `ora.rac1.ASM1.asm` on member `rac1`

Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`

Stop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.

Attempting to stop `ora.rac2.ASM2.asm` on member `rac2`

Stop of `ora.rac2.ASM2.asm` on member `rac2` succeeded.

Attempting to stop `ora.rac2.vip` on member `rac2`

Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.

Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`

Stop of `ora.rac2.vip` on member `rac2` succeeded.

Stop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.

Attempting to stop `ora.rac1.vip` on member `rac1`

Stop of `ora.rac1.vip` on member `rac1` succeeded.

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....SM1.asm application    OFFLINE   OFFLINE               

ora....C1.lsnr application    OFFLINE   OFFLINE               

ora.rac1.gsd   application    ONLINE    UNKNOWN   rac1        

ora.rac1.ons   application    ONLINE    UNKNOWN   rac1        

ora.rac1.vip   application    OFFLINE   OFFLINE               

ora....SM2.asm application    OFFLINE   OFFLINE               

ora....C2.lsnr application    OFFLINE   OFFLINE               

ora.rac2.gsd   application    ONLINE    UNKNOWN   rac2        

ora.rac2.ons   application    ONLINE    UNKNOWN   rac2        

ora.rac2.vip   application    OFFLINE   OFFLINE       

发现还有 UNKNOWN状态没有关闭的，继续使用crs_stop命令关闭：

        

[oracle@rac1 ~]$ crs_stop ora.rac1.gsd

Attempting to stop `ora.rac1.gsd` on member `rac1`

Stop of `ora.rac1.gsd` on member `rac1` succeeded.

[oracle@rac1 ~]$ crs_stop ora.rac1.ons

Attempting to stop `ora.rac1.ons` on member `rac1`

Stop of `ora.rac1.ons` on member `rac1` succeeded.

[oracle@rac1 ~]$ crs_stop ora.rac2.gsd

Attempting to stop `ora.rac2.gsd` on member `rac2`

Stop of `ora.rac2.gsd` on member `rac2` succeeded.

[oracle@rac1 ~]$ crs_stop ora.rac2.ons

Attempting to stop `ora.rac2.ons` on member `rac2`

Stop of `ora.rac2.ons` on member `rac2` succeeded.

再查看状态，为全部 OFFLINE状态：

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....SM1.asm application    OFFLINE   OFFLINE               

ora....C1.lsnr application    OFFLINE   OFFLINE               

ora.rac1.gsd   application    OFFLINE   OFFLINE               

ora.rac1.ons   application    OFFLINE   OFFLINE               

ora.rac1.vip   application    OFFLINE   OFFLINE               

ora....SM2.asm application    OFFLINE   OFFLINE               

ora....C2.lsnr application    OFFLINE   OFFLINE               

ora.rac2.gsd   application    OFFLINE   OFFLINE               

ora.rac2.ons   application    OFFLINE   OFFLINE               

ora.rac2.vip   application    OFFLINE   OFFLINE               

[oracle@rac1 ~]$ 

在启动时可能会发现如下错误：

[oracle@rac1 ~]$ srvctl

/u01/app/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

解决方案连接： http://blog.csdn.net/rlhua/article/details/21858001

使用   srvctl start 按以下顺序启动：

[oracle@rac1 ~]$ srvctl start nodeapps -n rac1 --在节点1启应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）

[oracle@rac1 ~]$ srvctl start nodeapps -n rac2 --在节点2启应用程序（虚拟 IP、GSD、TNS 监听器和 ONS）

[oracle@rac1 ~]$ srvctl start asm -n rac1 --在节点1启动ASM实例

[oracle@rac1 ~]$ srvctl start asm -n rac2 --在节点2启动ASM实例

[oracle@rac1 ~]$ 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....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