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

  • @ocptechnology
    @ocptechnology2 жыл бұрын

    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.Shah116 ай бұрын

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

  • @jeevananthamvaradhan2596
    @jeevananthamvaradhan25963 ай бұрын

    Super ji

  • @ocptechnology

    @ocptechnology

    3 ай бұрын

    Thank you 🙏

  • @knowledegofeveryyhing5277
    @knowledegofeveryyhing5277 Жыл бұрын

    Great and Superb Video Sir , Thanks for the sharing

  • @ocptechnology

    @ocptechnology

    Жыл бұрын

    Thank you for your valuable feedback 🙏

  • @carloscamillo47
    @carloscamillo4711 ай бұрын

    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

  • @muralivenkatesan1215
    @muralivenkatesan12156 ай бұрын

    Nice explanation, thanks

  • @AvinashKumar-qg7zv
    @AvinashKumar-qg7zv6 ай бұрын

    Very informative and simple to understand

  • @ocptechnology

    @ocptechnology

    6 ай бұрын

    Thank you Avinash

  • @knowledegofeveryyhing5277
    @knowledegofeveryyhing52772 жыл бұрын

    Very good video sir thanks for sharing

  • @ocptechnology

    @ocptechnology

    2 жыл бұрын

    thank you dear

  • @brahmanand2319
    @brahmanand23192 жыл бұрын

    Nice activity sir ji.

  • @ocptechnology

    @ocptechnology

    2 жыл бұрын

    Thank you dear

  • @ramkenam
    @ramkenam2 жыл бұрын

    very informative and nice video 👍🏻

  • @ocptechnology

    @ocptechnology

    2 жыл бұрын

    thank you Nidhi

  • @debkumarpayra5900
    @debkumarpayra59002 жыл бұрын

    Nice video. 👍👍

  • @ocptechnology

    @ocptechnology

    2 жыл бұрын

    Thanks dear

  • @shashiranjan06cse04
    @shashiranjan06cse042 жыл бұрын

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

  • @nishakicooking1236
    @nishakicooking12362 жыл бұрын

    So much use full contents

  • @ocptechnology

    @ocptechnology

    2 жыл бұрын

    Thank you dear

  • @ansarimd6643
    @ansarimd66432 жыл бұрын

    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?

  • @rowlandjones3872
    @rowlandjones387211 күн бұрын

    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

    11 күн бұрын

    Have you seen the complete 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

    11 күн бұрын

    Simple bro just take export from 18c and import in 19c

  • @MrMandarpriya
    @MrMandarpriya9 ай бұрын

    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.

  • @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

  • @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

  • @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,

  • @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

  • @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?

  • @mmaheshrao5473
    @mmaheshrao547311 ай бұрын

    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Ай бұрын

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

  • @ocptechnology

    @ocptechnology

    Ай бұрын

    What issue are you facing?