Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Shouldnt a PSU change the database version?

edited Feb 4, 2010 2:17AM in Database Install/Upgrade/Opatch (MOSC) 8 commentsAnswered
Hello, I've recently decided to change to the oracle Patch Set Update (PSU) method as opposed to just CPU + one-offs as needed.  I had read that when you apply a PSU, you are basically changing your version.  For example applying PSU #3 (january 2010) to a 10.2.0.4 database would make that database '10.2.0.4.3'.  I liked this idea, because I was hoping just a query of V$Version would give you your patch level (as opposed to an 'opatch lsinventory' and a decipering of bug numbers.)

But, when I query my v$version after the patch, it still says 10.2.0.4.0.   When I query my dba_registry, it only shows workspace manager at 10.2.0.4.3  (everything else at 10.2.0.4.0.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center