Oracle Database Upgrade 11G,12C,18C

Steps to upgrade database from Oracle 11g to 12C to 18C

1: Change Oracle directory to new Home then rdbms/admin
cd 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

Oracle DBA Interview Questions

Hi all,

As per my industry experience till date I am going to share interview topic to be covered to clear any interview.
I have around 5 years of experience with this profile,I have been interviewed by various reputed organisation's.So here I am going to help you with things that has to be done.

1 Prepare Oracle Architecture in depth which include background processes and memory architecture.
2 Oracle DataGaurd
3 RAC --- Cache Fusion
            --- Flow of query in RAC Enviroment
4 DR Drills
5 Database HealthCheckup
6 AWR ASSH RMAN
7 Wait Events
8 Shell Scripting
9 DG Broker
10 Migration,Up gradation
11 ASM
12 Patching
13 Data Pump, Transportable Tablespace
14 Linux OS
15 Session Management

I will soon cover all this topic in details and will let you know about how you can turn the table in interview's on your side.