in Oracle

ORA-29701 / CRS-4124 Oracle ASM start failed

Encountered CRS-4124, the OHASD cannot be started, it shows as below:

[bob@ocp ~]$ crsctl start has
CRS-4124: 未能启动 Oracle High Availability Services。
CRS-4000: 命令 Start 失败, 或已完成但出现错误。

Cannot startup the instance:

[bob@ocp ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 8月 28 13:56:52 2019

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> conn / as sysasm
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

The solution refer to
CRS-4124: Oracle High Availability Services startup failed.
and
Solutions: error while starting of Oracle Single instance ASM Database
Go to directory /u01/app/bob/product/11.2.0/grid/crs/install/, use below two commands,

./roothas.pl -deconfig -force
./roothas.pl

It will have below problem when execute ./roothas.pl.

[root@ocp install]# ./roothas.pl
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1780.
    (Maybe you should just omit the defined()?)
2019-08-28 14:02:58: Checking for super user privileges
2019-08-28 14:02:58: User has super user privileges
2019-08-28 14:02:58: Parsing the host name
Using configuration parameter file: ./crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'bob', privgrp 'tom'..
Operation successful.
CRS-4664: Node ocp successfully pinned.
Adding daemon to inittab
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start: Inappropriate ioctl for device at ./roothas.pl line 296.

Use below method to solve this issue,

[root@ocp install]# ./roothas.pl -deconfig -force
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1780.
    (Maybe you should just omit the defined()?)
2019-08-28 14:23:15: Checking for super user privileges
2019-08-28 14:23:15: User has super user privileges
2019-08-28 14:23:15: Parsing the host name
Using configuration parameter file: ./crsconfig_params
CRS-2613: Could not find resource 'ora.cssd'.
CRS-4000: Command Stop failed, or completed with errors.
CRS-2613: Could not find resource 'ora.cssd'.
CRS-4000: Command Delete failed, or completed with errors.
CRS-4133: Oracle High Availability Services has been stopped.
ADVM/ACFS is not supported on redhat-release-server-7.2-9.el7.x86_64

ACFS-9201: Not Supported
Successfully deconfigured Oracle Restart stack
[root@ocp install]# ./roothas.pl
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1702.
    (Maybe you should just omit the defined()?)
defined(@array) is deprecated at crsconfig_lib.pm line 1780.
    (Maybe you should just omit the defined()?)
2019-08-28 14:23:39: Checking for super user privileges
2019-08-28 14:23:39: User has super user privileges
2019-08-28 14:23:39: Parsing the host name
Using configuration parameter file: ./crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'bob', privgrp 'tom'..
Operation successful.
CRS-4664: Node ocp successfully pinned.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on redhat-release-server-7.2-9.el7.x86_64




ocp     2019/08/28 14:23:53     /u01/app/bob/product/11.2.0/grid/cdata/ocp/backup_20190828_142353.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[root@ocp install]# exit
logout

When doing the command ./roothas.pl, type below command in another terminal, the ./roothas.pl will be executed successful.

[root@ocp ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1

Start the OHASD,

[bob@ocp install]$ crsctl start has
CRS-4640: Oracle High Availability Services 已处于活动状态
CRS-4000: 命令 Start 失败, 或已完成但出现错误。
[bob@ocp install]$ crsctl check has
CRS-4638: Oracle High Availability Services 联机
[bob@ocp install]$ crs_stat -t
名称         类型         目标    状态    主机
------------------------------------------------------------
ora.cssd       ora.cssd.type  OFFLINE   OFFLINE
ora.diskmon    ora....on.type OFFLINE   OFFLINE
[bob@ocp install]$ crs_start ora.cssd
Attempting to start `ora.cssd` on member `ocp`
Attempting to start `ora.diskmon` on member `ocp`
Start of `ora.diskmon` on member `ocp` succeeded.
Start of `ora.cssd` on member `ocp` succeeded.

The successful result was:

[bob@ocp install]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[bob@ocp install]$

Start the ASM instance:

[bob@ocp install]$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 8月 28 14:40:44 2019

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size          2212656 bytes
Variable Size         256552144 bytes
ASM Cache          25165824 bytes
ORA-15110: no diskgroups mounted


SQL>  select name,state,type from v$asm_diskgroup;

NAME
--------------------------------------------------------------------------------
STATE                 TYPE
--------------------------------- ------------------
DATA
DISMOUNTED


SQL> alter diskgroup data mount;

Diskgroup altered.

SQL> select name,state,type from v$asm_diskgroup;

NAME
--------------------------------------------------------------------------------
STATE                 TYPE
--------------------------------- ------------------
DATA
MOUNTED               NORMAL

SQL> select instance_name, status from v$instance;

INSTANCE_NAME
------------------------------------------------
STATUS
------------------------------------
+ASM
STARTED


SQL>

SQL> quit

CRS-4124: Oracle High Availability Services startup failed.
Solutions: error while starting of Oracle Single instance ASM Database
oracle 11g R2 单实例 ASM 启动:ORA-29701:+unable+to+connect+to+Cluster+Synchronization+Service
ORA-15110: no diskgroups mounted

Write a Comment

Comment