Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.

Status
Not open for further replies.

Livia8

Technical User
Oct 29, 2003
130
IE
Hi,

I've been asked to identify all the cpu (ebs) patches applied to our database.

opatch lsinventory doesn't list them, I've also tried using select * from sys.registry$history but that didn't work either,.

Two more attempts were SELECT * FROM ad_bugs; and SELECT * FROM ad_applied_patches; - the latter seemed to be getting me closer, but I'm not sure I can stand over its output.

Can anyone suggest any other entry I can use?

Many thanks.
 
Why thank you, that's so helpful... :|

I have spent half of the day trawling through the internet and I haven't been able to find what I was looking for, that's why I've posted the question here.

It's the list of patches applied to our database that I need to find, not the list of patches available.

 
Never mind, it seems that SELECT * FROM ad_applied_patches; was what I needed, after all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top