To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove OLAP. Remove OLAP Catalog by running the SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.

[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release Production on Mon Feb 26 01:48:34 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> @catnoamd.sql

Synonym dropped.

Synonym dropped.

Synonym dropped.

Synonym dropped.

Synonym dropped.

<<< OUTPUT Truncated>>>>

PL/SQL procedure successfully completed.

1 row deleted.

SQL> commit;

Commit complete.


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


  1. Pingback: Upgrade 12c to 19c: Traditional | My Oracle Blog

Leave a Reply

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