Oracle 11g to 12c step by step database upgrade | 11204 to 12101 manual upgrade process

[@arundubey5896]

Very rare explainers found like you .. excellently explained the whole scenario.. so easy to make understand for beginner as well !! keep the good work ! 💐

[@dbagenesis]

Most welcome !

[@narendrastudy4286]

Very very beautifully explained loved it, i watch this video whenever i feel like upgrading, bec just going through this video i believe I have upgraded a DB😘😘😘😘

[@dbagenesis]

Glad it was helpful!

[@aasif4594]

Oracle 11.2.0.4 to 12.2.0 Upgrade via Manual Method =================================================== PREPARE FOR UPGRADE ------------------- 1) Take DB backup via RMAN 2) Take ORACLE_HOME, OraInventory backup via OS level copy 3) Run the utlrp.sql script to validate the invalid objects 4) exec dbms_stats.gather_database_stats; 5) exec dbms_stats.gather_dictionary_stats; 6) exec dbms_stats.gather_fixed_objects_stats; INSTALL 12.2.0.1 ---------------- 1) Download and install 12.2.0.1 into a different Oracle Home Location 2) Run the pre-upgrade utility which resides under 12.2.0.1 Home 12_HOME/rdbms/admin/preupgrd.sql 3) Review and fix all the issues reported via above script 4) Shutdown the DB, Listener, EMC START THE UPGRADE ---------------- 1) Copy DBS and Network folder from old O_H to new O_H 2) Set environment variable O_H to new O_H location 3) Startup the DB in Startup Upgrade mode 4) Run the upgrade utility which upgrades the database. Exit from sqlplus cd $ORACLE_HOME/rdbms/admin $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql POST UPGRADE STEPS ------------------ 1) Statup DB normally. Make sure its started with 12.2.0.1 O_H 2) Run the utlrp.sql script to validate the invalid objects 3) Run the post-upgrade script 12cHome/rdbms/admin/utlu12.2.sqql 12cHome/rdbms/admin/captuppst.sql 12cHome/rdbms/admin/utlu122s.sql 4) Check the components status select comp_name,status,substr(version,1,10) as version from dba_registry; 5) Change the compatibility parameter to 12.2.0.1 scope=spfile 6) Check the version details post upgrade select comp_name, version, status from dba_registry 7) Bounce the database CLEANUP PROCESS --------------- 1) Update teh new O_H under /etc/oratab file 2) Unistall the old O_H 3) Take a fresh backup of database post upgrade

[@sadanb4876]

Nice one

[@ShuvodipDasgupta1610]

Thank you

[@mvkishore]

The video was really very informative and good. Thanks for sharing the detailed upgrading process.

[@dbagenesis]

Glad it helped you!

[@madhukarsargar5414]

Thanks for very easy and clear explanation but what about timestamp version upgrade

[@himabindhu7970]

Excellent explanation and Awesome Video, please do more videos which will help for freshers and as well as for experienced people to brush up :)

[@dbagenesis]

Thank you! Will do!

[@thakkaramit5403]

nice explanation sir, I really like your detail explanation method.

[@manikbasha4745]

Wonderful video detailed explanation Thanks very much!!!

[@dbagenesis]

Glad it was helpful!

[@preethiumesh]

Very useful for me, thanks a lot DBA genesis

[@dbagenesis]

Thank you!

[@huipingwen4925]

This video presents Systematical and detail procedure.

[@ibrahimjsowe8987]

Thanks a lot…..what an excellent demo?

[@dbagenesis]

My pleasure!

[@kumarkoruturu8187]

tq u so much ....broo......such valuable video .....in depth detailed upgradation.....once agaiy tq uu ....broo....do more videossss

[@dbagenesis]

You are most welcome. Also check our support website for latest DBA Articles: support.dbagenesis.com/

[@ramakrishnab6254]

Bro.. Super explanation....!!

[@dbagenesis]

Thank you!

[@amitshinde9724]

nice video tysm for this its very helpfull

[@dbagenesis]

Thank you!

[@tauseefmohmmed5447]

Make a video onOracle RAC install

[@MuhammadAli-fi3mn]

Thanks for the nice video. Just wondering why you used a manual method to upgrade the database instead of using a Database upgrade assistant.

[@itisvikash]

Sir can you upload video on upgradation from 11.1.0 to 11.2

[@dbagenesis]

I already have published it. Search once on KZbin

[@Silverdragon517]

Awesome Video, How can I get a copy of your steps in the first screen . I want to use them as notes for the upgrade

[@Kashyap-Amit]

I didn't find timezone upgrade steps. Also looking for logic, 'why we need to upgrade timezone' I know about it but why not sure

[@rupeshrock]

Why we run three 'exec dbms' scripts plz GIve me explanation

[@HarishN-vn9sg]

picture perfect................Thanx...........

[@dbagenesis]

Welcome 😊

[@Vone_WorldClass]

This is very clearly explain,but can I create new oracle home upgrade as the same old home location?

