Oracle License Compliance Scripts – Oracle LMSCollection Tool

Oracle license compliance scripts or often called Oracle LMS scripts its official name is Oracle LMS Collection tool. Most Oracle customers are introduced to it for the first time when they are going through an Oracle license audit. The Oracle license compliance scripts was developed by Oracle’s audit organization (LMS) to use when performing Oracle software license audits.

 

When are the Oracle license compliance scripts used?


Oracle LMS use the tools during Oracle audits or ULA certifications. It can also be used for companies to perform internal Oracle license audits. You can request a light version via Oracle mysupport, or you may have a copy since a previous Oracle license audit.

Note.

Oracle recently updated their audit clause in the Oracle Master Agreement (OMA), which is now referencing the requirement to run data measurement tools during Oracle license audits.

 

What are Oracle License compliance scripts really?

It is a collection of scripts that needs to run of the servers where Oracle software is installed. The scripts include Review Lite script for Oracle database, CPU queries and scripts for Oracle middleware and Oracle applications.


What Oracle software do the LMS scripts cover?


    • Oracle database, including all database options and management packs
    • Oracle middleware, including Oracle Application Server, Oracle Weblogic, Oracle Weblogic Options, Oracle Weblogic Management Packs, Oracle Tuxedo and Oracle Webcenter
    • Oracle Business Intelligence

Who in your organization will be running the scripts?


Oracle will not be running the script on your servers. You will receive a copy of the Oracle LMS scripts and instructions on how to run them. In order to run the scripts you need system admins access right for window and root for linux/Unix and admin rights for certain Oracle middleware products.

 

What will the Oracle License Compliance Scripts detect?


Oracle LMS scripts will be able to detect both active and historical usage of Oracle software, it is not unusual to see unlicensed usage going back as much as 10 years. If you have mistakenly used non-licensed products in the past, Oracle will require a license purchase.

 

When should / can you use the LMS Scripts?

 

You should use them whenever you want an “audit” like result from your Oracle licensing position. This should always be when you have an Oracle license audit. You then analyze the scripts before you share the output with Oracle. If you have an Oracle ULA certification you should do the same. But also if you want to have highest accuracy for your internal Oracle license review, you should use the LMS scripts. The best SAM tools in the market are only correct 80-90%  – the missing 10-20% equals millions of dollars in financial risk of unlicensed Oracle software. 


 

Can I read the Oracle License compliance script output?


No, you need both training in how to interpret the output as well as deep understanding of Oracle licensing rules and policies. Redress Compliance have expert knowledge to help you analyze the script output before you share any data with Oracle.


Oracle license compliance script


 

Oracle LMS Scripts – A video

 

In this video we provide a guide into what is Oracle LMScollection tool aka LMS scripts. The Oracle license audit tools that Oracle uses when they audits its customers How can use run them? Are you allowed to make use of them and how does the script output look like?

00:00 Introduction to the video, what will you learn in this video?
00:50 What is Oracle LMSCollection Tool? Does it scan your network for Oracle software?
01:37 Which Oracle software products does LMScollectiontool detect and measure?
02:39 How to run the scripts
03:22 Can you use Oracle LMS Scripts to measure and audit your Oracle software?
04:30 How does the Oracle Database output look like?
05:17 EBS script output, what to review?
05:35 Oracle Middleware script – how does it work?
06:30 How to make use of the LMS scripts, in a license audit or ULA.

 

Oracle LMS Scripts & License Audit Tools - Ultimate guide

 

Transcript: 

Hi there, this is Fredrik from Redress Compliance. I’m going to talk about LMS Collection Tool. What you will learn in this video is what is the LMS Collection tool, how do you run it, what does it measure, does it scan your network for Oracle software, how does the output look like, how do you interpret it? Maybe one of the reasons why you’re watching this video is that you’re audited by Oracle, and you’re wondering if you run Oracle audit script, what data will it pick up, and what will it show?

I’ll tell you the smart move to do is to have an independent consultant, like either Redress Compliance or someone else help you analyze that output before you share it with Oracle, so that you can make adjustments to your Oracle environments before the audit begins. If you like the video, please subscribe to our channel. If you have any questions, please ask them in the comment section. Here we go.

The Oracle LMS collection tool is a collection of scripts that Oracle uses when they’re auditing their customers. The script is something that every customer needs to run, Oracle will not run it for you. It will not scan your network to identify where you have Oracle installed, Oracle is relying that you know where you have Oracle installed. You run the LMS Collection Tool and it will scan the specific server for hardware and software information, and it will gather information about Oracle software that you need to license, it will not scan your network for servers. Which Oracle products does it cover? The tool is designed to collect software usage data for the following Oracle product families, Oracle database products and all its options. It will capture not only what is being used today, but also what has been used in the past.

