Find out patches applied from OEM

 

You  may have hundreds of servers in your infrastructure.You want to check patches applied on some of the  oracle_home of server.

Do you want to login to each server and run opatch lsinventory command ?

If i want to compare patch levels of couple of databases , do i have to login into each of those servers,run opatch lsinventory and then compare the results using excel etc.. ?

Well OEM grid control makes life easier now .OEM Grid gathers patch level information in different ORACLE_homes.You can also compare configuration between different homes.You can see the query corresponding query as well

I found this very useful when i wanted to compare patches on Dev Vs QA Vs Prod

This is how you do it, Check it out

Login to grid control and choose

Deployments – > Configuration -> Search -> Search Software Installations

Search Oracle Products Installed in Oracle Homes

Go for product oracle database Look for patches interim patches in home

-Pramod for ORASTAR