To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to Enterprise Manager.

Copy the $ORACLE_HOME/rdbms/admin/emremove.sql script from the target ORACLE_HOME into the source ORACLE_HOME.

Step 1: If database control is configured, stop EM Database Control, using the following command

gt; emctl stop dbconsole

Step 2: Connect to the database using the SYS account AS SYSDBA




Without the set echo and server output commands, you will not be able to follow the progress of the script.

[oracle@localhost admin]$ cd /u01/app/oracle/product/
[oracle@localhost admin]$ ls emremove.sql
[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release Production on Mon Feb 26 01:46:36 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @emremove.sql
old 70: IF (upper('&LOGGING') = 'VERBOSE')
new 70: IF (upper('VERBOSE') = 'VERBOSE')

PL/SQL procedure successfully completed.


Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.