So for example, if you’ve used diagnostic pack and ginning pack four or five years ago, there will be evidence in the database and the script will detect that, and Oracle will ask that you pay a license for that usage. It will capture information about Oracle Lead Business Suite, it will capture information about Oracle Application Server, which is Oracle internet application server, information about web logic server, standard edition, enterprise server, WebLogic Suite, it will capture information about Oracle SOA, Tuxedo, Oracle business intelligence products and web center. And you will notice here that there’s many products that are missing and Oracle do have a script for Primavera, Hyperion, JD Edwards, but there are many products that Oracle does not have a script for. And what you need to do in order to run the script? You can run the script locally or remotely.

On Windows, you need to have admin rights. On Unix or Linux, you need to have Root or Sudo access to run the scripts. The scripts are using SQL Plus to connect and will only perform read-only operations, what this means is that it does not impact performance. The database script can be run without any input from the user, the middleware script needs to have a manual input from the user to run. When it comes to virtualization, the tool can measure Oracle VM, IBM LPAR, Solaris, HP nPar and Hyper-V. For VMware, Oracle will request that you run a separate tool, PowerCLI, but you can also run a free tool like Rvtools. Who can use the LMS Collection tool? And for this, you can find answers in the licensing agreement for LMS Collection tool. And here is the most important sentences that you should be reviewing.

“Oracle grants You a non-exclusive, non-transferrable limited right to use the Software, subject to the terms of this Agreement, for the limited purpose of measuring, monitoring and/or managing Your usage of Programs.” What does it mean? It means that Oracle gives you the right to use the LMS Collection tool for measuring, monitoring and managing your Oracle software licenses. Second, very important paragraph is, “You may allow Your agent and contractors (including, without limitation, outsourcers) to use the Software for this purpose and You are responsible for their compliance with this Agreement to such use.” What does it mean? It means that your contractors, consultants can help you, using the LMS collection tool to measure your Oracle software licenses. This means that any Oracle customer can use the LMS collection tool to understand, what is the software that you’re using, and what is your licensing position? If you run the LMS collection tool on an Oracle database, what will the output look like?

It will provide you with 11 CSV files that needs to be analyzed in order to understand what is the licensing requirement? One file is called DBA feature, another is License, options, Oracle Products, parameters, segments, sessions, summary, users, V-option and version, all of these files are important in one way or another. Here’s a few examples of what you can find in the scripts. The challenge is not to run the script, it is to have the right expertise and the knowledge about how to interpret the script output. If you do not have the training or the know-how, you should be finding a consultant that can help you interpret the script output. Here’s an example of what it looks if you extract EBS output, there are many more CSV files that needs to be analyzed. You will need to have the expertise in interpreting the script output, and then you need to apply your EBS licensing knowledge.

The script that is picking up the middleware licensing information is very different from the database and the EBS script. The script will copy files containing information about your middleware installations. When you’re running the middleware script, it will copy files from your servers into the script output. Some of the files that we are looking at is the config XML file, this is the opmn file, this is the registry files, this is the comp file and the info file, and a couple of other files as well, these are the most important files to look at. If you have the LMS Collection tool, you can run the script, have a look at the output and try to understand, is this something that you can interpret by yourself? Most likely, it is not. And some of the scripts that I cannot analyze, when I’m looking at output, it’s almost impossible to understand what is important, and what is not.

Now, when you watch the video and you have a better understanding of what are the scripts about, you’re thinking, “how can I make use of this?” Maybe the reason why you’re watching this video is that you have an audit from Oracle, and you’re worried that you’re going to be audit-compliant. The best thing you can do is to work with a firm who can analyze the output before you send it to Oracle, then you will know what you’re sharing with Oracle. Maybe you have an Oracle ULA that is up for renewal, either you want to exit or you want to renew, using the Oracle audit script is really the only way to be certain about your licensing position. Thank you for watching. If you think that we can help you, you can reach us at www.redresscompliance.com. Thank you.

 


 


If you would like to be updated on Oracle licensing and recieve more tips follow us on
social media:


✔️ Follow us on LinkedIn
✔️ Subscribe to our channel on YouTube



 If you have an Oracle license audit and Oracle asks you to run the scripts our team can help you analyze the scripts before you share them with Oracle. The same goes for any other Oracle licensing situation which could be internal Oracle license review of Oracle ULA Certification, where you want to run the Oracle LMS scripts or License Compliance Scripts. If you are interested to know more about our Oracle license consulting services, contact us to schedule a meeting.