RE: Oracle License for Optional Packs Question

Advanced compression will also be triggered if someone issues an expdp command with the COMPRESSION option. We were bit by that once. The DBA who did it had no idea it was a license violation. Neither did anyone else until it suddenly showed up in dba_feature_usage_statistics.

Jay Miller
Sr. Oracle DBA
201.369.8355

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Knecht Sent: Friday, November 17, 2017 12:51 AM To: Nagaraj S
Cc: dba oracle; oracle-l
Subject: Re: Oracle License for Optional Packs Question

The four options you are concerned with, can't be disabled. It would be simple for Oracle to implement a mechanisms to do so, but I suppose all the accidental violations that netted them money, outweigh the benefit of doing so.

Particularly advanced security or advanced compression are tricky because they can be used outside of the database as well (think Data Guard Redo Compression or RMAN backup compression, for example).

What I have seen some people do is run a job in the database that scans for objects that would violate their allowed functionality, and produce an alert when something was found. My framework, zztat, can also run checks like this.

If you have already found something inside the database that uses such functionality, the only way out is, as you have stated, a full export / import.

Stefan

--

//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at zztat.net<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=WGczLAQxy3u3y9Yi6DWT-fKlY6xo2bm42gVydi-H-Qw&s=Wunyd2JZC6zHsiF0WIzkrQq8bFDU4-YmnKY64wuDt6M&e=> | Support our Indiegogo campaign at igg.me/at/zztat<https://urldefense.proofpoint.com/v2/url?u=http-3A__igg.me_at_zztat&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=WGczLAQxy3u3y9Yi6DWT-fKlY6xo2bm42gVydi-H-Qw&s=KnQ-DXDfBpRrBy2IT3AD2S8WVCcBE7C0T6mjvnghtR4&e=> | _at_zztat_oracle
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 17 2017 - 22:03:38 CET