Oracle RAC database management || Oracle RAC Commands || crsctl vs srvctl command

SdĂ­let
VloĹžit
  • čas přidĂĄn 8. 07. 2024
  • Learn Oracle RAC database important commands || Understand how to start or stop rac database along with CRS services || Also, learn how to add datafile or how to rename datafile in the RAC database. How to change any parameter in the RAC database.
    Oracle RAC database admin commands
    How to manage parameter files, control files, datafile and redo log file in RAC
    The topics covered in this tutorial are listed below:
    03:27 How to start and stop RAC cluster/grid
    23:15 crsctl vs srvctl
    26:37 How to verify Oracle RAC Configuration
    29:40 How to stop and start RAC DB/Instance
    32:12 How to rename/Multiplex control file in RAC
    37:37 How to manage spfile in RAC on ASM
    44:41 How to add and rename datafile in RAC
    52:22 How to rename or resize Redo log file in RAC
    55:07 How to change any parameter in RAC
    🔥 For DBA Training or Database Assistance, Call/WhatsApp: tel: +91 8169158909
    🌐 Explore our Website links below for More Courses/contents/documents:
    Purchase Ready course: Complete Oracle DBA Course www.oracledbaonlinetraining.c...
    Purchase the Documents related to our CZcams videos: Oracle DBA CZcams Video Related Documents www.oracledbaonlinetraining.c...
    🔥 Join Our Exclusive Membership Program Today for only INR Rs.1199:
    Become a member now and enjoy benefits such as loyalty badges, exclusive members-only videos, early access to new content, priority comment replies, and exclusive DBA content related to various topics. [Join Now]( / @oracledbaonlinetraining )
    #oracledatabase #OracleDBAOnlineTraining #oracle19c #oracle12c
    ----------------
    ABOUT OUR CHANNEL:
    Welcome to Oracle DBA Online Training! Our channel covers a diverse range of topics including Oracle Database architecture, installation, database upgrades, administration, Data Guard, RAC database architecture, GoldenGate, and more.
    🔗 Check out our channel here: Oracle DBA Online Training / @oracledbaonlinetraining
    🚀 Don't Forget to Subscribe!
    ----------------
    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...
    ----------------
    MY PC CONFIGURATIONS:
    For those curious about my PC setup:
    1. RAM: Corsair Vengeance LPX 16GB DDR4 3200MHz - Buy Here: amzn.to/3vfMBY0
    2. SSD: Seagate Barracuda Q5 1TB Internal SSD - M.2 NVMe PCIe Gen3 ×4 - Buy Here: amzn.to/2TiDyHX
    3. Processor: AMD Ryzen 5 3600 - Buy Here: amzn.to/2TeCxR3
    4. Motherboard: Gigabyte B450M DS3H - Buy Here: amzn.to/2Sp59q5
    5. Cabinet: Ant Esports ICE-300TG Mid Tower Gaming Cabinet - Buy Here: amzn.to/2RKJ6u5
    6. Monitor: LG 22 inch IPS Monitor - Full HD - Buy Here: amzn.to/3vfOnZa
    7. Microphone: Boya BYM1 Omnidirectional Lavalier Condenser Microphone - Buy Here: amzn.to/3bSiM8a
    ----------------
    🌐 Find Us At: Oracle DBA Online Training: www.oracledbaonlinetraining.com/
    📧 Get in Touch: Email: support@oracledbaonlinetraining.com
    🌐 Connect with Us:
    - WhatsApp: WhatsApp Now wa.me/918169158909
    - Facebook: Follow Us / oracledbaonline
    - Telegram: Join Our Channel t.me/joinchat/nWHoPJ9C27BjMmI1
    - LinkedIn: Connect / oracle-dba-online-trai...
    - Twitter: Follow @online_dba / oradbaonline
    - Blogger: Read Our Blog oracledbatrainingexperts.blog...
    💰 Support Us on PayPal: Donate Now: www.paypal.me/oracledbatraining
    Thank you for being part of our community! Your support drives us to create valuable content for Oracle DBAs and enthusiasts.

Komentáře • 35

  • @ganeshgavhane5021
    @ganeshgavhane5021 Před rokem +1

    Thanks, it will be very helpful to us

  • @mido2elghoury
    @mido2elghoury Před rokem

    thank you so much always follow your channel great video

  • @balchandum4068
    @balchandum4068 Před 2 lety +1

    Very useful video. Thank you so much.

  • @nadunsamarasinghe5592
    @nadunsamarasinghe5592 Před rokem +1

    Its very useful and if you have free time just share the usage of the oifcfg command related stuff as well. Thanks...!🙏🙏

  • @ManishSingh-wj2yz
    @ManishSingh-wj2yz Před 2 lety +1

    Nice explanation. Thanks

  • @dunglecong5898
    @dunglecong5898 Před 2 lety +1

    thank you so much. I always follow your channel.

  • @gaminglegend2346
    @gaminglegend2346 Před 2 lety +1

    very useful video. Thanks a lot..

  • @thirumurugan5959
    @thirumurugan5959 Před rokem +1

    Great

  • @surajitgupta7987
    @surajitgupta7987 Před 2 lety +2

    what is the difference between data/racdb/users1.dbf and data/racdb/datafile/users._81.1_8....Is there any difference between these two datafiles

  • @sundeepkumar6774
    @sundeepkumar6774 Před rokem

    Thank you for sharing the videos
    is it possible to share the oracle rac vdi?
    its taking too much time to configure RAC

  • @amandeepgera4109
    @amandeepgera4109 Před 2 lety +3

    Thanks allott...Request you to please create videos on scenarios of Dataguard archive log gap resolution

  • @mayanks6728
    @mayanks6728 Před 2 lety +1

    Thanks ,can we bring down whole cluster both nodes including has with one cmd ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  Před 2 lety +2

      Yes but u need to separately bring down oracle has services.. please check video i have mentioned it in

  • @nishakicooking1236
    @nishakicooking1236 Před 2 lety +1

    sir
    please provide the doc ..which is used in this video .

  • @sinu1241
    @sinu1241 Před 2 lety +1

    Hi Sir.... nice video... I have few doubts
    1) when u stop all cluster, u have specifically stop HAS services, however while starting you have executed only "start crs".... why ? you have not started HAS first
    2) if we execute #start crs, why it is not started the DB ?

    • @OracleDBAOnlineTraining
      @OracleDBAOnlineTraining  Před 2 lety +2

      Thank you for your query
      I believe you are asking me questions related to standalone cluster.
      1) To stop standalone cluster we have to use HAS command crs will fail.
      2) Since I stopped database manually before stopping cluater services... Because of which its not starting db.

  • @pranavjoshi5961
    @pranavjoshi5961 Před 2 lety +1

    Hello ...
    Is it possible to upgrade 19c non cdb database to 21c?

  • @muhammadkamranahmed5713
    @muhammadkamranahmed5713 Před 4 měsĂ­ci

    What is the software name where u open different shells

  • @surajitgupta7987
    @surajitgupta7987 Před 2 lety

    what is the difference between thread and group in redo?

  • @kdnice37
    @kdnice37 Před rokem +1

    Is there a transcript of this tutorial?

  • @prabhugowdruuu432
    @prabhugowdruuu432 Před 2 lety

    I want Oracle rac installation in windows 10 and tutorials bro

  • @amalphilip7699
    @amalphilip7699 Před 2 lety +1

    Can you create psu patch applying tutorials

  • @rafiabbasi1
    @rafiabbasi1 Před 2 lety +1

    what is the website url ?