chopt – Desabilitando Options do Oracle Database

Aprendi essa no Blog Upgrade your Database – NOW!.

Pena que apenas quatro Options possam ser removidas por esta ferramenta.

[ricardo@Melquior ~]$ chopt

usage:

chopt enable|disable option

options:
                  dm = Oracle Data Mining RDBMS Files
                olap = Oracle OLAP
        partitioning = Oracle Partitioning
                 rat = Oracle Real Application Testing

e.g. chopt enable rat


[ricardo@Melquior ~]$
[ricardo@Melquior ~]$ chopt disable dm

Writing to /home/ricardo/oracle/base/product/12.1.0.2/db_1/install/disable_dm.log...
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk dm_off ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1

[ricardo@Melquior ~]$
[ricardo@Melquior ~]$ chopt disable olap

Writing to /home/ricardo/oracle/base/product/12.1.0.2/db_1/install/disable_olap.log...
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk olap_off ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1

[ricardo@Melquior ~]$
[ricardo@Melquior ~]$ chopt disable rat

Writing to /home/ricardo/oracle/base/product/12.1.0.2/db_1/install/disable_rat.log...
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk rat_off ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1
/usr/bin/make -f /home/ricardo/oracle/base/product/12.1.0.2/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/ricardo/oracle/base/product/12.1.0.2/db_1

[ricardo@Melquior ~]$

4 comments

  1. Legal…..

    Parece que as option que podem ser removidas são aquelas selecionadas na tela de instalação “Select Database Edition” (No box “Select option…”).

    SQL> !chopt

    usage:

    chopt

    options:
    dm = Oracle Data Mining RDBMS Files
    dv = Oracle Database Vault option
    lbac = Oracle Label Security
    olap = Oracle OLAP
    partitioning = Oracle Partitioning
    rat = Oracle Real Application Testing

    e.g. chopt enable rat

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.