Known Issue: Oracle Database inventory fails to be gathered from Automatic Storage Management (ASM) instances (IOJ-1730590)
Known Issue: Oracle Database inventory fails to be gathered from Automatic Storage Management (ASM) instances (IOJ-1730590)
Symptoms
Oracle Database inventory cannot be gathered from Automatic Storage Management instances. These instances typically have a name that starts with "+ASM".
Logging generated by the ndtrack process while gathering Oracle Database inventory may indicate an error attempting to connect to this type of instance. For example:
[Sat 16 May 2020 09:08:27 PM UTC (G, 0)] {21587} Started tracking Oracle instance "+ASM1" in "/ora/ab573/grid/oracle/19c". [Sat 16 May 2020 09:08:43 PM UTC (G, 0)] {21587} | ORA-01507: database not mounted [Sat 16 May 2020 09:08:43 PM UTC (G, 0)] {21587} | <br> [Sat 16 May 2020 09:08:43 PM UTC (G, 0)] {21587} Failed to inventory Oracle instance "+ASM1" in "/ora/ab573/grid/oracle/19c".
Detailed "etap.trace" style tracing from the agent may also show an error like:
Error 0x80004005 "ORA-15000: command disallowed by current instance type" occurred while attempting to access "OraOLEDB".
Cause
This type of failure can occur because the +ASM instance is commonly not accessible. For example, the SYSASM system privilege is normally required to connect to the +ASM instance, but accounts used by the inventory gathering process for connecting to Oracle Database may not have this privilege. Further, +ASM instances only contain selected memory structures and are not full database instances.
Fix information
The inventory gathering process has been updated to avoid attempting to connect to and gather inventory from any Oracle instances whose names start with "+ASM". This data is typically not important to gather, as the details from these special system instances do not normally have material implications from a licensing perspective.
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.