Summary

Synopsis

Decommissioned Oracle database instances are still present even after updated Inventory has been performed and the instance has been removed from the host database machine, why is this.

Discussion

Oracle database instance information is kept for 4 weeks after the date the instance was last reported, this is in-line with Oracle's audit requirements.

There are several items that can be reviewed to ensure the Oracle instance inventory is accurate and in-line with the above requirement.

-Ensure the "Service the ManageSoft database" scheduled task is enabled, this is responsible for clearing the old instances.

-Ensure the Oracle database inventory task is ran to gather updated Oracle inventory.

If there are still instances present the following query can be used to identify the last inventory date of the instance to determine if the 4 week period has been reached. This date is stored in the Inventory Manager database "ServiceProvider" table as he "LastInventoryDate" column and is compared to the runtime of the above task to determine if the instance should be cleared.

"SELECT

sp.[ComputerID]

,sp.[ParentServiceProviderID]

,sp.[ServiceProviderTypeID]

,sp.[ServiceProviderNameID]

,sp.[CreationDate]

,sp.LastInventoryDate AS 'SP Last Inventory Date'

,spn.[ServiceProviderNameID]

,spn.[Name]

,ir.[SWDate]

,ir.[HWDate]

,ir.[FilesDate]

,ir.[ServicesDate] AS 'InvRep Services Date'

from ServiceProvider sp

INNER JOIN serviceprovidername spn

ON spn.ServiceProviderNameID = sp.ServiceProviderNameID

INNER JOIN computer c

ON c.ComputerID = sp.ComputerID

INNER JOIN InventoryReport ir

ON ir.ComputerID = c.ComputerID

Where ComputerCN = '<***EnterComputerHostName'***> "