{"id":14545,"date":"2021-07-09T16:45:32","date_gmt":"2021-07-09T19:45:32","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=14545"},"modified":"2021-07-12T10:12:43","modified_gmt":"2021-07-12T13:12:43","slug":"creating-a-19c-database-with-a-lower-compatible-parameter","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/creating-a-19c-database-with-a-lower-compatible-parameter\/","title":{"rendered":"Creating a 19c database with a lower COMPATIBLE parameter"},"content":{"rendered":"

Those days, I was trying to create a 19c database with a lower COMPATIBLE, so I could have a fallback plan after plugin a PDB from a lower release.<\/p>\n

However, when trying to create it using DBCA command:<\/p>\n

dbca -silent -createDatabase \\\r\n-gdbName cdb19c \\\r\n-templateName General_Purpose.dbc \\\r\n-characterSet AL32UTF8 \\\r\n-createAsContainerDatabase true \\\r\n-numberOfPDBs 1 \\\r\n-pdbAdminPassword \"Rodrigo.123\" \\\r\n-pdbName PDB01 \\\r\n-useLocalUndoForPDBs false \\\r\n-databaseConfigType SINGLE \\\r\n-databaseType MULTIPURPOSE \\\r\n-datafileDestination \/u01\/app\/oradata \\\r\n-dvConfiguration false \\\r\n-emConfiguration NONE \\\r\n-enableArchive false \\\r\n-memoryMgmtType AUTO_SGA \\\r\n-totalMemory 4000 \\\r\n-nationalCharacterSet AL16UTF16 \\\r\n-olsConfiguration false \\\r\n-recoveryAreaDestination \/u01\/app\/fra \\\r\n-sampleSchema false \\\r\n-sid cdb19c \\\r\n-storageType FS \\\r\n-useOMF false \\\r\n-sysPassword \"Rodrigo.123\" \\\r\n-systemPassword \"Rodrigo.123\" \\\r\n-initParams compatible=12.1.0.2.0<\/pre>\n
I got the following error:<\/p>\n
Prepare for db operation\r\n8% complete\r\nCopying database files\r\n9% complete\r\n[WARNING] ORA-00201: control file version 19.0.0.0.0 incompatible with ORACLE version 12.1.0.2.0\r\nORA-00202: control file: '\/u01\/app\/oracle\/cfgtoollogs\/dbca\/orcl\/tempControl.ctl'\r\n\r\n[WARNING] ORA-01507: database not mounted\r\nORA-06512: at \"SYS.X$DBMS_BACKUP_RESTORE\", line 8418\r\nORA-06512: at \"SYS.X$DBMS_BACKUP_RESTORE\", line 8412\r\nORA-06512: at line 1\r\n\r\n10% complete\r\n[WARNING] ORA-01507: database not mounted\r\nORA-06512: at \"SYS.X$DBMS_BACKUP_RESTORE\", line 8418\r\nORA-06512: at \"SYS.X$DBMS_BACKUP_RESTORE\", line 8412\r\nORA-06512: at line 1\r\n\r\n[WARNING] ORA-01507: database not mounted\r\n\r\n[WARNING] ORA-01507: database not mounted\r\n\r\n[WARNING] ORA-01507: database not mounted\r\n\r\n[WARNING] ORA-01507: database not mounted\r\n\r\n31% complete\r\nCreating and starting Oracle instance\r\n[FATAL] ORA-01503: CREATE CONTROLFILE failed\r\nORA-01565: error in identifying file '\/u01\/app\/oradata\/ORCL\/sysaux01.dbf'\r\nORA-27037: unable to obtain file status\r\n\r\n46% complete\r\n100% complete\r\n[FATAL] ORA-01503: CREATE CONTROLFILE failed\r\nORA-01565: error in identifying file '\/u01\/app\/oradata\/ORCL\/sysaux01.dbf'\r\nORA-27037: unable to obtain file status\r\n\r\n31% complete\r\n8% complete\r\n0% complete\r\nLook at the log file \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/orcl\/orcl2.log\" for further details.<\/pre>\n
So, the issue is that when I’ve selected “General Purpose”<\/strong> template in DBCA, it will actually restore the control files and data files from a pre-built database template, not create it from scratch.\u00a0 And the control file version there is 19.0.0.0, so there is no chance to select a template with pre-built data files and control files and also define the COMPATIBLE parameter.<\/strong><\/p>\n
To fix the issue, you have to use the DBCA GUI and select the “Custom Database”<\/strong> option. Later, on the last screen where you can check and alter the init file, change the COMPATIBLE parameter to the desired version:<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
Just pay attention to avoid compatible issues, like:<\/p>\n