Database Upgrade from 9.2.0.6 to 10.2.0.5 question related to Oracle Label Security OLS
Dear Experts,
9.2.0.6 version does not have Oracle Label Security installed (see below query under Oracle Label Security) . But read me (see below under READ ME ) for upgrading 9.2.0.6 to 10.2.0.5, it says we need to install it from 9.2 installer and then run a script catnools.sql to remove it -- why? Can we do the 10.2.0.5 upgrade without installing Oracle Label Security that is not needed.
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security'; --- from 9i
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Oracle Label Security
====READ ME==============================================================
10.1.2 Upgrading a Release 9.2 Database Not Using Oracle Label Security
To avoid errors when upgrading from release 9.2, Oracle Label Security should be installed. Use one of the following methods to check if Oracle Label Security is installed:
9.2.0.6 version does not have Oracle Label Security installed (see below query under Oracle Label Security) . But read me (see below under READ ME ) for upgrading 9.2.0.6 to 10.2.0.5, it says we need to install it from 9.2 installer and then run a script catnools.sql to remove it -- why? Can we do the 10.2.0.5 upgrade without installing Oracle Label Security that is not needed.
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security'; --- from 9i
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Oracle Label Security
====READ ME==============================================================
10.1.2 Upgrading a Release 9.2 Database Not Using Oracle Label Security
To avoid errors when upgrading from release 9.2, Oracle Label Security should be installed. Use one of the following methods to check if Oracle Label Security is installed:
0