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

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,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Skype: malluramadurg

[harryfowles]

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.

[tabrezmohammad]

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

[BHARARHROYAL]

Much thanks for your valuable session sir.

[steventan]

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

[Theeksheth]

Thank you so much for the great explanation

[prasaddurgaoli]

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

[romitacharya]

good contents, very practical... Thanks

[rakeshranjankumar]

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

[seemabankar]

Really helpful..Thanks for such great video

[jorgeguerrero]

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

[sanjeetsony]

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?

[MrHitchfan]

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?

[ameetmehta]

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

[VinothKumar-hrey]

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

[goodg]

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

[lucian]

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!

[raghuveer]

Hi sir,

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

[sunilmulage]

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

[kumarvarun]

Is there any way to apply datapatch(OJVM) without downtime like rolling fashion in 3 node rac ??

[sinu]

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 ?