Oracle RAC Patching Steps - opatchauto apply method || oracle 19c patching
Vložit
- čas přidán 23. 07. 2024
- Learn How to Perform Oracle RAC Patching using opatchauto apply method || oracle patch apply step by step || Oracle 19c Patching step by step guide. Oracle 12c rac patching steps
How to apply latest patches on oracle rac database using opatchauto apply method
In This tutorial I will guide you how to apply latest patches on oracle rac database using opatchauto apply method.
How to download 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 about Oracle DBA Online Training. We cover lots of cool stuff such as Oracle Database architecture, installation, database upgradation, administration, Data Guard, RAC database architecture, goldengate 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 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...
########### 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
6. LG 22 inch (55cm) IPS Monitor - Full HD, IPS Panel with VGA, HDMI, DVI, Audio Out Ports - 22MP68VQ
amzn.to/3vfOnZa
7. Mic Used for Recording this video:
Boya BYM1 Omnidirectional Lavalier Condenser Microphone with 20ft Audio Cable (Black)
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.
Very well explained. What i most liked about this is completely practical. All steps are covered.👍👍
Thank you so much
Hi Sir , we love your long and detailed explanation in video . we love your way of you explain. I never skip advertisement on your video I just mute it and go for refreshment . Thank you a lot sir for all your efforts .
Nice to hear that
Such a nice explanation like always. Very well explained 🙏🙏🙏
Thank you
Very well explained step by step..Thank you
Thank you for watching our videos
Thank you very much 🙏
Welcome!
Thank you and appreciated.
Welcome
very well explained and easy way to understand.
Thank you for watching our videos
Excellent... Explain .. Thanks
You are welcome
very well explained , thanks
Thank you so much
Good information bro
Thank you for your feedback. keep watching keep learning. Subscribe channel if you have not done yet. Have a great learning.
Nice explained but few q in mind 1. how oracle will know my setups location for rdbms and setups for ojvm and setups for grid to install patches you have given only one patch id that is for database only wht abt gird and ojvm 2. Is it runtime? No downtime required then what abt other nodes in rac how they will know that first node patching is done and now we have to start 2nd node.. 3.you copied some commands from youe notepad for necessary checks b4 n after patch can you share us that notead. 4.
Thanks for the video, excellent. How should I do when I have a two-node RAC in production and a two-node contingency RAC with standby database. Does the opatchauto work also when I have three databases in the same RAC?
Yes, it will work if all 3 databases have a common db home
Awesome explanation....
Thank you for watching our videos
Than you very much, Is it possible to share all the Docs ? it is for my practice purpose . Please let me know,
good explaination.
Thank you
Nicely explained. I have followed the Steps and video. I did not find when you have executed the "./datapatch -verbose" command ?
In autopatch method it is automatically done be utility we don't run manually..so u can verify details from dba_registry_sqlpatches
Can you share the doc used in the trainings please
hello sir...one question...if we have 19c grid home and several db on the server with 12c , 18c and 19c home. in 6 node cluster..can we use the same approach? do we need to shutdown first the other db with different version?
Yes u can keep grid on 19c and along with this multiple different versions of database software.
@@OracleDBAOnlineTraining sir i already hv grid with 19c and different version of databases. i want to know while doing parching do i need to shut the instance down which is having different versions .
Cool Stuff ! Nicely explained. I have a question. In your Video you mentioned not to run the datapatch but in your doc you mentioned to run it. Please clarify. ( Is this for completeness sake)
From the DOC I found this below lines for datapatch:==
Once Patching completed run below command from oracle home OPatch path:
./datapatch -verbose
You don't have to run datapatch manually... it will be taken care of by opatchauto utility when u run apply command. Please ignore the command mentioned in my TextPad in the videos.
Sir what if we execute datapatch again ?
U can reexecute
@@OracleDBAOnlineTraining Sir, what’s the db status while patch getting applied on node1??
Great explanation
How can I borrow your notepad file ???
Thanks for sharing knowledge. .
one doubt, do we need take down time for 19c patch or not required. .
means down need to down the Db. .
for Java Patch we need to open in Upgrade mode na, so we need down time or not?
Basically if its single instance db then u will require downtime. But u can avoid downtime by performing switchover. If its RAC patches can be applied in rolling manner
If I wants to use resume, what would be the proprt syntax:
a) opatchauto -apply /path_to_patch resume
Or
b) opatchauto -apply resume
B
autopatch utility can be done only when we have full downtime..correct?
No downtime required
@@OracleDBAOnlineTraining even in 2 or 3 node setup. ?
Hello sir,
Can you please share the document which I can follow to perform this in test environment.
Thank you
All documents are not available freely you need to be get membership
@@OracleDBAOnlineTraining how to get the membership?
You can take membership by clicking join now option
Sir, what’s the db status while patch getting applied on node1??
any update ?
Can you reframe your query
@@OracleDBAOnlineTraining when u execute opatch auto in node1 then db instance & crs on node1 get stopped... but what about the component and db instance status on node 2 ?
Db will be up and running on node 2. I have shown complete details in video
Thanks for the video. Could you please share the doc for this video
If you are interested about documents u can take all documents but its chargeable
@@OracleDBAOnlineTraining how much
For documents its 2500 /-
Can I apply the patch one at a time? (only 1 node are up while the other nodes are down)
Yes
@@OracleDBAOnlineTraining Thank you so much sir.
@@OracleDBAOnlineTraining Sir, when I run /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-08-18_11-11-03AM.log,
I'm having errors like this
OPATCHAUTO-72050: System instance creation failed.
OPATCHAUTO-72050: Failed while retrieving system information.
OPATCHAUTO-72050: Please check log file for more details.
OPatchauto session completed at Thu Aug 18 11:11:19 2022
Time taken to complete the session 0 minute, 25 seconds
should I open my 2nd node?
So here it is not required to verify conflict check and system space check ?
And what permission should be given to patch folder?
777
Always a best practice to do these checks
@@OracleDBAOnlineTraining ok thanks 😊
awesome video, where i get the doc
For Documents please check purchase option on our website
Super 💖.
Can you share the document sir
Thank you
Is there required db down before patching ?
Yes db instance needs to be down before Patching. If it is single instance you have to bring down the database completely, if it is RAC environment then you can bring down instance in rolling manner.
/u01/software/OPatch/opatchauto apply /u01/latestpatch/325**** , so here /u01/latestpatch/325**** is the patch location . but which is this location /u01/software/OPatch/ ? Aware that /u01/software is the grid location. Could you please ans me. i would really appreciate.
/u01/software is grid home and under this OPatch is utility location where opatch utility resides
sir,,,why 5 patches for grid?
Thats what oracle provide
Can you share the steps which are in notepad
Please watch complete video you will get everything u need to know... Have a great learning experience
Can you show us how the backup is taken before patching
Yes I will make video on that topic
The second is up? While we patch the first?
Yes thats called as rolling patch
@@OracleDBAOnlineTraining thank you very much for the reply and fantastic video
Yes
Hi, can you please share the steps as well
Yes I will share the document in sometime
Hi Rajesh, You can download steps from following google drive links:
drive.google.com/file/d/19ntS5kd8jGW9yR-6kDLetGzlSDZSVZB0/view?usp=sharing
please like and share thanks
@@OracleDBAOnlineTraining Thank you so much..
Opatch auto run ./datapatch automatically ?
Not required..run only if dba_registry_history view not updated
@@OracleDBAOnlineTraining thank u 🙏. You are awesome buddy