Oracle CPU history

I have ran the following queries:

Select * From sys.registry$history

Select * From v$version

The first query seems to be in date order and the last entry back in 2012 as "APPLY" 11.2.0.3"

Likewise the version of v$version shows in PL/SQL release 11.2.0.3.0

My question is, is there anywhere to see a build history for r11 of Oracle database? I.e. a list of database versions per CPU to see how far behind in terms of security it is? for example version 11.2.0.3 seems to relate to the CPU in October 2011?
LVL 4
pma111Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Docteur_ZCommented:
sys.registry$history  gives you the Patch level applied to the DB - at the condition catpatch.sql or catbundle.sql have been run onto your DB.

v$version only gives you the global version of you Oracle DB Engine - without patchset

The most precise way to get your engine version is to use the OS level command opatch - you'll find it in your $ORACLE_HOME/OPatch directory.
For example :
cd $ORACLE_HOME/OPatch
./opatch lsinventory
0
pma111Author Commented:
Thanks... but not sure if some confusion... What I was asking - is there any website or similar to show what the current CPU patchset version is for r11? And ideally a version history showing each version and how it correlates to each CPU. Too see how far behind we are?
0
slightwv (䄆 Netminder) Commented:
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

pma111Author Commented:
Kind of slightwv, but I was hoping the cpu might tie up with a version, i.e similar to this for vmware:

http://www.virten.net/vmware/esxi-release-build-number-history/

I have no idea how up to date or behind we are with the informaiton returned from the query - can you advise?
0
slightwv (䄆 Netminder) Commented:
The CPUs are typically for ALL currently supported versions.

If you want to see release dates based on your current version you will likely have to log into Oracle Support and do a patchset search for your specific version.
0
pma111Author Commented:
Is it not as simple as seeing your build version and being able to see how many cpus are missing?
0
pma111Author Commented:
And do you have to install them all... or will just applying the last cpu make you up to date? Or is the previous cpu and pre req for the latest cpu?
0
slightwv (䄆 Netminder) Commented:
>>And do you have to install them all...

You will need to read the fine print.  Most patchsets are inclusive of all previous patches.  Not sure about CPUs specifically but I think most are.

>>Is it not as simple as seeing your build version and being able to see how many cpus are missing?

Not that I'm aware of.  Many patches do not change the version number.  This is where the lsinventory of OPatch posted above is important.

Some one-off patches are simple file copies so not even OPatch will record them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.