Hi,
I'm having a strange question, when we have done auditing, we found that we have agreed to use the packages, we are not actually using the packages. qwq need to remove this, please let me know how can I do it ( we have not even configured OEM, so manually we need to remove.)
SQL> select * from sysman.mgmt_licenses;
USERNAME TIMESTAMP I_AGREE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------- --------------------------------
SYSTEM 10-Jun-05 YES
SQL>
SQL> select distinct a.pack_display_label as OEM_PACK,decode(b.pack_name, null, 'NO', 'YES') as PACK_ACCESS_GRANTED,PACK_ACCESS_AGREED from SYSMAN.MGMT_LICENSE_DEFINITIONS a,SYSMAN.MGMT_ADMIN_LICENSES b,(select decode(count(*), 0, 'NO', 'YES') as PACK_ACCESS_AGREED from SYSMAN.MGMT_LICENSES where upper(I_AGREE)='YES') c where a.pack_label = b.pack_name(+) order by 1, 2;
OEM_PACK PAC PAC
-------------------------------------------------------------------------------------------------------------------------------- --- ---
Application Server Configuration Pack YES YES
Application Server Diagnostics Pack YES YES
Database Configuration Pack YES YES
Database Diagnostics Pack YES YES
Database Tuning Pack YES YES
SQL> sho parameter pack
SQL>
Version: 10.2.0.3
O.S: AIX 6.1
Please let me know how to remove these packages and permissons.
p.s I know to remove options using chopt command, can I use the same to remove the permissions?
Thanks and Regards
Venkata