My Oracle Support Banner

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 AUGUST 19, 2022

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

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


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