search
HomeDatabaseMysql TutorialHow to Check and Enable/Disable Oracle Binary Options (Doc I

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/bin

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:

 
Product/Component Short Name
Automated Storage Management ASM
Context Management Text CTX
Oracle Data Mining DM
Database Vault DV
Oracle OLAP OLAP
Oracle Label Security OLS
Oracle Partitioning PART
Real Application Cluster RAC
Real Application Testing RAT

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 divs.

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:

$ cd

$ ./runInstaller

  click on "Installed Products"
  select the ORACLE_HOME
  click on "Expand All"
  Review the list or products installed.

2. Use the opatch utility:

$ export PATH=$ORACLE_HOME/OPatch:$PATH

$ 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:

$ORACLE_HOME/rdbms/lib/libknlopt.a

The relevant files contained within this archive and status's associated with them are:

Automatic Storage Mgt ON=kfon.o
Automatic Storage Mgt OFF=kfoff.o

Context Management Text ON=kciwcx.o
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:

$ cd $ORACLE_HOME/rdbms/lib

$ ar -tv libknlopt.a

For IBM AIX

$ cd $ORACLE_HOME/rdbms/lib

$ ar -X64 -tv libknlopt.a

 Sample output:

$ ar -tv libknlopt.a
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:

$ cd $ORACLE_HOME/rdbms/lib

$ ar -t libknlopt.a | grep -c

For IBM AIX

$ cd $ORACLE_HOME/rdbms/lib

$ ar -X64 -t libknlopt.a | grep -c

Where is:

 
Product/Component Short Name
Automated Storage Management ASM kfon.o
Oracle Data Mining DM dmwdm.o
Database Vault DV kzvidv.o
Oracle OLAP OLAP xsyeolap.o
Oracle Label Security OLS kzlilbac.o
Oracle Partitioning PART kkpoban.o
Real Application Cluster RAC kcsm.o
Real Application Testing RAT kecwr.o

For example:

$ ar -t libknlopt.a | grep -c kfon.o

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:

Enable
------

$ 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:

 
Product/Component Enable Switch Disable Switch
Automated Storage Management asm_on asm_off
Oracle Data Mining dm_on dm_off
Database Vault dv_on dv_off
Oracle OLAP olap_on olap_off
Oracle Label Security lbac_on lbac_off
Oracle Partitioning part_on part_off
Real Application Cluster rac_on rac_off
Real Application Testing rat_on rat_off

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.

usage:

chopt

For example to enable/disable Oracle Partitioning:

Enable
------
--
$ chopt enable partitioning

Disable
-------
--
$ chopt disable partitioning

This utility only works for the following products/components:

 
Product/Component Option
Oracle Data Mining dm
Database Vault dv
Oracle OLAP olap
Oracle Label Security lbac
Oracle Partitioning partitioning
Real Application Testing rat


For Oracle Database 12.1 , only the following components can be enabled/disabled:

 
Product/Component Option
Oracle Data Mining dm
Oracle OLAP olap
Oracle Partitioning partitioning
Real Application Testing rat


Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
解决kernel_security_check_failure蓝屏的17种方法解决kernel_security_check_failure蓝屏的17种方法Feb 12, 2024 pm 08:51 PM

Kernelsecuritycheckfailure(内核检查失败)就是一个比较常见的停止代码类型,可蓝屏错误出现不管是什么原因都让很多的有用户们十分的苦恼,下面就让本站来为用户们来仔细的介绍一下17种解决方法吧。kernel_security_check_failure蓝屏的17种解决方法方法1:移除全部外部设备当您使用的任何外部设备与您的Windows版本不兼容时,则可能会发生Kernelsecuritycheckfailure蓝屏错误。为此,您需要在尝试重新启动计算机之前拔下全部外部设备。

电脑里enable是什么意思电脑里enable是什么意思Aug 30, 2023 pm 01:55 PM

电脑里enable是指的是启用或激活某个功能或选项的意思,在计算机领域,enable通常用于描述在软件或硬件中启用某种功能或选项的过程。详细介绍:1、在软件方面,enable通常指的是在应用程序或操作系统中启用某个功能;2、在硬件方面,enable通常指的是在计算机系统中启用某个设备或接口。

如何在Windows 11/10中关闭Palm Check如何在Windows 11/10中关闭Palm CheckFeb 19, 2024 pm 09:45 PM

本文将指导您在Windows11/10PC上关闭PalmCheck功能。PalmCheck是一项设计用来防止在键盘输入时意外手掌或其他部位的触摸被误识别为输入的功能。通常可以在触摸板设置中找到,特别是在笔记本电脑等设备上具有触摸功能的设备。有时候,您可能需要关闭PalmCheck或类似的功能,以便在需要同时使用键盘和触摸板的情况下更加灵活地控制输入。在本文中,我们将介绍如何在Windows11/10PC上禁用PalmCheck功能,让您能够更好地应对游戏或运行应用程序时的需求。什么是触摸板上的P

主板上的数字音频输出接口-SPDIF OUT主板上的数字音频输出接口-SPDIF OUTJan 14, 2024 pm 04:42 PM

主板上SPDIFOUT连接线序最近我遇到了一个问题,就是关于电线的接线顺序。我上网查了一下,有些资料说1、2、4对应的是out、+5V、接地;而另一些资料则说1、2、4对应的是out、接地、+5V。最好的办法是查看你的主板说明书,如果找不到说明书,你可以使用万用表进行测量。首先找到接地,然后就可以确定其他的接线顺序了。主板vdg怎么接线连接主板的VDG接线时,您需要将VGA连接线的一端插入显示器的VGA接口,另一端插入电脑的显卡VGA接口。请注意,不要将其插入主板的VGA接口。完成连接后,您可以

解读Linux 系统Keepalived健康检查机制解读Linux 系统Keepalived健康检查机制Feb 28, 2024 am 09:52 AM

在进行负载均衡时,一般都会部署一个健康检查工具,确保后端realserver是正常的,可以提供服务的,避免出现后端realserver已经宕机或服务不可用时,负载均衡器扔将请求分发到realserver,影响整体业务访问。健康检查的方式有很多,可以自行部署脚本,当然当前用的比较多的就是keepalived服务了。keepalived的健康检查方式有三种,tcp_check、http_check、misc_check。keepalived配置简述keepalived主要有三个模块,分别是core、

ubuntu系统使用vsftpd搭建FTP服务器。ubuntu系统使用vsftpd搭建FTP服务器。Feb 18, 2024 pm 05:50 PM

在Ubuntu系统上使用vsftpd搭建FTP服务器,您可以按照以下步骤进行操作:安装vsftpd:打开终端,并执行以下命令来安装vsftpd:sudoaptupdatesudoaptinstallvsftpd配置vsftpd:使用文本编辑器(如nano或vi)打开vsftpd的配置文件:sudonano/etc/vsftpd.conf在配置文件中,您可以根据需要进行以下更改或添加:启用匿名访问(如果需要):anonymous_enable=YES禁用匿名上传(如果需要):anon_upload

btc交易app怎么安装注册?btc交易app怎么安装注册?Feb 21, 2025 pm 07:09 PM

本篇文章将详细介绍如何安装和注册比特币交易应用。比特币交易应用允许用户管理和交易比特币等加密货币。文章逐步指导用户完成安装和注册过程,包括下载应用程序、创建账户、进行身份验证和首次存款。文章的目标是为初学者提供清晰易懂的指南,帮助他们轻松进入比特币交易的世界。

SQL语句中的AND运算符和OR运算符怎么用SQL语句中的AND运算符和OR运算符怎么用May 28, 2023 pm 04:34 PM

SQLAND&OR运算符AND和OR运算符用于基于一个以上的条件对记录进行过滤。AND和OR可在WHERE子语句中把两个或多个条件结合起来。如果第一个条件和第二个条件都成立,则AND运算符显示一条记录。如果第一个条件和第二个条件中只要有一个成立,则OR运算符显示一条记录。"Persons"表:LastNameFirstNameAddressCityAdamsJohnOxfordStreetLondonBushGeorgeFifthAvenueNewYorkCarter

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment