Blog

  • Oracle, Oracle 12c, Page d'accueil

Creation d'une CDB avec DBCA et un sous-ensemble d'options

Par défaut, la création d’une CDB avec DBCA ne permet pas de désactiver l’installation de certains composants.
La note « Creating A Container Database (CDB) With A Subset Of Options (Doc ID 2001512.1) » propose un contournement qui implique d’exécuter DBCA en mode graphique pour générer les scripts et de modifier ensuite ces scripts (avec la mise en commentaire de certains scripts SQL associés) avant de les lancer.
Il est possible d’utiliser une autre méthode (non officielle) avec DBCA en mode silencieux.

Par défaut, si on ne fait rien, tous ces composants sont installés :

SET LINES 200 PAGES 200
col COMP_NAME for a10
col COMP_NAME for a40
col VERSION for A15
SELECT comp_id, comp_name, version, status FROM dba_registry ORDER BY comp_id;
COMP_ID       COMP_NAME                            VERSION     STATUS
------------- ------------------------------------ ----------- --------
DV            Oracle Database Vault                12.1.0.2.0  VALID
RAC           Oracle Real Application Clusters     12.1.0.2.0  VALID
SDO           Spatial                              12.1.0.2.0  VALID
ORDIM         Oracle Multimedia                    12.1.0.2.0  VALID
CONTEXT       Oracle Text                          12.1.0.2.0  VALID
OWM           Oracle Workspace Manager             12.1.0.2.0  VALID
XDB           Oracle XML Database                  12.1.0.2.0  VALID
CATALOG       Oracle Database Catalog Views        12.1.0.2.0  VALID
CATPROC       Oracle Database Packages and Types   12.1.0.2.0  VALID
JAVAVM        JServer JAVA Virtual Machine         12.1.0.2.0  VALID
XML           Oracle XDK                           12.1.0.2.0  VALID
CATJAVA       Oracle Database Java Packages        12.1.0.2.0  VALID
APS           OLAP Analytic Workspace              12.1.0.2.0  VALID
XOQ           Oracle OLAP API                      12.1.0.2.0  VALID
OLS           Oracle Label Security                12.1.0.2.0  VALID

Extrait de la note 2001512.1 :
« One workaround is to use the DataBase Configuration Assistant (dbca) to generate the database creation scripts and then remove the references for the options that are not to be installed. »
La mise en commmentaire dans le script permet de ne pas réaliser l’installation des options correspondantes au moment de l’exécution :

$ cat cdb1.sql
set verify off
ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE
host /scratch/dbuser/app/oracle/product/12.1.0.2/dbhome_1/bin/orapwd file=/scratch/dbuser/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwcdb1 force=y format=12
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/CreateDB.sql
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/CreateDBFiles.sql
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/CreateDBCatalog.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/JServer.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/context.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/ordinst.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/interMedia.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/cwmlite.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/spatial.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/labelSecurity.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/apex.sql
-- @/scratch/dbuser/app/oracle/admin/cdb11/scripts/datavault.sql
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/CreateClustDBViews.sql
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/lockAccount.sql
@/scratch/dbuser/app/oracle/admin/cdb1/scripts/postDBCreation.sql

Une autre solution est de modifier le script PERL ${ORACLE_HOME}/rdbms/admin/catcon.pl.
Ce programme est utilisé pour lancer les scripts associés aux composants.
Si on regarde le répertoire des scripts générés, on constate que le paramètre « -b » permet d’identifier l’option associée :

