11 Replies Latest reply: Apr 30, 2014 6:55 AM by venkata_sudheer RSS

    Uninstall license and packs

    venkata_sudheer

      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