How to upgrade oracle database 11g to 19c on Linux step by step

preview_player
Показать описание
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:55 bash_profile
01:30 rman full database backup
02:10 purge recycle bin
02:25 gather dictionary stats
05:22 check the timezone version
05:37 shutdown database
06:34 start database from 19c home
07:15 run dbupgrade utility
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?

Join Our Official Telegram Channel

Chat with me on:

MY Gadgets:

Join Our Official Telegram Group

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,
Рекомендации по теме
Комментарии
Автор

Extremely Thankful for this video and amazing step by step vlogs sir.

Sagar.Shah
Автор

Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump

imtiazmahmood
Автор

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

rowlandjones
Автор

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

Shazrash
Автор

Anyone is there who will help me in solve the oracle issue

Shazrash
Автор

nice video.. convert non-cdb to cdb also can be included ..

shashiranjancse
Автор

Hi Mr. Shripal. Thanks for your excelent video. My upgrade was succesfully performed. More one subscribed on your channel. I´m Londrina - PR - Brasil.

carloscamillo
Автор

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

amitvyas
Автор

Very good video sir thanks for sharing

knowledegofeveryyhing
Автор

I think mention the flash recovery also if upgradation failure due to any reason atleast we can go back to old version

ansarimd
Автор

Very informative and simple to understand

AvinashKumar-qgzv
Автор

Great and Superb Video Sir, Thanks for the sharing

knowledegofeveryyhing
Автор

How to upgrade from oracle 8 to orace 10g. Plz guide

relaxingmusic
Автор

hi sir, what will be the impact on licensing .

mmaheshrao
Автор

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

vetrivels
Автор

I don’t see where you restore the backups to the target db

daveradoicic
Автор

Sir I wished to know if at source I have 11.2.04, and at destination 19c. So then how do I perform datapump

MrMandarpriya