ASM configuration error “ASM Instance already exists”

1- When checked, ASM instance was not running
   ps -ef|grep smon
— no asm_smon_+ASM instance there


2- While starting ASM instance manually get following error:


export ORACLE_SID=+ASM
sqlplus /as sysasm


SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 21 08:37:49 2018


Copyright (c) 1982, 2013, 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
SQL> exit




1- Checked the cluster services:


./crsctl stat res -t


2- CSSD was not running. Started ora.cssd resource using root:


./crsctl start resource ora.cssd


CRS-2672: Attempting to start ‘ora.cssd’ on ‘GMIDB’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘GMIDB’
CRS-2676: Start of ‘ora.diskmon’ on ‘GMIDB’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘GMIDB’ succeeded


3- Tried starting the ASM manually again:


sqlplus / as sysasm


SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 21 08:56:49 2018


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted


PFILE was not found to instace for startup. when checked from $GRID_HOME/dbs, there was no pfile with name init+ASM.ora which needs to be created to resolve this issue


4- checked the v$asm_diskgroup view for ASm groupd for their status, and found no ASM group found no rows retrieved:


SQL> select name, state from v$asm_diskgroup;
no rows found


5- Start ASMCA gui and check if it was showing diskgroups there. No gorup found.
Create new ASM diskgroups DBFILES & ARCH using asmca utility.
It will show the success of diskgroup creation and then will mount the disk groups.


6- Check again from v$asm_diskgroup view:


SQL> select name, state from v$asm_diskgroup;


NAME                           STATE
—————————— ———–
DBFILES                         MOUNTED
ARCH                            MOUNTED


7- After restarting ASM instance, it will again give the same error as in point
3. But this time, v$asm_diskgroup shows the diskgroups but in dismounted state:


SQL> select name, state from v$asm_diskgroup;


NAME                           STATE
—————————— ———–
DBFILES                         DISMOUNTED
ARCH                            DISMOUNTED


8- Mount them manually like:


SQL> alter diskgroup DBFILES mount;
SQL> alter diskgroup RAC mount;


which will successfully mount it.


9- Now create pfile from momory. It will create init+ASM.ora file in $GRID_HOME/dbs


SQL> create pfile from memory;


10- Alter the init+ASM.ora file and add following parameters:


[oracle@GMIDB:/u01/app/oracle/product/12.2.0/grid/dbs]vi init+ASM.ora


instance_type=ASM
diagnostic_dest=’/u01/app/oracle/’
asm_diskgroups=’DBFILES’
asm_diskgroups=’ARCH’
asm_power_limit=1
large_pool_size=12M
remote_login_passwordfile=’EXCLUSIVE’


11- shutdown the ASM instance and start it using parameter file like :


[oracle@GMIDB dbs]$ sqlplus / as sysasm


SQL*Plus: Release 12.2.0.1.0 Production on TueApr 21 12:45:37 2018


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to an idle instance.


SQL>  startup pfile=’/u01/app/oracle/product/12.2.0/grid/dbs/init+ASM.ora’
ASM instance started


Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL>


**** here another issue resolved. As now disks are mounted automatically


12- Now create SPFILE from pfile for ASM instance to automatically select the SPfile we get following error ORA-29786: SIHA attribute GET failed with error


SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200]
lsts[0]]


SQL> create spfile=’/u01/app/oracle/product/12.2.0/grid/dbs/spfile+ASM.ora’ from pfile=’/u01/app/oracle/product/12.2.0/grid/dbs/init+ASM.ora’
  2  ;
create spfile=’/u01/app/oracle/product/12.2.0/grid/dbs/spfile+ASM.ora’ from pfile=’/u01/app/oracle/product/12.2.0/grid/dbs/init+ASM.ora’
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]]


13- Check the status of diskgroups again:


SQL> select status,instance_name from v$instance;


STATUS       INSTANCE_NAME
———— —————-
STARTED      +ASM


SQL> select name,state from v$asm_diskgroup;


NAME                           STATE
—————————— ———–
DBFILES                         MOUNTED
ARCH                            MOUNTED


diskgroups are fine


14- Exit from the SQL console and check if ASM resource is online in cluster services:


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


It means, no ASM resource created that has to communicate with cluster services


15- Add ASM resource using srvctl command as :


[oracle@GMIDB dbs]$ srvctl add asm
[oracle@GMIDB dbs]$ srvctl config asm
ASM home: /u01/app/oracle/product/12.2.0/grid
ASM listener: LISTENER
Spfile:
ASM diskgroup discovery string: ++no-value-at-resource-creation–never-updated-through-ASM++


16- Now check the status of newly created ASM resource and start it using srvctl command:


[oracle@GMIDB dbs]$ srvctl status asm
ASM is not running.
[oracle@GMIDB dbs]$ srvctl start asm
[oracle@GMIDB dbs]$
[oracle@GMIDB dbs]$ srvctl status asm
ASM is running on GMIDB


17- Now connect with sqlplus as sysasm and create spfile:


[oracle@GMIDB dbs]$ sqlplus / as sysasm


SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 21 13:01:37 2018


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle DBFILESbase 11g Enterprise Edition Release 12.2.0.1.0 – 64bit Production
With the Automatic Storage Management option


SQL> show parameter spfile


NAME                                 TYPE        VALUE
———————————— ———– ——————————
spfile                               string


SQL> create spfile from pfile;


File created.


SQL> shutdown
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started


Total System Global Area 1135747072 bytes
Fixed Size                  2260728 bytes
Variable Size            1108320520 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

  • June 25, 2018 | 51 views
  • Comments