My Oracle Support Banner

OPS Center OCDoctor: ERROR: DB Contains Schema Objects In INVALID State! (Doc ID 1956223.1)

Last updated on OCTOBER 04, 2019

Applies to:

Enterprise Manager Ops Center - Version 12.2 and later
Information in this document applies to any platform.

Goal

Prior to upgrade to 12.2.2 "OCDoctor (version 4.44) --troubleshoot" output shows:

ERROR: DB contains Schema Objects in INVALID state!
This will cause the Upgrade to 12c R2 U2 to fail!
List with objects in state 'INVALID':

OBJECT_NAME OBJECT_TYPE STATUS
----------------------------------- -------------------- ----------
V_VMB_ORA_PRE_ENG_SYS_CON_209 VIEW INVALID

Please open a Service Request with Oracle Support to get this issue resolved!
Trying to upgrade the EC in this state will result in a failure and rollback to current state!


 

Solution

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
Goal
Solution


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