<<Back to DB Administration Main Page
ERROR: Unable to get logical block size for spfile '+DATA/ORCL/spfileORCL.ora'
Extract From AlertLogERROR: 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:
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;
Comments
Post a Comment