RAC Instance startup fails with ORA-15017, CRS-2674

Starting instance fails: 
[grid@grac42 ~]$ srvctl start instance -d grac4 -i grac41
PRCR-1013 : Failed to start resource ora.grac4.db
PRCR-1064 : Failed to start resource ora.grac4.db on node grac41
CRS-5017: The resource action "ora.FRA.dg start" encountered the following error: 
ORA-15032: not all alterations performed
ORA-15017: diskgroup "FRA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
. For details refer to "(:CLSN00107:)" in "/u01/app/11204/grid/log/grac41/agent/crsd/oraagent_grid/oraagent_grid.log".

CRS-2674: Start of 'ora.FRA.dg' on 'grac41' failed

Check for available ASM DG 
[grid@grac42 ~]$  asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     40944    18561            10236            4162              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576     40952    40761                0           40761              0             N  FRA2/
MOUNTED  NORMAL  N         512   4096  4194304      6132     4960             2044            1458              0             Y  OCR/

-->  DG FRA replaced by new DG FRA2 !

Check database resource 
[grid@grac42 ~]$  srvctl config database -d grac4
Database unique name: grac4
Database name: grac4
Oracle home: /u01/app/oracle/product/11204/racdb
Oracle user: oracle
Spfile: +DATA/grac4/spfilegrac4.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: grac4
Database instances: grac41,grac42,grac43
Disk Groups: DATA,FRA
Mount point paths: 
Services: grac41,grac42,grac43,report
Type: RAC
Database is administrator managed

--> Database startup still depends on FRA DG 

ot@grac42 Desktop]# srvctl modify database -d grac4 -a 'DATA,FRA2'
[root@grac42 Desktop]# 
[root@grac42 Desktop]# srvctl config database -d grac4
Database unique name: grac4
Database name: grac4
Oracle home: /u01/app/oracle/product/11204/racdb
Oracle user: oracle
Spfile: +DATA/grac4/spfilegrac4.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: grac4
Database instances: grac41,grac42,grac43
Disk Groups: DATA,FRA2
Mount point paths: 
Services: grac41,grac42,grac43,report
Type: RAC
Database is administrator managed

Drop the old resource for FRA DG 
[root@grac42 Desktop]# crsctl delete resource 'ora.FRA.dg'

Restart instance 
[grid@grac42 ~]$ srvctl start instance -d grac4 -i grac42

Leave a Reply

Your email address will not be published. Required fields are marked *