[20221222]How to Enable and Disable Database Options in oracle 11g.txt

[20221222]How to Enable and Disable Database Options in oracle 11g.txt

Here is the list of database options and switches:

Database Option              ON        OFF
Data Mining                  dm_on     dm_off
Data Mining Scoring Engine   dmse_on   dmse_off
Database Vault               dv_on     dv_off
Label Security               bac_on    lbac_off
Partitioning                 part_on   part_off
Real Application Clusters    rac_on    rac_off
Spatial                      sdo_on    sdo_off
Real Application Testing     rat_on    rat_off
OLAP                         olap_on   olap_off
Automatic Storage Management asm_on    asm_off
Context Management Text      ctx_on    ctx_off

for example:

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_off ioracle

--//也可以使用chopt enable/disable.

$ chopt
usage:
chopt <enable|disable> <option>
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

--//選項大部分在libknlopt.a檔案中.
$ locate libknlopt.a
/u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/lib/libknlopt.a

$ ar -t /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/lib/libknlopt.a
kkxwtp.o
kfoff.o
ktd.o
kxmwsd.o
kciwcx.o
sllfls.o
kprnts.o
kzlnlbac.o
kzvndv.o
kdzof.o
jox.o
ksnkcs.o
kecwr.o
kkpoban.o
dmwdm.o
xsyeolap.o

這篇文章涉及到的Binary Options 如下：
RAC (Real Application Cluster)
RAT (Real Application Testing)
OLS (Oracle Label Security)
DV (Database Vault)
ASM (Automated Storage Management)
OLAP (Oracle OLAP)
PART (Oracle Partitioning)
CTX (Context Management Text)

這裡的file 引數可以包含內容：

RAC - kcsm.o
RAT - kecwr.o
OLS - kzlilbac.o
DV - kzvidv.o
ASM - kfon.o
OLAP - xsyeolap.o
PART - kkpoban.o
CTX - kciwcx.o

% make -f ins_rdbms.mk {option}

這裡的Option 可以使用使用如下值：

RAC - rac_on / rac_off
RAT - rat_on / rat_off
OLS - lbac_on / lbac_off
DV - dv_on / dv_off
ASM - asm_on / asm_off
OLAP - olap_on / olap_off
PART - part_on / part_off
CTX - ctx_on / ctx_off
DM - dm_on / dm_off

--//也可以透過查詢檢視v$option獲取相關資訊.
--//select * from v$option;