Menu Bar

Tuesday, April 18, 2023

Patching Questions

1) If we find any conflicts in One-Off Patches ? --> We will rollback the patch and get the alternate patch from Oracle and then we will apply it.

2) RAC database patching differences as compared to a single node?

--> https://docs.oracle.com/cd/B16240_01/doc/em.102/e15294/rac.htm

3) Utility to apply patch --> Opatch 

4) Difference b/w PSU and One Off Patches?

5) Prechecks for One Off and Datapatches?

6) Before applying a Patch how do we know if its going to be successfull --> 

   Optach prereq checkconflictagainstOHwithdetails  -ph ./

7) Opatch utility 

8) How to rollback a Oneoff patch or PSU ?

9) What to do if a PDB goes to restricted mode after patching ?

   -->  select * from pdb_plug_in_violations

10) After db upgrade users report login issues / password expired ,-> 

   sqlnet.ora --> allowed logon versions server // client   = 8

No comments:

Post a Comment