How to find which latest patch is avaliable in oracle 11g database
Is it write?
In order to find out oracle DB status or patch level — connect to oracle database using sys/system/any db privs user and run below queries.
sql> select *from sys.v$version;
sql> select * from sys.registry$history;
| 11/3/2011 6:38:20.261000 AM | APPLY | SERVER | 11.2.0.3 | 0 | Patchset 11.2.0.2.0 | PSU |
| 12/19/2012 5:59:26.788000 PM | APPLY | SERVER | 11.2.0.3 | 0 | Patchset 11.2.0.2.0 | PSU |
Output is as above,Here is 'Version' filed in that it's shown 11.2.0.3 it's patch version?
Kindly Reply,
Regards,
Sachin