EM12c : MGMT$STORAGE_REPORT_LOCALFS view does not have entries for all the hosts discovered on EM. (Doc ID 1932709.1)

Last updated on JUNE 29, 2021

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:
1. Connect as sysman to repository
2. Run the following query :

SELECT
b.target_name,
FROM mgmt_storage_report_data a,
mgmt$ecm_current_snapshots b
WHERE storage_layer = 'LOCAL_FILESYSTEM'
AND entity_type = 'Mountpoint'
AND a.ecm_snapshot_id = b.ecm_snapshot_id
AND b.snapshot_type = 'host_storage'

This does not return the hosts details.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.