This discussion is archived
13 Replies Latest reply: Oct 18, 2012 8:25 AM by 911488 RSS

Opatch auto fail

911488 Newbie
Currently Being Moderated
Hi,

ich tried to install the Patch 14275572: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES DB PSU 11.2.0.3.4), but it fails. My scenario is a non shared GI Home, non shared Database home and ACFS will not be used. In the readme, I figured out to do it like this:

Case 1.1.1: ACFS File System Is Not Configured and Database Homes Are Not Shared
Follow these instructions in this section if the GI home is not shared and none of the Oracle database homes is shared.
As root user execute the following command on each node of the cluster:
# opatch auto <UNZIPPED_PATCH_LOCATION> -ocmrf <ocm response file>

Here is what happens:
[root@rac1 grid]# opatch auto /home/grid/patch/ -ocmrf /home/grid/ocm.rsp
Executing /usr/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /home/grid -patchn patch -ocmrf /home/grid/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/app/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-10-18_14-36-44.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
unable to get oracle owner for
Ok, I unzipped the patch into a empty directory.

The opatch logfile tells me:
[18.10.2012 14:36:47]        OPatch invoked as follows: 'query -get_patch_type /home/grid/patch/14275605 -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc '
[18.10.2012 14:36:47]        OUI-67077:
                             Oracle Home       : /u01/app/11.2.0/grid
                             Zentrales Bestandsverzeichnis: /u01/app/oraInventory
                                von           : /u01/app/11.2.0/grid/oraInst.loc
                             OPatch-Version    : 11.2.0.3.0
                             OUI-Version       : 11.2.0.3.0
                             OUI-Speicherort      : /u01/app/11.2.0/grid/oui
                             Speicherort von Log-Datei : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2012-10-18_14-36-47PM_1.log
[18.10.2012 14:36:47]        Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt
[18.10.2012 14:36:47]        /home/grid/patch/14275605/etc/config path does not exist or is not a directory
[18.10.2012 14:36:47]        OUI-67075:Das Patch-Objekt konnte nicht geladen werden. Mögliche Ursachen sind:
                               Der angegebene Pfad ist kein Shiphome für Interim-Patches
                               Metadatendateien fehlen im Patch-Bereich
                               Patch-Verzeichnis = /home/grid/patch/14275605
                               Details = Input metadata files are missing.
[18.10.2012 14:36:47]        Stack-Beschreibung: java.lang.RuntimeException: Patch Location "/home/grid/patch/14275605" doesn't point to a valid patch area.
[18.10.2012 14:36:47]        StackTrace: oracle.opatch.QuerySession.process(QuerySession.java:965)
[18.10.2012 14:36:47]        StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1821)
[18.10.2012 14:36:47]        StackTrace: oracle.opatch.OPatch.main(OPatch.java:583)
I don't know how to proceed, as I followed the Readme step by step. Any hints?

