On Oracle single instance ASM
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
************************************************
-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
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
crsctl status res | grep -v "^$" | \
awk -F "=" 'BEGIN {print ""} {printf("%s", NR%4 ? $2 "|" : $2 "\n")}' | \
sed -e 's/ *, /,/g' -e 's/, /,/g' | \
awk -F "|" '
BEGIN {
printf "%-40s %-35s %-20s %-50s\n\n", \
"RESOURCE_NAME", "RESOURCE_TYPE", "TARGET", "STATE"
}
{
split($3, trg, ",")
split($4, st, ",")
}
{
for (i in trg) {
printf "%-40s %-35s %-20s %-50s\n", \
$1, $2, trg[i], st[i]
}
}'
RESOURCE_NAME RESOURCE_TYPE TARGET STATE
ora.DATA.dg ora.diskgroup.type OFFLINE OFFLINE
ora.LISTENER.lsnr ora.listener.type ONLINE ONLINE on oragrid
ora.asm ora.asm.type ONLINE ONLINE on oragrid
ora.cssd ora.cssd.type ONLINE ONLINE on oragrid
ora.diskmon ora.diskmon.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE on oragrid
ora.ons ora.ons.type OFFLINE OFFLINE
[grid@oragrid grid]$
