Very rare explainers found like you .. excellently explained the whole scenario.. so easy to make understand for beginner as well !! keep the good work ! 💐
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😘😘😘😘
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
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.
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 ?
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
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.
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.
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??
Very rare explainers found like you .. excellently explained the whole scenario.. so easy to make understand for beginner as well !! keep the good work ! 💐
Most welcome !
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😘😘😘😘
Glad it was helpful!
Excellent explanation and Awesome Video, please do more videos which will help for freshers and as well as for experienced people to brush up :)
Thank you! Will do!
The video was really very informative and good.
Thanks for sharing the detailed upgrading process.
Glad it helped you!
This video presents Systematical and detail procedure.
Very useful for me, thanks a lot DBA genesis
Thank you!
Thanks for very easy and clear explanation but what about timestamp version upgrade
Thanks a lot…..what an excellent demo?
My pleasure!
Wonderful video detailed explanation Thanks very much!!!
Glad it was helpful!
nice explanation sir, I really like your detail explanation method.
tq u so much ....broo......such valuable video .....in depth detailed upgradation.....once agaiy tq uu ....broo....do more videossss
You are most welcome. Also check our support website for latest DBA Articles: support.dbagenesis.com/
Make a video onOracle RAC install
Why we run three 'exec dbms' scripts plz GIve me explanation
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
Bro.. Super explanation....!!
Thank you!
nice video
tysm for this
its very helpfull
Thank you!
Thanks for the nice video. Just wondering why you used a manual method to upgrade the database instead of using a Database upgrade assistant.
super explanation
Thank you so much 🙂
Thanks a ton.🙌
picture perfect................Thanx...........
Welcome 😊
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
Nice one
Thank you
Sir can you upload video on upgradation from 11.1.0 to 11.2
I already have published it. Search once on TH-cam
This is very clearly explain,but can I create new oracle home upgrade as the same old home location?
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.
please can you tell which version of linux used in this practical ?
I guess OEL 6.5 but you can also go for OEL 7.6, which I currently use for all trainings.
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 ?
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
do you have a video on patching?
Not yet but I guess when you download the patch, you get a read-me file. This will help you perform the patching.
sir, can you please help with patching 11g and 12c? Thanks
Sure, added to my list. Will post videos soon!
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
Hi, Can you help us on RAC upgrade?
ankit gupta it is same bro
kindly make one video of downgrade.
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?
There is no need for data transfer, once you perform the upgrade, the 11g DB will be running from the new Oracle home 12c.
phase 49 took 84802 seconds ? 23 hours ?
please provide the upgrade method from 11.2.0.1 to 11.2.0.4 upgrade video
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?
Then you have to downgrade. Follow downgrade steps on Oracle docs
Excellent video ..thank you
Thank you!
thanks for the video :)
Thank you!
Make a video on rolling upgrade in RAC
Done!
@@dbagenesis please provide the link, bhaiya !
Very useful video👏
Thank you!
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.
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.
how do i register my oracle database active data guard license?
Thanks you
Can this work for 11.2.0.4 to 19 c also ?
Excellent video......
Thank you!
During the installation portion of this video, why did you select all the groups to be 'dba' and not 'oinstall'? Just curious...
you can choose either it will work
Thanks!
What is the purpose of validating invalid objects? Also how do you backup ORACLE_HOME and ORAInventory?
respond ASAp
Thank you.
OS level copy you can do
Any Tutorials related to Golden gate ??
we do have video course on Golden Gate: dbagenesis.com/p/oracle-golden-gate-masterclass
@@dbagenesis Thank You Sir ..
thanks a lot...
Thank you!
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??
I am wondering this too . This is huge time to be spent in db upgrade.
Great sir
Thank you!
Thanku sir
Welcome