适用范围

Oracle Database - Enterprise Edition - Version 11.2.0.4.0 and later

问题概述

[grid@snyxdb ~]$ crsctl start has
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Start failed, or completed with errors.
[grid@snyxdb ~]$

问题原因

以下文件损坏或误删除，造成HAS无法启动
/etc/init.d/ohasd
/etc/init.d/afd
/etc/init.d/init.ohasd
/etc/init.d/init.tfa
/etc/rc.d/rc3.d/S96ohasd
/etc/rc.d/rc3.d/S96afd
/etc/rc.d/rc5.d/S96ohasd
/etc/rc.d/rc5.d/S96afd
/etc/oracle
/etc/oracleafd.conf
/etc/oraInst.loc
/etc/oratab

解决方案

[root@orcldb install]# /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose
[root@orcldb install]# /u01/app/11.2.0/grid/root.sh
Check /u01/app/11.2.0/grid/install/root_snyxdb_2024-05-08_18-22-25.log for the output of root script
[root@orcldb install]# cat /u01/app/11.2.0/grid/install/root_snyxdb_2024-05-08_18-22-25.log
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node snyxdb successfully pinned.
Adding Clusterware entries to inittab

snyxdb     2024/05/08 18:22:40     /u01/app/11.2.0/grid/cdata/snyxdb/backup_20240508_182240.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[root@orcldb install]# su - grid
Last login: Wed May  8 18:22:38 CST 2024 on pts/0
[grid@snyxdb ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      snyxdb
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       snyxdb
[grid@snyxdb ~]$
[grid@snyxdb ~]$ srvctl add asm -p +OCR_VOT/asm/asmparameterfile/registry.253.1168451615 -d /dev/oracleasm/disks/
[grid@snyxdb ~]$ sqlplus / as sysasm
SQL> startup
[grid@snyxdb ~]$ asmcmd lsdg
[grid@snyxdb ~]$ srvctl add listener
[root@orcldb install]# su - oracle
Last login: Wed May  8 18:32:36 CST 2024 on pts/0
[oracle@snyxdb ~]$ srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/dbhome_1
[grid@snyxdb ~]$ crsctl stop has
[grid@snyxdb ~]$ crsctl start has
[grid@snyxdb ~]$ crsctl stat res -t

参考文档

rootcrs.pl/roothas.pl Fails With Can't locate Env.pm (Doc ID 2019784.1)