[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;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2932711/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Disable Database Audit In Oracle 19c RAC-20220111DatabaseOracle
- alter database disable thread 2Databasethread
- ADFS – How to enable Trace Debugging and advanced access logging
- How to enable Traefik Dashborad in K3s
- oracle ENABLE=BROKENOracle
- How to disable transparent hugepages (THP) on Red Hat Enterprise Linux 7Linux
- How to disable transparent Hugepage (THP) on Red Hat Enterprise Linux 8?Linux
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- ORACLE database vaultOracleDatabase
- Oracle clone databaseOracleDatabase
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Oracle Database Scheduler整理OracleDatabase
- Oracle Physical Database LimitsOracleDatabaseMIT
- Oracle ENABLE=broken引數與TCP KeepAliveOracleTCP
- AD-禁用賬戶命令 Disable-ADAccount & 批量啟用賬戶命令 Enable-adaccount
- Disable Tfa In Oracle 19c RAC-20220112Oracle
- How Oracle Store Number internal(zt)Oracle
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- How to Install EMC PowerPath on Oracle VM 3.4Oracle
- Oracle 19c Concepts(01):Introduction to Oracle DatabaseOracleDatabase
- Oracle 19c Concepts(13):Oracle Database InstanceOracleDatabase
- Oracle OCP(35):Database 安裝OracleDatabase
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle DG Standby Database型別OracleDatabase型別
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- Oracle 12C Database File Mapping for Oracle ASM FilesOracleDatabaseAPPASM
- oracle非同步IO之filesystemio_options引數Oracle非同步
- Oracle OCP(38):Database 物理結構OracleDatabase
- 關於Oracle Database Vault介紹OracleDatabase
- Scheduler in Oracle Database 10g(轉)OracleDatabase
- [翻譯]-Detect And Repair Corruption in an Oracle DatabaseAIOracleDatabase
- Oracle 19c Database Management ToolsOracleDatabase
- Oracle 19c Concepts(00):Changes in This Release for Oracle Database ConceptsOracleDatabase
- 【Oracle】Windows安裝oracle11gR1 database 11.1.0.6OracleWindowsDatabase
- How To Deal With Split Brain In Oracle 19c RacAIOracle
- Disable the Evolve Job SYS_AUTO_SPM_EVOLVE_TASK in Oracle 12cOracle
- Oracle OCP(37):Database 體系結構OracleDatabase