Monday, September 25, 2017

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

received this error while performing the import on a RAC database.

The issue is that init<SID>.ora file has value of

SPFILE= '+DATA/dev1tstp/spfiledev1tstp.ora'

where as when we look at the ASM and srvctl config database -d dev1tstp

The SPFILE is

 '+DATA/dev1tstp/spfiledev1tst.ora'

change the init<SID>.ora to the value form srvctl config and it fixed the issue.


No comments: