19c GI Patching - 19c RAC Oracle Home Patching - Database Post Patching Steps - Datapatch

Подписаться 22 тыс.

Просмотров 13 тыс.

50% 1

GI Home patching:
===============
1) Stop GI Home as root user
2) Unlock the GI Home as root user
3) grant permission patch directory as root user
4) As grid user do prechks
Do OPatch version and current lspatches checks
Conflict pre checks:
System space prechk:
5) Apply Patch:
6) Post verification
7) Lock and start GI
DB Home patching
================
Stop DB Home as root user
grant permission on patch directory as root user
As oracle user do prechks
Do OPatch version and current lspatches checks
Conflict pre checks:
System space prechk:
Apply Patch:
Post verification
Start ORACLE_HOME as root user
RAC Database Patching - Datapatch
==============================
Do database prechecks
Run the database post steps - datapatch
Verify the database post steps
#19c #Patching #OPatch #RACPatching #OracleHomePatching #Datapatch #Rolling #12c #Oracle #RAC #Database #Exadata
Please do follow me and support me on,
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@harryfowles5088 3 года назад

Very well done, important not to stop at the 17 minute mark as the subsequent demonstration is very informative and helps to illustrate the previous section.

@Mallik034 3 года назад

That's nice catch. I believe explanation with graphical illustration will help in understanding easily. Glad that it helped you.

@tabrezmohammad1715 3 года назад

Your content is Gold for a DBA👏🏻👏🏻👏🏻👏🏻

@Mallik034 3 года назад

thanks

@steventan5414 2 года назад

Your videos are the best, you answered all my questions regarding this topic. Thank you!!!

@BHARARHROYAL 3 года назад

Much thanks for your valuable session sir.

@Mallik034 3 года назад

Always welcome

@Theeksheth 9 месяцев назад

Thank you so much for the great explanation

@romitacharya 3 года назад

good contents, very practical... Thanks

@Mallik034 3 года назад

You are welcome

@vnaprasad 4 месяца назад

Thank you Bro. Very informative.

@prasaddurgaoli6219 Год назад

Create restore point and take backup of binary is missing other wise it is amazing video

@ramyali9435 2 года назад

Many thanks for your efforts

@sarvarshaikh1600 3 года назад

Thank you so much 🙏

@Mallik034 3 года назад

You're welcome 😊

@rakeshranjankumar7094 2 года назад

Thanks you sir Sir...... You explain steps very well. the ocmrf response file is depricated

@Mallik034 2 года назад

Yes that correct

@seemabankar8116 3 года назад

Really helpful..Thanks for such great video

@barryyoung7099 Год назад

Very Good

@jorgeguerrero9117 3 года назад

Hi, why you dont´use opatchauto instead of opatch ? With opatchauto you can patch in a single command both GI home and DB home and will avoid all the manul steps that you are doing

@Mallik034 3 года назад

opatchauto is really a great tool. You can use that In case if opatchauoto fails at end moment suppose after 99% of patching completed and if it fails then it will rollback everything. opatchauto can to >>> GI patching >>> DB patching >>> datapatch also

@ameetmehta6749 Год назад

Hi , Nice explanation . Really helpful . 1 query While patching on node 1 , DB is fully running on Node 2 correct ? I mean no need to take application downtime? right ? Please let me know

@ameetmehta6749 Год назад

Please reply ..

@sanjeetsony2991 3 года назад

Thanks Mallik, very informative 🙏🙏 , one quick query do we need to run the Datapatch verbose from all the nodes? Or just running it from one node is fine?

@Mallik034 3 года назад

Any one node u can run it. No need to run from all the nodes

@lucian1094 2 года назад

Very nice tutorial, thanks! For 12c I guess that are similar steps. I have to migrate a 12c database, is it correct to install database software on new machines, install patches and after that to restore database with rman? Ty!

@Mallik034 2 года назад

Thats correct

@good123g 9 месяцев назад

sir.when we unlock gi home does it bring down the DBs(instances)on that particular server?

@Mallik034 9 месяцев назад

Yes thats correct

@good123g 9 месяцев назад

@@Mallik034 imagine that there are 2 nodes. Does it apply datapatch verbose during first node or during the second node?

@MrHitchfan 3 года назад

Hi mallik, In the first node we can see 3 diff DB running with diff home. To patch DEV DB using rolling fashion , we can use srvctl stop instance... command right to stop the instance on node 1. Is srvctl stop instance & srvctl stop home same or different in this scenario?

@Mallik034 3 года назад

Yes we can do that. better you can go with srvctl stop home. If only DBs running on that home means it does not matter you can go with whichever way. Other than DB some services and listener are all running on that home means then you have to go with srvctl stop home.

@VinothKumar-hr6ey 3 года назад

Thank you for the detailed session :) Quick question: For Ex: If a DB_HOME1 has 10 databases, here we are using SRVCTL to STOP/START databases in its original state. Usually DATAPATCH to be run in UPGRADE mode, in the above case how we can start DB in UPGRADE and once patch completed later need to start DB to its original state. Can you please suggest

@Mallik034 3 года назад

Only only if you apply OJVM patch then you need to start your database instance in upgrade mode and run the datapatch If you apply PSU you can run the datapatch in open mode.

@Mallik034 3 года назад

You have to set cluster_database parameter to false and start only 1 instance in upgrade mode and run the datapatch. After datapatch set cluster_database parameter back to true and start your database using srvctl

@raghuveer6193 2 года назад

Hi sir , We can opatchauto sir it will apply on both grid and oracle home , ojvm we will separately

@sunilmulage9129 2 года назад

Do we need to apply datapatch for every database in cluster by setting environment Suppose we have multiple databases in 2 node rac

@sinu1241 2 года назад

Hi Malik, Nice content.. can u share me the notepad with all commands for reference ? One quick question, while patching to DB home, do we need to bring down DB or instance only ?

@rakeshranjankumar7094 2 года назад

we need to bring down one instance out of two instance running for the database then we can apply the patch at binary level for one instance then start instance one and then go to second node stop instance second and apply the patch to binary of 2nd instance and then start second instance ,, to apply the patch at database level using datapatch we can apply data patch when both the instance are running and up. Datapatch can be applied to only one instance