?
Solved

Oracle RDBMS security patch reports

Posted on 2013-01-15
8
Medium Priority
?
466 Views
Last Modified: 2013-01-30
Aside from using costly commercial vulnerability scanners, are there any easy techniques to produce a management friendly report on what security patches are missing from an Oracle 11g database? Or better still to produce a “fully security patched” type assurance report to management.

Could you provide simple steps to get to the report, or direction to a sample report?
Also, excuse my ignorance, but I have heard systems administrators say they often fall behind on database security patches as they are concerned applying the patch could cause issues with the proper functioning of the application, is this a valid concern or a load of nonsense? Have you ever applied a security patch that has had an unfortunate knock on effect on the application that it drives.

Please keep answers simple to a non DBA/management freindly.
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 38778623
>>what security patches are missing from an Oracle 11g database

I don't know of a way to produce a list of missing patches.  Maybe another Expert will know a way.

You can get a list of applied patches with: opatch lsinventory

>>patch could cause issues with the proper functioning of the application

Sadly, this is accurate.  Oracle patches can, and do, introduce new bugs.

I have this same exact 'debate' with our Security folks all the time because I don't patch my databases just because Oracle releases a patch.

They typically back off when I state:  I'll apply whatever patch you direct me to but will not be responsible for what it breaks.

You need to apply Oracle patches in a test environment and test, test ,test.
0
 
LVL 3

Author Comment

by:pma111
ID: 38778647
are the release of security patches pretty common for 11g?

Could you give a rough indication of how many security related patches are released per year?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38778696
You can take a look at:
http://www.oracle.com/technetwork/topics/security/alerts-086861.html

Now the fun:  I'm not sure what Oracle considers a 'Security' patch over a normal patch that might 'fix' a vulnerability.  I've never taken the time to dive into that end of the pool.

Hopefully another Expert will be along soon that can help shed some light on this topic.
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 3

Author Comment

by:pma111
ID: 38778706
Ok, thanks for your help so far though...
0
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 1000 total points
ID: 38778819
>>>You need to apply Oracle patches in a test environment and test, test ,test.
after applying to a production database: pray, pray, pray
and if it does break: patch, patch, patch

every 3 months there is an "planned"  patch.
however any customer can ask for a fix which can lead to a patch.

for the report
> what patch is your database on now ? for example: 11.2.0.3 patch #10 from september
> what patch is the latest for that database version 11.2.0.3 ?
list all of the cve in slightwv's comment:

Security Alert Number And Description       Latest Version/Date
>>>> Alert for CVE-2013-0422       Rev 1, 13 January 2013
Alert for CVE-2012-4681       Rev 1, 30 August 2012
Alert for CVE-2012-3132       Rev 1, 10 August 2012
Alert for CVE-2012-1675       Rev 1, 30 April 2012

The Alert for CVE... describes all the vulnerability problems the databases prior to that version have.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38778838
>>after applying to a production database: pray, pray, pray

I second that statement!

I have had things to beautifully in test only to break once it hits production.  It's impossible to test for everything...

Oracle is famous for rolling out some pretty major rewrites of code in what is considered a minor patchset.

For example from 10.2.0.3 to 10.2.0.4 a TON of their XML stuff was basically new code (which means, basically untested).  Of course, they will never tell you this...
0
 
LVL 3

Author Comment

by:pma111
ID: 38778910
"for the report
> what patch is your database on now ? for example: 11.2.0.3 patch #10 from september
> what patch is the latest for that database version 11.2.0.3 ?"

How can you see "what patch your database is on now?", and "what patch is the latest for that version"?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38778927
>>How can you see "what patch your database is on now?",

re: http:#a38778696

You can get a list of applied patches with: opatch lsinventory

>>and "what patch is the latest for that version"?

The latest alerts and vulnerabilities should be posted on the link I provided in the first post.

For all patches:  The only way I know if is log into Oracle Support and select your database version and platform.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

752 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