My Oracle Support Banner

EM 13c: OMS Upgrade to 13.5 Fails With "ErrorCode: 942SQLState:42000 Message: ORA-00942: table or view does not exist" (Doc ID 2797317.1)

Last updated on JANUARY 18, 2023

Applies to:

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


Enterprise Manager upgrade from 13.3 to 13.5 fails with below error


<timestamp> rcu:Extracted Statement from File Name: '<middleware_home>/oracle_common/../oracle_common/common/sql/svctbl/sql/create_user.sql'Line Number: 23
<timestamp> rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 942SQLState:42000 Message: ORA-00942: table or view does not exist

Error encountered executing SQL statement FileName: '<middleware_home>/oracle_common/../oracle_common/common/sql/svctbl/sql/create_user.sql' LineNumber: '23'
SQL Statement: [GRANT select on schema_version_registry to SYSMAN_STB]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

<timestamp> NOTIFICATION STB: oracle.sysman.assistants.rcu.backend.action.JavaAction::perform: JavaAction command= oracle.ias.version.SchemaVersionUtil:utilDropRegistryEntry.
<timestamp> NOTIFICATION STB: oracle.sysman.assistants.rcu.backend.action.JavaAction::perform: JavaAction command=



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.