1 8 9 10 11 12 Previous Next 173 Replies Latest reply: May 30, 2013 12:07 PM by Hussein Sawwan-Oracle Go to original post Branched to a new discussion. RSS
      • 150. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
        user10994730
        Thanks Hussein,

        Any idea why am i still getting this error?

        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
        • 151. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
          Hussein Sawwan-Oracle
          I think it's something to do with missing packages.

          Error When Installing 11g Patch Set 4 (11.1.1.5.0): 'UnsatisfiedLinkError' and 'cannot open shared object file' [ID 1323972.1]
          10.2.0.1 database installation fails with "java.lang.UnsatisfiedLinkError: lib/i386/libawt.so: libXtst.so.6: cannot open shared object file" on SLES 11 [ID 1427934.1]
          DBConsole Failed to Start with the Error log4j:ERROR Please initialize the log4j system properly in the emdb.nohup File [ID 825753.1
          Installing Grid Control 10.2 on Oracle Enterprise Linux 5 x86_64 EMDeploy Fails with exitCode=7 [ID 958435.1]
          "Exception java.lang.UnsatisfiedLinkError:... libXtst.so.6 or libXt.so.6 " or while Installing 10gR2 on RHEL/OEL 5 [ID 551406.1]

          Thanks,
          Hussein
          • 152. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
            user10994730
            oracle@hmf-hrm-001:~> rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep xorg-x11-libs
            xorg-x11-libs-7.4-8.26.32.1 (x86_64)
            xorg-x11-libs-32bit-7.4-8.26.32.1 (x86_64)
            oracle@hmf-hrm-001:~> rpm -qa | grep xorg-x11-libs
            xorg-x11-libs-7.4-8.26.32.1
            xorg-x11-libs-32bit-7.4-8.26.32.1
            oracle@hmf-hrm-001:~>
            • 153. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
              user10994730
              Hi Hussein,

              I was able to resolve the issue with following patch which I have missed after r.12.1.1 upgrade.

              Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]

              Apply AS 10g Forms/Reports Patch 13579719 (SLES 11 only)
              Apply the patch 13579719 to resolve an issue with relinking Oracle Reports

              Then I have successfully upgraded to r12.1.3.

              Purging timing information for prior sessions.

              sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql
              10 1000

              Done purging timing information for prior sessions.

              AutoPatch is complete.

              AutoPatch may have written informational messages to the file
              /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_u9239090.lgi

              Errors and warnings are listed in the log file
              /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_u9239090.log
              145837.1
              and in other log files in the same directory.Enter value for a: 9239090
              old 1: select bug_number from ad_bugs where bug_number = '&a'
              new 1: select bug_number from ad_bugs where bug_number = '9239090'

              BUG_NUMBER
              --------------------------------------------------------------------------------
              9239090




              Regarding HRMS Legislative Data (hrglobal.drv) we have to follow note:145837.1 as per the read me of 9239090. What steps do I have to perform as per note:145837.1.

              The note says under Master pre-req table
              12.1.3OR R12.HR_PF.B.delta3 for US is HR.

              What does this mean?
              Our is HRMS application.


              Thanks.
              • 154. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                Hussein Sawwan-Oracle
                For global legislation, no more patches are required.

                If you want to apply the latest HRMS patchset, please refer to:

                Oracle Human Resources Management Systems Readme, HRMS Release Update Pack 5 for Release 12.1 [ID 1456556.1]
                Known Issues on Top of Patch 13418800 - R12.HR_PF.B.DELTA.5 (HRMS 12.1 RUP5) [ID 1428906.1]

                Thanks,
                Hussein
                • 155. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                  542838
                  While applying 13418800 R12.HR_PF.B.delta.5 patch workers faild at this point.
                  I see something related to these failed workers in this
                  Patch 13418800 Causes Several LDTs Fail While Calling FNDLOAD [ID 1469117.1] note.

                  FAILED: file hxczzhxclcdf0002.ldt on worker 1.
                  FAILED: file payusgenupgdef.ldt on worker 2.
                  FAILED: file pycougp.ldt on worker 3.
                  FAILED: file payipgenupgdfn.ldt on worker 4.
                  oracle@hmf-hrm-001:~> sqlplus apps@LNXRES

                  SQL*Plus: Release 10.1.0.5.0 - Production on Mon May 20 13:29:55 2013

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

                  Enter password:

                  Connected to:
                  Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                  With the Partitioning, OLAP, Data Mining and Real Application Testing options

                  SQL> ad_bug.sql
                  SP2-0042: unknown command "ad_bug.sql" - rest of line ignored.
                  SQL> @ad_bug.sql
                  Enter value for a: 9817770
                  old 1: select bug_number from ad_bugs where bug_number = '&a'
                  new 1: select bug_number from ad_bugs where bug_number = '9817770'

                  BUG_NUMBER
                  --------------------------------------------------------------------------------
                  9817770

                  SQL> /
                  Enter value for a: 9966055
                  old 1: select bug_number from ad_bugs where bug_number = '&a'
                  new 1: select bug_number from ad_bugs where bug_number = '9966055'

                  BUG_NUMBER
                  --------------------------------------------------------------------------------
                  9966055

                  SQL> /
                  Enter value for a: 11072961
                  old 1: select bug_number from ad_bugs where bug_number = '&a'
                  new 1: select bug_number from ad_bugs where bug_number = '11072961'

                  no rows selected

                  SQL>


                  What should I be doing?
                  • 156. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                    Hussein Sawwan-Oracle
                    Please make sure you have the patches mentioned in (Patch 13418800 Causes Several LDTs Fail While Calling FNDLOAD [ID 1469117.1]) applied -- Please query AD_BUGS table to verify.

                    Thanks,
                    Hussein
                    • 157. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                      542838
                      except this 11072961 other 2( Patch 9817770 and Patch 9966055) from the note were applied.

                      Should apply 11072961 patch after stoping the other 13418800 (R12.HR_PF.B.DELTA.5) patch in the middle and reapply?

                      Thanks.
                      • 158. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                        Hussein Sawwan-Oracle
                        user539835 wrote:
                        except this 11072961 other 2( Patch 9817770 and Patch 9966055) from the note were applied.

                        Should apply 11072961 patch after stoping the other 13418800 (R12.HR_PF.B.DELTA.5) patch in the middle and reapply?

                        Thanks.
                        Yes, please.

                        Thanks,
                        Hussein
                        • 159. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                          542838
                          Can I leave the other patch session 13418800 (R12.HR_PF.B.DELTA.5) as it is apply 11072961 patch from another window?

                          Or should issue CTL C with 13418800 (R12.HR_PF.B.DELTA.5) patch and start allover again after applying 11072961 patch?

                          Thanks.
                          • 160. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                            Hussein Sawwan-Oracle
                            user539835 wrote:
                            Can I leave the other patch session 13418800 (R12.HR_PF.B.DELTA.5) as it is apply 11072961 patch from another window?
                            No.
                            Or should issue CTL C with 13418800 (R12.HR_PF.B.DELTA.5) patch and start allover again after applying 11072961 patch?
                            You need to terminate the current adpatch session, apply the missing patch, then re-apply Patch 13418800

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

                              I was able to apply both the patches now.

                              SQL> /
                              Enter value for a: 11072961
                              old 1: select bug_number from ad_bugs where bug_number = '&a'
                              new 1: select bug_number from ad_bugs where bug_number = '11072961'

                              BUG_NUMBER
                              --------------------------------------------------------------------------------
                              11072961
                              Enter value for a: 13418800
                              old 1: select bug_number from ad_bugs where bug_number = '&a'
                              new 1: select bug_number from ad_bugs where bug_number = '13418800'

                              BUG_NUMBER
                              -------------------------------------------------------------------------------
                              13418800


                              Now I am implementing US/GLOBAL legilslation after applying 13418800 (R12.HR_PF.B.DELTA.5) patch.

                              I will do following to run the DataInstall program
                              for locallization and hrglobal.drv instal.

                              ====================
                              Legislation Details
                              ====================

                              Installed legislations
                              (Code) Application
                              ----------------------------- -------------------------
                              US Human Resources
                              US College Data
                              Global Human Resources

                              java oracle.apps.per.DataInstall apps xxxxxx thin hmf-o
                              db-001:1524:LNXRES

                              select 1 from DataInstall Main Menu
                              Enter your choice (for example 2I) : 31I for US localization

                              FOR GLOBAL HUMAN RESOURCES

                              java oracle.apps.per.DataInstall apps xxxxxx thin hmf-o
                              db-001:1524:LNXRES

                              select 1 from DataInstall Main Menu
                              Enter your choice (for example 2I) : 1I for Global

                              Repeat same steps for US College Data too.

                              Applying hrglobal.drv under oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/driver>
                              using adpatch.

                              -rwxr-xr-x 1 oracle puppet 258603 May 20 09:21 hrglobal.drv


                              Please correct me if I have missed anything.



                              Thanks.
                              • 162. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                Hussein Sawwan-Oracle
                                Please correct me if I have missed anything.
                                All the steps are OK and I don't you missed anything.

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

                                  I have completed the task mentioned in my previous update. Please let me know if everyhting looks OK.

                                  The following actions will be performed:


                                  Localisation Product(s) Leg. Data? Action
                                  -------------------- ------------------------ ---------- -------------
                                  Global Human Resources Installed Install
                                  United States Human Resources Installed Install

                                  Localisation College Data? Action
                                  -------------- ------------- -------------
                                  United Kingdom
                                  United States Installed Install

                                  Option Data? Action
                                  ------------------------------ ------------- -------------
                                  JIT/Geocode
                                  Oracle Time and Labor (OTL)


                                  001:/data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/driver> adpatch

                                  Copyright (c) 2002 Oracle Corporation
                                  Redwood Shores, California, USA

                                  Oracle Applications AutoPatch

                                  Version 12.0.0

                                  NOTE: You may not use this utility for custom development
                                  unless you have written permission from Oracle Corporation.


                                  Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
                                  You must use OAM Patch Wizard for this feature. Alternatively, you can
                                  review the README for pre-requisite information.


                                  Your default directory is '/data/rel12/apps/apps_st/appl'.

                                  Enter the directory where your Oracle Applications patch has been unloaded

                                  The default directory is [data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/driver] :

                                  Please enter the name of your AutoPatch driver file : hrglobal.drv


                                  Purging timing information for prior sessions.

                                  sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000

                                  Done purging timing information for prior sessions.

                                  AutoPatch is complete.

                                  AutoPatch may have written informational messages to the file
                                  /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_hrglobal.lgi

                                  Errors and warnings are listed in the log file
                                  /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_hrglobal.log

                                  and in other log files in the same directory.


                                  Thanks.
                                  • 164. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                    Hussein Sawwan-Oracle
                                    The above looks OK to me.

                                    Thanks,
                                    Hussein