RE: Oracle license requirements for unused options

  • From: <Jay.Miller@xxxxxxxxxxxxxxxx>
  • To: <Freek.DHooge@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Oct 2011 15:33:46 +0000

Hmm, unfortunately awrrpt.sql is exactly what I wanted to double check.  I know 
that we have it unclicked in OEM but it's hard to police awrrpt usage.  I 
suppose we should probably had rm'ed the script from all our test servers to be 
on the safe side but it didn't occur to me until now.



Jay Miller
Sr. Oracle Database Administrator
201.369.8355

-----Original Message-----
From: D'Hooge Freek [mailto:Freek.DHooge@xxxxxxxxx] 
Sent: Tuesday, October 18, 2011 10:33 AM
To: Miller, Jay; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle license requirements for unused options

Jay,

You can check the MGMT_ADMIN_LICENSES view to verify if someone has clicked 
"yes" in the dbconsole when asked if a license was available for the management 
pack.

Don't know if there is a flag set when running the awrrpt.sql script or when 
selecting directly from the hist* tables.

Regards,

 
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jay.Miller@xxxxxxxxxxxxxxxx
Sent: dinsdag 18 oktober 2011 16:16
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle license requirements for unused options

Revisiting this thread from back in May...
Does anyone know of a method in 10g to check whether a Diagnostic Pack option 
was ever used?  I'm concerned that someone might at some point have run an 
awrrpt on a dev database without realizing that required a license and want to 
check whether it has ever happened.

For 11g Oracle provides scripts to check this (option_usages.sql) but they 
don't seem to work in 10g.

Appreciate any help in advance.



BTW - people might find this of interest:
http://searchoracle.techtarget.com/news/2240035131/Common-traps-in-Oracle-licensing-audits
I have verified that when we uninstall certain options and then patch the 
database the options come back.


Thanks,
Jay Miller
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2011