Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle rdbms 12c on Grid Infrastructure 18c.

VickyIndApr 15 2019 — edited Apr 15 2019

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.

Comments

Processing

Post Details

Added on Apr 15 2019
2 comments
603 views