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'***> "
Related Articles
Oracle Database or Option license "At risk" with message "Option License does not match instance" 41Number of Views Oracle Database instances read from TNSNAMES.ORA are never deleted 4Number of Views Known Issue: Oracle Database instances read from TNSNAMES.ORA are never deleted (IOJ-1769976) 14Number of Views Oracle inventory gathering status may report an error message "Oracle database does not appear to be in the open state" ev… 4Number of Views Known Issue: Oracle Database inventory fails to be gathered from Automatic Storage Management (ASM) instances (IOJ-1730590) 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago