Enable/disable oracle components usinig chopt command like utility:
From 11g relase 2, we can enable/disable oracle components using the command line utility called CHOPT.
This utility is located in $ORACLE_HOME/bin location.
In older versions, In order to enable/disable oracle components we have to use OUI(till 11.1) or we need to enable/disable component at binary level using relink (make) cmd(11.1.0.7)
But from 11g release 2,
Using chopt utility we can enable/disable following components:
dm = Oracle Data Mining RDBMS Files
dv = Oracle Database Vault option
lbac = Oracle Label Security
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
syntax: chopt [ enable | disable] db_option
bash-3.00$ chopt
usage:
chopt
options:
dm = Oracle Data Mining RDBMS Files
dv = Oracle Database Vault option
lbac = Oracle Label Security
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
steps to enable/disable oracle components
1) shutdown the database for which do you want to enable/disable the oracle component.2) enable/disable the component using chopt command.
3) startup the database and verify the component installed using v$option view.
Eg: Enable partitioning for database
select * from v$option where parameter=’ Partitioning’;
PARAMETER VALUE
----------------------- -----------
Partitioning FALSE
shut immediate
cd $ORACLE_HOME/bin
bash-3.00$ chopt enable Partitioning
startup
select * from v$option where parameter=’ Partitioning’;
PARAMETER VALUE
----------------------- -----------
Partitioning TRUE
No comments:
Post a Comment