This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject

A new Flexera Community experience is coming on November 25th. Click here for more information.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle Inventory through Adapter

msutharh
By
Level 7

We have FNMS 2019 R1 on-premise and installed Oracle Enterprise Manager adapter on Beacon server and configured as instructions given in Inventory Adapters and Reference Guide. 

Then installed ODAC122010Xcopy_32bit driver on Beacon server and follow instructions given in KB, after that restarted Beacon Service and Restart server.

https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/How-to-check-Oracle-database-connection-from-the-Inventory/ta-p/2053

and register DLL file of 64 bit operating system. we are able to test connection but got error while collecting inventory.

But still getting error that this error in OracleDBInventory.log "Message: OLE DB provider for Provider=OraOLEDB.Oracle is not installed, Message: Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Connection".

 

‎Oct 14, 2019 11:38 PM

0 Kudos
(4) Replies

msutharh
By
Level 7

Can someone answer my query ?

‎Oct 16, 2019 06:14 AM

0 Kudos

adrian_ritz1
By
Level 10
In response to msutharh

Hi,

I wonder why don't you install FNMS agents on servers, and they will gather the oracle inventory automatically.

I personally didn't work with Oracle adapter, I only used in the past the connection with tnsnames.ora and remotely audited the servers, when I was on FNMS 9.2, how ever I encountered a lot of issues, port closed, accounts that are not working, etc. 

From my point of view  using the Flexera agent is the best approach.

 

‎Oct 16, 2019 07:48 AM

0 Kudos

mag00_75
By Level 8 Champion
Level 8 Champion

Hi

You might need to have the Oracle SQLnet binaries installed and Oracle_Home configured.

In our company we use the light-agent for Linux instead to run local inventory as root. For the light agent you need to maintain the inventorySettings.xml which gets updated more often comparing to the agent.

Advantages is that you will get an improved inventory especially for options & management packs. You might also find oracle databases not registered in OEM if you have local inventory.

With the minimum version of 2019r1.2 and the inventorysettings.xml from September, alot of bugs have been solved that was showing usage in the wrong way

‎Oct 16, 2019 01:45 PM

msutharh
By
Level 7
In response to mag00_75

Error has been resolved after re-configured OLEDB drivers and restart Beacon server.

‎Oct 22, 2019 02:45 AM