Search This Blog

Total Pageviews

Monday 7 May 2012

ORA-29701: unable to connect to Cluster Synchronization Service

On Oracle single instance ASM


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

======================================================

[oracle@ ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid 
[oracle@ ~]$ export ORACLE_SID=+ASM 
[oracle@ ~]$ sqlplus "/as sysasm" 

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 5 11:14:29 2010 
Copyright (c) 1982, 2009, Oracle. All rights reserved. 
Connected to an idle instance. 

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

[oracle@oel5u4-+ASM bin] ./crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'oel5u4'
CRS-2679: Attempting to clean 'ora.diskmon' on 'oel5u4'
CRS-2681: Clean of 'ora.diskmon' on 'oel5u4' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'oel5u4'
CRS-2676: Start of 'ora.diskmon' on 'oel5u4' succeeded
CRS-2676: Start of 'ora.cssd' on 'oel5u4' succeeded

[oracle@oel5u4-+ASM bin] ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE
ora.FRA.dg     ora....up.type OFFLINE   OFFLINE
ora....ER.lsnr ora....er.type ONLINE    ONLINE    oel5u4
ora.asm        ora.asm.type   OFFLINE   OFFLINE
ora.cssd       ora.cssd.type  ONLINE    ONLINE    oel5u4
ora.diskmon    ora....on.type ONLINE    ONLINE    oel5u4
ora.orcl.db    ora....se.type OFFLINE   OFFLINE
[oracle@oel5u4-+ASM bin] sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 7 10:42:02 2012

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

Connected to an idle instance.

SQL> startup

Start the services 
[oracle@oel5u4-+ASM bin] ./crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'oel5u4'
CRS-2679: Attempting to clean 'ora.diskmon' on 'oel5u4'
CRS-2681: Clean of 'ora.diskmon' on 'oel5u4' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'oel5u4'
CRS-2676: Start of 'ora.diskmon' on 'oel5u4' succeeded
CRS-2676: Start of 'ora.cssd' on 'oel5u4' succeeded
[oracle@oel5u4-+ASM bin] ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE
ora.FRA.dg     ora....up.type OFFLINE   OFFLINE
ora....ER.lsnr ora....er.type ONLINE    ONLINE    oel5u4
ora.asm        ora.asm.type   OFFLINE   OFFLINE
ora.cssd       ora.cssd.type  ONLINE    ONLINE    oel5u4
ora.diskmon    ora....on.type ONLINE    ONLINE    oel5u4
ora.orcl.db    ora....se.type OFFLINE   OFFLINE
[oracle@oel5u4-+ASM bin] sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 7 10:42:02 2012

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

Connected to an idle instance.


SQL> startup
ASM instance started

Total System Global Area  284565504 bytes
Fixed Size                  1336036 bytes
Variable Size             258063644 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted



************************************************

-bash-4.2$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Sun Nov 11 17:54:34 2018

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

Connected to an idle instance.

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


-bash-4.2$ ps -ef|grep -i asm
grid       4509   3833  0 17:50 pts/1    00:00:00 grep --color=auto -i asm


-bash-4.2$ ps -ef|grep -i d.bin
grid       4241      1  3 17:50 ?        00:00:01 /u01/app/12.2.0/grid/bin/ohasd.bin reboot
grid       4383      1  1 17:50 ?        00:00:00 /u01/app/12.2.0/grid/bin/oraagent.bin
grid       4403      1  0 17:50 ?        00:00:00 /u01/app/12.2.0/grid/bin/evmd.bin
grid       4415      1  0 17:50 ?        00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid       4465   4403  0 17:50 ?        00:00:00 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.log
grid       4516   3833  0 17:50 pts/1    00:00:00 grep --color=auto -i d.bin



-bash-4.2$ cd $ORACLE_HOME
-bash-4.2$ cd bin
-bash-4.2$ ./crsctl status resource ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=OFFLINE
STATE=OFFLINE




-bash-4.2$ ./crsctl status resource ora.asm
NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=OFFLINE

-bash-4.2$ ./crsctl start resource ora.asm
CRS-4995:  The command 'Start  resource' is invalid in crsctl. Use srvctl for this command.

-bash-4.2$ crsctl start resource -all      <<<<<<<<<<<<<<<<<  Or start all the resource
CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'oel7-ora'
CRS-5702: Resource 'ora.evmd' is already running on 'oel7-ora'
CRS-2501: Resource 'ora.ons' is disabled
CRS-2672: Attempting to start 'ora.cssd' on 'oel7-ora'
CRS-2672: Attempting to start 'ora.diskmon' on 'oel7-ora'
CRS-2676: Start of 'ora.diskmon' on 'oel7-ora' succeeded
CRS-2676: Start of 'ora.cssd' on 'oel7-ora' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'oel7-ora'
CRS-2676: Start of 'ora.asm' on 'oel7-ora' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'oel7-ora'
CRS-2676: Start of 'ora.DATA.dg' on 'oel7-ora' succeeded
CRS-4000: Command Start failed, or completed with errors.


[oracle@OEL7-ORA ~]$ ps -ef|grep -i smon
grid       5192      1  0 17:59 ?        00:00:00 asm_smon_+ASM


-bash-4.2$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Sun Nov 11 17:59:48 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select * from dual;

ADDR                   INDX    INST_ID     CON_ID D
---------------- ---------- ---------- ---------- -
0000000011272A1C          0          1          0 X







Oracle DBA

anuj blog Archive