ASM instance startup fail with below error
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
sqlplus /nolog
C:\Users\DBServer01>sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 12 21:42:47 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
sqlplus /nolog
C:\Users\DBServer01>sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 12 21:42:47 2023
Version 19.15.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
SQL> connect / 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
C:\Users\DBServer01>crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'DBServer01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'DBServer01'
CRS-2673: Attempting to stop 'ora.orcl11g.db' on 'DBServer01'
CRS-2673: Attempting to stop 'ora.ncdb19c.db' on 'DBServer01'
CRS-2673: Attempting to stop 'ora.LISTENER_ASM.lsnr' on 'DBServer01'
CRS-2677: Stop of 'ora.LISTENER_ASM.lsnr' on 'DBServer01' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'DBServer01' succeeded
CRS-2677: Stop of 'ora.orcl11g.db' on 'DBServer01' succeeded
CRS-2677: Stop of 'ora.ncdb19c.db' on 'DBServer01' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'DBServer01'
CRS-2673: Attempting to stop 'ora.ons' on 'DBServer01'
CRS-2677: Stop of 'ora.evmd' on 'DBServer01' succeeded
CRS-2677: Stop of 'ora.ons' on 'DBServer01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'DBServer01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
C:\Users\DBServer01>
C:\Users\DBServer01>
C:\Users\DBServer01>crsctl start has
CRS-4123: Oracle High Availability Services has been started.
C:\Users\DBServer01>crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE DBServer01 STABLE
ora.LISTENER_ASM.lsnr
ONLINE ONLINE DBServer01 STABLE
ora.ORA_DATA.dg
OFFLINE OFFLINE DBServer01 STABLE
ora.ons
ONLINE ONLINE DBServer01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE DBServer01 STABLE
ora.ncdb19c.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.orcl11g.db
1 ONLINE ONLINE DBServer01 Open,HOME=D:\Softwar
e\ORADB\app\oracle\p
roduct\11.2.0\dbhome
_1,STABLE
--------------------------------------------------------------------------------
C:\Users\DBServer01>crsctl start res ora.cssd -init
CRS-2672: Attempting to start 'ora.cssd' on 'DBServer01'
CRS-2676: Start of 'ora.cssd' on 'DBServer01' succeeded
C:\Users\DBServer01>crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE DBServer01 STABLE
ora.LISTENER_ASM.lsnr
ONLINE ONLINE DBServer01 STABLE
ora.ORA_DATA.dg
OFFLINE OFFLINE DBServer01 STABLE
ora.ons
ONLINE ONLINE DBServer01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE DBServer01 STABLE
ora.evmd
1 ONLINE ONLINE DBServer01 STABLE
ora.ncdb19c.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.orcl11g.db
1 ONLINE ONLINE DBServer01 Open,HOME=D:\Softwar
e\ORADB\app\oracle\p
roduct\11.2.0\dbhome
_1,STABLE
--------------------------------------------------------------------------------
No comments:
Post a Comment