Summary
Decommissioned Oracle database instances are still present even after updated Inventory has been performed and the instance has been removed from the host.
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'***> "
