| Patchset information [message #60053] |
Mon, 12 January 2004 11:32  |
Ray
Messages: 58
Registered: January 2000
|
Member |
|
|
All,
Oracle version = 9.2.0.1, OS = Solaris8
I know that this is a simple question but I have just started in this job and thought I would ask anyway - Is there a command that will tell me what ORACLE patches are loaded? I know that the OS has showrev -p and all but I was wondering if there was something internal. Also, Does anyone know of a way - in metalink, to show all of the latest patches without all of the accompaning text, links, etc. I just am looking for a comparison list of what I have and what I should have. Thanks in advance for any help.
|
|
|
|
|
|
|
|
|
|
| Re: Patchset information [message #60087 is a reply to message #60068] |
Thu, 15 January 2004 03:25  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If you are on 8i, you could run 'owhat oracle' to get the list of patches installed against this kernel. 9i doesnt include owhat, but since its a shell script, which calls Unix's what program, you can copy 'owhat' from 8i installation to the 9i $ORACLE_HOME/bin and still use it.
Other than this, you could use
thiru@9.2.0:SQL>select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release <B>9.2.0.1.0</B> - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
that tells you the Release,major,minor patch numbers.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
