6 Replies Latest reply: Feb 20, 2013 12:26 PM by User12614136-Oracle RSS

    Need help with opatch for OBIEE 11g

    479332
      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
          Hi,

          I am facing the same issue while applying a patch, Any idea ??
          • 2. Re: Need help with opatch for OBIEE 11g
            Turribeach
            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
              Hi,

              Any one find any solution to this??
              • 4. Re: Need help with opatch for OBIEE 11g
                771453
                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
                  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-Oracle
                    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.