ERROR: Unable to get logical block size for spfile

<<Back to DB Administration Main Page

ERROR:  Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'

Extract From AlertLog
ERROR: Unable to get logical block size for spfile '+DATA/MTSIM1P/spfileORCL.ora'.
Wed Aug 22 02:17:22 2018
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'.
Wed Aug 22 02:17:22 2018
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'.
Wed Aug 22 02:17:22 2018
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'.
Wed Aug 22 02:17:22 2018
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'.
Wed Aug 22 02:17:22 2018
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'.

Investigation:

ORCL1> show parameter spfile
NAME                                 TYPE            VALUE
------------------------------------ --------------- ------------------------------
spfile                               string          +DATA/ORCL/PARAMETERFILE/spfile.1288.984754717
$ asmcmd ls -l +DATA/ORCL/PARAMETERFILE/spfile.1288.984754717
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  HIGH    COARSE   AUG 21 22:00:00  Y    spfile.1288.984754717
$cat $ORACLE_HOME/dbs/initORCL1.ora
SPFILE='+DATA/ORCL/spfileORCL.ora'

In the investigation it is found that the SPFILE path in $ORACLE_HOME/dbs/initORCL1.ora is different than database parameter spfile and actual SPFILE in ASM

Solution1:

Find the correct spfile path from spfile parameter in database and update the correct spfile path in $ORACLE_HOME/dbs/initORCL1.ora. 

Solution2:

Make ASM alias for spfile for the spfile path displayed in $ORACLE_HOME/dbs/initORCL1.ora and update spfile parameter in database


ASMCMD>mkalias +DATA/ORCL/PARAMETERFILE/spfile.1288.984754717 +DATA/ORCL/spfile.1288.984754717
SQL>alter system set spfile='+DATA/ORCL/spfile.1288.984754717'sid='*' scope=spfile;