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

    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.

       

      [oracle@dm04dbadm01 ~]$  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

      [oracle@dm04dbadm01 ~]$ . .GRID

      [oracle@dm04dbadm01 ~]$  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.

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

          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.
            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.