[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;