For upgrading Oracle database from 11g to 19c, we need to remove the Enterprise manager repository manually. Below are the steps,
- Stop the em dbconsole If database control is configured.
[oracle@ol7-dev u01]$ emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 22.214.171.124.0 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. https://ol7-dev:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ... ... Stopped.
2. Copy emremove.sql from target 19c ORACLE_HOME/rdbms/admin to source 11g ORACLE_HOME/rdbms/admin
[oracle@ol7-dev admin]$ cp /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/emremove.sql /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
3. Connect to source database using sys user and run emremove.sql
[oracle@ol7-dev admin]$ sqlplus SQL*Plus: Release 126.96.36.199.0 Production on Sat Nov 7 22:53:58 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @$ORACLE_BASE/product/11.2.0/db_1/rdbms/admin/emremove.sql old 70: IF (upper('&LOGGING') = 'VERBOSE') new 70: IF (upper('VERBOSE') = 'VERBOSE') PL/SQL procedure successfully completed. SQL>
EM repository has been removed successfully…