If hostname changed (click here) and ORACLE ASM restart is not able start and connect,
[root@oemserver oracle]# crsctl start has
CLSU-00100: operating system function: opendir failed with error data: 2
CLSU-00101: operating system error message: No such file or directory
CLSU-00103: error location: scrsearch1
CLSU-00104: additional error information: cant open scr home dir scls_scr_getval
CRS-4000: Command Start failed, or completed with errors.
Note: Below steps may loose your ASM disk data, so pls do not try below steps on prod directly .
Solution : Please refer below steps from Root user.
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl -deconfig -force
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl
or
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl /u01/app/oracle/product/12.2.0.1/grid/crs/install/root.sh
==== Other Issue during start ORACLE ASM Restart ======================
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE oemserver STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE oemserver STABLE
--------------------------------------------------------------------------------
Error :
[oracle@oemserver ~]$ crsctl start resource ora.cssd
CRS-4995: The command 'Stop resource' is invalid in crsctl. Use srvctl for this command.
Solution :
./crsctl start resource ora.cssd -unsupported
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE oemserver STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE oemserver STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE oemserver STABLE
--------------------------------------------------------------------------------
=====================================================================
If asm is not starting, set display and use asmca. it will start ASM and you can mount disk which you wants.
[oracle@oemserver ~]$ asmca
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE oemserver STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE oemserver STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE oemserver STABLE
--------------------------------------------------------------------------------
[oracle@oemserver ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 19 14:09:20 2023
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
=====================================================================
Steps to add Listner/Disk/ASM in SRVCTL
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.asm
OFFLINE OFFLINE oemserver STABLE
ora.ons
OFFLINE OFFLINE oemserver STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE oemserver STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE oemserver STABLE
--------------------------------------------------------------------------------
[oracle@oemserver ~]$ srvctl add listener -listener LISTENER -endpoints 1521
[oracle@oemserver ~]$ srvctl add asm -l LISTENER -d DATA -p +data/spfile.ora
[oracle@oemserver ~]$ srvctl config asm
ASM home: <CRS home>
Password file:
Backup of Password file:
ASM listener: LISTENER
Spfile: +data/spfile.ora
ASM diskgroup discovery string: DATA
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
OFFLINE OFFLINE oemserver STABLE
ora.asm
OFFLINE OFFLINE oemserver STABLE
ora.ons
OFFLINE OFFLINE oemserver STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE oemserver STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE oemserver STABLE
--------------------------------------------------------------------------------
[oracle@oemserver ~]$
No comments:
Post a Comment