2 Replies Latest reply on Apr 15, 2019 5:49 PM by VickyInd

    Oracle rdbms 12c on Grid Infrastructure 18c.


      Hi All,


      We are migrating Oracle database Release from Exadata x3-2 to Exadata x7-2. We are having grid infrastructure as 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 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/' ;

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


      ERROR at line 1:

      ORA-17502: ksfdcre:4 Failed to create file


      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.


      [oracle@dm04dbadm01 ~]$  ls -trlh $ORACLE_HOME/bin/oracle

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

      [oracle@dm04dbadm01 ~]$ . .GRID

      [oracle@dm04dbadm01 ~]$  ls -trlh $ORACLE_HOME/bin/oracle

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



        • 1. Re: Oracle rdbms 12c on Grid Infrastructure 18c.

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

          • 2. Re: Oracle rdbms 12c on Grid Infrastructure 18c.

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


            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>




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

                       1 DATAC1     

                       2 RECOC1     

                       3 DATA_DM04