Has anybody here sought to import software inventory data from OEM into FlexNet? If so, I'd love to connect to hear about what you've done!
(FlexNet does provide an out-of-the-box integration with OEM to use it as a source for discovering a list of Oracle Database instances in the environment, so that those instances can be subsequently targeted for inventory gathering. This question is not about that integration; I'm looking for experiences with custom integrations that extract data from OEM about Oracle software that is installed on computers and import that data as software inventory into FlexNet.)
Jul 24, 2019 11:22 PM
Mar 23, 2022 11:08 AM
You don't normally have to do too much to have the agent gather Oracle Database option details as part of its regular inventory gathering.
Here is a helpful references to learn more about how the agent gathers details about Oracle Database and related software: Agent-Based Collection of Oracle Inventory.
Apr 21, 2023 03:27 AM
That's great. I will review the ndi file and check it returns the DB options the OEM server manages remotely on other DB. This solves a large deployment problem and avoid having to scan each oracle DB locally. Also, I haven't found much description in the doc regarding this capability and I only found doc on OEM generating the tnsname.ora which still require us to scan locally on each DB which takes a lot effort as DB existence is hard to track. Thanks again.
Apr 21, 2023 01:50 PM
Got it. Thanks. Does the agent need the beacon to discover the SID first or does it figure it out locally from looking into the File path? I couldn't quite figure out if it pulls the discovery data from the beacon or the agent can figure out the oracle DB on its own and knows it all. I assume we would still need to have the DBA to run the create_oracle_audit_user.sql ahead of the scan? And is the same script for OEM server as well as the individual DB?
Apr 21, 2023 03:18 PM