How to Fix ORA-01130 or ORA-00201 Errors When Provisioning an Oracle VDB (KBA6234)

Issue

The following errors may be encountered during VDB provision.

Error
Failed to recreate control file.

Error Code
exception.oracle.targetscripts.controlfile.create

Suggested Action
Review the Oracle alert log for more details.

Command Output
command: umask 027; . $DB_SCRIPT_DIR/setup-oraenv.sh; $DLPX_SHELL $DB_SCRIPT_DIR/doCreateControlFile.sh "$LOGON_STR" $DB_SCRIPT_DIR "/mnt/provision/abc" output:END_OF_SETUP SYS_GUID=ABE1163150432C9FE055224C9A2E9568 SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 2 03:36:56 2020 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> ORACLE instance shut down. SQL> ORACLE instance started. Total System Global Area  775946240 bytes Fixed Size     2929208 bytes Variable Size   218107336 bytes Database Buffers   549453824 bytes Redo Buffers     5455872 bytes SQL>   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17  CREATE CONTROLFILE REUSE SET DATABASE 'ABC' RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01210: data file header is media corrupt ORA-01110: data file : '/mnt/provision/abc/datafile/oradata/rh74db02/datafile/RH74DB02/datafile/o1_mf_system_ds8fwxmd_.dbf' ORA-01130: database file version 12.1.0.2.0 incompatible with ORACLE version 11.2.0.4.0 ORA-01110: data file 1: '/mnt/provision/abc/datafile/oradata/rh74db02/datafile/RH74DB02/datafile/o1_mf_system_ds8fwxmd_.dbf' SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options STARTED CREATE_CONTROL_FILE_ERROR 

or

Error
Failed to mount database instance. See command output for more information.

Error Code
exception.oracle.targetscripts.db.mount

Suggested Action
Make sure that the parameters in init<sid>.ora file are valid. Review the Oracle alert log for more details if applicable.

Command Output
command: umask 027; . $DB_SCRIPT_DIR/setup-oraenv.sh; $DLPX_SHELL $DB_SCRIPT_DIR/mount-vdb-instance.sh "restrict pfile='/mnt/provision/def/datafile/init.ora.rename'" output:END_OF_SETUP END_OF_SETUP #####DELPHIX_START_ERROR##### ERROR : ERROR : SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 25 23:14:18 2020 ERROR : ERROR : Copyright (c) 1982, 2014, Oracle.  All rights reserved. ERROR : ERROR : Connected to an idle instance. ERROR : ERROR : SQL> ORACLE instance started. ERROR : ERROR : Total System Global Area  775946240 bytes ERROR : Fixed Size     2929208 bytes ERROR : Variable Size   218107336 bytes ERROR : Database Buffers   549453824 bytes ERROR : Redo Buffers     5455872 bytes ERROR : ORA-00201: control file version 12.1.0.2.0 incompatible with ORACLE version 11.2.0.4.0 ERROR : ORA-00202: control file: '/mnt/provision/def/datafile/oradata/rh74db02/controlfile/control01.ctl' ERROR : ERROR : ERROR : SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production ERROR : With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options #####DELPHIX_END_ERROR##### MOUNT_DATABASE_ERROR

Applicable Delphix Versions 

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

 

Resolution

The pertinent errors here are:

ORA-00201: control file version 12.1.0.2.0 incompatible with ORACLE version 11.2.0.4.0

or

ORA-01130: database file version 11.2.0.4.0 incompatible with ORACLE version

Update the compatible parameter either through specifying the parameter in "VDB Configure Parameters" or by specifying a VDB config template. The compatible parameter must be set to the control file version which is 12.1.0.2.0 in the above examples.

Please see Configuration Settings for Oracle Virtual Databases for more information on setting VDB parameters.