Enabling and Disabling Database Options

All New From Oracle ….
Amazing Tools , If you install Oracle Database After that you remember that you should enable/Disable some Feature Like Oracle Security ad you Forget Script That Located in RDBMS/admin the What Reinstall Again

In ORACLE 11gR2 you Can do this Easily Just Follow The Below Steps :

The chopt tool is a command-line utility that is located in the ORACLE_HOME\bin directory. The syntax for chopt is as follows:

chopt [ enable | disable] db_option
 

The possible values for db_option described in the following table.

Value Description
dm Oracle Data Mining RDBMS Files
dv Oracle Database Vault
lbac Oracle Label Security
olap Oracle OLAP
partitioning Oracle Partitioning
rat Oracle Real Application Testing
ode_net_2 Oracle Database Extensions for .NET 2.0

 Example :

To enable the Oracle Label Security option in your Oracle binary files

1-Shut down the database with srvctl or SQL*Plus:  

SQL>Shutdown immediate (single node)
 
srvctl stop database -d ORCL

2-Run the following commands: 

cd %ORACLE_HOME%/bin
chopt enable lbac

3-Start Database :

srvctl start database -d ORCL
OR 
SQL>Startup  (Single Node)

In linux the “chopt” statement will show the following output

[oracle@localhost ~]$ chopt
 
usage:
 
chopt [enable|disable] {option}
 
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
 
e.g. chopt enable rat

 Thank you
Osama Mustafa

One thought on “Enabling and Disabling Database Options

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.