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 |

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

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

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

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

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

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

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

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


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

SublimeText3 Linux new version
SublimeText3 Linux latest version

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

Atom editor mac version download
The most popular open source editor

WebStorm Mac version
Useful JavaScript development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
