This discussion is archived
6 Replies Latest reply: Feb 20, 2013 10:26 AM by user12614136 RSS

Need help with opatch for OBIEE 11g

479332 Newbie
Currently Being Moderated
I'm running into some more of Oracle's typical gibberish and poorly written documentation, and need some help patching OBIEE 11g.

I'm TRYING to follow the instructions here:
https://updates.oracle.com/Orion/Services/download?type=readme&aru=13160647

So, let's see. How about step 2:

For FMW Opatch usage, please refer the doc at :
http://www.oracle.com/technology/software/products/ias/files/fmw_opatch.htm

Well, that IP address automatically redirects to the general download page:
http://www.oracle.com/technetwork/indexes/downloads/index.html

Nice.

So, let's try this doc:
http://docs.tpu.ru/docs/oracle/en/owl/E14571_01/doc.1111/e16793/opatch.htm#CBHDEGBJ

Section 2.3.2, "Patching a Fusion Middleware Product"

Quoting: "Once you obtain the patch, determine the Oracle home directory to which you are going to apply the patch....If you do not know the name of your Oracle home, you should run the opatch lshomes command as described in Section 2.4.6, "Listing the Applicable Oracle Homes for a Patch" to obtain a list of Oracle homes that pertain to the domain."

So let's see, I've got two OPATCH.BAT files, one in c:\mw_home1\Oracle_BI1=OPatch\, and the other in c:\mw_home1\oracle_common\OPatch\.

I open a command window, CD to one of those paths, and run opatch lshomes. I get this error:
"The Oracle Home C:\mw_home1 is not OUI based home. Please give proper Oracle Home. OPatch returns with error code = 1. OPatch failed with error code = 1"

Same results for the other opatch.bat in the other directory.

Besides the atrocious grammar, this error message is not helpful in the least. I'm trying to patch OBIEE 11g, which is installed in c:\mw_home1. What else is opatch wanting?
  • 1. Re: Need help with opatch for OBIEE 11g
    842814 Newbie
    Currently Being Moderated
    Hi,

    I am facing the same issue while applying a patch, Any idea ??
  • 2. Re: Need help with opatch for OBIEE 11g
    Turribeach Guru
    Currently Being Moderated
    I would think the ORACLE_HOME variable is not set?

    PS: Whoever coded that error message needs to learn some english...
  • 3. Re: Need help with opatch for OBIEE 11g
    844744 Newbie
    Currently Being Moderated
    Hi,

    Any one find any solution to this??
  • 4. Re: Need help with opatch for OBIEE 11g
    771453 Newbie
    Currently Being Moderated
    Hi,

    Please run this command in a DOS window: "set ORACLE_HOME=E:\Oracle\Middleware\Oracle_BI"

    This changes your Oracle Home to you BI installation folder. Change the above mentioned path according to your installation. To see if this worked run the following command in the Opatch folder: "opatch version"

    If it shows something like this:

    "Invoking OPatch 11.1.0.8.0

    OPatch Version: 11.1.0.8.0

    OPatch succeeded."

    ...it means you are ready to start patching. :)

    Regards,
    Jaime
  • 5. Re: Need help with opatch for OBIEE 11g
    634277 Newbie
    Currently Being Moderated
    Sorry -- posted a reply to the wrong thread. Thanks.

    Edited by: OBI Wan on Feb 21, 2012 5:22 PM
  • 6. Re: Need help with opatch for OBIEE 11g
    user12614136 Newbie
    Currently Being Moderated
    Yes, the error message is misleading. It should say something like "Environment variable ORALCE_HOME has not been set or set incorrectly".

    Here is how I solved the problem on a Windows Oracle Fusion Middleware SOA installation. The SOA installation already comes with OPatch installed. In my case it is located in D:\Oracle\Middleware\Oracle_SOA1\OPatch. On a command prompt, I set the environment variable ORACLE_HOME like this

    set ORACLE_HOME=D:\Oracle\Middleware\Oracle_SOA1

    and the CLASSPATH variable like this

    set classpath=

    The latter prevents opatch from loading classes it does not need and throwing java.lang.ClassNotFoundException. Also notice ORACLE_HOME does not point to D:\Oracle\Middleware but D:\Oracle\Middleware\Oracle_SOA1. I made a mistake by setting ORACLE_HOME to D:\Oracle\Middleware kept getting:

    "Recommended actions: Please make sure no other OPatch or OUI processes is running. Try to run $ORACLE_HOME/oui/bin/runInstsaller.

    OPatch failed with error code = 20"

    I wasted a lot of time trying to figure out what went wrong.

Legend

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