Oracle rdbms 12c on Grid Infrastructure 18c.

VickyInd

Hi All,

We are migrating Oracle database Release 12.1.0.2 from Exadata x3-2 to Exadata x7-2. We are having grid infrastructure as 12.1.0.2 on source Exadata X3-2, we are migrating databases

onto target Exadata X7-2 having grid Infrastructure as 18c.

After cloning binaries for oracle rdbms 12.1.0.2 onto X7-2 and while trying to create spfile i am getting below error.

SQL> create spfile='+DATA_DM04/NPLDBBDR/PARAMETERFILE/spfileNPLDBB.ora' from pfile='/u01/app/oracle/product/12.1.0.2/dbhome_29/dbs/initpfile.ora' ;

create spfile='+DATA_DM04/NPLDBBDR/PARAMETERFILE/spfileNPLDBB.ora' from pfile='/u01/app/oracle/product/12.1.0.2/dbhome_29/dbs/initpfile.ora'

*

ERROR at line 1:

ORA-17502: ksfdcre:4 Failed to create file

+DATA_DM04/NPLDBBDR/PARAMETERFILE/spfileNPLDBB.ora

ORA-15001: diskgroup "DATA_DM04" does not exist or is not mounted

ORA-15040: diskgroup is incomplete

I have checked the permissions for grid and rdbms ontp x7-2 both are same as below and diskgroup are also mounted and having no issues.

[[email protected] ~]$  ls -trlh $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 313M Apr 15 07:01 /u01/app/oracle/product/12.1.0.2/dbhome_29/bin/oracle

[[email protected] ~]$ . .GRID

[[email protected] ~]$  ls -trlh $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 396M Apr  3 12:42 /u01/app/18.0.0.0/grid/bin/oracle

Thanks.

robinsc

Check the compatible parameter at the asm spfile level. It should not be higher than 12.1

VickyInd

I have checked the compatible parameters. T We have set database_compatibility at 11.2.0.3.

SQL> col COMPATIBILITY form a10

col DATABASE_COMPATIBILITY form a10

col NAME form a20

select group_number, name, compatibility, database_compatibility from v$asm_diskgroup;SQL> SQL> SQL>

GROUP_NUMBER NAME                 COMPATIBIL DATABASE_C

------------ -------------------- ---------- ----------

           1 DATAC1               18.0.0.0.0 11.2.0.4.0

           2 RECOC1               18.0.0.0.0 11.2.0.3.0

           3 DATA_DM04            18.0.0.0.0 11.2.0.3.0

Thanks.