My Oracle Support Banner

EM13C : Applying RU14 Fails With Artifact Mrs-Namedquery Error: Ora-00904: “usage_type”: Invalid Identifier (Doc ID 2953510.1)

Last updated on AUGUST 04, 2023

Applies to:

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


In Enterprise Manager (EM) Cloud Control while applying Release Update (RU) 14 it is failing with the below:

File Name or Source

Relevance to the Issue
[May 18, 2023 9:36:22 AM] Command used to update MRS is : <OMS_HOME>/bin/emctl register oms metadata -service namedQuery -file_list <OMS_HOME>/.omspatcher_storage/registerFile/34980354/namedQuery_oracle.sysman.xa.txt -pluginId oracle.sysman.xa
[May 18, 2023 9:36:23 AM] Oracle Enterprise Manager Cloud Control 13c Release 5
[May 18, 2023 9:36:23 AM] Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
[May 18, 2023 9:36:27 AM] SYSMAN password: SYSMAN password: EM-04041: Error occurred during Metadata registration. Error is: EMMetadataRegistrationFailureException occurred for file <OMS_HOME>/plugins/oracle.sysman.xa.oms.plugin_13. MRS EMMetadataServiceInfo: Name: Named Query Metadata Registration Id: namedQuery Parser class: oracle.sysman.core.uifwk.metadata.namedQuery.NamedQueryMetadataService XSD name: oracle/sysman/emSDK/core/uifwk/metadata/namedQuery/NamedQuery.xsd Jar file locations: Plugin XML Location: namedQuery SDK Level: partner Description: Parser for Named Query Metadata Service. Registration mode: POST_REP_SCHEMA Weight: 500 SubSystemId: UIFramework InvokeOnlyForFirstOMS: true ResourceFileSuffixs: [] isThreadSafe: false isPrevVerMetadataIncluded: false Error is SQL Exception :java.sql.SQLSyntaxErrorException: ORA-00904: "USAGE_TYPE": invalid identifier
[May 18, 2023 9:36:27 AM] . Check <OMS_HOME>/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for more details.



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

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