Тёмный

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

OCP TECHNOLOGY
Подписаться 11 тыс.
Просмотров 8 тыс.
50% 1

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,

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 51   
@ocptechnology
@ocptechnology 2 года назад
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 😀
@Sagar.Shah11
@Sagar.Shah11 6 месяцев назад
Extremely Thankful for this video and amazing step by step vlogs sir.
@muralivenkatesan1215
@muralivenkatesan1215 6 месяцев назад
Nice explanation, thanks
@AvinashKumar-qg7zv
@AvinashKumar-qg7zv 6 месяцев назад
Very informative and simple to understand
@ocptechnology
@ocptechnology 6 месяцев назад
Thank you Avinash
@knowledegofeveryyhing5277
@knowledegofeveryyhing5277 Год назад
Great and Superb Video Sir , Thanks for the sharing
@ocptechnology
@ocptechnology Год назад
Thank you for your valuable feedback 🙏
@carloscamillo47
@carloscamillo47 11 месяцев назад
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
@ocptechnology 11 месяцев назад
Thank you dear
@ramkenam
@ramkenam 2 года назад
very informative and nice video 👍🏻
@ocptechnology
@ocptechnology 2 года назад
thank you Nidhi
@knowledegofeveryyhing5277
@knowledegofeveryyhing5277 2 года назад
Very good video sir thanks for sharing
@ocptechnology
@ocptechnology 2 года назад
thank you dear
@debkumarpayra5900
@debkumarpayra5900 2 года назад
Nice video. 👍👍
@ocptechnology
@ocptechnology 2 года назад
Thanks dear
@brahmanand2319
@brahmanand2319 2 года назад
Nice activity sir ji.
@ocptechnology
@ocptechnology 2 года назад
Thank you dear
@jeevananthamvaradhan2596
@jeevananthamvaradhan2596 3 месяца назад
Super ji
@ocptechnology
@ocptechnology 3 месяца назад
Thank you 🙏
@shashiranjan06cse04
@shashiranjan06cse04 2 года назад
nice video.. convert non-cdb to cdb also can be included ..
@nishakicooking1236
@nishakicooking1236 2 года назад
So much use full contents
@ocptechnology
@ocptechnology 2 года назад
Thank you dear
@ansarimd6643
@ansarimd6643 2 года назад
I think mention the flash recovery also if upgradation failure due to any reason atleast we can go back to old version
@ocptechnology
@ocptechnology 2 года назад
That's good point, I'll try to make the same video. How is the video?
@imtiazmahmood1757
@imtiazmahmood1757 Месяц назад
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
@ocptechnology 13 дней назад
Simple bro just take export from 18c and import in 19c
@rowlandjones3872
@rowlandjones3872 12 дней назад
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
@ocptechnology 12 дней назад
Have you seen the complete video?
@vetrivels9236
@vetrivels9236 Год назад
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
@ocptechnology Год назад
Bro export library path also from new home
@vetrivels9236
@vetrivels9236 Год назад
@@ocptechnology Done but getting the same error.
@ocptechnology
@ocptechnology Год назад
@@vetrivels9236 share your environment details on support@ocptechnology.com I'll help you by tomorrow morning
@MrMandarpriya
@MrMandarpriya 9 месяцев назад
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
@ocptechnology 9 месяцев назад
Very simple, Just take full export normally and import it in a 19c environment.
@amitvyas3885
@amitvyas3885 Год назад
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
@ocptechnology Год назад
Yes I'll dear
@relaxingmusic2194
@relaxingmusic2194 Год назад
How to upgrade from oracle 8 to orace 10g. Plz guide
@ocptechnology
@ocptechnology Год назад
I haven't worked on 8i, but you can do one thing take export backup from 8i and import it in 10g,
@daveradoicic
@daveradoicic Год назад
I don’t see where you restore the backups to the target db
@ocptechnology
@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
@mmaheshrao5473
@mmaheshrao5473 11 месяцев назад
hi sir , what will be the impact on licensing .
@ocptechnology
@ocptechnology 11 месяцев назад
You should have 19c licence
@yolandoo404
@yolandoo404 Год назад
does it work with 11g XE to 19c XE?
@ocptechnology
@ocptechnology Год назад
I'm not sure, you can try
@yolandoo404
@yolandoo404 Год назад
@@ocptechnology thank you for your respond :)
@tamahesh
@tamahesh Год назад
Can we upgrade from 10g to 19c
@ocptechnology
@ocptechnology Год назад
Yes we can
@Shazrash
@Shazrash Месяц назад
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
@ocptechnology Месяц назад
Hi, Where you stuck?
@Shazrash
@Shazrash Месяц назад
Anyone is there who will help me in solve the oracle issue
@ocptechnology
@ocptechnology Месяц назад
What issue are you facing?
Далее
How to UPGRADE ORACLE 12c to 19c using RMAN Backup
8:39
How to configure Oracle 19c Dataguard with PDB
15:39
2DROTS vs WYLSACOM! КУБОК ФИФЕРОВ 1 ТУР
07:25
Elden Ring DLC - ПОДОЖГЛО ПОПУ!
07:26
Просмотров 459 тыс.
How to upgrade Oracle 11G to 19C using Auto Upgrade
13:29
how to restore rman backup on different server
12:39
Просмотров 30 тыс.
Upgradation in Oracle | Learnomate technologies
28:57
Просмотров 1,4 тыс.
Oracle Database 12c to 19c Upgrade Manually on Linux
51:52
2DROTS vs WYLSACOM! КУБОК ФИФЕРОВ 1 ТУР
07:25