Oracle 12c rac upgrade to 19c steps - Part 2 RDBMS upgradation to 19c

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ก.พ. 2025
  • Oracle 12c to 19c RAC database upgrade steps - Part 2 RDBMS Upgrade steps || oracle 12c rac upgrade to 19c || Learn How to upgrade the oracle RAC database from 12c to 19c
    In this tutorial, I will guide you on how to perform RDBMS up-gradation in the Oracle RAC database.
    Part 1 of this video can be found at the following link:
    Upgrade grid infrastructure from 12c to 19c || Grid up-gradation step by step guide: • Upgrade grid infrastru...
    Learn how to upgrade the oracle 12c to 19c rac database.
    Direct Upgrade to Oracle Database 19c
    oracle database upgrade from 12c to 19c manual steps ||
    Learn How to upgrade the oracle 12c database to 19c manually. oracle 12c to 19c manual upgrade steps oracle 12c to 19c upgrade steps ||
    For downloading software refer to the below links:
    1. For Oracle grid and RDBMS 19c software check the below link:
    www.oracle.com...
    2.Download Oracle Linux 7.8 from the below link:
    yum.oracle.com...
    3. Download VirtualBox from the below link:
    www.virtualbox...
    Check out previous videos:
    Oracle RAC Patching Steps - opatchauto apply method || oracle 19c patching:
    • Oracle RAC Patching St...
    How to download the latest PSU Patches from Oracle SUPPORT || Latest Patches Oracle:
    • How to download latest...
    Applying Latest patch on Oracle 19c RAC database || Apply Jan 2021 RU Patch Demo in Rolling manner:(Manual Patching method)
    • Applying Latest patch ...
    oracledatabase #OracleDBAOnlineTraining #oracle19c #oracle12c
    ABOUT OUR CHANNEL:
    Our channel is Oracle DBA Online Training. We cover lots of cool stuff such as Oracle Database architecture, installation, database up-gradation, administration, Data Guard, RAC database architecture, golden gate, and many more.
    Check out our channel here:
    / @oracledbaonlinetraining
    Don’t forget to subscribe!
    Oracle 12c RAC installation on Linux step by step
    • Oracle 12c RAC install...
    CHECK OUT OUR OTHER VIDEOS
    1) How to Create Physical Standby Database manually: • create physical standb...
    2) Oracle Data Guard Switchover Manual Steps Using SQLPLUS
    • Oracle Data Guard Swit...
    3)Oracle 19c Active Data Guard DML Redirection
    • Oracle 19c Active Data...
    4)Oracle 19c Database - Active Data Guard (ADG)
    • Oracle 19c Active Data...
    5) Oracle Enterprise Manager Cloud Control 13c Installation Guide:
    • Oracle Enterprise Mana...
    6) Oracle 19c RAC installation on Linux step by step complete guide
    • Oracle 19c RAC install...
    7) create a physical standby database step by step oracle 19c
    • create physical standb...
    8) Apply latest patches on Oracle 19c RAC database
    • Applying Latest patch ...
    9) Oracle 19c RAC database software Installation & database creation using DBCA on Linux step by step:
    • Oracle 19c RAC databas...
    10) Oracle Linux Installation on VirtualBox || How to install Linux on VirtualBox
    • Oracle Linux Installat...
    11.Oracle 12c to 19c database upgrade using DBUA tool
    • Oracle 12c to 19c data...
    12.Oracle 12c to 19c manual upgrade steps - Oracle Database Upgrade:
    • Oracle 12c to 19c manu...
    13. Oracle 21c RAC Installation on Linux Step by Step
    • Oracle 21c RAC Install...
    ########### My PC Configurations ############
    1. RAM:
    Corsair Vengeance LPX 16GB (1x16GB) DDR4 3200MHZ UDIMM C16 Desktop RAM Memory Module(Buy 2 RAM of 16GB):
    amzn.to/3vfMBY0
    2. SSD Hard Disk:
    Seagate Barracuda Q5 1 TB Internal SSD - M.2 NVMe PCIe Gen3 ×4, 3D QLC for Desktop or Laptop, 1-Year Rescue Services (ZP1000CV3A001)
    amzn.to/2TiDyHX
    3. Processor:
    AMD Ryzen 5 3600 Desktop Processor 6 Cores up to 4.2 GHz 35MB Cache AM4 Socket (100-000000031)
    amzn.to/2TeCxR3
    4. Motherboard:
    Gigabyte B450M DS3H (AMD Ryzen AM4/M.2/HMDI/DVI/USB 3.1/DDR4/Micro ATX/Motherboard)
    amzn.to/2Sp59q5
    5. Ant Esports ICE-300TG Mid Tower Gaming Cabinet Computer case Supports ATX, Micro-ATX, Mini-ITX Motherboard with Transparent Tempered Glass Side Panel, 4 x 120 mm Fan (3 Rainbow Front/ 1 Black Rear)
    amzn.to/2RKJ6u5
    ----------------
    🌐 Find Us At: Oracle DBA Online Training: www.oracledbao...
    📧 Get in Touch: Email: support@oracledbaonlinetraining.com
    🌐 Connect with Us:
    WhatsApp: WhatsApp Now wa.me/91816915...
    Facebook: Follow Us / oracledbaonline
    Telegram: Join Our Channel t.me/joinchat/...
    LinkedIn: Connect / oracle-dba-online-trai...
    Twitter: Follow @online_dba / oradbaonline
    Blogger: Read Our Blog oracledbatrain...
    💰 Support Us on PayPal: Donate Now: www.paypal.me/...
    Thank you for being part of our community! Your support drives us to create valuable content for Oracle DBAs and enthusiasts.