[oracle ~]$ grep catcon scripts/* | cut -d " " -f 8-1 8- , 8-8-
scripts/apex.sql:host -b catapx -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/apex/catapx.sql 1change_on_install 1SYSAUX 1SYSAUX 1TEMP 1/i/ 1NONE;
scripts/context.sql:host -b catctx -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/ctx/admin/catctx.sql 1change_on_install 1SYSAUX 1TEMP 1LOCK;
scripts/context.sql:host -b dr0defin -u CTXSYS/CTXSYS -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/ctx/admin/defaults/dr0defin.sql 1\"AMERICAN\";
scripts/context.sql:host -b dbmsxdbt /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/dbmsxdbt.sql;
scripts/CreateClustDBViews.sql:host -b catclust /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catclust.sql;
scripts/CreateDBCatalog.sql:host -b catalog /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catalog.sql;
scripts/CreateDBCatalog.sql:host -b catproc /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catproc.sql;
scripts/CreateDBCatalog.sql:host -b catoctk /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catoctk.sql;
scripts/CreateDBCatalog.sql:host -b owminst /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/owminst.plb;
scripts/CreateDBCatalog.sql:host -b pupbld -u SYSTEM/&&systemPassword /u01/app/oracle/product/12.1.0.2/dbhome_1/sqlplus/admin/pupbld.sql;
scripts/CreateDBCatalog.sql:host -b hlpbld -u SYSTEM/&&systemPassword -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/sqlplus/admin/help/hlpbld.sql 1helpus.sql;
scripts/cwmlite.sql:host -b olap -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/olap/admin/olap.sql 1SYSAUX 1TEMP;
scripts/datavault.sql:host -b catmac -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catmac.sql 1SYSAUX 1TEMP 1&&sysPassword;
scripts/interMedia.sql:host -b iminst /u01/app/oracle/product/12.1.0.2/dbhome_1/ord/im/admin/iminst.sql;
scripts/JServer.sql:host -b initjvm /u01/app/oracle/product/12.1.0.2/dbhome_1/javavm/install/initjvm.sql;
scripts/JServer.sql:host -b initxml /u01/app/oracle/product/12.1.0.2/dbhome_1/xdk/admin/initxml.sql;
scripts/JServer.sql:host -b xmlja /u01/app/oracle/product/12.1.0.2/dbhome_1/xdk/admin/xmlja.sql;
scripts/JServer.sql:host -b catjava /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catjava.sql;
scripts/JServer.sql:host -b catxdbj /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catxdbj.sql;
scripts/labelSecurity.sql:host -b catols /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catols.sql;
scripts/ordinst.sql:host -b ordinst -a 1  /u01/app/oracle/product/12.1.0.2/dbhome_1/ord/admin/ordinst.sql 1SYSAUX 1SYSAUX;
scripts/postDBCreation.sql:host -b catbundleapply /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catbundleapply.sql;
scripts/postDBCreation.sql:host -b utlrp /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/utlrp.sql;
scripts/spatial.sql:host -b mdinst /u01/app/oracle/product/12.1.0.2/dbhome_1/md/admin/mdinst.sql;

Il suffit donc de modifier temporairement le script PERL en ajoutant un test pour la présence des options non souhaitées et une sortie directe dans ce cas.
La modification se fait après la ligne die « At least one file name must be supplied » if !@ARGV;) :

[oracle ~]$ cp -p /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl.noopt
[oracle ~]$ cp -p /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl.ori
[oracle ~]$ vi /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl.noopt
# some things must have been specified:
# - base for log file names
# - at least one sqlplus script
die "Base for log file names must be supplied" if !$opt_b;
die "At least one file name must be supplied" if !@ARGV;
##### MODIFIER POUR NE PAS INSTALLER LES COMPOSTANTS
if ( $opt_b ~~ ['catapx'] ) {
   print "***** Do no install APEX *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['catctx', 'dr0defin', 'dbmsxdbt'] ) {
   print "***** Do no install CONTEXT *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['owminst'] ) {
   print "***** Do no install WORKSPACE MANAGER *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['olap'] ) {
   print "***** Do no install OLAP *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['catmac'] ) {
   print "***** Do no install DB VAULT *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['iminst'] ) {
   print "***** Do no install INTERMEDIA *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['initjvm', 'initxml', 'xmlja', 'catjava', 'catxdbj'] ) {
   print "***** Do no install JSERVER *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['catols'] ) {
   print "***** Do no install LABEL SECURITY *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['ordinst'] ) {
   print "***** Do no install MULTIMEDIA *****; exiting\n";
   exit 0
}
if ( $opt_b ~~ ['mdinst'] ) {
   print "***** Do no install SPATIAL *****; exiting\n";
   exit 0
}
####################################################
[oracle ~]$ cp -p /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl.noopt /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl

Exécution de la création du CDB en mode silencieux sans les options indésirables :

[oracle ~]$ dbca \
    -silent \
    -createDatabase \
    -templateName modeleORCL.dbt \
    -gdbName CDBORCL \
    -databaseConfType RAC \
    -sid CDBORCL \
    -createAsContainerDatabase true -numberOfPDBs 0 \
    -sysPassword password \
    -systemPassword password \
    -emConfiguration NONE \
    -dvConfiguration FALSE \
    -storageType ASM \
    -nodelist node1,node2
Creating and starting Oracle instance
1% complete
3% complete
Creating database files
4% complete
7% complete
Creating data dictionary views
8% complete
10% complete
13% complete
14% complete
15% complete
16% complete
18% complete
Adding Oracle JVM
24% complete
29% complete
35% complete
37% complete
Adding Oracle Text
39% complete
40% complete
Adding Oracle Multimedia
41% complete
51% complete
Adding Oracle Spatial
52% complete
59% complete
Adding Oracle Label Security
66% complete
Adding Oracle Application Express
70% complete
74% complete
Adding Oracle Database Vault
81% complete
Creating cluster database views
82% complete
88% complete
Completing Database Creation
90% complete
91% complete
94% complete
97% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/CDBORCL.log" for further details.

La sortie standard affiche les options comme si elles étaient installées mais les opérations sont en fait ignorées, ce qui est visible dans le fichier journal :

[oracle ~]$ grep "***** Do no install" /u01/app/oracle/cfgtoollogs/dbca/CDBORCL/*.log | grep -v trace.log
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/apex.log:**** Do no install APEX *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/context.log:***** Do no install CONTEXT *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/context.log:***** Do no install CONTEXT *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/context.log:***** Do no install CONTEXT *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/CreateDBCatalog.log:***** Do no install WORKSPACE MANAGER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/datavault.log:***** Do no install DB VAULT *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/interMedia.log:***** Do no install INTERMEDIA *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/JServer.log:***** Do no install JSERVER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/JServer.log:***** Do no install JSERVER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/JServer.log:***** Do no install JSERVER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/JServer.log:***** Do no install JSERVER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/JServer.log:***** Do no install JSERVER *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/labelSecurity.log:***** Do no install LABEL SECURITY *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/ordinst.log:***** Do no install MULTIMEDIA *****; exiting
/u01/app/oracle/cfgtoollogs/dbca/CDBORCL/spatial.log:***** Do no install SPATIAL *****; exiting

Et confirmé après la création dans la vue CDB_REGISTRY:

SELECT comp_id, comp_name, version, status FROM cdb_registry ORDER BY con_id;
COMP_ID      COMP_NAME                            VERSION      STATUS
------------ ------------------------------------ ------------ -----------
XDB          Oracle XML Database                  12.1.0.2.0   VALID
RAC          Oracle Real Application Clusters     12.1.0.2.0   VALID
CATPROC      Oracle Database Packages and Types   12.1.0.2.0   VALID
CATALOG      Oracle Database Catalog Views        12.1.0.2.0   VALID

Pour annuler la modification :

[oracle ~]$ cp -p /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl.ori /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin/catcon.pl

Remarques :
– Oracle XML Database est un composant obligatoire en 12c.
– Cette opération permet de réduire notablement le temps de création d’une CDB.
– Ne pas installer JServer JAVA Virtual Machine permet de pas avoir à installer le patch OJVM (no rolling / no standby first).
– Ne pas installer APEX sur la CDB permet d’avoir plusieurs versions différentes d’APEX sur les PDB.

dummydba
dummydba
Voir tous ses articles
Articles récents

Mentions légales & Politique de confidentialité