Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to know what patches are missing in my Oracle database?

Posted on 2012-03-14
5
Medium Priority
?
367 Views
Last Modified: 2012-08-14
Hello,

Is there any software or script that helps to know what patches are missing in an Oracle database? I'm not talking about what patches are already installed.
Or the only way is reading about all patches releases up today.

O/S: Windows Server 2003
Oracle 10g / 11g

Thanks
0
Comment
Question by:miyahira
  • 2
  • 2
5 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 37722110
Oracle releases quarterly patches that are cumulative.  If you apply the latest of these quarterly patches, you don't need to worry about missing patches.
0
 
LVL 23

Expert Comment

by:David
ID: 37722388
0
 
LVL 1

Author Comment

by:miyahira
ID: 37874226
The 3rd party tools are for Linux, not Windows.
There's no answer valid, please close question.
0
 
LVL 23

Accepted Solution

by:
David earned 2000 total points
ID: 37874335
That's odd.  I rechecked my source and quickly found download links at Tenable for all Windows platforms, 32 or 64 bit, as well as Mac and mobile options.  See at http://www.tenable.com/products/nessus/select-your-operating-system:

Windows XP, 2003, Vista, 2008 & 7 (32 bits):
Nessus-5.0.1-i386.msi (11696 KB)

Windows XP, 2003, Vista, 2008 & 7 (64 bits):
Nessus-5.0.1-x86_64.msi (13027 KB)

Therefore, the answer to your question is "yes".  Hope this helps!
0
 
LVL 1

Author Comment

by:miyahira
ID: 37881833
I dind't check well, that was my fault. Thanks for your help dvz.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question