5 Replies Latest reply: Mar 2, 2011 12:42 PM by user649511 RSS

    Wizard issue with patch 7461070

    user649511
      Version 2.1.8. Attempting step "9-Apply DBA CUP and related patches (Required)" from the "Upg to Rel 12.1.1" category and the step is not finding patch 7461070 even though it has been staged into the EOF_HOME/patches folder. I am not able to download patches automatically from the server, have a seperate thread on that, but since this step won't find the patch even when manually downloaded and staged it will not complete without error. Is this a bug in the Maintenance Wizard? If so, is there a workaround? Thanks!
      .
      From the step log file (Note that it even shows the patch in the 'ls' command after it tries to download it).
      .
      Checking for Download of Patch: 7461070
      ... Checking existence of patch: 7461070 on local node /u01/mwiz/mwizdb/10.2.0/eof/patches
      ... Not found, trying to ftp from updates.oracle.com
      ... About to get patches: 7461070

      Running Download script get_from_url_1704_7461070.sh in /u01/mwiz/mwizdb/10.2.0/eof/patches

      ################################################
      -rw-r--r-- 1 oramwiz dba 6751974 Mar 2 06:09 p7461070_R12_LINUX.zip

      ERROR - Looks like ftp failed, see ls -l p7461070\* (above) of EOF_PATCH_TOP
      EOF_PATCH_TOP=/u01/mwiz/mwizdb/10.2.0/eof/patches
      Log of session: /u01/mwiz/mwizdb/10.2.0/eof/log/INSTANCE_1704/get_from_url_7461070\*.log
      ===================================================================
      1) Have the administrator try running the ftp script manually.
      OR
      2) set HOME/.netrc, then try Script: /u01/mwiz/mwizdb/10.2.0/eof/log/INSTANCE_1704/get_from_url_1704_7461070.sh
        • 1. Re: Wizard issue with patch 7461070
          user649511
          This is very confusing. I turned on DEBUG and reran and it looks like it is buiding the search based on X86-64 bit versions of the patches. This may just be coding logic but strange that it finds the first two GENERIC patches but won't find 7461070. We are a split database configuration where our databases, including the wizard database, are on 64bit but our apps servers are 32bit. Hopefully this configuration is not an issue with the wizard. Any help or suggestions apprciated. Thanks!
          .
          Patches being downloaded from patch list file: patchfile_ad17089s.txt, using Patch Name: patchfile_ad17089s
          From File Patch_List=/u01/mwiz/mwizdb/10.2.0/eof/patches/patchfile_ad17089s.txt

          Checking for Download of Patch: 9179588
          ... Checking existence of patch: 9179588 on local node /u01/mwiz/mwizdb/10.2.0/eof/patches
          Checking locally for patch: /u01/mwiz/mwizdb/10.2.0/eof/patches/p9179588_R12_Linux-x86-64.zip
          OK - appears on local machine - 79016 bytes for this GENERIC type patch.

          Checking for Download of Patch: 9477107
          ... Checking existence of patch: 9477107 on local node /u01/mwiz/mwizdb/10.2.0/eof/patches
          Checking locally for patch: /u01/mwiz/mwizdb/10.2.0/eof/patches/p9477107_R12_Linux-x86-64.zip
          OK - appears on local machine - 38579 bytes for this GENERIC type patch.

          Checking for Download of Patch: 7461070
          ... Checking existence of patch: 7461070 on local node /u01/mwiz/mwizdb/10.2.0/eof/patches
          Checking locally for patch: /u01/mwiz/mwizdb/10.2.0/eof/patches/p7461070_R12_Linux-x86-64.zip
          ... Not found, trying to ftp from updates.oracle.com
          .
          ###########################################################
          #################### Get_Patch_Updates ####################
          ###########################################################
          Patch_Type : R12
          Platname : Linux-x86-64
          Patch_Ext : zip
          P1 : p7461070
          File should be then : p7461070_R12_Linux-x86-64.zip
          DOWNLOADED_FILE :
          NORMAL PATCH detected : 0
          ################################################
          -rw-r--r-- 1 oramwiz dba 6751974 Mar 2 06:09 p7461070_R12_LINUX.zip
          .
          ERROR - Looks like ftp failed, see ls -l p7461070\* (above) of EOF_PATCH_TOP
          EOF_PATCH_TOP=/u01/mwiz/mwizdb/10.2.0/eof/patches
          Log of session: /u01/mwiz/mwizdb/10.2.0/eof/log/INSTANCE_1704/get_from_url_7461070\*.log
          • 2. Re: Wizard issue with patch 7461070
            mybro62-Oracle
            Yes this is a bug. I found the issue in the file ./COMMON/patch_utilities.sh where when setting the platname variable the script cases the return of a remotely executed 'uname' command. There was a case value that then checks for 64 bit but it uses a local 'uname' execution to attempt to determine if it is linux 64 bit. Since it is a local execution it picks up the 64 os on your MW server. Please make the following change to the file ./COMMON/patch_utilities.sh to temporarily work around the issue until the next release of MW 2.19

            case $OS_NAME in
            SunOS) platname=SOLARIS64
            platform_id=23
            ;;
            HP*) ## Based on bug: 5494237
            model=`uname -m`
            if [ "${model}" = "ia64" ]
            then
            platname=HPUX-IA64
            platform_id=197
            else
            platname=HPUX64
            platform_id=58
            fi
            ;;
            AIX) platname=AIX64-5L
            platform_id=212
            ;;
            Windows_NT) platname=WINNT
            platform_id=912
            ;;
            Linux)
            CHECK_64=`uname -a | grep -i "x86_64"`
            if [ "${CHECK_64}" != "" ];then
            platname=Linux-x86-64
            ### NOT SURE ON THIS ON ? MY ARU is not returning 2 linux ones
            platform_id=46
            else
            platname=LINUX
            platform_id=46
            fi
            ;;
            *) echo "WARNING - node: $node not setup for automated patching on this OS ($OS_NAME)."
            ;;
            esac

            to

            case $OS_NAME in
            SunOS) platname=SOLARIS64
            platform_id=23
            ;;
            HP*) ## Based on bug: 5494237
            model=`uname -m`
            if [ "${model}" = "ia64" ]
            then
            platname=HPUX-IA64
            platform_id=197
            else
            platname=HPUX64
            platform_id=58
            fi
            ;;
            AIX) platname=AIX64-5L
            platform_id=212
            ;;
            Windows_NT) platname=WINNT
            platform_id=912
            ;;
            Linux) platname=LINUX
            platform_id=46
            ;;
            *) echo "WARNING - node: $node not setup for automated patching on this OS ($OS_NAME)."
            ;;
            esac

            Edited by: mybro62 on Mar 2, 2011 10:11 AM
            • 3. Re: Wizard issue with patch 7461070
              user649511
              Thanks for the information! I'll give this a try and get back to you. I also have an SR open on this and they are talking with development as well.
              • 4. Re: Wizard issue with patch 7461070
                mybro62-Oracle
                What is the SR number so I can update it please?

                Thanks

                Dave
                • 5. Re: Wizard issue with patch 7461070
                  user649511
                  That worked. Thanks so much, many hours lost on this one. The SR is 3-3092021331 and I had previously noted in it your response and that I was going to try it. I would close it now but can't seem to get to MOS for some reason. Thanks again for the help!!