Home » RDBMS Server » Server Administration » Querying installed bugfixes ( merged 2)
Querying installed bugfixes ( merged 2) [message #406187] Tue, 02 June 2009 14:03 Go to next message
Messages: 1
Registered: June 2009
Junior Member
Is there a table or view that can be queried to list the installed interim patches (bugfixes)?

I know the opatch lsinventory command will yield this information, but a SQL statement to pull the info from a table would be very convenient.
Re: Querying installed bugfixes ( merged 2) [message #406250 is a reply to message #406187] Wed, 03 June 2009 01:06 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is dba_registry_history but it does not contains all patches, it seems to contain the latest ones but only temporarily and it never contains those apply on binaries before you created the database.

Previous Topic: ORA-01031: insufficient privileges during create pfile from spfile
Next Topic: ORACLE 10.2 not able to start listener (merged 3)
Goto Forum:

Current Time: Wed Oct 26 18:31:29 CDT 2016

Total time taken to generate the page: 0.12695 seconds