Oracle Instance Inventory Failed

[sasikumar_r]

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

[durgeshsingh]

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)

[dbeckner]

@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