Day: January 23, 2021

PRCR-1001 : Resource ora.asm does not exist

Cause:

After installing grid,i cant start asm resource

[oracle@exdbadm01 ~]$ srvctl start asm 
PRCR-1001 : Resource ora.asm does not exist

Check the resource status

[oracle@exdbadm01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       exdbadm01
ora.ons
               OFFLINE OFFLINE      exdbadm01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       exdbadm01

ASM resource doesnot reflect in the list of resources

After investing the logfiles, i can see that SPFILE was not accessible because css

*** 2021-01-23 19:29:47.210
kgxgncin: CLSS init failed with status 3
kgxgncin: return status 3 (1311719766 SKGXN not av) from CLSS
KGGPNP_SIHA: resource 'ora.asm' is not available [200]
KGGPNP_SIHA: attribute 'SPFILE' get failed sts[200] lsts[0]
kgxgncin: CLSS init failed with status 3
kgxgncin: return status 3 (1311719766 SKGXN not av) from CLSS
2021-01-23 19:29:47.182536*:kgflk.c@160: kgflkLockInit2: Unable to get CSS context(2)
kgxgncin: CLSS init failed with status 3
kgxgncin: return status 3 (1311719766 SKGXN not av) from CLSS
2021-01-23 19:29:47.245344*:kgflk.c@160: kgflkLockInit2: Unable to get CSS context(2)
kgxgncin: CLSS init failed with status 3
kgxgncin: return status 3 (1311719766 SKGXN not av) from CLSS
kjidpins: unable to connect to NM

After scrutinizing the ASM configuration,i found out that asm was not added to cluster confoguration

[oracle@exdbadm01 ~]$ srvctl config asm
PRCR-1001 : Resource ora.asm does not exist

Solution:

Add the asm resource to the cluster configuration

[oracle@exdbadm01 ~]$ srvctl add asm

Check if ora.asm resource reflect

[oracle@exdbadm01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       exdbadm01
ora.asm
               OFFLINE OFFLINE      exdbadm01
ora.ons
               OFFLINE OFFLINE      exdbadm01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       exdbadm01

Start the ASM

[oracle@exdbadm01 ~]$ srvctl start asm

Check the ASM status

[oracle@exdbadm01 ~]$ srvctl status asm
ASM is running on exdbadm01

Hope this worked for you!

[INS-40404] The installer has detected a configured instance of Oracle grid infrastructure software on the server.

Cause:

When installing oracle grid for a server,this error pops up because of improper cleanups of the previous grid software directories and files.I hope i can save your time,by giving you this solution

,
Cause - You selected to install and configure a new Oracle grid infrastructure installation (Oracle Clusterware and Oracle ASM). However, only one installation of Oracle Clusterware and Oracle ASM can be configured on a server at the same time.  

Action - Deconfigure the existing Oracle Grid Infrastructure software before installing and configuring a new instance of Oracle Grid Infrastructure software.

Solution:

These culprit registry files though it acts as pointer for ASM disks cause this error and disallow you to go forward to the next step!

Take a backup of these files

[root@exdbadm01 oracle]# cp ocr.loc ocr.loc.bkp
[root@exdbadm01 oracle]# cp olr.loc olr.loc.bkp

Then remove ocr.loc and olr.loc files and continue your installation

[root@exdbadm01 etc]# cd /etc/oracle
[root@exdbadm01 etc]# rm -rf ocr.loc
[root@exdbadm01 oracle]# ls
cell      ocr.loc.orig  olr.loc.orig  scls_scr
lastgasp  olr.loc       oprocd        setasmgid
[root@exdbadm01 oracle]# rm -rf olr.loc

Hope it works and save your time 🙂