1 8 9 10 11 12 Previous Next 173 Replies Latest reply on May 30, 2013 5:07 PM by Hussein Sawwan-Oracle Go to original post Branched to a new discussion.
      • 135. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
        user10994730
        I was trying to apply 8551790 I am getting following.

        oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/8551790> opatch apply -invPtrLoc /data
        /oracle/oraInst.loc

        Oracle Interim Patch Installer version 1.0.0.0.58
        Copyright (c) 2007 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 : /data/rel12/apps/tech_st/10.1.2
        Oracle Home Inventory : /data/rel12/apps/tech_st/10.1.2/inventory
        Central Inventory : /data/oracle/oraInventory
        from : /data/oracle/oraInst.loc
        OUI location : /data/rel12/apps/tech_st/10.1.2/oui
        OUI shared library : /data/rel12/apps/tech_st/10.1.2/oui/lib/linux/liboraInst
        aller.so
        Java location : /data/rel12/apps/tech_st/10.1.2/jre/1.4.2/bin/java
        Log file location : /data/rel12/apps/tech_st/10.1.2/.patch_storage/<patch ID
        /*.log
        Problems with the lock file
        Lock file exists, details are:
        Interim Patch 8557019 is holding the lock from this patch 8551790,
        probably due to previous unsuccessful operation

        ERROR: OPatch failed during pre-reqs check.



        I tried rollback 8557019 with following step and did not proceed.
        Do you want me to proceed?


        oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/.patch_storage/8557019> ./rol
        lback_8557019.sh
        This script is going to roll back the changes made to system files on
        this Oracle Home only. It does not perform any of the following:
        - Inventory update
        - Oracle binary re-link
        - Customized steps performed manually by user
        Please use this script with supervision from Oracle Technical Support.
        To rollback a patch, please use 'opatch rollback'.
        About to modify Oracle Home( /data/rel12/apps/tech_st/10.1.2 )
        Do you want to proceed? [Y/N]
        N
        User responded with : N


        Patch 8557019: make: Fatal error: Command failed for target `dejvm'0.1.2/lib32/WS6U1/crti.o: open failed: No such file or directory [ID 1291895.1]
        says apply following pre-req but I do not see in read me of 8557019. I see 8551790 only.

        8904424

        Edited by: user10994730 on Apr 4, 2013 9:09 AM
        • 136. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
          Hussein Sawwan-Oracle
          To resolve the locking issue, please refer to:

          OPATCH: Interim Patch is holding the lock from this patch [ID 257800.1]
          Opatch error : "Unable to lock Central Inventory" [ID 861677.1]
          OPatch Lsinventory Reports "OUI-67076 : OracleHomeInventory was not able to create a lock file" in Unix [ID 1086853.1]

          Thanks,
          Hussein
          • 137. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
            user10994730
            Thanks. I was able to do with following steps.

            drwxr-x--- 3 oracle puppet 4096 Apr 4 10:36 8528194
            -rw-r----- 1 oracle dba 250 Apr 4 10:44 patch_locked
            drwxr-x--- 3 oracle puppet 4096 Apr 4 11:33 8557019
            drwxr-xr-x 2 oracle puppet 4096 Apr 4 12:01 8551790
            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/.patch_storage> more patch_locked
            Locked for patch : 8557019
            Locked by class : Apply
            Locked by process : 14761
            Locked at time : Thu Apr 4 10:44:17 2013
            Effective User ID : 104
            Real User ID : 104
            Host details : hmf-hrm-001
            RAC node details : Not Applicable

            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/.patch_storage> mv patch_locked /tmp/.

            oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/8551790> opatch apply -invPtrLoc /data
            /oracle/oraInst.loc

            Oracle Interim Patch Installer version 1.0.0.0.58
            Copyright (c) 2007 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 : /data/rel12/apps/tech_st/10.1.2
            Oracle Home Inventory : /data/rel12/apps/tech_st/10.1.2/inventory
            Central Inventory : /data/oracle/oraInventory
            from : /data/oracle/oraInst.loc
            OUI location : /data/rel12/apps/tech_st/10.1.2/oui
            OUI shared library : /data/rel12/apps/tech_st/10.1.2/oui/lib/linux/liboraInst
            aller.so
            Java location : /data/rel12/apps/tech_st/10.1.2/jre/1.4.2/bin/java
            Log file location : /data/rel12/apps/tech_st/10.1.2/.patch_storage/<patch ID
            /*.log
            Creating log file "/data/rel12/apps/tech_st/10.1.2/.patch_storage/8551790/Apply_
            8551790_04-04-2013_12-20-42.log"

            Looking for /data/oracle/r12/10.1.2.3_upgrade/8551790/files/ocm.zip...
            Invoking fuser to check for active processes.

            Backing up comps.xml ...

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

            Please shut down Oracle instances running out of this ORACLE_HOME
            (Oracle Home = /data/rel12/apps/tech_st/10.1.2)
            Is this system ready for updating?
            Please respond Y|N >
            Y
            Applying patch 8551790...

            Patching copy files...

            Inventory is good and does not have any dangling patches.

            Updating inventory...

            Verifying patch...
            Backing up comps.xml ...

            OPatch succeeded.
            oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/8551790>

            oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/.patch_storage>
            • 138. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
              user10994730
              Failed reports patch 7016961.
              oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/7016961> ./patch.sh

              Patch Utility: Applying patch 7016961 for 6.0.8.2 on Linux 32

              Using /data/rel12/apps/tech_st/10.1.2/lib as temporary working directory

              This procedure assumes that:
              - Your current working directory
              /data/oracle/r12/10.1.2.3_upgrade/7016961
              is where you have restored this patch archive to.
              - You have read the README.* file.
              - You have at least 1 Mb available in the following filesystem.
              /data/rel12/apps/tech_st/10.1.2
              - You have at least 1 Mb available in following filesystem
              /data/rel12/apps/tech_st/10.1.2/lib
              - You have shutdown all database instances under this ORACLE_HOME
              before running this script.
              - YOU WILL NOT INTERRUPT THIS PROCEDURE!
              Are you ready to continue? [N] => Y


              File /data/rel12/apps/tech_st/10.1.2/lib/libca60.a is missing
              File /data/rel12/apps/tech_st/10.1.2/lib/libca60.a is not writable
              Patch can not be installed.
              oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/7016961>

              oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib>

              oracle@hmf-hrm-001:/data/rel12/apps/tech_st/10.1.2/lib> ls -l libca*
              -rwxr-xr-x 1 oracle dba 383176 Mar 26 2009 libca.a
              lrwxrwxrwx 1 oracle dba 10 Feb 12 14:05 libca.so -> libca.so.0
              -rwxr-xr-x 1 oracle dba 314971 Mar 26 2009 libca.so.0

              Help is appreciated.

              Edited by: user10994730 on Apr 4, 2013 11:36 AM
              • 139. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                Hussein Sawwan-Oracle
                Did you select the correct release when you downloaded this patch since it is available for different releases?

                Thanks,
                Hussein
                • 140. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                  user10994730
                  I have downloaded this patch for 6.0.8.2 for 11i.
                  I am going to download for 10.1.2 and apply.

                  Thanks.
                  • 141. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                    user10994730
                    I was applying patch 10152652 as per upgrading oracle 10G AS forms and reports in EBS release 12. Note:437878.1 and got following warning.
                    Can I continue with rest of the patches and take care of this later if this is a relinking executables?

                    /usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: warni
                    ng: libXtst.so.6, needed by /data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/lib
                    awt.so, not found (try using -rpath or -rpath-link)
                    mv rwproxy /data/rel12/apps/tech_st/10.1.2/bin/rwproxy
                    chmod 700 /data/rel12/apps/tech_st/10.1.2/bin/rwproxy
                    oracle@hmf-hrm-001:~/r12/10.1.2.3_upgrade/10152652>
                    • 142. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                      Hussein Sawwan-Oracle
                      Can I continue with rest of the patches and take care of this later if this is a relinking executables?
                      Apply all patches then apply this one and see if you get the same message.

                      Thanks,
                      Hussein
                      • 143. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                        user10994730
                        Thanks Hussein,. I did following steps.

                        hmf-hrm-001:/usr/lib # cp -p libXtst.so.6 libXtst.so.6_orig
                        hmf-hrm-001:/usr/lib # ls -l libXtst*
                        lrwxrwxrwx 1 root root 16 Nov 21 12:32 libXtst.so.6 -> libXtst.so.6.1.0
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6.1.0
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6_orig
                        hmf-hrm-001:/usr/lib # unlink libXtst.so.6
                        hmf-hrm-001:/usr/lib # ls -l libXtst*
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6.1.0
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6_orig
                        hmf-hrm-001:/usr/lib # ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6hmf-hrm-001:/usr/lib #
                        hmf-hrm-001:/usr/lib # ls -l libXtst*
                        lrwxrwxrwx 1 root root 29 Apr 4 15:39 libXtst.so.6 -> /usr/X11R6/lib/libXtst.so.6.1
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6.1.0
                        -rwxr-xr-x 1 root root 22260 Oct 10 2011 libXtst.so.6_orig


                        I am still getting following warning after I did post install steps for patch 6400501.


                        # $ make -f ins_reports.mk install


                        `cat /data/rel12/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lpthread -lm -L/data/rel12/apps/tech_st/10.1.2/lib -L/data/rel12/apps/tech_st/10.1.2/lib/stubs/ -lutj -lutl -ljvm -lhpi -lnsl
                        /usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: warning: libXtst.so.6, needed by /data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/libawt.so, not found (try using -rpath or -rpath-link)
                        mv rwproxy /data/rel12/apps/tech_st/10.1.2/bin/rwproxy
                        chmod 700 /data/rel12/apps/tech_st/10.1.2/bin/rwproxy
                        • 144. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                          Hussein Sawwan-Oracle
                          Please see if the following docs help.

                          Relink Reports After Applying Any Patch, Getting Errors: collect2: ld returned 1 exit status, make: *** [rwbuilder] Error 1 [ID 1218994.1]
                          'rtsora' Module Failed to Relink While Installing 10.2.0.3 Or 10.2.0.4 Patchset on Linux x86 [ID 413538.1]
                          libaio.so.1: cannot open shared object file [ID 859523.1]
                          11g: Error while loading shared libraries During 11.1.0.1 Agent Installation: libaio.so.1: cannot open shared object file [ID 1286258.1]

                          If not, please log a SR for this error.

                          Thanks,
                          Hussein
                          • 145. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                            user10994730
                            Can I go ahead and apply Oracle E-Business Suite/Forms Interoperability Patch
                            and take care of this warning later as per note:437878.1?

                            Thanks.

                            Edited by: user10994730 on Apr 9, 2013 8:29 AM
                            • 146. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                              Hussein Sawwan-Oracle
                              user10994730 wrote:
                              Can I go ahead and apply Oracle E-Business Suite/Forms Interoperability Patch
                              and take care of this warning later as per note:437878.1?

                              Thanks.

                              Edited by: user10994730 on Apr 9, 2013 8:29 AM
                              Yes you could.

                              Thanks,
                              Hussein
                              • 147. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                user10994730
                                I ran following step as per Deploying a New Forms .ear File in Oracle Applications Release 12 [ID 397174.1] Note. I See following errros.


                                oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/fnd/12.0.0/bin> txkrun.pl -script=CfgOC4JApp
                                *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
                                *** Log File = /data/rel12/inst/apps/LNXRES_hmf-hrm-001/logs/appl/rgf/TXK/txkCfgOC4JApp_Tue_Apr_9_14_50_35_2013.log
                                Program : /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Tue Apr 9 14:50:35 2013

                                *** Log File = /data/rel12/inst/apps/LNXRES_hmf-hrm-001/logs/appl/rgf/TXK/txkCfgOC4JApp_Tue_Apr_9_14_50_35_2013.log

                                Enter Application name for re-deployment ? forms
                                Enter Oc4j Instance password for re-deployment ?
                                Run Autoconfig <Yes/No> ? No


                                *****************************************************
                                Required values for starting OC4J instance "forms":
                                ====================================================
                                s_formsstatus = enabled
                                s_forms_nprocs = 1 (value should be greater than 0)


                                Existing values from the context file:
                                ======================================
                                s_formsstatus = enabled
                                s_forms_nprocs = 1
                                ----------------------------------------------

                                *** Values for context variables are VALID ***

                                ----------------------------------------------

                                *****************************************************

                                Stopping all OPMN processes.
                                OPMN stopped.
                                OPMN started.
                                Deplolying Application : "forms" onto OC4J instance: "forms"
                                Application deployed successfully.
                                Stopping and starting OC4J instances.

                                Errors encountered running /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl

                                *******FATAL ERROR*******
                                PROGRAM : /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl(/data/rel12/apps/apps_st/appl/fnd/12.0.0/bin/txkrun.pl)
                                TIME : Tue Apr 9 14:54:32 2013
                                FUNCTION: TXK::Process::run [ Level 3 ]
                                MESSAGES:
                                Command error: <rc> = 52224, <command> = /data/rel12/apps/tech_st/10.1.3/opmn/bin/opmnctl stopproc instancename=forms


                                STACK TRACE
                                TXK::Error::abort('TXK::Error','HASH(0x821bf64)') called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299
                                TXK::Common::doError('TXK::Process=HASH(0x8b4df44)','Command error: <rc> = 52224, <command> = /data/rel12/apps/tec...','undef') called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314
                                TXK::Common::setError('TXK::Process=HASH(0x8b4df44)','Command error: <rc> = 52224, <command> = /data/rel12/apps/tec...') called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/Process.pm line 449
                                TXK::Process::run('TXK::Process=HASH(0x8b4df44)','HASH(0x89a5024)') called at /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 1587
                                TXK::RunScript::execOPMNControl('HASH(0x911e808)') called at /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 703
                                require /data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/RunScript.pm line 105
                                TXK::RunScript::require('TXK::RunScript','/data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfg...') called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/Script.pm line 177
                                eval {...} called at /data/rel12/apps/apps_st/appl/au/12.0.0/perl/TXK/Script.pm line 177
                                TXK::Script::run('TXK::Script=HASH(0x8ac4418)','/data/rel12/inst/apps/LNXRES_hmf-hrm-001/logs/appl/rgf/TXK','/data/rel12/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfg...') called at /data/rel12/apps/apps_st/appl/fnd/12.0.0/bin/txkrun.pl line 174


                                Help is appreciated.
                                • 148. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                  user10994730
                                  Still getting following error while trying to run this "make -f ins_reports.mk install" after completing Oracle E-Business Suite/Forms Interoperability Patches and other patches as per note 437878.1.

                                  /usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: warning: libXtst.so.6, needed by /data/rel12/apps/tech_st/10.1.2/jdk/jre/lib/i386/libawt.so, not found (try using -rpath or -rpath-link)
                                  mv rwproxy /data/rel12/apps/tech_st/10.1.2/bin/rwproxy
                                  chmod 700 /data/rel12/apps/tech_st/10.1.2/bin/rwproxy



                                  hmf-hrm-001:/ # find / -name libXtst.so.6
                                  /usr/lib64/libXtst.so.6.1.0
                                  /usr/lib64/libXtst.so.6
                                  /usr/lib/libXtst.so.6.1.0
                                  /usr/lib/libXtst.so.6
                                  /usr/lib/libXtst.so.6_orig
                                  /data/lnxresora/8.0.6/lib/stubs/libXtst.so.6
                                  /data/lnxresora/iAS/lib/stubs/libXtst.so.6
                                  /data/rel12/apps/tech_st/10.1.2/lib/stubs/libXtst.so.6
                                  /data/rel12/apps/tech_st/10.1.3/lib/stubs/libXtst.so.6



                                  I ran Concurrent program active users after applying forms/reports patches and getting the following error.

                                  ---------------------------------------------------------------------------
                                  Application Object Library: Version : 12.0.0

                                  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                                  FNDSCURS module: Active Users
                                  ---------------------------------------------------------------------------

                                  Current system time is 12-APR-2013 15:23:43

                                  ---------------------------------------------------------------------------


                                  +-----------------------------
                                  | Starting concurrent program execution...
                                  +-----------------------------


                                  APPLLCSP Environment Variable set to :

                                  Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
                                  American_America.UTF8

                                  '.,'

                                  /data/rel12/apps/tech_st/10.1.2/bin/rwrun: error while loading shared libraries: libXtst.so.6: cannot open shared object file: No such file or directory



                                  I ran active users program before starting forms/reports upgrade after r12.1.1 upgrade it ran fine.

                                  ---------------------------------------------------------------------------
                                  Application Object Library: Version : 12.0.0

                                  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                                  FNDSCURS module: Active Users
                                  ---------------------------------------------------------------------------

                                  Current system time is 25-MAR-2013 16:32:07

                                  ---------------------------------------------------------------------------


                                  +-----------------------------
                                  | Starting concurrent program execution...
                                  +-----------------------------


                                  APPLLCSP Environment Variable set to :

                                  Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
                                  American_America.UTF8

                                  '.,'

                                  Enter Password:
                                  REP-0004: Warning: Unable to open user preference file.

                                  Report Builder: Release 10.1.2.3.0 - Production on Mon Mar 25 16:32:49 2013

                                  Copyright (c) 1982, 2005, Oracle. All rights reserved.


                                  ---------------------------------------------------------------------------
                                  Start of log messages from FND_FILE
                                  ---------------------------------------------------------------------------
                                  ---------------------------------------------------------------------------
                                  End of log messages from FND_FILE
                                  ---------------------------------------------------------------------------


                                  ---------------------------------------------------------------------------
                                  Executing request completion options...

                                  ------------- 1) PRINT   -------------


                                  Printing output file.
                                  Request ID : 1711961      
                                  Number of copies : 0      
                                  Printer : noprint

                                  --------------------------------------


                                  Finished executing request completion options.

                                  ---------------------------------------------------------------------------
                                  Concurrent request completed successfully
                                  Current system time is 25-MAR-2013 16:33:02

                                  ---------------------------------------------------------------------------




                                  Active users Concurrent program ran fine before forms/reports upgrade.

                                  Even oracle support having hard time figuring out this issue.
                                  Any Idea what could be the reason for this issue?


                                  Can I still go ahead and start r12.1.3 upgrade and while oracle support is working on this issue?
                                  • 149. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                    Hussein Sawwan-Oracle
                                    Can I still go ahead and start r12.1.3 upgrade and while oracle support is working on this issue?
                                    I would say yes you can. However, you may ask Oracle support since you already have a SR created.

                                    Thanks,
                                    Hussein