La configuration des options sous Entreprise Edition avant Oracle 11g pouvait être un véritable parcours du combattant. Donc, une attention particulière devait avoir lieu avant l’installation des binaires Oracle; à savoir quelles options devaient être installées! Depuis la version 11g, les choses ont bien changé, grâce à l’utilitaire “chopt” se trouvant sous $ORACLE_HOME/bin.

Voici la syntaxe d’utilisation de “chopt”:

chopt [enable |disable] db_option

db_option:

  • dm = Oracle Data Mining
  • dv = Oracle Database Vault
  • lbac = Oracle Label Security
  • olap = Oracle OLAP
  • partitioning = Oracle Partitionin
  • rat = Oracle Real Application Testing
  • ode_net = Oracle Database Extensions for .NET 1.x
  • ode_net_2 = Oracle Database Extensions for .NET 2.0

Voici un exemple d’utilisation de “chopt”:

  • Activation du data mining:
oracle@SORCQ01:/u00/app/oracle/product/11.2.0/db_1bin [dbq1] chopt enable dmWriting to /u00/app/oracle/product/11.2.0/db_1/install/enable_dm.log...
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk dm_on ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcr.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 208456    Maximum size: 65536
        Extra instructions are being generated for each reference to a TOC
        symbol if the symbol is in the TOC overflow area.
  • Vérification de la bannière:
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 14:00:01 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With Data Mining options
  • Désactivation du data mining:
oracle@SORCQ01:/u00/app/oracle/product/11.2.0/db_1bin [dbq1] chopt disable dmWriting to /u00/app/oracle/product/11.2.0/db_1/install/disable_dm.log...
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk dm_off ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcr.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 208456    Maximum size: 65536
        Extra instructions are being generated for each reference to a TOC
        symbol if the symbol is in the TOC overflow area.
  • Vérification de la bannière:
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 14:04:05 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Il est donc bien plus facile d’ajouter ou d’enlever des options avec la version Oracle 11g via “chopt”. De plus, il n’est pas nécesssaire de lancer un arrêt de la base. C’est très pratique.