RE: Oracle license requirements for unused options
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "Jay.Miller@xxxxxxxxxxxxxxxx" <Jay.Miller@xxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2011 16:33:24 +0200
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:
- » Oracle license requirements for unused options- Jay.Miller
- » Re: Oracle license requirements for unused options- Toon Koppelaars
- » RE: Oracle license requirements for unused options- Khan, Arif
- » Re: Oracle license requirements for unused options- Rich Jesse
- » Re: Oracle license requirements for unused options- Paul Drake
- » Re: Oracle license requirements for unused options- Toon Koppelaars
- » Re: Oracle license requirements for unused options- Howard Latham
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » Re: Oracle license requirements for unused options- Iquatealerts
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Allen, Brandon
- » RE: Oracle license requirements for unused options- Goulet, Richard
- » RE: Oracle license requirements for unused options- norman . dunbar . capgemini
- » RE: Oracle license requirements for unused options- Goulet, Richard
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- norman . dunbar . capgemini
- » RE: Oracle license requirements for unused options- Dunbar, Norman (Capgemini)
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Allen, Brandon
- » RE: Oracle license requirements for unused options- Yong Huang
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options - D'Hooge Freek
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- TJ Kiernan
- » RE: Oracle license requirements for unused options- Jay.Miller
- » RE: Oracle license requirements for unused options- DOBSON L.
- » RE: Oracle license requirements for unused options- Chitale, Hemant Krishnarao
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » Re: Oracle license requirements for unused options- De DBA
- » RE: Oracle license requirements for unused options- D'Hooge Freek
- » Re: Oracle license requirements for unused options- Howard Latham
- » RE: Oracle license requirements for unused options- Joel.Patterson
- » Re: Oracle license requirements for unused options- De DBA