Steps to upgrade database from Oracle 11g to 12C to 18C
1: Change Oracle directory to new Home then rdbms/admincd Oracle_12C_Home/rdbms/admin
2: Login to sqlplus with old Oracle home,and run preupgrd.sql present in 12C home
3:If em is configured it has to be stoped before running database in upgrade mode
emctl stop dbconsole
4:Run UTLU112I.sql
Gather dictionary Statistics and Empty the recycle bin
5:Set Oracle12C home
Set Oracle SID
Copy Parameter file from Oracle_11G_Home to Oracle_12C_home/dbs
6:Startup upgrade
7:catctl.pl -n 4 catupgrd.sql
This runs upgrade in parallel 4.
8:postupgrade_fixup.sql
9:utlu122s.sql (Pre upgrade Status tool)
10:catuppst.sql------------------------>Timexone Upgrade if required.
11: utlrp.sql-------------------------------->Object validation
Soon I will add database upgrade with screenshot.
Stay Tunned