Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to list set of installed patchs in sqlplus
- Thread starter Ogzilal
- Start date
Hello,
what exactly are you looking for?
1)The exact version of your Oracle 9.2.0 may be found in view v$version.
2)Interim patches on top of some 9.2.0.X:
I doubt they are stored in the database at all, but not sure about it.
Usually I get this information at operating system level by opatch lsinventory.
Note that opatch usually is not in the oracle/bin directory, but in a directory of its own, named OPatch.
hope this helps
what exactly are you looking for?
1)The exact version of your Oracle 9.2.0 may be found in view v$version.
2)Interim patches on top of some 9.2.0.X:
I doubt they are stored in the database at all, but not sure about it.
Usually I get this information at operating system level by opatch lsinventory.
Note that opatch usually is not in the oracle/bin directory, but in a directory of its own, named OPatch.
hope this helps
- Status
Similar threads
