12C Cluster Database target version 11.2.0.3 is showing "Pending" Status as soon as were promoted while its Database instances are showing up (Doc ID 1518530.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.
Cluster database status pending in Enterprise Manager 12c

Symptoms

12.1.0.2 CC

Cluster Database target version 11.2.0.3 is showing "Pending" Status as soon as were promoted

while its Database instances are showing up


OMS trace files emoms.trc.1

showing the following error

2012-11-28 09:27:35,951 [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR homepg.RacDbSummaryRegionAttrs logp.251 - Exception while determining RAC database properties for target: dataprd_qdc. Some properties will not be displayed on RAC home page Summary Region. Exception: ORA-01403: no data found
ORA-06512: at "SYSMAN.EMD_RAC", line 6313
ORA-06512: at line 1

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "SYSMAN.EMD_RAC", line 6313
ORA-06512: at line 1


running EMDIAG check commands

$ repvfy verify targets -level 9

resulted in the following

verifyTARGETS
1013. Composite targets with missing metric dependency details: 2
7003. Master Agents referring to non-existing targets (13629936): 3

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms