My Oracle Support Banner

EM 12c, EM 13c: Accessing Plugins Page in Enterprise Manager Cloud Control Reports ADF_FACES-60097 Error and Message: java.sql.SQLException: No aru property found for host (Doc ID 1468544.1)

Last updated on NOVEMBER 28, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Accessing Plugins page from EM 12c Cloud Control reports ADFC error.

ADF_FACES-60097: For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #12

+ gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out

java.sql.SQLException: No aru property found for host myhost.oracle.com

Case I: If Host target is not yet discovered

Verified from listtargets output:

<AGENT_INST_HOME>/bin >./emctl config agent listtargets
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.

 Case II: If Host target is available

- Connect to repository database as SYSMAN and execute:

select * from mgmt_oms_parameters where name='HOST_NAME';

HOST_URL                                                                      NAME                                          VALUE                                                TIMESTAMP                                                        

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
myhost.oracle.com:4889_Management_Service                HOST_NAME                              myhost.oracle.com                                 22-OCT-09                  

- Check whether the value returned in above query is present in the repository:

select target_name from mgmt_targets where target_type='host' and target_name='myhost.oracle.com';
no rows

- From the Agent on the OMS server,

$ agent_inst/bin/emctl config agent listtargets | grep host
[myhost, host]

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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