4 Replies Latest reply: Feb 6, 2013 12:07 AM by 979524 RSS

    EBS R12 database upgrade to 11gR2

    979524
      Hi All,

      I am in EBS DB upgrade stage to 11.2.03 and following the note:1058763.1

      Please give me a clarity on the below :

      Apply patch 6400501(Conditional) ? My EBS version is 12.1.3 and DB is 10.2.0.4.

      Do I need to apply this patch ? and calrify me the steps

      1 - login ->DB user
      2 - unzip
      3 - cd /patch dir
      4 - opatch apply

      below steps, I think I need to run as applmgr not DB user

      5 - cd $ORACLE_HOME/forms/lib32
      Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
      6 - make -f ins_forms.mk install
      7 - cd $ORACLE_HOME/reports/lib32
      Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
      8 - make -f ins_reports.mk install


      Please help me with proper steps.


      Thanks,
      Kn
        • 1. Re: EBS R12 database upgrade to 11gR2
          EBSDBA
          I am in EBS DB upgrade stage to 11.2.03 and following the note:1058763.1

          Please give me a clarity on the below :

          Apply patch 6400501(Conditional) ? My EBS version is 12.1.3 and DB is 10.2.0.4.

          Do I need to apply this patch ? and calrify me the steps

          1 - login ->DB user
          No, not as DB user but as application owner (applmgr) and apply this patch to 10.1.2 ORACLE_HOME.. (You need to source the environment file from $INST_TOP/ora/10.1.2/<CONTEXT_NAME>.env
          2 - unzip
          Correct
          3 - cd /patch dir
          Correct
          4 - opatch apply
          Correct



          below steps, I think I need to run as applmgr not DB user

          5 - cd $ORACLE_HOME/forms/lib32
          Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
          6 - make -f ins_forms.mk install
          7 - cd $ORACLE_HOME/reports/lib32
          Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
          8 - make -f ins_reports.mk install

          These steps should also be performed on 10.1.2 iAS ORACLE HOME,

          For more information please see

          How to apply Patch 6400501 to a Release 12 APPS-Tier ORACLE_HOME ? [ID 799907.1]

          Thanks
          • 2. Re: EBS R12 database upgrade to 11gR2
            Hussein Sawwan-Oracle
            Apply patch 6400501(Conditional) ? My EBS version is 12.1.3 and DB is 10.2.0.4.

            Do I need to apply this patch ? and calrify me the steps
            If you are on Linux/Unix, then the answer is Yes.
            1 - login ->DB user
            As mentioned above, you need to login as applmgr user.

            You can simply source APPS<CONTEXT_NAME>.env file under $APPL_TOP directory -- http://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120509.htm#F_92659x3Ax20H1x20Head1x3Ax20Environmentx20Settings
            2 - unzip
            3 - cd /patch dir
            4 - opatch apply

            below steps, I think I need to run as applmgr not DB user

            5 - cd $ORACLE_HOME/forms/lib32
            Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
            6 - make -f ins_forms.mk install
            7 - cd $ORACLE_HOME/reports/lib32
            Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
            8 - make -f ins_reports.mk install


            Please help me with proper steps.
            In addition to the doc referenced above by EBSDBA, please see (Error While Applying Post Instructions Steps Of Patch 6400501 (R12) [ID 1107843.1]).

            Thanks,
            Hussein
            • 3. Re: EBS R12 database upgrade to 11gR2
              979524
              Thanks for reply.

              Opatch applied successfully
              cd $ORACLE_HOME/forms/lib
              make -f ins_forms.mk install

              successfully completed


              But I got error while running below commands

              cd $ORACLE_HOME/reports/lib
              make -f ins_reports.mk install


              /usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4'
              /usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4'
              /usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4'
              collect2: ld returned 1 exit status
              make: *** [rwbuilder] Error 1



              Please help me on this.



              Thanks,
              Kn
              • 4. Re: EBS R12 database upgrade to 11gR2
                979524
                Hi ..

                Good news

                Issue resolved after the below steps

                # mv /usr/lib/libXtst.so.6 /usr/lib/libXtst.so.6.ORG
                # ln –s /usr/X11R6/lib/libXtst.so.6 /usr/lib/libXtst.so.6


                Ran again the steps

                cd $ORACLE_HOME/reports/lib
                make -f ins_reports.mk install


                no error.


                Thanks
                Kn