Install/Deinstall Oracle Lable Secuirty

Oracle provide you with amazing tools to secure your data, and make sure no one will access to it. One of this amazing tools is Oracle label security (OLS) allows access control down to individual rows based on attached labels. Similar functionality can be reproduced using Fine Grained Access Control (FGAC) but OLS provides an out-of-the-box solution to row-level security. In this article I’ll present a simple example of the configuration of OLS.

To understand OLS you could read oracle documentation about it, OLS has two parts One binary which installed through Oracle Universal Installer (OUI) and to know if you have been install it you can check log in information to sqlplus  banner

Oracle Label Security  ….

All this in the 11g become more easier since you can install all features while you choose enterprise edition and use chopt to enable and disable :

chopt enable lbac
chopt disable lbac

 talking about second part which can be installed via PL/SQL packages,all this can be installed thru catols.sql
and you can use this way in 10g or 11g, and to de-install the OLS you can use the catnools.sql. but just as information oracle recommend that to install OLS you need to use DBCA.

if you decide to goes thru manual way its better to read MOS notes since you need to apply some patches to complete the installation.

sqlplus / as sysdba
SQL> @?/rdbms/admin/catols.sql

sqlplus / as sysdba
SQL> @?/rdbms/admin/catnools.sql

Just as note : If you install OLS while installation AUD$ table dropped from SYS schema and recreated on SYSTEM to be –> SYSTEM.AUD$

And Once you remove OLS its recreated again on SYS.AUD$

Thank you
Osama Mustafa

Manually Install/De-Install Database Options in Oracle Database 10gR2


When a new database is created using DBCA, by default some of the common database options are installed like Oracle JVM and Oracle Text. But, when you manually create the database none of them get installed. You need to manually install them. I thought of sharing Metalink Note Id’s for some of the Common Database Options which you can manually install/de-install once database has been created:

Oracle JVM
Note:276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X

Oracle Text
Note:280713.1 Manual installation, deinstallation of Oracle Text 10gR1 and 10gR2

Oracle XML DB
Note:243554.1 How to Deinstall and Reinstall XML Database (XDB)

Oracle Multimedia
Installation, Upgrade and Downgrade information can be found in the following Manual: Oracle® interMedia User’s Guide 10g Release 2 (10.2) Appendix B Installing and Upgrading Oracle interMedia 

Oracle OLAP
Note:296187.1 How To Manually Install Oracle OLAP into a 9i or 10g Database After the DB Has Been Created 

Oracle Spatial
Note:270588.1 Steps for Manual Installation / Verification of Spatial 10g

Oracle Ultra Search
Note:337992.1 How to Manually Install and Uninstall Ultra Search 10gR2 Server Components 

Oracle Label Security
Note:171155.1 How to Install / Deinstall Oracle Label Security Oracle9i/10g

Sample Schemas
  Note:340112.1 How To Install Sample Schemas in 10g?

Enterprise Manager Repository
Note:114763.1 How to Create Enterprise Manager 2.1 Repository Using EMCA

Oracle Application Express
Note:445205.1 How to download and install Application Express / HTMLDB

Oracle Warehouse Builder
Note:459961.1 How to Install Warehouse Builder Repository( on a RAC Database on Windows and UNIX 

Oracle Database Vault
Note:445092.1 How to Install Database Vault Patches on top of

Oracle Database Extensions for .NET
Note:374820.1 How to Install the Oracle Database Extensions for .NET (ODE.NET) Hope you find this document helpful 🙂

Thanks For our Friend Momen For this Artical its was posted in his blog.
and i share for more useful information .