13 Replies Latest reply: Oct 18, 2012 10:25 AM by 911488 RSS

    Opatch auto fail

    911488
      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-Oracle
          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
            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-Oracle
              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
                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-Oracle
                  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-Oracle
                    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
                      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-Oracle
                        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
                          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-Oracle
                            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-Oracle
                              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-Oracle
                                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
                                  Hi,

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

                                  Regards,
                                  Carsten