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 "ERROR: Unable to get logical block size for spfile" errors in few databases. 




ERROR: 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



Comments

Popular posts from this blog

Useful OEM Queries to get Target details from OEM Repository

WARNING: Subscription for node down event still pending' in Listener Log

ORA-65139: Mismatch between XML metadata file and data file