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
1 comment:
You are a savior brother. just a great solution.
Post a Comment