Thanks in advance.
  • 1. Re: Opatch auto fail
    Catalin Trifu Newbie
    Currently Being Moderated
    Where did you unpack the patch ? Did you unpack to /home/grid/patch ?
    Try:

    unzip patch.zip -d <SOME_DIR>
    cd <SOME_DIR>
    # opatch auto -ocmrf <response_file_loc>
  • 2. Re: Opatch auto fail
    911488 Newbie
    Currently Being Moderated
    HI,

    yes, I unzipped it into /home/grid/patch, and I tried your hint, but it doesn't work either.
  • 3. Re: Opatch auto fail
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    maybe you specified the wrong "root" for OPatch.

    OPatch is looking for the following folder: /home/grid/patch/14275605/etc/config

    Can you check if this folder is there?
    If not, can you see etc/config in any other folder below the patch. If yes in which?

    Regards
    Sebastian
  • 4. Re: Opatch auto fail
    911488 Newbie
    Currently Being Moderated
    Hi,

    no, the directory is not there. The structure of the directory is listed below:
    -rw-r--r-- 1 root root         21 12. Okt 09:29 README.txt
    -rw-r--r-- 1 root root        450 12. Okt 09:29 bundle.xml
    drwxrwxr-x 6 root root       4096 12. Okt 09:29 14275605
    drwxr-xr-x 5 root root       4096 12. Okt 09:29 14275572
    -rw-rw-r-- 1 root root     111737 15. Okt 12:13 README.html
    drwxrwxr-x 5 grid oinstall   4096 18. Okt 14:56 ..
    drwxrwxr-x 4 root root       4096 18. Okt 14:56 .
    The patch 14275572 contains two subpatches, on for the Database (14275605), and one for the Grid Infrastructure (14275572). The directory 14275572 contains the following files:
    [grid@rac1 patch]$ ls -lart 14275572
    insgesamt 20
    drwxr-xr-x  4 grid oinstall 4096 12. Okt 09:28 etc
    drwxr-xr-x  4 grid oinstall 4096 12. Okt 09:28 custom
    drwxr-xr-x 17 grid oinstall 4096 12. Okt 09:29 files
    drwxrwxr-x  5 grid oinstall 4096 12. Okt 09:29 .
    drwxrwxr-x  5 grid oinstall 4096 18. Okt 14:56 ..
    The other patch (14275605):
    [grid@rac1 patch]$ ls -lart 14275605
    insgesamt 28
    drwxrwxr-x 4 grid oinstall 4096  4. Apr 2012  13696216
    drwxr-xr-x 4 grid oinstall 4096  4. Apr 2012  13343438
    drwxrwxr-x 4 grid oinstall 4096 13. Jun 09:03 13923374
    drwxrwxr-x 4 grid oinstall 4096  4. Okt 03:38 14275605
    -rwxr-xr-x 1 grid oinstall 2871  4. Okt 03:38 patchmd.xml
    drwxrwxr-x 6 grid oinstall 4096 18. Okt 14:28 .
    drwxrwxr-x 5 grid oinstall 4096 18. Okt 14:56 ..
    Within this directory there is another directory called 14275605, in which the subdirs (files, etc) are available. So I wonder, why the opatch auto command doesn't find it?
  • 5. Re: Opatch auto fail
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    this looks correct. Was the same in 11.2.0.3.3
    Does the oracle and GI user have read access on all files?

    Regards
    Sebastian
  • 6. Re: Opatch auto fail
    Catalin Trifu Newbie
    Currently Being Moderated
    Hi,

    Check the opatch auto log; it is in the directory: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto<DATE>.log

    Regards,
    Catalin
  • 7. Re: Opatch auto fail
    911488 Newbie
    Currently Being Moderated
    Hi,

    on what files? The patch dir, that contains the patches has 777.
    drwxrwxrwx  4 grid oinstall      4096 18. Okt 16:09 patch
    The user grid and the user oracle are both in the oinstall group.

    Edited by: carstenj on Oct 18, 2012 4:22 PM

    I wonder if the command 2opatch auto /home/grid/patch -ocmrf /home/grid/ocm.rsp" is correct, because I don't know how opatch can figure out whats the ORACLE_HOME for the Database installation?!

    Edited by: carstenj on Oct 18, 2012 4:22 PM
  • 8. Re: Opatch auto fail
    Catalin Trifu Newbie
    Currently Being Moderated
    Hi,

    It figures it out by querying the cluster. Just a though: did you set the environment properly before running opatch auto ?
    Read through the opatch auto logfile in GRID_HOME/cfgtoollogs/opatchauto<DATE>.log and see the steps it goes through;
    there has to be some hint to why it's failing. Post some of the log on the forum

    Cheers
  • 9. Re: Opatch auto fail
    911488 Newbie
    Currently Being Moderated
    Hi,

    ah ok, here it is:
    ...
    2012-10-18 16:23:18: Patch type is "legacy_bundle_top"
    2012-10-18 16:23:18: Running as user grid: /u01/app/11.2.0/grid/OPatch/opatch query -get_patch_type /home/grid/patch/14275605 -oh /u01/app/11.2.0/grid
    2012-10-18 16:23:18: s_run_as_user2: Running /bin/su grid -c ' /u01/app/11.2.0/grid/OPatch/opatch query -get_patch_type /home/grid/patch/14275605 -oh /u01/app/11.2.0/grid '
    2012-10-18 16:23:20: Removing file /tmp/filePbD7so
    2012-10-18 16:23:20: Successfully removed file: /tmp/filePbD7so
    2012-10-18 16:23:20: /bin/su exited with rc=0
     75
    2012-10-18 16:23:20: output is
    2012-10-18 16:23:20: Patch type is
    2012-10-18 16:23:20: GI patches are /home/grid/patch/14275572 /home/grid/patch/14275605
    2012-10-18 16:23:20: DB patches are /home/grid/patch/14275572/custom/server/14275572 /home/grid/patch/14275605
    2012-10-18 16:23:20: Running /u01/app/11.2.0/grid/bin/crsctl check cluster -n rac1
    2012-10-18 16:23:20: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl check cluster -n rac1
    2012-10-18 16:23:20: Command output:
    
    **************************************************************
    rac1:
    CRS-4537: Cluster Ready Services is online
    CRS-4529: Cluster Synchronization Services is online
    CRS-4533: Event Manager is online
    **************************************************************
    End Command output
    2012-10-18 16:23:20: Looking for configured databases on node rac1 2012-10-18 16:23:20: Databases configured on node rac1 are: GCRAC 2012-10-18 16:23:20: Determining ORACLE_HOME paths for configured databases 2012-10-18 16:23:20: Executing cmd: /u01/app/11.2.0/grid/bin/srvctl config database -d GCRAC 2012-10-18 16:23:22: Command output:
    Eindeutiger Datenbankname: GCRAC
    Datenbankname: GCRAC
    Oracle-Standardverzeichnis: /u01/app/oracle/product/11.2.0/dbhome_1
    Oracle-Benutzer: oracle
    Spfile: +DATA/GCRAC/spfileGCRAC.ora
    Domain: ****.de
    Startoptionen: open
    Stoppoptionen: immediate
    Datenbankrolle: PRIMARY
    Verwaltungs-Policy: AUTOMATIC
    Server-Pools: GCRAC
    Datenbankinstanzen: GCRAC1,GCRAC2
    Datenträgergruppen: DATA
    Mount Point-Pfade:
    Services:
    Typ: RAC
    Die Datenbank ist administratorverwaltet
    End Command output
    2012-10-18 16:23:22: output is 2012-10-18 16:23:22: Oracle home for database GCRAC is 2012-10-18 16:23:22: Oracle Home  is configured with Database(s)-> GCRAC 2012-10-18 16:23:22: unable to get oracle owner for
    But I can't see whats going wrong.
  • 10. Re: Opatch auto fail
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    can you try setting NLS_LANGUAG to AMERICAN_AMERICA?

    I don't hope so, but I fear that opatch parses an output, and does not expect a German response.

    Regards
    Sebastian
  • 11. Re: Opatch auto fail
    Catalin Trifu Newbie
    Currently Being Moderated
    Hi,

    I believe the problem is you are using german as your locale:

    Datenbankname: GCRAC
    Oracle-Standardverzeichnis: /u01/app/oracle/product/11.2.0/dbhome_1
    Oracle-Benutzer: oracle
    ......
    2012-10-18 16:23:22: output is
    2012-10-18 16:23:22: Oracle home for database GCRAC is
    2012-10-18 16:23:22: Oracle Home is configured with Database(s)-> GCRAC
    2012-10-18 16:23:22: unable to get oracle owner for

    So basically opatch can not determine the ORACLE_HOME. So reset the locale before running opatch and and make sure NLS_LANG is also set to some english variant.

    Cheers,
    Catalin

    Edited by: 848222 on Oct 18, 2012 7:48 AM
  • 12. Re: Opatch auto fail
    Catalin Trifu Newbie
    Currently Being Moderated
    FYI: It is a known issue; check MOS note. OPATCH AUTO Fails with "unable to get oracle owner for" in Multi-Byte Language Environment (Doc ID 1325256.1)
  • 13. Re: Opatch auto fail
    911488 Newbie
    Currently Being Moderated
    Hi,

    thanks to you all, it works now. I didn't find this note.

    Regards,
    Carsten

Legend

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