Metrics of the Oracle agent display n/a when an inactive host object binds to "OracleInstance.participatingHosts". (4229382)

• One is the older which exists and created by VMWare-agent(vmId is not null). However, the virtual machine is deleted, but the host object still exists in the FMS. The host object doesn't collect data(cpu, memory) any more, it's not alive.
• The 2rd host object is live, it has the same host name. A new VM with the same name is created in the VM-cluster, so a new host object has the same name is created in Foglight.

WORKAROUND

Run the Query_Oracle_Instances_IncludeVMRef.groovy script to query the hosts with the hostname to get the host uniqueid.

Modify the host uniqueIds in the script Modify_ParticipatingHosts_With_ResolveIncorrectHost.groovy and run it to delete the older host object and update the "OracleInstance.participatingHosts", "OracleInstance.ActiveHost" to use the new Host object.

STATUS

This is listed a known issue ORAFOG-660