ERROR: Unable to get logical block size for spfile ‘+DATA1/RACTEST/spfileRACTEST.ora’

Created 12.1.0.2 CDB/PDB database through DBCA, there are a lot of below errors in alert.log.

Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.
Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.
Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.
Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.
Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.
Mon Oct 24 23:33:11 2016
ERROR: Unable to get logical block size for spfile '+DATA1/RACTEST/spfileRACTEST.ora'.

Go to $ORACLE_HOME/dbs and check initRACTEST1.ora file, which was created by DBCA.

$cd $ORACLE_HOMEdbs
$cat initRACTEST1.ora
'+DATA1/RACTEST/spfileRACTEST.ora'

--- DBCA scripts
---
[RACTEST1] oracle@racnode1:/u01/app/oracle/admin/RACTEST/scripts$ cat RACTEST1.sql
set verify off
ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE
ACCEPT dbsnmpPassword CHAR PROMPT 'Enter new password for DBSNMP: ' HIDE
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/orapwd file=+DATA1/RACTEST/orapwRACTEST force=y format=12 dbuniquename=RACTEST
host /u01/app/12.1.0.2/grid/bin/setasmgidwrap o=/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl add database -d RACTEST -pwfile +DATA1/RACTEST/orapwRACTEST -o /u01/app/oracle/product/12.1.0/dbhome_1 -p +DATA1/RACTEST/spfileRACTEST.ora -n RACTEST -a "DATA1,FRA"
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl add instance -d RACTEST -i RACTEST1 -n racnode1
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl add instance -d RACTEST -i RACTEST2 -n racnode2
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl add instance -d RACTEST -i RACTEST3 -n racnode3
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl add instance -d RACTEST -i RACTEST4 -n racnode4
host /u01/app/oracle/product/12.1.0/dbhome_1/bin/srvctl disable database -d RACTEST
@/u01/app/oracle/admin/RACTEST/scripts/CreateDB.sql
@/u01/app/oracle/admin/RACTEST/scripts/CreateDBFiles.sql
@/u01/app/oracle/admin/RACTEST/scripts/CreateDBCatalog.sql
@/u01/app/oracle/admin/RACTEST/scripts/JServer.sql
@/u01/app/oracle/admin/RACTEST/scripts/context.sql
@/u01/app/oracle/admin/RACTEST/scripts/ordinst.sql
@/u01/app/oracle/admin/RACTEST/scripts/interMedia.sql
@/u01/app/oracle/admin/RACTEST/scripts/cwmlite.sql
@/u01/app/oracle/admin/RACTEST/scripts/spatial.sql
@/u01/app/oracle/admin/RACTEST/scripts/labelSecurity.sql
@/u01/app/oracle/admin/RACTEST/scripts/apex.sql
@/u01/app/oracle/admin/RACTEST/scripts/datavault.sql
@/u01/app/oracle/admin/RACTEST/scripts/CreateClustDBViews.sql
host echo "SPFILE='+DATA1/RACTEST/spfileRACTEST.ora'" > /u01/app/oracle/product/12.1.0/dbhome_1/dbs/initRACTEST1.ora
@/u01/app/oracle/admin/RACTEST/scripts/lockAccount.sql
@/u01/app/oracle/admin/RACTEST/scripts/postDBCreation.sql
@/u01/app/oracle/admin/RACTEST/scripts/PDBCreation.sql
@/u01/app/oracle/admin/RACTEST/scripts/plug_RACTESTPDB.sql
@/u01/app/oracle/admin/RACTEST/scripts/postPDBCreation_RACTESTPDB.sql

Check ASM diskgroup files, and there is no ‘+DATA1/RACTEST/spfileRACTEST.ora’ file exists.

ASMCMD> cd RACTEST/
ASMCMD> ls -l

Type Redund Striped Time Sys Name
 Y 3F9BD96544BC0349E053530F040A8320/
 Y 3F9C860784456287E053530F040ADB20/
 Y CONTROLFILE/
 Y DATAFILE/
 Y ONLINELOG/
 Y PARAMETERFILE/
 Y PASSWORD/
 Y TEMPFILE/
PASSWORD UNPROT COARSE OCT 24 15:00:00 N orapwractest=> +DATA1/RACTEST/PASSWORD/pwdractest.1427.926092135

ASMCMD> cd PARAMETERFILE/
ASMCMD> pwd
+data1/RACTEST/PARAMETERFILE
ASMCMD> ls -l
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE OCT 25 10:00:00 Y spfile.1438.926119495

SOLUTION:

  1. Give right path and name for spfile in pfile. Get the right spfile name and path from alert.log when instance startup everytime.
$cat initRACTEST1.ora
'+data1/RACTEST/PARAMETERFILE/spfile.1438.926119495'

2. Or remove initRACTE1.ora from $ORACLE_HOME/dbs if pfile is not referenced at all.

Advertisements
This entry was posted in 12c new features, Configuration, GI and RAC and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s