To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove OLAP. Remove OLAP Catalog by running the 184.108.40.206.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.
[oracle@localhost admin]$ sqlplus / as sysdba SQL*Plus: Release 220.127.116.11.0 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 18.104.22.168.0 - 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. SQL>
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: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
Pingback: Upgrade 12c to 19c: Traditional | My Oracle Blog