My Oracle Support Banner

EM 13.4 RU10 Apply Fails With ORA-00942: table or view does not exist (Doc ID 2772540.1)

Last updated on MAY 03, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 to 13.4.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

EM (Enterprise Manager) 13.4 Release Update (RU) 10 Patch 32318082 apply fails with errors below

<MIDDLEWARE_HOME>/cfgtoollogs/omspatcher/32318082/omspatcher_<TIMESTAMP>_deploy.log

[Apr 28, 2021 5:22:08 PM] Please monitor log file: <MIDDLEWARE_HOME>/cfgtoollogs/omspatcher/<TIMESTAMP>_SystemPatch_32318082_1/rcu_applypatch_original_patch_<TIMESTAMP>.log
[Apr 28, 2021 5:22:27 PM] [ Error during Patch and deploy artifacts phase ] Detail: Patch application failed to complete some of the actions.
Some error occurred during RCU update. Please refer individual log file(s) for details.
Log file location: <MIDDLEWARE_HOME>/cfgtoollogs/omspatcher/<TIMESTAMP>_SystemPatch_32318082_1/rcu_applypatch_original_patch_<TIMESTAMP>.log
[Apr 28, 2021 5:22:27 PM] The error output for the rcu update action is :
stty: standard input: Inappropriate ioctl for device
stty: standard input: Inappropriate ioctl for device
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.

***********************************************
Executing Patch Application Steps.....

***********************************************
Enter the SYSMAN password:

RCU Logfile: <MIDDLEWARE_HOME>/oracle_common/rcu/log/empatch/logs/<TIMESTAMP>.log

Enter the database password(User:SYSMAN):
Processing command line ....
Repository_Patching_Utility - Checking Prerequisites
Checking Global Prerequisites
Repository_Patching_Utility - Checking Prerequisites
Checking Component Prerequisites
Repository_Patching_Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository_Patching_Utility - ApplyRepositoryPatch
Repository ApplyRepositoryPatch in progress.
Percent Complete: 55
Percent Complete: 58
ORA-00942: table or view does not exist
File:<MIDDLEWARE_HOME>/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/sql/db/13.4.1.v/13.4.1.8/gef/gef_metadata_tables.sql
Statement:COMMENT ON TABLE "GEF_EXTRACTS_E" is 'This table stores source extract information.'

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.