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
5 жыл бұрын
Nice one
@ShuvodipDasgupta1610
4 жыл бұрын
Thank you
@arundubey5896
4 жыл бұрын
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
4 жыл бұрын
Most welcome !
@narendrastudy4286
2 жыл бұрын
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
2 жыл бұрын
Glad it was helpful!
@mvkishore
6 жыл бұрын
The video was really very informative and good. Thanks for sharing the detailed upgrading process.
@dbagenesis
3 жыл бұрын
Glad it helped you!
@himabindhu7970
3 жыл бұрын
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
3 жыл бұрын
Thank you! Will do!
@thakkaramit5403
4 жыл бұрын
nice explanation sir, I really like your detail explanation method.
@preethiumesh
6 жыл бұрын
Very useful for me, thanks a lot DBA genesis
@dbagenesis
3 жыл бұрын
Thank you!
@huipingwen4925
5 жыл бұрын
This video presents Systematical and detail procedure.
@manikbasha4745
3 жыл бұрын
Wonderful video detailed explanation Thanks very much!!!
@dbagenesis
3 жыл бұрын
Glad it was helpful!
@kumarkoruturu8187
5 жыл бұрын
tq u so much ....broo......such valuable video .....in depth detailed upgradation.....once agaiy tq uu ....broo....do more videossss
@dbagenesis
5 жыл бұрын
You are most welcome. Also check our support website for latest DBA Articles: support.dbagenesis.com/
@ibrahimjsowe8987
2 жыл бұрын
Thanks a lot…..what an excellent demo?
@dbagenesis
2 жыл бұрын
My pleasure!
@HarishN-vn9sg
3 жыл бұрын
picture perfect................Thanx...........
@dbagenesis
3 жыл бұрын
Welcome 😊
@madhukarsargar5414
4 жыл бұрын
Thanks for very easy and clear explanation but what about timestamp version upgrade
@amitshinde9724
6 жыл бұрын
nice video tysm for this its very helpfull
@dbagenesis
3 жыл бұрын
Thank you!
@pravpandit
3 жыл бұрын
Thanks a ton.🙌
@ramakrishnab6254
5 жыл бұрын
Bro.. Super explanation....!!
@dbagenesis
3 жыл бұрын
Thank you!
@priyaramu7922
4 жыл бұрын
super explanation
@dbagenesis
4 жыл бұрын
Thank you so much 🙂
@dsbs-ke1yn
4 жыл бұрын
Thanks you
@tauseefmohmmed5447
6 жыл бұрын
Make a video onOracle RAC install
@gemuandore7910
5 жыл бұрын
thanks for the video :)
@dbagenesis
3 жыл бұрын
Thank you!
@jamshedkhan6121
5 жыл бұрын
thanks a lot...
@dbagenesis
3 жыл бұрын
Thank you!
@narendrapakalapati5660
5 жыл бұрын
Excellent video ..thank you
@dbagenesis
3 жыл бұрын
Thank you!
@JavedShaikh-ej6ty
5 жыл бұрын
Very useful video👏
@dbagenesis
3 жыл бұрын
Thank you!
@amitthakur528
5 жыл бұрын
Great sir
@dbagenesis
3 жыл бұрын
Thank you!
@MuhammadAli-fi3mn
4 жыл бұрын
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
4 жыл бұрын
Sir can you upload video on upgradation from 11.1.0 to 11.2
@dbagenesis
4 жыл бұрын
I already have published it. Search once on KZitem
@ayoob999
6 жыл бұрын
Excellent video......
@dbagenesis
3 жыл бұрын
Thank you!
@ronaknmodi
4 жыл бұрын
Make a video on rolling upgrade in RAC
@dbagenesis
4 жыл бұрын
Done!
@itisvikash
4 жыл бұрын
@@dbagenesis please provide the link, bhaiya !
@bharathkumar-ds8cd
3 жыл бұрын
kindly make one video of downgrade.
@rupeshrock
5 жыл бұрын
Why we run three 'exec dbms' scripts plz GIve me explanation
@Silverdragon517
2 жыл бұрын
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
@Essentialliv52
5 жыл бұрын
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
4 жыл бұрын
Then you have to downgrade. Follow downgrade steps on Oracle docs
@Kashyap-Amit
3 жыл бұрын
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
@Vone_WorldClass
4 жыл бұрын
This is very clearly explain,but can I create new oracle home upgrade as the same old home location?
@dbagenesis
4 жыл бұрын
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.
@tauseefmohmmed5447
6 жыл бұрын
Thanku sir
@dbagenesis
3 жыл бұрын
Welcome
@ankitgupta10
6 жыл бұрын
Hi, Can you help us on RAC upgrade?
@dhyanswaroop2606
4 жыл бұрын
ankit gupta it is same bro
@rajatsanwal9919
2 жыл бұрын
phase 49 took 84802 seconds ? 23 hours ?
@Essentialliv52
5 жыл бұрын
please provide the upgrade method from 11.2.0.1 to 11.2.0.4 upgrade video
@pranavjoshi5961
4 жыл бұрын
Any Tutorials related to Golden gate ??
@dbagenesis
4 жыл бұрын
we do have video course on Golden Gate: dbagenesis.com/p/oracle-golden-gate-masterclass
@pranavjoshi5961
4 жыл бұрын
@@dbagenesis Thank You Sir ..
@reginaforka7444
3 жыл бұрын
do you have a video on patching?
@dbagenesis
3 жыл бұрын
Not yet but I guess when you download the patch, you get a read-me file. This will help you perform the patching.
@reginaforka7444
3 жыл бұрын
sir, can you please help with patching 11g and 12c? Thanks
@dbagenesis
3 жыл бұрын
Sure, added to my list. Will post videos soon!
@pramod172
4 жыл бұрын
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
@rehantayyab82
4 жыл бұрын
please can you tell which version of linux used in this practical ?
@dbagenesis
4 жыл бұрын
I guess OEL 6.5 but you can also go for OEL 7.6, which I currently use for all trainings.
@rehantayyab82
4 жыл бұрын
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
4 жыл бұрын
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
4 жыл бұрын
There is no need for data transfer, once you perform the upgrade, the 11g DB will be running from the new Oracle home 12c.
@masudhasan9315
4 жыл бұрын
how do i register my oracle database active data guard license?
@jasonstewart1504
4 жыл бұрын
What is the purpose of validating invalid objects? Also how do you backup ORACLE_HOME and ORAInventory? respond ASAp Thank you.
@rajatsanwal9919
2 жыл бұрын
OS level copy you can do
@rameshkumar-lf4nd
3 жыл бұрын
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
3 жыл бұрын
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.
@surajkhanna1735
3 жыл бұрын
Can this work for 11.2.0.4 to 19 c also ?
@thetechcafe754
4 жыл бұрын
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
2 жыл бұрын
I am wondering this too . This is huge time to be spent in db upgrade.
@lindabrown7470
5 жыл бұрын
During the installation portion of this video, why did you select all the groups to be 'dba' and not 'oinstall'? Just curious...
Пікірлер: 92