Ora-20000 : Direct Downgrade Of EM Database Control Not Supported Despite Sysman User Is Dropped (Doc ID 1292035.1)

Last updated on MARCH 28, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

While downgrading the database from 11.2.0.1 to 10.2.0.4 the following error is received:


"ORA-20000: Direct downgrade of EM Database Control not supported"


This is a known issue and documented in <Document 443890.1>. As a resolution of this issue, one need to execute below step and then do the downgrade

DROP USER sysman CASCADE;

Even after running the above step, same error is received again and again.

Once a SYSMAN user is dropped successfully and if tried again the user should get a message 'SYSMAN' does not exist. But in this case, the message "SYSMAN is dropped" keeps appearing all the time.

Cause

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