Today I’ve encountered an annoying issue while adapting a few scripts for automatic database creation. I track it here so hopefully it may save a few hours of troubleshooting to someone…<\/p>\n
I’ve used the DBCA to prepare a new template:<\/p>\n
dbca -> Create Database -> Advanced Mode -> General Purpose -> \r\nCreate As Container Database -> Create an Empty Container Database<\/pre>\n<\/p>\n
Then continued by customizing other options, including init parameters and datafile\/logfile paths. Finally, I’ve saved it as a new template instead of creating the database.<\/p>\n
I’ve checked the resulting .dbc and seen that there was, as expected, the parameter “enable_pluggable_database”=”true”.<\/p>\n
Then I’ve moved the template file to my $HOME directory and tested the silent database creation with the option “-createAsContainerDatabase true”:<\/p>\n
$ ${ORACLE_HOME}\/bin\/dbca -silent \\\r\n-createDatabase \\\r\n-createAsContainerDatabase true \\\r\n-templateName \/home\/oracle\/Template_12_EE_MULTITENANT.dbc \\\r\n-gdbname cdb1 \\\r\n-sid cdb1 \\\r\n-responseFile NO_VALUE \\\r\n-characterSet AL32UTF8 \\\r\n-SYSPASSWORD *** \\\r\n-SYSTEMPASSWORD *** \\\r\n-redoLogFileSize 256 \\\r\n-initparams open_cursors=1300 \\\r\n-initparams processes=3000 \\\r\n-initparams enable_pluggable_database=true<\/pre>\nThe database configuration has completed successfully, without errors. I’ve accessed my new container, and I’ve been surprised by seing:<\/p>\n
SQL> select * from v$pdbs;\r\n\r\nno rows selected\r\n\r\nSQL><\/pre>\nIn fact, there were no pdb$seed datafiles:<\/p>\n
SQL> select distinct con_id from cdb_data_files;\r\n\r\n CON_ID\r\n----------\r\n 1\r\n\r\nSQL><\/pre>\nAfter little investigation, I’ve found these lines in the dbca trace.log:<\/p>\n
[main] [ 2014-03-28 10:37:53.956 CET ] [Host.startOperation:2651] is Template CDB false\r\n[main] [ 2014-03-28 10:37:53.956 CET ] [TemplateManager.isInstallTemplate:2314] Selected Template by user:=Template CEI 8K 12 EE MULTITENANT\r\n[main] [ 2014-03-28 10:37:53.956 CET ] [TemplateManager.isInstallTemplate:2321] The Message Id to be searched:=null\r\n[main] [ 2014-03-28 10:37:53.957 CET ] [Host.startOperation:2663] Template Selected is User created NON-CDB Template. Creating database as NON-CDB\r\n[main] [ 2014-03-28 10:37:53.957 CET ] [HAUtils.getCurrentOracleHome:490]\u00a0 Oracle home from system property: \/ccv\/app\/oracle\/product\/12.1.0.1<\/pre>\n<\/p>\n
Then I’ve struggled with dbca and templates a few times before finding that, actually, the magic “enable pluggable database” is done by dbca only if the template file name is not customized.<\/p>\n
Running the same exact command with the very same template file but renamed to $ORACLE_HOME\/assistants\/dbca\/templates\/General_Purpose.dbc actually works (notice the diff at the first line):<\/p>\n
$ diff \/home\/oracle\/Template_12_EE_MULTITENANT.dbc $ORACLE_HOME\/assistants\/dbca\/templates\/General_Purpose.dbc\r\n$ ${ORACLE_HOME}\/bin\/dbca -silent \\\r\n-createDatabase \\\r\n-createAsContainerDatabase true \\\r\n-templateName General_Purpose.dbc \\\r\n-gdbname cdb1 \\\r\n-sid cdb1 \\\r\n-responseFile NO_VALUE \\\r\n-characterSet AL32UTF8 \\\r\n-SYSPASSWORD *** \\\r\n-SYSTEMPASSWORD *** \\\r\n-redoLogFileSize 256 \\\r\n-initparams open_cursors=1300 \\\r\n-initparams processes=3000 \\\r\n-initparams enable_pluggable_database=true<\/pre>\n<\/p>\n
SQL> select * from v$pdbs;\r\n\r\n CON_ID DBID CON_UID GUID\r\n---------- ---------- ---------- --------------------------------\r\nNAME OPEN_MODE RES\r\n------------------------------ ---------- ---\r\nOPEN_TIME\r\n---------------------------------------------------------------------------\r\nCREATE_SCN TOTAL_SIZE\r\n---------- ----------\r\n 2 4086042395 4086042395 F5A8226121F93B96E0434B96780A8C91\r\nPDB$SEED READ ONLY NO\r\n28-MAR-14 10.20.42.813 AM\r\n 1720341 283115520\r\n\r\nSQL> select distinct con_id from cdb_data_files;\r\n\r\n CON_ID\r\n----------\r\n 2\r\n 1\r\n\r\nSQL><\/pre>\n<\/p>\n
I’ve also tried to cheat and use a symlink to my previous custom template, and surprisingly, it still works:<\/p>\n
$ ls -l $ORACLE_HOME\/assistants\/dbca\/templates\/General_Purpose.dbc\r\nlrwxrwxrwx 1 oracle dba 74 Mar 28 13:07 \/u01\/app\/oracle\/product\/12.1.0.1\/assistants\/dbca\/templates\/General_Purpose.dbc -> \/home\/oracle\/Template_12_EE_MULTITENANT.dbc\r\n$<\/pre>\nIn the dbca trace log the message saying that the DB will be NON-CDB disappears:<\/p>\n
[main] [ 2014-03-28 10:12:14.683 CET ] [Host.startOperation:2651] is Template CDB false\r\n[main] [ 2014-03-28 10:12:14.683 CET ] [TemplateManager.isInstallTemplate:2314] Selected Template by user:=General Purpose\r\n[main] [ 2014-03-28 10:12:14.683 CET ] [TemplateManager.isInstallTemplate:2321] The Message Id to be searched:=GENERAL_PURPOSE\r\n[main] [ 2014-03-28 10:12:14.683 CET ] [HAUtils.getCurrentOracleHome:490] Oracle home from system property: \/ccv\/app\/oracle\/product\/12.1.0.1<\/pre>\nSo the problem is really caused by the different filename\/location of the template.<\/p>\n
IMHO it’s a kind of bug, the decision between a CDB and NON-CDB should not be taken by DBCA.\u00a0 Moreover, it’s not based on the content of the template, which would be logic. But today I’m late and lazy, I will not open a SR for this.<\/p>\n
:-\/<\/p>\n","protected":false},"excerpt":{"rendered":"
Today I’ve encountered an annoying issue while adapting a few scripts for automatic database creation. I track it here so hopefully it may save a few hours of troubleshooting to someone… I’ve used the DBCA to prepare a new template: … Continue reading