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
How to use MySQL functions for data processing and calculationHow to use MySQL functions for data processing and calculationApr 29, 2025 pm 04:21 PM

MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.

An efficient way to batch insert data in MySQLAn efficient way to batch insert data in MySQLApr 29, 2025 pm 04:18 PM

Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.

Steps to add and delete fields to MySQL tablesSteps to add and delete fields to MySQL tablesApr 29, 2025 pm 04:15 PM

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.

How to analyze the execution plan of MySQL queryHow to analyze the execution plan of MySQL queryApr 29, 2025 pm 04:12 PM

Use the EXPLAIN command to analyze the execution plan of MySQL queries. 1. The EXPLAIN command displays the execution plan of the query to help find performance bottlenecks. 2. The execution plan includes fields such as id, select_type, table, type, possible_keys, key, key_len, ref, rows and Extra. 3. According to the execution plan, you can optimize queries by adding indexes, avoiding full table scans, optimizing JOIN operations, and using overlay indexes.

How to use MySQL subquery to improve query efficiencyHow to use MySQL subquery to improve query efficiencyApr 29, 2025 pm 04:09 PM

Subqueries can improve the efficiency of MySQL query. 1) Subquery simplifies complex query logic, such as filtering data and calculating aggregated values. 2) MySQL optimizer may convert subqueries to JOIN operations to improve performance. 3) Using EXISTS instead of IN can avoid multiple rows returning errors. 4) Optimization strategies include avoiding related subqueries, using EXISTS, index optimization, and avoiding subquery nesting.

How to configure the character set and collation rules of MySQLHow to configure the character set and collation rules of MySQLApr 29, 2025 pm 04:06 PM

Methods for configuring character sets and collations in MySQL include: 1. Setting the character sets and collations at the server level: SETNAMES'utf8'; SETCHARACTERSETutf8; SETCOLLATION_CONNECTION='utf8_general_ci'; 2. Create a database that uses specific character sets and collations: CREATEDATABASEexample_dbCHARACTERSETutf8COLLATEutf8_general_ci; 3. Specify character sets and collations when creating a table: CREATETABLEexample_table(idINT

How to uninstall MySQL and clean residual filesHow to uninstall MySQL and clean residual filesApr 29, 2025 pm 04:03 PM

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

How to rename a database in MySQLHow to rename a database in MySQLApr 29, 2025 pm 04:00 PM

Renaming a database in MySQL requires indirect methods. The steps are as follows: 1. Create a new database; 2. Use mysqldump to export the old database; 3. Import the data into the new database; 4. Delete the old database.

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

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function