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: 65144
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: Oracle Shutdown
Next Topic: ORA-01031: insufficient privileges during create pfile from spfile
Goto Forum:

Current Time: Sun Aug 20 21:56:34 CDT 2017

Total time taken to generate the page: 0.08084 seconds