ORA-29701: unable to connect to Cluster Synchronization Service

修改主机名后，has无法启动，将has启动之后，尝试ASMCA，出现如图提示：

再尝试登陆asm实例，出现日下提示：

[oracle@edgzrip2-+ASM ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 3 00:53:35 2019

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

解决问题过程：

1、查看服务

[oracle@gzrip2-+ASM ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.cssd ora.cssd.type 0/5 0/5 OFFLINE OFFLINE
ora.diskmon ora....on.type 0/10 0/5 OFFLINE OFFLINE
ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE edgzrip2
ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE

2、添加asm服务

[oracle@gzrip2-+ASM ~]$ srvctl add asm

3、查看服务

[oracle@gzrip2-+ASM ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.asm ora.asm.type 0/5 0/ OFFLINE OFFLINE
ora.cssd ora.cssd.type 0/5 0/5 OFFLINE OFFLINE
ora.diskmon ora....on.type 0/10 0/5 OFFLINE OFFLINE
ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE gzrip2
ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE
ora.prod4.db ora....se.type 0/2 0/1 OFFLINE OFFLINE

4、启动asm服务

[root@gzrip2 ~]# /u01/app/11.2.0/grid/bin/crsctl start resource ora.asm
CRS-2672: Attempting to start 'ora.asm' on 'gzrip2'
CRS-2676: Start of 'ora.asm' on 'gzrip2' succeeded

5、启动cssd服务

[root@gzrip2 ~]# /u01/app/11.2.0/grid/bin/crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'gzrip2'
CRS-2672: Attempting to start 'ora.diskmon' on 'gzrip2'
CRS-2676: Start of 'ora.diskmon' on 'gzrip2' succeeded
CRS-2676: Start of 'ora.cssd' on 'gzrip2' succeeded

6、查看服务

[oracle@gzrip2-+ASM ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE gzrip2
ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE gzrip2
ora.diskmon ora....on.type 0/10 0/5 OFFLINE OFFLINE
ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE gzrip2
ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE
ora.prod4.db ora....se.type 0/2 0/1 OFFLINE OFFLINE

7、尝试登陆asm实例

[oracle@edgzrip2-+ASM ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 3 01:21:16 2019

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Automatic Storage Management option

至此问题解决。

tips:

查看ora.cssd服务属性

[oracle@gzrip2-+ASM ~]$ crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m

查看ora.diskmon服务属性

[oracle@gzrip2-+ASM ~]$ crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=3
DESCRIPTION="Resource type for Diskmon"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=10
SCRIPT_TIMEOUT=60
START_TIMEOUT=600
STOP_TIMEOUT=60
UPTIME_THRESHOLD=5s

      1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动

        crsctl disable has

        crsctl enable has

      2)HAS手动启动和停止

        crsctl start has

        crsctl stop has

      3)查看HAS的状态

        crsctl check has

      4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动，那么你可以修改这两个服务的AUTO_START属性

        crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

        or 

      5)如果想取消ora.css和ora.diskmon的Auto start

        crsctl modify resource "ora.cssd" -attr "AUTO_START=never"

        crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"

参考文档：
https://blog.csdn.net/haiross/article/details/16861849
https://blog.csdn.net/zxyhw/article/details/11711337
https://blog.csdn.net/EVISWANG/article/details/52576084

2019-3-3 12:30 AM

巴特西

ORA-29701: unable to connect to Cluster Synchronization Service

最新文章

热门文章