Day: October 25, 2016

Plugin versions on agent does not support target type oracle_pdb

It seems a bug.

Tried to add a CDB database with PDBS into 12c OEM, and got the following errors. 

Failed RACTEST : Plugin versions on agent https://oemnode1:3872/emd/main/  does not support target type oracle_pdb

 Actually there is another CDB database of same cluster has been added onto OEM months ago. So the error message is misleading.

Below actions were taken, then CDB database was added onto OEM successfully.

  1.  Shutdown and startup CDB database with all PDBS  open.
  2. Bounced OEM agent.
  3. Manually added cluster DB, cluster DB instances, and pluggable databases successfully.
Advertisement

ERROR: Unable to get logical block size for spfile

Always make sure the referenced pfile or spfile exists and accessible.

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

...
..
.
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 files, there is no ‘+DATA1/RACTEST/spfileRACTEST.ora’ file existed.

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.