RE: Oracle license requirements for unused options
Date: Tue, 18 Oct 2011 15:33:46 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F72592BF96_at_PRDCTWPEMLMB03.prod-am.ameritrade.com>
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_at_uptime.be]
Sent: Tuesday, October 18, 2011 10:33 AM
To: Miller, Jay; oracle-l_at_freelists.org
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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: dinsdag 18 oktober 2011 16:16
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 18 2011 - 10:33:46 CDT