How to identified the patch applied in Oracle Database

Apply the patch is DBA responsibility and we applied it Quarterly as per our GMB plan based on Oracle release patch. You can identified the patch set applied in your database using Oracle opatch utility which will show you the list of all the bug fixed during patching. Sometimes latest patch conflict with the older patch, in that case you must check all the patches installed to the oracle database using opatch lsinventory.

Using opatch lsinventory


[oracle@dbatrainings ~]$ $ORACLE_HOME/OPatch/opatch lsinventory


You can also able to find details using below command.


[oracle@dbatrainings ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -details

Alternate option login as a sysdba and execute command from the SQL prompt to get the patch detail.


[oracle@dbatrainings ~]$ sqlplus / as sysdba


SQL> set serverout on;


SQL> exec dbms_qopatch.get_sqlpatch_status;


If you want to understand information of particular patch ID you can able to get more details.


SQL> select xmltransform(dbms_qopatch.is_patch_installed(‘29494060’),dbms_qopatch.get_opatch_xslt) “Patch installed?” from dual;


Alternate option you are able to find from registry.


SQL> select * from sys.registry$history;


SQL> select * from sys.dba_registry_sqlpatch;

For More Details, you can reach us using the below link. 

YOUTUBE: HTTPS://WWW.YOUTUBE.COM/DBATRAINING

TELEGRAM APP: HTTPS://T.ME/DBAHELP

WHATSAPP: HTTPS://CHAT.WHATSAPP.COM/EZ2L3S79TXL4PJEIZOYFOA

WEBSITE: HTTP://DBATRAININGS.COM/

EMAIL: INFO@DBATRAININGS.COM

LINKEDIN: HTTPS://WWW.LINKEDIN.COM/IN/DBATRAININGS/

FB PAGE: HTTPS://WWW.FACEBOOK.COM/DBATRAININGS/

FB GROUP: HTTPS://WWW.FACEBOOK.COM/GROUPS/402208687087064/

0 views

ADDRESS :

LOCATION :

701, Linden, Rosalie Complex Khadakpada, Kalyan (W) Mumbai, Maharashtra 421301)

CONTACT US :

+919322846017  &   +919867493019

EMAIL: 

QUICK LINKS :

SUBSCRIBE HERE :

Don’t Miss a Lecture. Subscribe Today. 

telegram-512.png

© 2019 DBA Trainings. Proudly Managed By Pearl Organisation

  • Grey LinkedIn Icon
  • Grey YouTube Icon
  • Grey Twitter Icon
  • Grey Facebook Icon