ความคิดเห็น • 62

  • @dotagamer5925
    @dotagamer5925 3 ปีที่แล้ว +2

    Sir, As Always …….. The best !!!

  • @SeunLaoye
    @SeunLaoye 3 ปีที่แล้ว +1

    This is a great explanation. Thanks for the detailed information on this topic

  • @ziadfawzi
    @ziadfawzi 2 ปีที่แล้ว +1

    Very useful video. Thank you.

  • @freeexampreparations76
    @freeexampreparations76 3 ปีที่แล้ว +3

    Thank you sir. It is very very helpful.🙏🙏🙏🙏

  • @rajkishore1960
    @rajkishore1960 ปีที่แล้ว +1

    I like your videos

  • @rajeshkunda6704
    @rajeshkunda6704 3 ปีที่แล้ว +3

    Hi, all are useful topics. Can you share db upgrade document also.

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +3

      Ok I will share in sometime

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว

      Download the document from following link drive.google.com/file/d/1y1bo3TcuV_Ux6DUAMBwx3tpUAQya26Ty/view?usp=sharing

  • @rakeshrawat_R2
    @rakeshrawat_R2 ปีที่แล้ว

    When you started the activity of Grid upgradation the DB was down, Is it necessary to down the DB while upgrading the GRID?
    second, when you start the RDBMS upgradation again the DB was down, and around the 23:04 timestamp, you said it is necessary while upgrade RDBMS the Db should be Up & running, and while RDMBS upgradation you started the DB.
    Could you please explain it?

  • @stephenlin5056
    @stephenlin5056 3 ปีที่แล้ว +2

    Great video, thank you! There is no downtime to application system during GRID upgrade, but there is downtime during RDBMS upgrade, right?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Yes right . Thank you for your feedback

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      If you are performing any critical database upgradation. It is always recommend to take downtime for upgradation to avoid any last minute surprises.

  • @kirankumar-np7tc
    @kirankumar-np7tc ปีที่แล้ว +1

    Hi
    No need to run preupgrade jar and preupgrde.fixup before upgrade?

  • @rajkishore1960
    @rajkishore1960 ปีที่แล้ว

    Thank you

  • @kdnice37
    @kdnice37 2 ปีที่แล้ว +1

    Great video. Can you provide access to your documentation?

  • @amankhaira-or3yf
    @amankhaira-or3yf 2 ปีที่แล้ว +1

    Wow what a explanation...Sir please share me the documents

  • @stephenlin5056
    @stephenlin5056 3 ปีที่แล้ว +2

    Do you have plan to provide vedio of 'Upgrade GRID and RBDMS for RAC (2 nodes) physical standby'?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +3

      Yes definitely I will prepare video on this topic.

    • @stephenlin5056
      @stephenlin5056 3 ปีที่แล้ว +1

      @@OracleDBAOnlineTraining Is the video of 'Upgrade GRID and RBDMS for RAC (2 nodes) physical standby' ready? Thank you very much!

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Not yet

  • @stephenlin5056
    @stephenlin5056 3 ปีที่แล้ว +1

    Do you have video about 'Oracle 12c rac upgrade to 19c using AutoUpgrade Method' ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Not yet but soon I will share this video... meanwhile u can refer single instance upgrade using Autoupgrade Method

  • @kirankumar-np7tc
    @kirankumar-np7tc 2 ปีที่แล้ว +1

    When you ran runinstaller what is the script it gave to run ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  2 ปีที่แล้ว +1

      Could you reframe your query

    • @kirankumar-np7tc
      @kirankumar-np7tc 2 ปีที่แล้ว +1

      @@OracleDBAOnlineTraining when fire runinstaller for db upgradation. Does it give any root script to run ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  2 ปีที่แล้ว +1

      Could you confirm if you are upgrading single instance or rac and what method you are using to upgrade db

    • @kirankumar-np7tc
      @kirankumar-np7tc 2 ปีที่แล้ว +1

      @@OracleDBAOnlineTraining rac database and rolling method. I watched ur video of rac db upgradation from 12c to 19c part2 video. When fire runinstaller for rac db upgradation. I dont know weather it give any root script or not. Pls tell me does it give any root script run ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  2 ปีที่แล้ว +1

      I think you have not checked entire video. During installation end root script execution will come. And after that using dbua we have to upgrade db

  • @Hindu-iy3uc
    @Hindu-iy3uc 3 ปีที่แล้ว +2

    Can u perform two node rac database upgrade from 12c to 19c using manual method as 80 % of upgradtion is done by manual method

  • @navinguptatcs7838
    @navinguptatcs7838 3 ปีที่แล้ว +1

    Is there a downtime involved during DB upgrade? Can this done with 0 downtime?

  • @DineshKumar-sc8dd
    @DineshKumar-sc8dd 2 ปีที่แล้ว +1

    Very well explained! Could you please share the documents.

  • @kishorerouthu8816
    @kishorerouthu8816 2 ปีที่แล้ว +1

    Hi Sir , Could you please share the doc plz..

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  2 ปีที่แล้ว +1

      The document is paid version if you are interested ping me on whatsapp no

  • @Hindu-iy3uc
    @Hindu-iy3uc 3 ปีที่แล้ว +1

    Hi good work can u share me the doc

  • @stephenlin5056
    @stephenlin5056 3 ปีที่แล้ว +1

    To reduce downtime, can I run './runInstaller' to install RDBMS after GRID dry-run, but before GRID actual upgrade? i.e.
    Day 1 (no downtime):
    1. (GRID) ./gridSetup.sh -dryRunForUpgrade
    2. (RDBMS) ./runInstaller
    Day 2 (need downtime)
    3. (GRID) ./gridSetup.sh
    4. (RDBMS) ./dbua

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว

      Yes you should always installation rdbms new version before actual Upgradation i.e. after grid upgrade. Actually grid upgrade can be done in rolling manner but not the rdbms

  • @joseluisdelarosa728
    @joseluisdelarosa728 3 ปีที่แล้ว +1

    hi ! great videos could you please share the document on database upgrade ? Best Regards

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Thank you I have shared u the link.

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +2

      I will share you new link in sometime to download latest updated document

    • @joseluisdelarosa728
      @joseluisdelarosa728 3 ปีที่แล้ว +1

      Thank you sir. All your explanations are very clear and all oriented to the needs of today's companies. You explain very Wells. The BEST on the net

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Glade to hear that.

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  3 ปีที่แล้ว +1

      Download the document from following link drive.google.com/file/d/1y1bo3TcuV_Ux6DUAMBwx3tpUAQya26Ty/view?usp=sharing