Last week, i have installed Oracle Enterprise Manager 12c(12.1.0.1) and when trying to add Fusion Application Instance, i have received below error:
"Targets found: Failed to find any product
family. Check host, port, credentials, protocol and be sure the admin server is
running. Reason: Failed to discover any product family. Only Weblogic related
targets are found. For discovering Fusion Middleware use Fusion Middleware
Discovery"
Solution:
I have followed Oracle®
Enterprise Manager Cloud Control Basic Installation Guide for agent configuration but was not able to discoverer product family. Then i talked to Oracle and got missing step details which fixed my issue.
If you are stuck in same step, Provide below database grants to fusion_runtime user which fixed issue and able to discoverer all the targets...
- grant execute on DBMS_SYSTEM to FUSION_RUNTIME;
- grant select on v_$parameter to FUSION_RUNTIME;
- grant select on gv_$instance to FUSION_RUNTIME;
- grant select on V_$INSTANCE to FUSION_RUNTIME;
- grant select on gv_$diag_info to FUSION_RUNTIME;
- grant select on gv_$parameter to FUSION_RUNTIME;
- grant select on gv_$instance to FUSION_RUNTIME;
Happy Monitoring..