Home » RDBMS Server » Server Administration » Querying installed bugfixes (10.2.0.4.0 merged 2)
Querying installed bugfixes (10.2.0.4.0 merged 2) [message #406187] Tue, 02 June 2009 14:03 Go to next message
Snikvit
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 (10.2.0.4.0 merged 2) [message #406250 is a reply to message #406187] Wed, 03 June 2009 01:06 Go to previous message
Michel Cadot
Messages: 64117
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.

Regards
Michel
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: Tue Dec 06 04:28:16 CST 2016

Total time taken to generate the page: 0.08323 seconds