Oracle Corner

This is a pretty simple problem, and there is an Oracle bug explained in Doc ID 2145349.1, but Oracle support doesn't offer solution, so I thought I should connect those two.

Symptoms

Mon Jul 17 21:50:44 2017ERROR: Unable to get logical block size for spfile '+ORADATA3/PPEN/spfilePPEN.ora'.
Mon Jul 17 21:50:45 2017ERROR: Unable to get logical block size for spfile '+ORADATA1/PPEN/spfilePPEN.ora'.
Cause


The problem is caused by init*.ora file pointing to a non-existing spfile, while spfile instance parameter is pointing to the correct one.

Solution

Create an alias in ASM that matches the name in init*.ora file.

ASMCMD> pwd+oradata1/PPEN
ASMCMD> ls PARAMETERFILE/spfile.268.948615175
ASMCMD> mkalias PARAMETERFILE/spfile.268.948615175 spfilePPEN.ora

Labels: "ERROR: Unable to get logical block size for spfile" solution