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.
Summary: Failed to query 1 out of the 1 Oracle services attempted.
Date/Time: 1/19/2023 4:32:33 pm
Failed to inventory Oracle instance 'ABCD01' on port '0'.
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.
Jan 24, 2023 07:41 AM
you need to ensure that you correctly set the following environment variables on the servers for oracle as well root user.
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)
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)
Jan 24, 2023 09:18 AM
@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.
Jan 24, 2023 09:54 AM