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 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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

File Name or Source
-------------------------
<OMS_HOME>\cfgtoollogs\omspatcher\<timestamp>_SystemPatch_<patch_number>\emctl_register_namedQuery_<timestamp>.log

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.5.1.0.0/metadata/namedQuery/oracle_cloud_vm_cluster_named_query.xml 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.

 

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
References


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