Oracle rdbms 12c on Grid Infrastructure 18c. — oracle-tech

    Forum Stats

  • 3,715,760 Users
  • 2,242,859 Discussions
  • 7,845,561 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Oracle rdbms 12c on Grid Infrastructure 18c.

VickyInd
VickyInd Member Posts: 2 Red Ribbon
edited April 2019 in Exadata

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.

Answers

  • robinsc
    robinsc Member Posts: 518 Silver Badge
    edited April 2019

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

  • VickyInd
    VickyInd Member Posts: 2 Red Ribbon
    edited April 2019

    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.

Sign In or Register to comment.