Hi members.
I am trying to better understand the options available to a customer to manage the NUP counts as detected by the LMS scripts and depicted on FNMS.
Scenario:
Customer restores and sanatizes a production ODBEE instance to Dev/Test. When restored, the instance has a crazy NUP count, say 40000. Where in production this was on a server licensed by Processor, in Dev/Test, we want to license the NUPs.
Options:
Questions:
Looking forward to the conversation and contributions from the community
‎Jul 24, 2019 02:01 AM
I would think that the best option to fix the scenario as at the original data source. When restoring a production Oracle DB into a non-production environment, the DBA should drop all of the production users out of the database so that the production LMS Scripts only find the non-prod DB Users for the NUP License.
During an actual Audit, the Oracle LMS Team may force you to count all 40000 users that exist in the restored database for NUP licensing.
Kirk
‎Jul 31, 2019 12:25 PM
Hi,
I can imagine, you could automate something using a Business Import (custom query). I don't have proper testing data at hand, but you may have a look into the view/table "InstanceUser".
SELECT * FROM InstanceUser
Best regards,
Markward
‎Jul 26, 2019 10:37 AM
Thank you.
Yes I am aware of this table in the schema, but am not aware of how it behaves after the next import of data. Also as indicated, making a change to data in FNMS which is then different to the LMS Audit zip file is not ideal and is not an action I would advise client to take.
‎Jul 31, 2019 04:34 AM
Hi,
I am also not completely sure how FNMS would behave after the next import, but I would guess it would overwrite the changes. This is clearly about timing, making sure the changes are applied between inventory import and license reconcile.
Referring to your initial comment I think this approach would still be more transparent than leaving out the users completely.
Best regards,
Markward
‎Jul 31, 2019 05:05 AM
I would think that the best option to fix the scenario as at the original data source. When restoring a production Oracle DB into a non-production environment, the DBA should drop all of the production users out of the database so that the production LMS Scripts only find the non-prod DB Users for the NUP License.
During an actual Audit, the Oracle LMS Team may force you to count all 40000 users that exist in the restored database for NUP licensing.
Kirk
‎Jul 31, 2019 12:25 PM
‎Aug 01, 2019 01:10 AM