{"id":15731,"date":"2024-10-21T12:07:28","date_gmt":"2024-10-21T11:07:28","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=15731"},"modified":"2024-10-21T12:38:47","modified_gmt":"2024-10-21T11:38:47","slug":"oracle-lms","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2024\/10\/21\/oracle-lms\/","title":{"rendered":"Oracle LMS"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Introduction<\/h3>\n\n\n\n<p>As a former Oracle LMS qualified auditor my opinion is sometimes requested before\/during\/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if<\/p>\n\n\n\n<p><em>\u201cThe Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide opinions on compliance status and will provide guidance, education and impartial opinions on a customer or partner\u2019s compliance state. For more information please visit the following website: http:\/\/www.oracle.com\/corporate\/lms.\u201d<\/em><\/p>\n\n\n\n<p>I very do hope that you will find interesting tips in this blog.<\/p>\n\n\n\n<p>Most of the time when a customer would like to check which Oracle options are used by his database infrastructure he is using the well known script \u201c<a href=\"https:\/\/support.oracle.com\/epmos\/main\/downloadattachmentprocessor?parent=DOCUMENT&amp;sourceId=1317265.1&amp;attachid=1317265.1:OPTIONUSAGESTAT&amp;clickstream=yes\">option_packs_usage_statistics.sql<\/a>\u201d. dbi services did checks of the options detected by the script provided by Oracle (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=1317265.1\"><em>My Oracle Support DOC ID 1317265.1<\/em><\/a>). Depending on your database usage this script will detect the usage of different options, but could you really trust the output of this script and how to interpret the output ?<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">Can we trust the output of option_packs_usage_statistics.sql ?<\/h6>\n\n\n\n<p>Posted from: <a href=\"https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/\">https:\/\/www.dbi-services.com\/blog\/could-you-trust-option_packs_usage_statistics-sql\/<\/a><\/p>\n\n\n\n<p><strong>More links: <\/strong><\/p>\n\n\n\n<p><strong>Is your DBA_FEATURE_USAGE_STATISTICS up-to-date?<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/is-your-dba_feature_usage_statistics-up-to-date\/\">https:\/\/www.dbi-services.com\/blog\/is-your-dba_feature_usage_statistics-up-to-date\/<\/a><\/p>\n\n\n\n<p><strong>Output from utility:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/mdinh.wordpress.com\/2023\/09\/06\/options_packs_usage_statistics-sql\/\">https:\/\/mdinh.wordpress.com\/2023\/09\/06\/options_packs_usage_statistics-sql\/<\/a><\/p>\n\n\n\n<p><strong>LMS official web site &amp; compliance<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/corporate\/license-management-services\/compliance\">https:\/\/www.oracle.com\/corporate\/license-management-services\/compliance<\/a><\/p>\n\n\n\n<h6 class=\"wp-block-heading\">Oracle LMS Scripts &amp; License Audit Tools &#8211; Ultimate guide<\/h6>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/@RedressCompliance\"><\/a><a href=\"https:\/\/www.youtube.com\/@RedressCompliance\">Redress Compliance &#8211; Oracle Licensing Experts<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\"  id=\"_ytid_90429\"  width=\"1200\" height=\"675\"  data-origwidth=\"1200\" data-origheight=\"675\" src=\"https:\/\/www.youtube.com\/embed\/CcSZmvu-0uI?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  epyt-is-override  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Introduction As a former Oracle LMS qualified auditor my opinion is sometimes requested before\/during\/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if \u201cThe Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2024\/10\/21\/oracle-lms\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Oracle LMS<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":15733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[384,1047,1048],"tags":[],"class_list":["post-15731","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer-science","category-oracle-it-vendors","category-oracle-blog-oracle-it-vendors"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=15731"}],"version-history":[{"count":3,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15731\/revisions"}],"predecessor-version":[{"id":15737,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/15731\/revisions\/15737"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/15733"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=15731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=15731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=15731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}