How to upgrade oracle database 11g to 19c on Linux step by step
we are going to learn how to upgrade the oracle 11g to 19c database on the Linux platform step by step.
#upgradeoracledatabase #upgrade11gto19c #upgradedatabase
00:00 Introduction
00:30 ocptechnology.com
00:55 bash_profile
01:30 rman full database backup
02:10 purge recycle bin
02:25 gather dictionary stats
02:47 run preupgrade.jar
04:10 run preupgrade_fixups.sql
05:22 check the timezone version
05:37 shutdown database
06:34 start database from 19c home
07:15 run dbupgrade utility
07:41 catuppst.sql
08:10 compile invalid objects
09:27 compatible parameters
10:10 gather fixed objects stats
10:30 post degradation steps
How can I upgrade from 11g to 19c?
How do I upgrade to Oracle 19c?
Can I upgrade 11.2 0.3 to 19c?
👉 Blog Link: ocptechnology.com/how-to-upgr...
Join Our Official Telegram Channel
👉t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: whatsapp.com/channel/0029VaS0...
👉Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
MY Gadgets:
👉Mic amzn.to/3lYLBW8
👉Laptop amzn.to/3ndktCa
👉Mouse amzn.to/3jn58Ok
👉Oracle Interview application play.google.com/store/apps/de...
👉Facebook page / ocptechnology
👉Instagram / digitalshripal
👉Website ocptechnology.com/
👉Twitter / ocptechnology
Join Our Official Telegram Group
👉t.me/ocptechnology
oracle database upgrade from 11g to 19c step by step Linux,
oracle database upgrade from 11.2.0.3 to 19c,
oracle 11g to 19c upgrade known issues,
oracle 11g to 19c upgrade checklist,
upgrade oracle 11g to 19c dbua,
oracle 11g to 19c deprecated features,
11.2.0.4 to 19c upgrade,
database upgrade from 12c to 19c using data pump,
Пікірлер: 51
Hello friends, If learn somthing from this video please write your fillings in the comment box, and linke the video. If you have any suggestion for me please ping me. You can join our official telegram group also t.me/oracledbahelp 😀
Extremely Thankful for this video and amazing step by step vlogs sir.
Super ji
@ocptechnology
3 ай бұрын
Thank you 🙏
Great and Superb Video Sir , Thanks for the sharing
@ocptechnology
Жыл бұрын
Thank you for your valuable feedback 🙏
Hi Mr. Shripal. Thanks for your excelent video. My upgrade was succesfully performed. More one subscribed on your channel. I´m Londrina - PR - Brasil.
@ocptechnology
11 ай бұрын
Thank you dear
Nice explanation, thanks
Very informative and simple to understand
@ocptechnology
6 ай бұрын
Thank you Avinash
Very good video sir thanks for sharing
@ocptechnology
2 жыл бұрын
thank you dear
Nice activity sir ji.
@ocptechnology
2 жыл бұрын
Thank you dear
very informative and nice video 👍🏻
@ocptechnology
2 жыл бұрын
thank you Nidhi
Nice video. 👍👍
@ocptechnology
2 жыл бұрын
Thanks dear
nice video.. convert non-cdb to cdb also can be included ..
So much use full contents
@ocptechnology
2 жыл бұрын
Thank you dear
I think mention the flash recovery also if upgradation failure due to any reason atleast we can go back to old version
@ocptechnology
2 жыл бұрын
That's good point, I'll try to make the same video. How is the video?
Hi i didnt see you or hear you mention that the preupgrade.jar file needs to be downloaded?? Or its not important for these steps
@ocptechnology
11 күн бұрын
Have you seen the complete video?
Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump
@ocptechnology
11 күн бұрын
Simple bro just take export from 18c and import in 19c
Sir I wished to know if at source I have 11.2.04, and at destination 19c. So then how do I perform datapump
@ocptechnology
9 ай бұрын
Very simple, Just take full export normally and import it in a 19c environment.
Sir, I just followed your steps and I am getting an error(ORA-12560: TNS:protocol adapter error) in step6 while connect database using the sqlplus / as sysdba(after I set up the oracle_sid, path, oracle_home). Could you please guide. FYI, I am doing this upgradation in windows server. Thanks
@ocptechnology
Жыл бұрын
Bro export library path also from new home
@vetrivels9236
Жыл бұрын
@@ocptechnology Done but getting the same error.
@ocptechnology
Жыл бұрын
@@vetrivels9236 share your environment details on support@ocptechnology.com I'll help you by tomorrow morning
I don’t see where you restore the backups to the target db
@ocptechnology
Жыл бұрын
If you doing this activity on same server then you don't need to restore any backup, if you want to see upgradation using RMAN backup check my another video
How to upgrade from oracle 8 to orace 10g. Plz guide
@ocptechnology
Жыл бұрын
I haven't worked on 8i, but you can do one thing take export backup from 8i and import it in 10g,
hello sir i am your subscriber . can you please create and share video about databse patching and migration and RAC ASM configuration. It would be a big help to me .. Thanks
@ocptechnology
Жыл бұрын
Yes I'll dear
Hello everyone who can help me in oracle dba bcz i m stuck here please help me who is doing work as a oracle dba
@ocptechnology
Ай бұрын
Hi, Where you stuck?
hi sir , what will be the impact on licensing .
@ocptechnology
11 ай бұрын
You should have 19c licence
does it work with 11g XE to 19c XE?
@ocptechnology
Жыл бұрын
I'm not sure, you can try
@yolandoo404
Жыл бұрын
@@ocptechnology thank you for your respond :)
Can we upgrade from 10g to 19c
@ocptechnology
Жыл бұрын
Yes we can
Anyone is there who will help me in solve the oracle issue
@ocptechnology
Ай бұрын
What issue are you facing?