How 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
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 |

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Kernelsecuritycheckfailure (kernel check failure) is a relatively common type of stop code. However, no matter what the reason is, the blue screen error causes many users to be very distressed. Let this site carefully introduce 17 types to users. Solution. 17 solutions to kernel_security_check_failure blue screen Method 1: Remove all external devices When any external device you are using is incompatible with your version of Windows, the Kernelsecuritycheckfailure blue screen error may occur. To do this, you need to unplug all external devices before trying to restart your computer.

In computers, enable refers to enabling or activating a certain function or option. In the computer field, enable is usually used to describe the process of enabling a certain function or option in software or hardware. Detailed introduction: 1. In terms of software, enable usually refers to enabling a certain function in an application or operating system; 2. In terms of hardware, enable usually refers to enabling a certain device or interface in a computer system.

SPDIFOUT connection line sequence on the motherboard. Recently, I encountered a problem regarding the wiring sequence of the wires. I checked online. Some information says that 1, 2, and 4 correspond to out, +5V, and ground; while other information says that 1, 2, and 4 correspond to out, ground, and +5V. The best way is to check your motherboard manual. If you can't find the manual, you can use a multimeter to measure it. Find the ground first, then you can determine the order of the rest of the wiring. How to connect motherboard VDG wiring When connecting the VDG wiring of the motherboard, you need to plug one end of the VGA cable into the VGA interface of the monitor and the other end into the VGA interface of the computer's graphics card. Please be careful not to plug it into the motherboard's VGA port. Once connected, you can

This article will guide you to turn off the PalmCheck function on Windows 11/10 PC. PalmCheck is a feature designed to prevent accidental palm or other touches from being mistakenly recognized as input when typing on the keyboard. This is usually found in touchpad settings, especially on touch-enabled devices like laptops. Sometimes you may want to turn off PalmCheck or a similar feature to give you more flexibility in controlling input in situations where you need to use both the keyboard and touchpad. In this article, we will introduce how to disable PalmCheck function on Windows 11/10 PC, so that you can better cope with the needs when gaming or running applications. What is the P on the touchpad?

When performing load balancing, a health check tool is generally deployed to ensure that the backend realserver is normal and can provide services. To avoid the situation where the backend realserver is down or the service is unavailable, the load balancer will distribute the request to the realserver. Impact on overall business access. There are many ways to perform health checks, and you can deploy scripts by yourself. Of course, the most commonly used one is the keepalived service. There are three health check methods for keepalived, tcp_check, http_check, and misc_check. Keepalived configuration brief keepalived has three main modules, namely core,

To use vsftpd to build an FTP server on an Ubuntu system, you can follow the steps below: Install vsftpd: Open a terminal and execute the following command to install vsftpd: sudoaptupdatesudoaptinstallvsftpd Configure vsftpd: Use a text editor (such as nano or vi) to open the configuration of vsftpd File: sudonano/etc/vsftpd.conf In the configuration file you can make the following changes or add as needed: Enable anonymous access (if needed): anonymous_enable=YES Disable anonymous upload (if needed): anon_upload

This article will provide a detailed introduction to how to install and register a Bitcoin trading application. The Bitcoin trading app allows users to manage and trade cryptocurrencies such as Bitcoin. The article guides users through the installation and registration process step by step, including downloading applications, creating accounts, performing identity verification, and first deposit. The goal of the article is to provide beginners with clear and easy-to-understand guidelines to help them easily enter the world of Bitcoin trading.

This article recommends the top ten digital currency trading apps in the world, including Binance, OKX, Huobi Global, Coinbase, Kraken, Gate.io, KuCoin, Bitfinex, Gemini and Bitstamp. These platforms have their own characteristics in terms of transaction pair quantity, transaction speed, security, compliance, user experience, etc. For example, Binance is known for its high transaction speed and extensive services, while Coinbase is more suitable for novices. Choosing a platform that suits you requires comprehensive consideration of your own needs and risk tolerance. Learn about the world's mainstream digital currency trading platforms to help you conduct digital asset trading safely and efficiently.
