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 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?
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
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.
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?
@@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 .
@@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?
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 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 ?
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.
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
Thank you very much 🙏
Welcome!
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.
Very well explained step by step..Thank you
Thank you for watching our videos
Good information bro
Thank you for your feedback. keep watching keep learning. Subscribe channel if you have not done yet. Have a great learning.
very well explained and easy way to understand.
Thank you for watching our videos
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
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
Thank you and appreciated.
Welcome
Excellent... Explain .. Thanks
You are welcome
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
Awesome explanation....
Thank you for watching our videos
good explaination.
Thank you
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??
very well explained , thanks
Thank you so much
Than you very much, Is it possible to share all the Docs ? it is for my practice purpose . Please let me know,
Great explanation
How can I borrow your notepad file ???
Can you share the doc used in the trainings please
autopatch utility can be done only when we have full downtime..correct?
No downtime required
@@OracleDBAOnlineTraining even in 2 or 3 node setup. ?
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
awesome video, where i get the doc
For Documents please check purchase option on our website
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 /-
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 .
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 😊
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
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,,,why 5 patches for grid?
Thats what oracle provide
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?
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..
Super 💖.
Can you share the document sir
Thank you
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
Can you show us how the backup is taken before patching
Yes I will make video on that topic
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
Opatch auto run ./datapatch automatically ?
Not required..run only if dba_registry_history view not updated
@@OracleDBAOnlineTraining thank u 🙏. You are awesome buddy