Invalid Objects for the Enterprise Manager Database Schema after Migration to (Doc ID 1954903.1)

Last updated on DECEMBER 23, 2014

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


After migration to 11.2.0.x, invalid objects remain in the database.  The objects belong to the OEM schema and are part of the 9i legacy database release.

"OWNER"                     "OBJECT_NAME"                             "OBJECT_TYPE"  
"OEM"                         "SMP_VDN_VIEW_GROUP_TARGET"   "VIEW"                        
"OEM"                         "SMP_VDN_VIEW_GROUP_CONTENT" "VIEW"                        
"OEM"                         "SMP_VIEW_ADMIN_CREDENTIALS"   "VIEW"                        
"OEM"                         "SMP_VIEW_AGENTS"                      "VIEW"                        
"OEM"                         "SMP_VDI"                                   "PACKAGE BODY"                
"OEM"                         "SMP_VDM_NOTIFICATION_PKG"     "PACKAGE BODY"                
"OEM"                         "SMP_VDS"                                  "PACKAGE BODY"                
"OEM"                         "SMP_VDP"                                  "PACKAGE BODY"                
"OEM"                         "SMP_VDN_TARGET_DELETE_TRIG"    "TRIGGER"                    
"OEM"                         "SMP_VTD_CLIENT_STATE_TRIGGER" "TRIGGER"                  

Compiling one of the invalid objects results in:



Migration from an earlier release of the database.


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