Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 08, 2011 at 02:47 PM

    Hi,

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

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Posted on Dec 08, 2011 at 02:51 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Dec 08, 2011 at 03:41 PM

    Hi Gaurav,

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

    Please check my reply in this thread: Problem after implementing SBP 3 for Oracle 11.2.0.2

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.