1 2 3 Previous Next 173 Replies Latest reply: May 30, 2013 12:07 PM by Hussein Sawwan-Oracle Branched to a new discussion. RSS

    Upgrading  ebs 11i to r12 12.1.1 on Suse

    user10994730
      HRMS application EBS 11.5.10.2 to 12.1.1
      SUSE
      db 11.2.0.3

      Hi Hussein,

      Thread I was communicating with under "$AD_TOP/bin/admsi.pl" subject.
      I am going to recap everything and put it here.

      Basicall we wer not able to use admrfpch utility to merger following patches.

      . Merge this patch (9179588:R12.AD.B) with 9477107:R12.AD.B and R12.AD.B.1
      (patch 7461070).
      Note: This merge should be a full merge using -admode


      and asked if we have all the rpms.


      hmf-hrm-001:~ # rpm -qa binutils*
      binutils-2.21.1-0.9.2
      rpm -qa compat*
      compat-32bit-2009.1.19-2.1
      rpm -qa libstdc*
      libstdc++-devel-4.3-62.198
      libstdc++46-4.6.1_20110701-0.13.9
      libstdc++46-32bit-4.6.1_20110701-0.13.9
      libstdc++33-3.3.3-11.9
      libstdc++33-32bit-3.3.3-11.9
      libstdc++43-devel-4.3.4_20091019-0.22.17
      rpm -qa gcc*
      gcc-info-4.3-62.198
      gcc-locale-4.3-62.198
      gcc43-4.3.4_20091019-0.22.17
      gcc43-32bit-4.3.4_20091019-0.22.17
      gcc43-c++-4.3.4_20091019-0.22.17
      gcc-32bit-4.3-62.198
      gcc43-locale-4.3.4_20091019-0.22.17
      gcc-c++-4.3-62.198
      gcc43-info-4.3.4_20091019-0.22.17
      gcc-4.3-62.198
      gcc_old-2.95.3-175.2
      rpm -qa glibc*
      glibc-locale-32bit-2.11.3-17.43.1
      glibc-devel-32bit-2.11.3-17.43.1
      glibc-32bit-2.11.3-17.43.1
      glibc-locale-2.11.3-17.43.1
      glibc-info-2.11.3-17.43.1
      glibc-2.11.3-17.43.1
      glibc-i18ndata-2.11.3-17.43.1
      glibc-devel-2.11.3-17.43.1
      rpm -qa krb5*
      krb5-1.6.3-133.48.48.1
      krb5-32bit-1.6.3-133.48.48.1
      krb5-client-1.6.3-133.48.48.1
      rpm -qa libai*
      libaio-devel-32bit-0.3.109-0.1.46
      libaio-devel-0.3.109-0.1.46
      libaio-32bit-0.3.109-0.1.46
      libaio-0.3.109-0.1.46
      rpm -qa libcom*
      libcom_err2-32bit-1.41.9-2.9.1
      libcom_err2-1.41.9-2.9.1
      rpm -qa libgcc*
      libgcc46-4.6.1_20110701-0.13.9
      libgcc46-32bit-4.6.1_20110701-0.13.9
      rpm -qa libstdc*
      libstdc++-devel-4.3-62.198
      libstdc++46-4.6.1_20110701-0.13.9
      libstdc++46-32bit-4.6.1_20110701-0.13.9
      libstdc++33-3.3.3-11.9
      libstdc++33-32bit-3.3.3-11.9
      libstdc++43-devel-4.3.4_20091019-0.22.17
      rpm -qa make*
      make-3.81-128.20
      makedumpfile-1.4.4-0.7.1
      rpm -qa openmotif*
      openmotif21-libs-2.1.30MLI4-123.1

      rpm -qa unzip*
      unzip-5.52-16.6

      Missing ones are (db1-32bit-1.85-225.22 and linux32-1.0-475.14)

      then

      rpm -Uvh db1-32bit-1.85-225.22.x86_64.rpm
      Preparing... ########################################### [100%]
      1:db1-32bit ########################################### [100%]
      hmf-hrm-001:/tmp # rpm -q db1-32bit-1.85-225.22.x86_64
      db1-32bit-1.85-225.22


      rpm -Uvh linux32-1.0-475.14.x86_64.rpm
      Preparing... ########################################### [100%]
      file /usr/bin/linux32 from install of linux32-1.0-475.14.x86_64 conflicts with file from package util-linux-2.19.1-6.33.35.1.x86_64
      file /usr/bin/linux64 from install of linux32-1.0-475.14.x86_64 conflicts with file from package util-linux-2.19.1-6.33.35.1.x86_64

      Installed rpm after uninstalling conflicting package.

      oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $ORACLE_HOME
      /data/rel12/apps/tech_st/10.1.2
      oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $LD_LIBRARY_PATH
      /data/rel12/apps/tech_st/10.1.2/lib
      oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> ./admrgpch -s /data/oracle/r12 -admode -d /data/oracle/r12/merge_patch/
      ./admrgpch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
      oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin>


      this is where I am now.

      oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> ./genclntsh
      /usr/bin/ld: i386:x86-64 architecture of input file `/data/rel12/apps/tech_st/10.1.2/lib/libn10.a(nnfgt.o)' is incompatible with i386 output
      /usr/bin/ld: i386:x86-64 architecture of input file `/data/rel12/apps/tech_st/10.1.2/lib/libn10.a(ntcontab.o)' is incompatible with i386 output
      collect2: ld returned 1 exit status
        • 1. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
          EBSDBA
          Hi,

          Please make sure you sourced the correct environment file.

          please post the output of

          which adpatch
          which admrgpch

          Thanks
          • 2. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
            user10994730
            oracle@hmf-hrm-001:~> cd /data/rel12/apps/apps_st/appl/ad/12.0.0/bin
            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> cd ../../../oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> . APPSLNXRES_hmf-hrm-001.env
            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> cd -
            /data/rel12/apps/apps_st/appl/ad/12.0.0/bin
            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $ORACLE_HOME
            /data/rel12/apps/tech_st/10.1.2
            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $LD_LIBRARY_PATH
            /data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/data/rel12/apps/apps_st/appl/cz/12.0.0/bin:/data/rel12/apps/tech_st/10.1.2/lib32:/data/rel12/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/data/rel12/apps/apps_st/appl/sht/12.0.0/lib
            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> ./admrgpch -s /data/oracle/r12 -admode -d /data/oracle/r12/merge_patch/
            ./admrgpch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> which adpatch
            /data/rel12/apps/apps_st/appl/ad/12.0.0/bin/adpatch
            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> which admrgpch
            /data/rel12/apps/apps_st/appl/ad/12.0.0/bin/admrgpch
            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin
            • 3. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
              Hussein Sawwan-Oracle
              oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> which admrgpch
              /data/rel12/apps/apps_st/appl/ad/12.0.0/bin/admrgpch
              oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin
              Can you please relink this executable file using this command? --> adrelink.sh force=y "ad admrgpch"

              Thanks,
              Hussein
              • 4. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                user10994730
                oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> adrelink.sh force=y "ad admrgpch"
                **********************************************************
                You are running adrelink, version 120.43

                Start of adrelink session
                Date/time is Thu Feb 14 12:03:33 EST 2013
                Log file is /data/rel12/apps/apps_st/appl/admin/log/adrelink.log
                Command line arguments are
                "force=y" "ad admrgpch"

                sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
                adrelink: Unable to determine RDBMS version

                adrelink is exiting with status 1

                End of adrelink session
                Date/time is Thu Feb 14 12:03:33 EST 2013
                **********************************************************

                Line-wrapping log file for readability ...

                Done line-wrapping log file.

                Original copy is /data/rel12/apps/apps_st/appl/admin/log/adrelink.lsv
                New copy is /data/rel12/apps/apps_st/appl/admin/log/adrelink.log

                oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin
                • 5. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                  EBSDBA
                  user10994730 wrote:
                  oracle@hmf-hrm-001:~> cd /data/rel12/apps/apps_st/appl/ad/12.0.0/bin
                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> cd ../../../oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> . APPSLNXRES_hmf-hrm-001.env
                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> cd -
                  /data/rel12/apps/apps_st/appl/ad/12.0.0/bin
                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $ORACLE_HOME
                  /data/rel12/apps/tech_st/10.1.2
                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> echo $LD_LIBRARY_PATH
                  /data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/data/rel12/apps/apps_st/appl/cz/12.0.0/bin:/data/rel12/apps/tech_st/10.1.2/lib32:/data/rel12/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/data/rel12/apps/apps_st/appl/sht/12.0.0/lib
                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/ad/12.0.0/bin> ./admrgpch -s /data/oracle/r12 -admode -d /data/oracle/r12/merge_patch/
                  Your source and destination directories must be under same directory.
                  so change the command to


                  admrgpch -s /data/oracle/r12 -d /data/oracle/r12/ -admode

                  ./admrgpch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

                  oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> which adpatch
                  /data/rel12/apps/apps_st/appl/ad/12.0.0/bin/adpatch
                  oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin> which admrgpch
                  /data/rel12/apps/apps_st/appl/ad/12.0.0/bin/admrgpch
                  oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/bin
                  Do you see this file under $ORACLE_HOME/lib/libcln*

                  Thanks
                  • 6. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                    user10994730
                    oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib> ls -lt libclntsh*
                    lrwxrwxrwx 1 oracle dba 17 Feb 12 14:05 libclntsh.so -> libclntsh.so.10.1
                    oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib>
                    • 7. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                      Hussein Sawwan-Oracle
                      sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
                      adrelink: Unable to determine RDBMS version
                      Are you sourcing the correct env file? Please issue "env" command to verify -- adpatch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file [ID 943005.1]

                      Please also see (Cloning EBS from Linux 4 to Linux 5 Fails: "Error While Loading Shared Libraries: libclntsh.so.10.1" [ID 736410.1]).

                      Thanks,
                      Hussein
                      • 8. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                        EBSDBA
                        user10994730 wrote:
                        oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib> ls -lt libclntsh*
                        lrwxrwxrwx 1 oracle dba 17 Feb 12 14:05 libclntsh.so -> libclntsh.so.10.1
                        oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib>
                        This shows the libclntsh.so.10.1 file is missing. so please make sure all the packages are installed.

                        Now that Mr.Hussein has come, i can not reply any where close to his speed and i dont want to give same reply. So i am loggin out ;)

                        Thanks
                        • 9. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                          user10994730
                          Thanks Hussein,

                          Emailed you output of env.


                          thanks
                          • 10. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                            Hussein Sawwan-Oracle
                            This shows the libclntsh.so.10.1 file is missing. so please make sure all the packages are installed.

                            Now that Mr.Hussein has come, i can not reply any where close to his speed and i dont want to give same reply. So i am loggin out ;)

                            Thanks
                            I disagree -- Please stay :)

                            Thanks,
                            Hussein
                            • 11. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                              user10994730
                              oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib> rpm -qa | grep gcc-*
                              libgcc46-4.6.1_20110701-0.13.9
                              gcc-info-4.3-62.198
                              gcc-locale-4.3-62.198
                              gcc43-4.3.4_20091019-0.22.17
                              gcc43-32bit-4.3.4_20091019-0.22.17
                              libgcc46-32bit-4.6.1_20110701-0.13.9
                              gcc43-c++-4.3.4_20091019-0.22.17
                              gcc-32bit-4.3-62.198
                              gcc43-locale-4.3.4_20091019-0.22.17
                              gcc-c++-4.3-62.198
                              gcc43-info-4.3.4_20091019-0.22.17
                              gcc-4.3-62.198
                              gcc_old-2.95.3-175.2


                              oracle@hmf-hrm-001:/usr/bin> ls -l gcc
                              lrwxrwxrwx 1 root root 19 Dec 7 15:38 gcc -> /opt/gcc295/bin/gcc


                              oracle@hmf-hrm-001:/usr/bin> cd /opt/gcc295/bin/
                              oracle@hmf-hrm-001:/opt/gcc295/bin> ls -ltr
                              total 460
                              -rwxr-xr-x 1 root root 76089 Aug 24 2004 g++
                              -rwxr-xr-x 1 root root 37171 Aug 24 2004 c++filt
                              -rwxr-xr-x 1 root root 35459 Aug 24 2004 unprotoize
                              -rwxr-xr-x 1 root root 40425 Aug 24 2004 protoize
                              -rwxr-xr-x 1 root root 18947 Aug 24 2004 gcov
                              -rwxr-xr-x 1 root root 79670 Aug 24 2004 cpp
                              -rwxr-xr-x 2 root root 75543 Aug 24 2004 i486-suse-linux-gcc
                              -rwxr-xr-x 2 root root 75543 Aug 24 2004 gcc
                              lrwxrwxrwx 1 root root 3 Dec 7 15:34 cc -> gcc
                              lrwxrwxrwx 1 root root 3 Dec 7 15:34 c++ -> g++
                              • 12. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                user10994730
                                As per note 943005.1

                                oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> . APPSLNXRES_hmf-hrm-001.env
                                oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> adpatch
                                adpatch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory



                                what is this as per 736410.1?
                                Install 32-bit (ppc) and 64-bit (ppc64) glibc-devel packages in the target, Linux 5, environment.


                                Thanks.
                                • 13. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                  Hussein Sawwan-Oracle
                                  user10994730 wrote:
                                  As per note 943005.1

                                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> . APPSLNXRES_hmf-hrm-001.env
                                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl> adpatch
                                  adpatch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory



                                  what is this as per 736410.1?
                                  Install 32-bit (ppc) and 64-bit (ppc64) glibc-devel packages in the target, Linux 5, environment.


                                  Thanks.
                                  Please verify your packages as per (Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]).

                                  Thanks,
                                  Hussein
                                  • 14. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                    user10994730
                                    I was looking at the hisroty of this system and I found following.

                                    Do you think this could be the reason?
                                    rpm -Uvh --nodeps gcc_old-2.95.3-175.2.i586.rpm
                                    hmf-hrm-001:/usr/bin # mv gcc gcc_4.3
                                    hmf-hrm-001:/usr/bin # ln -s gcc /opt/gcc295/bin/gcc

                                    oracle@hmf-hrm-001:/usr/bin> ls -l gcc*
                                    lrwxrwxrwx 1 root root 19 Dec 7 15:38 gcc -> /opt/gcc295/bin/gcc
                                    lrwxrwxrwx 1 root root 7 Nov 21 12:32 gcc_4.3 -> gcc-4.3
                                    -rwxr-xr-x 1 root root 234752 Jan 13 2012 gcc-4.3


                                    Thanks.
                                    1 2 3 Previous Next