1 2 Previous Next 22 Replies Latest reply on Jun 21, 2018 11:29 AM by Beauty_and_dBest

    Opatch for 12.0.6 Appstier

    Beauty_and_dBest

      EBS 12.0.6

      10.1.2

      OL6

       

      Hi ALL,

       

      In doc note > Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

       

      We have item

      2.)

      Apply patch 6400501 (conditional)

      If you are on a UNIX/Linux platform, apply the 10.1.0.5 version of Patch 6400501 to the iAS 10.1.2 Applications tier Oracle home.

      Note: For Linux x86-64 environments, download the Linux 32-bit version of the patch as the Applications tier Oracle home is 32-bit.

       

      Is the above patch applicable in 12.0.6 iAS 10.1.2?

       

      I tried running opatch lsinventory to check of patch 6400501 already exist, but I got error

       

      $ opatch lsinventory

       

      Oracle Interim Patch Installer version 1.0.0.0.55

      Copyright (c) 2006 Oracle Corporation. All Rights Reserved..

       

      We recommend you refer to the OPatch documentation under

      OPatch/docs for usage reference. We also recommend using

      the latest OPatch version. For the latest OPatch version

      and other support related issues, please refer to document

      293369.1 which is viewable from metalink.oracle.com

       

      Cannot open the file: /etc/oraInst.loc

      Please use -invPtrLoc option and specify the correct file for OPatch to look for central inventory.

       

      ERROR: OPatch failed because of Inventory problem.

       

      What Opatch version do I install in iAS 10.1.2?

      Why is that out apps still runs even without /etc/oraInst.loc?

      How do I rebuild the oraInventory folder?

      How do I know if patch 6400501 already applied before if the inventory is missing?

       

       

      Please help how to resolve the issue.

       

       

       

      Kind regards,

      jc

        • 1. Re: Opatch for 12.0.6 Appstier
          Beauty_and_dBest

          Hi ALL,

           

          I was able to rebuilt the oraIventory using:

           

          ./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2" ORACLE_HOME_NAME="PPAPROD_IAS_apps_tech_st_10_1_2"

           

           

          Then I check patch 6400501 and it is not existing.

           

          So I applied it as below, but I encountered error

           

          [applmgr@oraapps-1 6400501]$ opatch apply

           

          Oracle Interim Patch Installer version 1.0.0.0.55

          Copyright (c) 2006 Oracle Corporation. All Rights Reserved..

           

          We recommend you refer to the OPatch documentation under

          OPatch/docs for usage reference. We also recommend using

          the latest OPatch version. For the latest OPatch version

          and other support related issues, please refer to document

          293369.1 which is viewable from metalink.oracle.com

           

          Oracle Home = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2

          Location of Oracle Universal Installer components = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/oui

          Location of OraInstaller.jar  = "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/oui/jlib"

          Oracle Universal Installer shared library = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so

          Location of Oracle Inventory Pointer = /etc/oraInst.loc

          Location of Oracle Inventory = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/inventory

          Path to Java = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/jre/1.4.2/bin/java

          Log file = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

           

          Creating log file "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/.patch_storage/6400501/Apply_6400501_06-11-2018_13-01-42.log"

           

          Invoking fuser to check for active processes.

           

          Invoking fuser on "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/wrap"

          Skipping invocation of fuser on "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/oracle" as the file does not exist or is a directory.

          Invoking fuser on "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/proc"

          Invoking fuser on "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/rman"

          Skipping invocation of fuser on "/mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/extproc" as the file does not exist or is a directory.

          Backing up comps.xml ...

           

          OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

           

           

          Please shut down Oracle instances running out of this ORACLE_HOME

          (Oracle Home = /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2)

          Is this system ready for updating?

          Please respond Y|N >

          Y

          Applying patch 6400501...

           

          Patching archive files...

           

          Running make for target iwrap.

           

          OPatch found the word "error" in stderr, please look into it.

          You may have to run the make again.

          Stderr Output (from /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/.patch_storage/6400501/make_local.stderr):

          /usr/lib/gcc/x86_64-redhat-linux/4.4.7/32/libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4'

           

          collect2: ld returned 1 exit status

           

          make: *** [wrap] Error 1

           

          Make failed.  If you continue, you will have to run make manually on the local system.

          Replying 'Y' will terminate the patch installation immediately. It WILL NOT restore any updates that have been performed to this point. It WILL NOT update the inventory.

          Replying 'N' will continue with additional make operations and update the inventory showing the patch has been applied.

          NOTE: After replying either 'Y' or 'N' it is critical to review:

                Metalink Note 312767.1 How to rollback a failed Interim patch installation.

           

          Do you want to STOP?

          Please respond Y|N >

          Y

          Local make failed.  See log file for details.

           

          ERROR: OPatch failed as make operation did not succeed

          [applmgr@oraapps-1 6400501]$

           

           

          Please help how to fix above errors.

           

           

          Kind regards,

          jc

          • 2. Re: Opatch for 12.0.6 Appstier
            mdtaylor

            Hi jc,

             

            Please ensure you have done these steps in the 10.1.2 and 10.1.3 homes:

             

            Update AS 10g (10.1.2 and 10.1.3) Oracle Homes (Oracle Linux 6, RHEL 6, Oracle Linux 7 and RHEL 7 only)

             

            After installation, users must update the stub libraries in the 10.1.2 and 10.1.3 Oracle Homes using the patch 12415211. In following the instructions below, please note that Opatch should not be used to install this patch.

             

            unlink /usr/lib/libXtst.so.6

            ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

             

            Oracle Forms Upgrade to 10.1.2.3 fails with error /usr/lib/libXtst.so.6: undefined reference (Doc ID 1120527.1)

             

            Users must specifically copy the files in the patch to the specified directories as follows for the 10.1.2 Oracle Home:

             

            $ cd /lv01/oracle/prod/apps/tech_st/10.1.2/lib

            $ cp -p -R stubs stubsORIG

            $ cd stubs

            $ cp /stage/software/12.2.2/10.1.2.3/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .

            $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

            $ ln -s libgcc_s.so.1 libgcc_s.so

             

            After this is done and sourcing the APPS<CONTEXT_NAME>.env file, users should relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.

             

            The instructions for the 10.1.3 Oracle Home are:

             

            $ cd /lv01/oracle/prod/apps/tech_st/10.1.3/lib

            $ cp -p -R stubs stubsORIG

            $ cd stubs

            $ cp /stage/software/12.2.2/10.1.2.3/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .

            $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

            $ ln -s libgcc_s.so.1 libgcc_s.so

             

            After this, users should relink sqlplus by running the <INSTALL_DIR>/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh script and ensuring that there are now no errors in the make log file output from the script.

             

            Regards,

            Michael

            • 3. Re: Opatch for 12.0.6 Appstier
              Beauty_and_dBest

              Thanks Michael,

               

              The process is so complicated, I can not comprehend well

               

              Can you please give specific steps to do firstly?

               

              Can you confirm my understanding?

               

              1. First thing to do is install patch 12415211  <<< This is using opatch apply right?

               

              I can not understand which patch will not use opatch apply

               

              The steps of installing above patch are :

               

              1.1

              =============

              unlink /usr/lib/libXtst.so.6

              ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

               

              1.2

              =============

              $ cd /lv01/oracle/prod/apps/tech_st/10.1.2/lib

              $ cp -p -R stubs stubsORIG

              $ cd stubs

              $ cp /stage/software/12.2.2/10.1.2.3/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .

              $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

              $ ln -s libgcc_s.so.1 libgcc_s.so

               

              After this is done and sourcing the APPS<CONTEXT_NAME>.env file, users should relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.

               

              1.3

              =============

              $ cd /lv01/oracle/prod/apps/tech_st/10.1.2/lib

              $ cp -p -R stubs stubsORIG

              $ cd stubs

              $ cp /stage/software/12.2.2/10.1.2.3/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .

              $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

              $ ln -s libgcc_s.so.1 libgcc_s.so

               

              After this, users should relink sqlplus by running the <INSTALL_DIR>/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh script and ensuring that there are now no errors in the make log file output from the script.

               

               

               

              After running above, what I am gonna do with patch 6400501? Since I have aborted it

               

               

              Kind regards,

              • 4. Re: Opatch for 12.0.6 Appstier
                Magnanimous

                Yes, please do apply the patch once the above steps are done.

                 

                Prashant

                • 5. Re: Opatch for 12.0.6 Appstier
                  Beauty_and_dBest

                  Hi ALL,

                   

                  I finished 1.1 and 1.2  then I run >> $ORACLE_HOME/appsutil/clone/adlnktools.sh

                   

                  But I got error:

                   

                  ar d /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libdeb.a `cat newlist`
                  for libs in /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libde.so.0 /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libdeb.so.0 ; do \
                              /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/genshlib $libs; \
                      done
                  deaac.o: could not read symbols: File in wrong format
                  genshlib: error: /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib/libde.so.0 not made
                  deaac.o: could not read symbols: File in wrong format
                  genshlib: error: /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib/libdeb.so.0 not made
                  make: *** [sharedlibs] Error 1
                  Failed linking targets sharedlibs on Tue Jun 12 00:30:14 +08 2018...

                  • 6. Re: Opatch for 12.0.6 Appstier
                    mdtaylor

                    Hi jc,

                     

                    Did you apply the following patch with opatch?

                     

                    Patch 12415211 10.1.2 HOME RELINKING FAILED WITH UNDEFINED REFERENCE ERROR ON ORACLE LINUX 6

                    https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=12415211

                     

                    It should have been applied with the steps from 1.2.

                     

                    Regards,

                    Michael

                    • 7. Re: Opatch for 12.0.6 Appstier
                      Beauty_and_dBest

                      Thanks Michael and Prasant,

                       

                      This is a new clone instance from Ubuntu5 to OL6.

                      But the main issue is the main adadmin relinking programs failed, so it followed all patches to be applied will fail as well

                      This is maybe the main issue? >> EBS 12.0.6 Relink error

                       

                       

                      Please help...

                       

                       

                      Kind regards,

                      • 8. Re: Opatch for 12.0.6 Appstier
                        EkOnkarr-Oracle

                        Hi,

                         

                        Please review the below Note:

                         

                        OPatch Error: libgcc_s.so: undefined reference to '__stack_chk_fail@GLIBC_2.4' While Applying Patch 19434967: MERGE REQUEST ON TOP OF 10.1.2.3.2PSU (Doc ID 2145703.1)

                         

                        Regards,

                        Onkar

                        • 9. Re: Opatch for 12.0.6 Appstier
                          Beauty_and_dBest

                          Hi Micheal,

                           

                          Did you apply the following patch with opatch?>> No

                          I just follow steps 1.2.

                           

                          Please help, with the relink error, many libraries in 10.1.2/lib are missing

                           

                           

                          Thanks,

                          • 10. Re: Opatch for 12.0.6 Appstier
                            Beauty_and_dBest

                            Thanks Onkar,

                             

                            The solution is the same with what Michael had provided

                             

                            1. cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.2/lib

                            2. cp -p -R stubs stubsORIG

                            3. cd stubs

                            4. cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so.

                            5. ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

                            6. ln -s libgcc_s.so.1 libgcc_s.so

                            7. Try reapplying the patch.

                             

                            $ cd /lv01/oracle/prod/apps/tech_st/10.1.2/lib

                            $ cp -p -R stubs stubsORIG

                            $ cd stubs

                            $ cp /stage/software/12.2.2/10.1.2.3/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .

                            $ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1

                            $ ln -s libgcc_s.so.1 libgcc_s.so

                             

                            I already tried this but I got error missing libraries

                             

                            /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libdeb.a `cat newlist`
                            for libs in /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libde.so.0 /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib//libdeb.so.0 ; do \
                                        /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/bin/genshlib $libs; \
                                done
                            deaac.o: could not read symbols: File in wrong format
                            genshlib: error: /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib/libde.so.0 not made
                            deaac.o: could not read symbols: File in wrong format
                            genshlib: error: /mnt/data/u01/oracle/PPAPROD/apps/tech_st/10.1.2/lib/libdeb.so.0 not made
                            make: *** [sharedlibs] Error 1
                            Failed linking targets sharedlibs on Tue Jun 12 00:30:14 +08 2018...

                             

                             

                            I have lots of missing file like libde.so.0 

                            $ ls -l libde*
                            -rwxr-xr-x 1 applmgr oinstall 2891840 Mar 25 12:56 libde.a
                            -rw-rw-r-- 1 applmgr oinstall 1859486 Jun 12 01:01 libdeb.a
                            lrwxrwxrwx 1 applmgr oinstall      11 May 18 12:19 libdeb.so -> libdeb.so.0
                            lrwxrwxrwx 1 applmgr oinstall      10 May 18 12:19 libde.so -> libde.so.0

                             

                            $ ls -l $FND_TOP/lib/libfnd.a

                            ls: cannot access /mnt/data/u01/oracle/PPAPROD/apps/apps_st/appl/fnd/12.0.0/lib/libfnd.a: No such file or directory

                             

                            Can I copy this from my 12.1.3 instance?

                             

                            Kind regards,

                            • 11. Re: Opatch for 12.0.6 Appstier
                              Magnanimous

                              Hello JC,

                               

                              I would suggest please copy libfnd.a and other missing files from the source instance.

                               

                              Prashant

                              • 12. Re: Opatch for 12.0.6 Appstier
                                Magnanimous

                                Please check the RPM as suggested in mos - 2057857.1

                                • 13. Re: Opatch for 12.0.6 Appstier
                                  Beauty_and_dBest

                                  Thanks Prasant,

                                   

                                  Can I copy $FND_TOP/lib/libfnd.a from the source Centos 6.9?

                                  Are there other ways to rebuild it?

                                  Is doc 2057857.1  applicable to Centos as source instance?

                                   

                                   

                                  Kind regards,

                                  • 14. Re: Opatch for 12.0.6 Appstier
                                    mdtaylor

                                    Hi jc,

                                     

                                    The unlink and soft link steps I provided earlier should resolve this latest issue with libdeb.so and libdeb.so.

                                     

                                    Concurrent Processing - Reports Using RWRUN Fail on Shared Library : libde.so.0 after Upgrade to Linux 5 (Doc ID 1087151.1)

                                     

                                    Once 10.1.2 relinks properly, try to relink from adadmin and see if the .a files get generated.  If not, copy again from the source.

                                     

                                    Regards,

                                    Michael

                                    1 2 Previous Next