Unable to get logical block size for spfile in alert log
We have created new database in shared environment using dbca, we Suddenly started seeing " E RR OR: Unable to get logical block size for spfile" errors in few databases. E RR OR : Unable to get logical block size for spfile '+DATA/aedvam01/spfileaedvam01.ora'. Wed Jul 19 02:21:07 2017 Work around: sho parameter spfile +DATA/AEDVAM01/PARAMETERFILE/spfile.1401.919658705 Create alias using correct name spfileaedvam01.ora Set environment to ASM Instance. . oraenv +ASM1 asmcmd mkalias +DATA/AEDVAM01/PARAMETERFILE/spfile.1401.919658705 +DATA/aedvam01/spfileaedvam01.ora