[@dbagenesis]

Not really, to achieve that, you first perform the upgrade into new home location, delete old home location (11g) and then perform Oracle Home migration (movement) to old home location. Kind of tedious job.

[@priyaramu7922]

super explanation

[@dbagenesis]

Thank you so much 🙂

[@pravpandit]

Thanks a ton.🙌

[@ronaknmodi]

Make a video on rolling upgrade in RAC

[@dbagenesis]

Done!

[@itisvikash]

@@dbagenesis please provide the link, bhaiya !

[@Essentialliv52]

excellent Also after 20 days if I need to revert it to oracle 11G, how do we do that? how do we get the data updated after the upgrade?

[@ankitmehta2460]

Then you have to downgrade. Follow downgrade steps on Oracle docs

[@ankitgupta10]

Hi, Can you help us on RAC upgrade?

[@dhyanswaroop2606]

ankit gupta it is same bro

[@bharathkumar-ds8cd]

kindly make one video of downgrade.

[@Essentialliv52]

please provide the upgrade method from 11.2.0.1 to 11.2.0.4 upgrade video

[@narendrapakalapati5660]

Excellent video ..thank you

[@dbagenesis]

Thank you!

[@gemuandore7910]

thanks for the video :)

[@dbagenesis]

Thank you!

[@JavedShaikh-ej6ty]

Very useful video👏

[@dbagenesis]

Thank you!

[@pranavjoshi5961]

Any Tutorials related to Golden gate ??

[@dbagenesis]

we do have video course on Golden Gate: dbagenesis.com/p/oracle-golden-gate-masterclass

[@pranavjoshi5961]

@@dbagenesis Thank You Sir ..

[@pramod172]

Hi.. my Major concern what is best way to revert upgrade incase of upgrade failure? Is it restoring backup again or any other ways? Kindly make a video or reply

[@reginaforka7444]

do you have a video on patching?

[@dbagenesis]

Not yet but I guess when you download the patch, you get a read-me file. This will help you perform the patching.

[@dsbs-ke1yn]

Thanks you

[@jamshedkhan6121]

thanks a lot...

[@dbagenesis]

Thank you!

[@rehantayyab82]

please can you tell which version of linux used in this practical ?

[@dbagenesis]

I guess OEL 6.5 but you can also go for OEL 7.6, which I currently use for all trainings.

[@rehantayyab82]

ok thanks ...... both possibilities are there i think installation of 12c on oel 5 ( if 11g already running on oel 5 ) or if 11g running on oel 6 than 12c on oel 6 as well am i right ?

[@joeyhcmc]

How was the data in 11g transferred to 12c? Via expdp utility or pointers to db file will be pointed to the original db files location in 11g?

[@dbagenesis]

There is no need for data transfer, once you perform the upgrade, the 11g DB will be running from the new Oracle home 12c.

[@reginaforka7444]

sir, can you please help with patching 11g and 12c? Thanks

[@dbagenesis]

Sure, added to my list. Will post videos soon!

[@ayoob999]

Excellent video......

[@dbagenesis]

Thank you!

[@jasonstewart1504]

What is the purpose of validating invalid objects? Also how do you backup ORACLE_HOME and ORAInventory? respond ASAp Thank you.

[@rajatsanwal9919]

OS level copy you can do

[@rajatsanwal9919]

phase 49 took 84802 seconds ? 23 hours ?

[@rameshkumar-lf4nd]

Hi Arun, Would you please let us know what is the significance of timzone upgrde to a minimum supported number w.r.to the version we are going to upgrade? What would happen in case if the timezone is not upgraded during the DB upgrade? One more doubt like would oracle DB run with higher version binaries without DB upgrade by simply starting up the old DB under new oracle version? Thanks in advance.

[@dbagenesis]

If the Pre-Upgrade Information Tool instructs you to upgrade the time zone files after completing the database upgrade, then use the DBMS_DST PL/SQL package to upgrade the time zone file. Applying a change to the database time zone file not only affects the way new data is handled, but potentially alters data stored in TIMESTAMP WITH TIME ZONE columns, so you need to consider the impact of this before upgrading the time zone file.

[@masudhasan9315]

how do i register my oracle database active data guard license?

[@amitthakur528]

Great sir

[@dbagenesis]

Thank you!

[@lindabrown7470]

During the installation portion of this video, why did you select all the groups to be 'dba' and not 'oinstall'? Just curious...

[@dbagenesis]

you can choose either it will work

[@lindabrown7470]

Thanks!

[@thetechcafe754]

How much time it took for the upgrade?? It seems from your log that it took 89000 sec, is it?? Can you share some information regarding how much time it take for a upgrade of a normal sample db??

[@rajatsanwal9919]

I am wondering this too . This is huge time to be spent in db upgrade.

[@surajkhanna1735]

Can this work for 11.2.0.4 to 19 c also ?

[@tauseefmohmmed5447]

Thanku sir

[@dbagenesis]

Welcome