- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Oracle Instance Inventory Failed
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oracle Instance Inventory Failed
Hi All,
We are inventorying the oracle instances using the flexnet inventory agent almost all the devices are returning the instance details except one.
On checking the All Discovered devices page -> device -> status, it is showing as Failed with the following error.
Last failure:
Summary: Failed to query 1 out of the 1 Oracle services attempted.
Date/Time: 1/19/2023 4:32:33 pm
Credential: None
Details
Failed to inventory Oracle instance 'ABCD01' on port '0'.
Message:
A database instance was discovered but was not running at inventory time. Please check whether the instance should be running.
Any suggestion on how to troubleshoot and fix this error would be very helpful.
Thank you
Sasi
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you need to ensure that you correctly set the following environment variables on the servers for oracle as well root user.
LD_LIBRARY_PATH
ORACLE_BASE
ORACLE_HOME
PATH
ORACLE_SID
-----------
------------------------
Windows
1. Open an administrative instance of command prompt
2. Change the directory to C:\Program Files (x86)\ManageSoft\Tracker (this is the default directory on a 64-bit machine)
3. Run the following command: ndtrack -t machine -o Upload=False
4. Give the machine some time to manually generate inventory
Obtain the "tracker.log" file from C:\Windows\Temp\ManageSoft
Obtain the ndi file from: C:\ProgramData\ManageSoft Corp\ManageSoft\Tracker\Inventories (standard .ndi file)
Obtain the Oracle ndi file from:C:\ProgramData\ManageSoft Corp\ManageSoft\Common\Uploads\Inventories (file name ends with: ..(Oracle).ndi.gz)
Non-Windows
1. Open a terminal window
2. Change directory to /opt/managesoft/bin
3. Run the following command: ./ndtrack -t machine -o Upload=false
4. Give the machine some time to allow it to manually generate inventory
Obtain the "tracker.log" file from /Var/Opt/Mangesoft/Log
Obtain the ndi file from: /var/opt/managesoft/uploads/Inventories (standard .ndi file)
Obtain the Oracle ndi file from: /var/opt/managesoft/uploads/Inventories/ (file name ends with: ..(Oracle).ndi.gz)
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sasikumar_r The error states that the instance was discovered, but the oracle instance was not running at the time of inventory. You should start by contacting the system owner or DBA for that instance and verify if the instance should be running. I have found that these cases can mean the database is a failover node or is powered off because it is due for decommissioning. Your Oracle DBAs should have more information on it.
Thanks,
Dan
