How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)
来源:互联网 发布:域名购买之后 编辑:程序博客网 时间:2024/05/21 10:04
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]Other UNIX
Goal
To show how to install/deinstall and/or disable/enable the following database components at the ORACLE_HOME software/binary level:
This requires advanced skills to make the changes and perform the relink.
This note WILL NOT address product specific scripts that are required at the database level for specific components to further complete the install/deinstall process.
Please refer to the appropriate Oracle Component Guide or as a starting point
Note 472937.1 Information On Installed Database Components and Schemas
Furthermore it will only cover UNIX/LINUX and Windows where applicable covering versions 9.2.0.x through 11.2.0.x.
Solution
Checking if products/components have been installed
Starting with releases 11.1.0.7.x and above all products are installed by default and the option to customize the product/component selection is no longer possible.
The only customization that can be done on these releases is to enable or disable certain products/components which will be covered in the following sections.
For versions 9.2.0.x through 11.1.0.6.x product installation can be confirmed in the following manner:
1. Using the Oracle Universal Installer (OUI) from either the $ORACLE_HOME/oui/bin or software installation media:
$ ./runInstaller
click on "Installed Products"
select the ORACLE_HOME
click on "Expand All"
Review the list or products installed.
2. Use the opatch utility:
$ opatch lsinventory -detail
Review the log file in either $ORACLE_HOME/.patch_storage/ or $ORACLE_HOME/cfgtoollogs/opatch/lsinv
Use the following notes to assist with product identification:
Note 783288.1 Oracle Database Software Component Guide for 10gR2
Note 783290.1 Oracle Database Software Component Guide for 11gR1
What file contains the various status's of products/components?
Once the products/components have been confirmed as being installed (applicable only to versions 9.2.0.x through 11.1.0.6.x) then they can be enabled/disabled at the binary level.
The file that contains the status of components being enabled or disabled is:
The relevant files contained within this archive and status's associated with them are:
Automatic Storage Mgt OFF=kfoff.o
Context Management Text ON=kciwcx.o <<CTX is always enabled and cannot be disabled.
Oracle Data Mining ON=dmwdm.o
Oracle Data Mining OFF=dmndm.o
Oracle Database Vault ON=kzvidv.o
Oracle Database Vault OFF=kzvndv.o
Oracle OLAP ON=xsyeolap.o
Oracle OLAP OFF=xsnoolap.o
Oracle Label Security ON= kzlilbac.o
Oracle Label Security OFF= kzlnlbac.o
Oracle Partitioning ON=kkpoban.o
Oracle Partitioning OFF=ksnkkpo.o
Real Application Cluster ON=kcsm.o
Real Application Cluster OFF=ksnkcs.o
Oracle Real Application Testing ON=kecwr.o
Oracle Real Application Testing OFF=kecnr.o
The following command can be used to verify the contents of the archive:
$ ar -tv libknlopt.a
For IBM AIX
$ cd $ORACLE_HOME/rdbms/lib
$ ar -X64 -tv libknlopt.a
Sample output:
rw-rw-r-- 94110/42424 275432 Sep 17 08:28 2011 kkxwtp.o
rw-rw-r-- 94110/42424 46832 Sep 17 07:14 2011 ktd.o
rw-r--r-- 503/502 25144 Sep 17 06:20 2011 kxmwsd.o
rw-r--r-- 503/502 44056 Sep 17 06:14 2011 kciwcx.o
rw-rw-r-- 94110/42424 4040 Sep 17 07:16 2011 sllfls.o
rw-rw-r-- 94110/42424 4032 Sep 17 07:16 2011 kprnts.o
rw-rw-r-- 94110/42424 5104 Sep 17 07:19 2011 kzvndv.o
rw-rw-r-- 94110/42424 4016 Sep 17 06:55 2011 kdzof.o
rw-rw-r-- 94110/42424 1512392 Sep 17 07:03 2011 jox.o
rw-rw-r-- 503/502 4032 Sep 17 06:05 2011 kecwr.o
rw-r--r-- 503/502 6352 Sep 17 06:19 2011 xsyeolap.o
rw-r--r-- 503/502 4872 Sep 17 06:14 2011 kzlnlbac.o
rw-r--r-- 503/502 4024 Sep 17 06:15 2011 dmwdm.o
rw-r--r-- 503/502 4608 Sep 17 05:56 2011 kfoff.o
rw-r--r-- 503/502 5272 Sep 17 05:57 2011 ksnkcs.o
rw-r--r-- 503/502 4032 Sep 17 06:05 2011 kkpoban.o
Checking if products/components have been enabled/disabled at the binary level
An alternative to going through the $ORACLE_HOME/rdbms/lib/libknlopt.a output line by line is to check the archive for the existance of the 'ON' file noted above by running the following command:
$ ar -t libknlopt.a | grep -c <filename>
For IBM AIX
$ cd $ORACLE_HOME/rdbms/lib
$ ar -X64 -t libknlopt.a | grep -c <filename>
Where <filename> is:
For example:
For IBM AIX
$ ar -X64 -t libknlopt.a | grep -c kfon.o
If the output is 0, the option is disabled.
If the output is 1, the option is enabled.
How to enable/disable products/components at the binary level
For all versions 9.2.0.x through 11.2.0.x or above products/components can be enabled or disabled by running 'make' commands and passing the appropriate switch.
Note:
All processes running from the ORACLE_HOME including but not limited to databases, listeners, intelligent agents, etc. must be shutdown/stopped before issuing these commands.
For example to enable/disable Oracle Partitioning:
------
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on ioracle
Disable
-------
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_off ioracle
The list of switches for each product/component are:
Warning: switching on ASM should only be done on Grid Infrastructure Homes in Oracle 11gR2. Doing it on an RDBMS ORACLE_HOME will result in errors on startup.
Starting with 11.2 and above there is a utility called 'chopt' that can be used in UNIX/LINUX and WINDOWS as well.
chopt <enable|disable> <option>
For example to enable/disable Oracle Partitioning:
--------
$ chopt enable partitioning
Disable
---------
$ chopt disable partitioning
This utility only works for the following products/components:
For Oracle Database 12.1 , only the following components can be enabled/disabled:
- How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)
- How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC [ID 28478
- How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (文档 ID 28
- How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (文档 ID 28
- How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (文档 ID 28
- How to Enable and Disable Root Login in Ubuntu
- Oracle - How to enable/disable a scheduled job?
- How to enable syntax highlighting and other options in VIM
- How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC
- How To Enable Android's Developer Options
- How can you disable the UDDI and UDDI Explorer functionality in WebLogic Server? (Doc ID 1274906.1)
- How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active (Doc ID 238507.1)
- Disable and enable Foreign Key and Check Constraints
- How to Relocate and Rename SYSTEM datafiles (Doc ID 191540.1)
- To enable and disable Portal Trace
- How to Enable or Disable DEP in Vista, Windows 7, and Windows 8
- How to disable certain HTTP methods (PUT, DELETE, TRACE and OPTIONS) in JBOSS7
- Oracle 11g: How to add/enable/disable/drop a constraint
- 获取聊天窗口内容
- 设计模式之中介模式
- 视域分析-转载
- Android实战技巧:ViewStub的应用
- Unity3d 内置世界变量
- How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)
- 海量数据库解决方案之视图合并应用原理
- View工作原理(四)view的layout过程
- 某客户在使用vmware将Oracle从物理机迁移到虚拟机碰到问题
- uploadify3.2.1使用详解
- 从零开始学iOS7开发系列教程2-To-do List软件开发实战(已完结)
- std::string 在字符串中查找第n个字符的位置
- Linux 学习小结(Linux文件权限与目录配置)
- Win server 2008 64位IIS 7加载非托管C++ dll(native dll)