关于虚拟机Linux重启导致ohasd和crs没有启动的处理

最新推荐文章于 2023-12-29 16:08:39 发布

haohaodeshijie123

最新推荐文章于 2023-12-29 16:08:39 发布

阅读量881

点赞数

分类专栏： oracle 11g 故障分析与处理

本文链接：https://blog.csdn.net/u011209497/article/details/9356275

版权

oracle 11g 故障分析与处理专栏收录该内容

3 篇文章 0 订阅

订阅专栏

重启linux系统后

首先检查：

#su - oracle

$ cd /u01/app/oracle/product/11.2.0/grid/bin

$ ./crsctl chech has

如果显示ohasd是not online，则是没有启动

$./crs_stat -t

如果显示没有crs资源，则是资源没有启动

其次处理：

$ sh -x /u01/app/oracle/product/11.2.0/grid/bin/crsctl check has

$ cd /u01/app/oracle/product/11.2.0/grid/crs/install

$ su

$ oracle

# ./roothas.pl -deconfig -force -verbose

# cd /u01/app/oracle/product/11.2.0/grid

# ./root.sh

（如果有用到的语句dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1）

再切换到oracle用户下

$ cd /u01/app/oracle/product/11.2.0/grid/bin

$ ./crsctl stat res -t //查询资源状态

$ ./crsctl start res -all //启动所有资源

Name           Type           Target    State     Host
------------------------------------------------------------
ora.cssd       ora.cssd.type ONLINE    ONLINE    localhost
ora.diskmon    ora....on.type ONLINE    ONLINE    localhost

对比正常的services：

少 ora.DATA.dg / ora.asm ,先添加ora.asm

$ srvctl add asm
$ ./crsctl start res ora.asm
$ ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.asm        ora.asm.type   ONLINE    ONLINE    localhost
ora.cssd       ora.cssd.type ONLINE    ONLINE    localhost
ora.diskmon    ora....on.type ONLINE    ONLINE    localhost

再添加ora.DATA.dg

# xhost +

#su - oracle

$ asmca

将diskgroup mount起来

$ ./crs_stat -t

之后登录sqlplus，startup等待mount上，就可以了，如果不行尝试以下步骤。

[oracle@localhost test]$ srvctl add database -d orcl -o $ORACLE_HOME
[oracle@localhost test]$ srvctl start database -d orcl

[oracle@localhost test]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle

[oracle@localhost ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE ONLINE       localhost
ora.DATA1.dg
               ONLINE ONLINE       localhost
ora.asm
               ONLINE ONLINE       localhost                Started
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE ONLINE       localhost
ora.diskmon
      1        ONLINE ONLINE       localhost
ora.orcl.db
      1        ONLINE ONLINE       localhost                Open