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: 64729
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: Fri Apr 28 03:57:37 CDT 2017

Total time taken to generate the page: 0.22498 seconds