Home » RDBMS Server » Server Administration » Is oracle patched?
Is oracle patched? [message #63074] Tue, 07 September 2004 09:01 Go to next message
jimbob
Messages: 20
Registered: April 2004
Junior Member
I would like to know what patches I need to apply to my version of oracle 8.1.7.4 on Sun Solaris. Is there a tool that I can use to determine this? Oracle has been running on this box for almost a year and has not been administered. Thank you in advance.

jb

Report message to a moderator

Re: Is oracle patched? [message #63078 is a reply to message #63074] Wed, 08 September 2004 02:08 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try this:
select * from product_component_version;

MHE

Report message to a moderator

Re: Is oracle patched? [message #63079 is a reply to message #63074] Wed, 08 September 2004 02:23 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

By querying product_component_version you will know which version and release you are using. But to check whether interim patches have been applied to your DB, you have to use OPATCH utility which you can easily find at Metalink.

Daljit Signh

Report message to a moderator

Previous Topic: Configuration for 4GT
Next Topic: ora-00604 and ora-04031
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:21:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.