This discussion is archived
6 Replies Latest reply: Feb 7, 2013 12:00 PM by alvaromiranda RSS

DB PSU patch installation in crs

954934 Newbie
Currently Being Moderated
Hello : I have done crs PSU patch installation before in a Oracle RAC enviroinment. But, if I have to apply rdbms PSU patch to crs, what is the process?

do I need to unlock crs/rdbms ...

Thanks
  • 1. Re: DB PSU patch installation in crs
    P.Forstmann Guru
    Currently Being Moderated
    Normally this is documented in the patch README: did you check instructions for Clusterware (10g) or Grid Infrastructure (11g) ?
  • 2. Re: DB PSU patch installation in crs
    954934 Newbie
    Currently Being Moderated
    it did not have a corresponding crs installation procedure. Also, there are few other patches that are installed in crs, but in the readme it says install in oracle home.
    it is a 11gr2 crs installation.

    Question, is what are the process to install a patch in crs, when it is not listed in the readme... like unlock crs etc
  • 3. Re: DB PSU patch installation in crs
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    the database PSU is normally bundles in the GI PSU. So there is no need to apply the RDBMS PSU to the GI home (only vice versa, there are some GI parts needed in the DB Home, like the srvctl utility).

    So refer to the GI PSU how to install, it should contain all necessary information.

    Regards
    Sebastian
  • 4. Re: DB PSU patch installation in crs
    alvaromiranda Explorer
    Currently Being Moderated
    example, to apply Jan 2013

    as Root

    GI_HOME=/u01/app/11.2.0.3/grid

    #to patch CRS/GI only
    ORACLE_BASE=/u01/app/grid
    ORACLE_HOME=/u01/app/11.2.0.3/grid
    $GI_HOME/OPatch/opatch auto /u01/patch/14727347 -oh $ORACLE_HOME -ocmrf /u01/rsp/ocm.rsp

    #to patch DB only
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

    $GI_HOME/OPatch/opatch auto /u01/patch/14727347 -oh $ORACLE_HOME -ocmrf /u01/rsp/ocm.rsp



    ----

    if you want to patch CRS and DBHOME

    GI_HOME=/u01/app/11.2.0.3/grid
    ORACLE_BASE=/u01/app/grid
    ORACLE_HOME=/u01/app/11.2.0.3/grid
    $GI_HOME/OPatch/opatch auto /u01/patch/14727347 -ocmrf /u01/rsp/ocm.rsp
  • 5. Re: DB PSU patch installation in crs
    954934 Newbie
    Currently Being Moderated
    Hello. Thanks for the responses. One more question.
    I need to apply patch listed below. Since we have 11gr2 clusterware, it looks like this dbms patch will need to be applied to crs oracle home, not database home. Especially, since it is a NET patch, and in 11gr2 listener runs from grid home.

    Oracle Database 11g Release 11.2.0.2.0
    ORACLE NET Patch for Bug# 13843062 for Linux-x86-64 Platforms


    But, in the installation doc, there is not mention of locking crs etc..... is that not needed?
  • 6. Re: DB PSU patch installation in crs
    alvaromiranda Explorer
    Currently Being Moderated
    hello.

    I did downloaded the patch and readme is clear that is only a RDBMS patch.

    Give a try and check if the issue is gone.

    If you have questions, you should ask Oracle SR were they instruct you to apply the patch.

    As a recommendation.

    Test in other system first, some one-off patch cause conflict with CPU/PSU and you need oracle support to generate a new one, or to confirm the patch is included in the CPU/PSU

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points