If you are trying to use label security in 11gR2 on Linux, you will probably have to relink Oracle with the following command to see the option in the DBCA.
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk lbac_on ioracle
Configure Instance
Once Oracle Label Security option has been installed on the server it can be added to an instance as follows.
• Start the Database Configuration Assistant (DBCA).
• On the Welcome screen click the Next button.
• On the Operations screen select the "Configure database options in a database" option and click the Next button.
• On the Databases screen select the relevant instance and click the Next button.
• On the Database Features screen select the Oracle Label Security option and click the Next button.
•Click the Finish button.
• Popup screens will appear to tell you what operations will be performed and that the database must be restarted once complete. Click the OK button on these popups.
• Once complete exit the DBCA and stop and start your instance.
good
ReplyDelete