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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 13:28:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.