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
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😘😘😘😘
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
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 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??
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
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!
This video presents Systematical and detail procedure.
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!
nice explanation sir, I really like your detail explanation method.
Thanks for very easy and clear explanation but what about timestamp version upgrade
picture perfect................Thanx...........
Welcome 😊
Wonderful video detailed explanation Thanks very much!!!
Glad it was helpful!
Very useful for me, thanks a lot DBA genesis
Thank you!
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/
nice video
tysm for this
its very helpfull
Thank you!
Thanks a lot…..what an excellent demo?
My pleasure!
super explanation
Thank you so much 🙂
Thanks a ton.🙌
Thanks you
Bro.. Super explanation....!!
Thank you!
thanks a lot...
Thank you!
thanks for the video :)
Thank you!
Excellent video ..thank you
Thank you!
Make a video onOracle RAC install
Why we run three 'exec dbms' scripts plz GIve me explanation
Thanks for the nice video. Just wondering why you used a manual method to upgrade the database instead of using a Database upgrade assistant.
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
Sir can you upload video on upgradation from 11.1.0 to 11.2
I already have published it. Search once on RUclips
Very useful video👏
Thank you!
Great sir
Thank you!
kindly make one video of downgrade.
Excellent video......
Thank you!
Thanku sir
Welcome
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
phase 49 took 84802 seconds ? 23 hours ?
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
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.
Make a video on rolling upgrade in RAC
Done!
@@dbagenesis please provide the link, bhaiya !
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
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.
sir, can you please help with patching 11g and 12c? Thanks
Sure, added to my list. Will post videos soon!
how do i register my oracle database active data guard license?
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 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.
Can this work for 11.2.0.4 to 19 c also ?
please provide the upgrade method from 11.2.0.1 to 11.2.0.4 upgrade video
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
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.
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.
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!
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 ..