After patch upgrade in 11g Not able to see current patch

[Former Member]

Hi Experts,

After upgrading the patch upgrade through MOPatch from 11.2.0.2.0 to 11.2.0.2.4 , I can see the log as succeeded .

But when I am connecting through sqlplus / as sysdba the version is still showing as 11.2.0.2.0 . Have I missed something I used the readme file README_201111_AIX which is downloaded with this patch.

I have to also add one more fix_control after patch upgrade that means system is reading the right patch. So, Please suggest how to check this .

Thanks in Advance.

[former_member188883 · Accepted solution]

Hi,

Please check the updated version using the command "opatch lsinventory -all "

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak

Yes there I can see the all patches installed but I am not able to figure out 11.2.0.2.4 anywhere as I have applied SBP and I can see thepatches applied on today but not able to see. 11.2.0.2.4 anywhere

Thanks in Advance.

[stefan_koehler]

Hi Gaurav,

we already discussed this topic several times. This is a normal behaviour.

Please check my reply in this thread:

Regards

Stefan

[Former Member]

Hi Stephan ,

Thanks for the reply . It is the normal behaviour thats I want to confirm.

@Deepak :- Thanks for your answer but version showing from the command is 11.2.0.2.0 . From the Stephan link I have got the point its normal behaviour and we can only check it from opatch log.

[Former Member]

Hello, navigate to

/oracle/SID/11202/OPatch directory and

execute

opatch lsinventory | more

You will see lines like this

Oracle Database 11g            11.2.0.2.0
There are 1 products installed in this Oracle Home.

What release you see here? Regards.

[Former Member]

Hi,

My output is :-

Oracle Database 11g 11.2.0.2.0

There are 1 products installed in this Oracle Home.

and also I can see the following that today these much patches installed successfully I am giving some example below :-

Patch 10149919 : applied on Thu Dec 08 05:22:25 EST 2011

Unique Patch ID: 14146533

Created on 3 Oct 2011, 00:42:46 hrs PST8PDT

Bugs fixed:

10149919

This patch overlays patches:

12827726

This patch needs patches:

12827726

as prerequisites

Patch 10188865 : applied on Thu Dec 08 05:22:11 EST 2011

Unique Patch ID: 13551988

Created on 21 Mar 2011, 03:16:39 hrs PST8PDT

Bugs fixed:

10188865

Patch 10190759 : applied on Thu Dec 08 05:21:56 EST 2011

Unique Patch ID: 13109839

Created on 11 Nov 2010, 20:29:55 hrs UTC

Bugs fixed:

10190759

Patch 10243045 : applied on Thu Dec 08 05:21:45 EST 2011

Unique Patch ID: 13169052

Created on 23 Nov 2010, 02:40:01 hrs PST8PDT

Bugs fixed:

10243045

Patch 10357961 : applied on Thu Dec 08 05:21:38 EST 2011

Unique Patch ID: 13814186

Created on 6 Jun 2011, 06:16:52 hrs PST8PDT

Bugs fixed:

10357961

But if the patches applied is 11.2.0.2.0 will not change to 11.2.0.2.4 or it will only change after applying patchset.

Thanks in advance.

[former_member188883]

Hi,

You can view the latest version applied in a file called version.txt which will be present in log folder when you applied the mopatch. It will demonstrate the updated version.

Additionally you can run sql command to check the oracle version

Select * from v$version;

or

select banner from v$version;

Hope this helps.

Regards,

Deepak Kori