1 2 3 4 5 Previous Next 70 Replies Latest reply: Jan 21, 2013 10:52 AM by Hussein Sawwan-Oracle Go to original post RSS
      • 30. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
        WF001
        Yes, it's my last choice because I need onsite the server room every time that is not convenient for me...

        Thanks for your advice.
        Sam :)
        • 31. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
          WF001
          Update status

          I tried reinstall the XSecurePro 8.5 but it's shown "XSession Internal Error" :
          The infinite LocalManager loop is occured.
          LoopCnt=811, mkLocalManagerCry-7

          And I tried to use X-Win32 tools, it can view the welcome screen properly. That's my good news.
          • 32. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
            WF001
            I've already installed R12 tech stack, but when I am applying patch AD 12.1.1 upgrade driver (7461070) . Its giving error

            ad_ddl.do_ddl('APPLSYS','INTERMEDIA',ad_ddl.create_grants,
            *
            ERROR at line 19:
            ORA-06550: line 19, column 40:
            PLS-00905: object SYSTEM.AD_DDL is invalid
            ORA-06550: line 19, column 3:
            PL/SQL: Statement ignored
            ........
            ..................


            And I try to install XL C/C++ Utilities v11.1 and compile the invalid object, it still to show the error as below,

            SQL> ALTER PACKAGE SYSTEM.AD_DDL COMPILE ;

            Warning: Package altered with compilation errors.

            SQL> show error
            Errors for PACKAGE SYSTEM.AD_DDL:

            LINE/COL ERROR
            -------- -----------------------------------------------------------------
            0/0 PLS-00923: native compilation failed: C compilation or linking
            failed:$ORACLE_HOME/bin/oraxlc[220]:
            /usr/vac/bin/xlc: not found

            #lslpp -l |grep xl
            xlC.aix61.rte 11.1.0.2 COMMITTED XL C/C++ Runtime for AIX 6.1
            xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
            xlC.rte 11.1.0.2 COMMITTED XL C/C++ Runtime
            xlC.sup.aix50.rte 9.0.0.1 COMMITTED XL C/C++ Runtime for AIX 5.2

            #lslpp -l |grep vac |grep 11.1
            vac.aix53.lib 11.1.0.0 COMMITTED XL C for AIX Libraries for AIX
            vacpp.cmp.rte 11.1.0.0 COMMITTED IBM XL C/C++ Compiler
            vacpp.cmp.tools 11.1.0.0 COMMITTED IBM XL C/C++ Tools

            Can anybody help me in fixing this ?
            Thanks
            Sam
            • 33. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
              azodpe
              Are you following MOS ID 798258.1?
              As per this doc, this patch has to be applied after merging with

              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.
              Do not use -preinstall or - driveronly mode.
              • 34. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                EBSDBA
                Hi Sam,

                Please post the output of

                #ls -ll /usr/vac/bin/xlc

                Please see

                PRO*C / IBM AIX: 'make: 1254-004 The error code from the last command is 127 / oraxlc[172] : /usr/local/bin/xlc: not found' [ID 762718.1]

                Thanks
                • 35. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                  Hussein Sawwan-Oracle
                  0/0 PLS-00923: native compilation failed: C compilation or linking
                  failed:$ORACLE_HOME/bin/oraxlc[220]:
                  /usr/vac/bin/xlc: not found

                  #lslpp -l |grep xl
                  xlC.aix61.rte 11.1.0.2 COMMITTED XL C/C++ Runtime for AIX 6.1
                  xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor
                  xlC.rte 11.1.0.2 COMMITTED XL C/C++ Runtime
                  xlC.sup.aix50.rte 9.0.0.1 COMMITTED XL C/C++ Runtime for AIX 5.2

                  #lslpp -l |grep vac |grep 11.1
                  vac.aix53.lib 11.1.0.0 COMMITTED XL C for AIX Libraries for AIX
                  vacpp.cmp.rte 11.1.0.0 COMMITTED IBM XL C/C++ Compiler
                  vacpp.cmp.tools 11.1.0.0 COMMITTED IBM XL C/C++ Tools

                  Can anybody help me in fixing this ?
                  Please see (Getting error "/usr/vac/bin/xlc: not found" while installing OCM [ID 1125399.1]).

                  Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit) [ID 761569.1]

                  Thanks,
                  Hussein
                  • 36. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                    WF001
                    Hi EBSDBA,

                    #ls -ll /usr/vac/bin/xlc
                    /usr/vac/bin/xlc not found

                    #oslevel
                    6.1.0.0

                    #ls -l /usr/vac/
                    total 0
                    drwxr-xr-x 3 bin bin 256 Jan 2 16:57 lib

                    #ls -l /usr/vac/lib/
                    total 0
                    drwxr-xr-x 2 bin bin 256 Mar 26 2010 aix53
                    lrwxrwxrwx 1 root system 13 Jan 2 16:57 libxl.a -> aix53/libxl.a
                    lrwxrwxrwx 1 root system 16 Jan 2 16:57 libxlopt.a -> aix53/libxlopt.a

                    #ls -l /usr/vacpp/
                    total 0
                    drwxr-xr-x 2 bin bin 256 Jan 2 17:49 bin
                    drwxr-xr-x 3 bin bin 256 Jan 2 16:57 exe
                    drwxr-xr-x 3 bin bin 256 Jan 2 16:57 lib

                    #ls -l /usr/vacpp/bin/
                    total 168
                    -r-xr-xr-x 1 bin bin 25957 Mar 6 2010 c++filt
                    -r-xr-xr-x 1 bin bin 6182 Mar 5 2010 linkxlC
                    -r-xr-xr-x 4 bin bin 9246 Mar 5 2010 makeC++SharedLib
                    -r-xr-xr-x 4 bin bin 9246 Mar 5 2010 makeC++SharedLib128
                    -r-xr-xr-x 4 bin bin 9246 Mar 5 2010 makeC++SharedLib_r
                    -r-xr-xr-x 4 bin bin 9246 Mar 5 2010 makeC++SharedLib_r7

                    #cat /.profile |grep PATH
                    PATH=/usr/bin:/usr/vacpp/bin:/usr/ccs/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/usr/local/bin:/usr/local/lib
                    export PATH

                    The metalink document ID 762718.1 says "2.Ensure that environment variable ORACCENV sets a values for the used C/C++ compiler - valid entries"
                    ORACCENV='cc=xlc'
                    export ORACCENV

                    Do you know where to set the above values? to $ORACLE_HOME/bin/oraxlc or appR12user's .profile ?
                    But I can't find the xlc file in /usr/vac/bin/ or :/usr/vacpp/bin/....., any problem?

                    Thanks
                    Sam
                    • 37. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                      WF001
                      I am confused about the next steps that I should follow the Upgrade Guide(Release 11i to 12.1.1 - Part No. E16342-04) or Release Notes 12.1.1 [ID 798258.1]....

                      Refer MOS ID 798258.1,
                      When directed to apply the AD 12.1.1 upgrade driver and run the American English upgrade patch driver in Chapter 3 of the Oracle Applications Upgrade Guide: Release 11i to Release 12.1.1, perform the following steps, instead:

                      1.Apply Patch 9179588 (9179588:R12.AD.B), following the instructions in the patch readme.
                      2.Apply Patch 7303029 (7303029:12.1.0) in preinstall mode. Please review step number 3 to check if you should merge this patch with other Pre-upgrade Patches.
                      3.Apply Pre-upgrade Patches released after Consolidated Upgrade Patch 7303029.....
                      4.Run the new merged American English upgrade patch driver, following the instructions in the Patch 7303029 readme.

                      Refer Oracle Applications Patching Procedures, I did not find how to use -admode option to merge this patch (9179588:R12.AD.B) with 9477107:R12.AD.B and R12.AD.B.1 (patch 7461070), can anybody please instruct how to do it?
                      http://download.oracle.com/docs/cd/B53825_03/current/acrobat/121adpp.pdf

                      Thanks a lot.
                      Sam
                      • 38. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                        WF001
                        I have searched the OTN that found the following method and I will try it soon, thanks Hussein.

                        admrgpch unable to merge patches - 0 unified drivers merged.
                        Option 2)

                        $ cd /EBS_12i_downloads/patches/AD_12.1.1/mergesource_dba_CPU_91795
                        $ ls *.zip > manifest.txt
                        $ admrgpch -admode -s . -d . -merge_name merger9179588 -manifest manifest.txt
                        • 39. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                          WF001
                          Thanks Hussein for your reply

                          I've already read the Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit) [ID 761569.1]

                          The Required Filesets & The Maintenance Tools are checked ok, and I 've download & installed the IBM XL C/C++ Utilities v11.1 (xlcpp.util.11.1.0.aix.base.tar.Z) only from the following link, but I still not found /usr/vac/bin/xlc file after installed.
                          http://www-01.ibm.com/support/docview.wss?uid=swg24026636

                          Thanks
                          Sam

                          Edited by: SamCH on 2013年1月2日 下午8:35
                          • 40. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                            EBSDBA
                            Hi,

                            Can you search for this file using find command?

                            #find /usr -name xlc

                            And i just checked in one of my instances, i found it

                            /usr/vacpp/bin/xlc

                            Thanks
                            • 41. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                              WF001
                              #find /usr -name xlc <-- can't find any results....

                              Thanks
                              Sam
                              • 42. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                                EBSDBA
                                Hi Sam,
                                #find /usr -name xlc <-- can't find any results....
                                
                                Thanks
                                Sam
                                That means it was not installed properly... Please check the README file carefully and try to install it again..


                                Thanks
                                • 43. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                                  Hussein Sawwan-Oracle
                                  SamCH wrote:
                                  Thanks Hussein for your reply

                                  I've already read the Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit) [ID 761569.1]

                                  The Required Filesets & The Maintenance Tools are checked ok, and I 've download & installed the IBM XL C/C++ Utilities v11.1 (xlcpp.util.11.1.0.aix.base.tar.Z) only from the following link, but I still not found /usr/vac/bin/xlc file after installed.
                                  http://www-01.ibm.com/support/docview.wss?uid=swg24026636

                                  Thanks
                                  Sam
                                  If it is installed, you should be able to issue "which xlc" as applmgr user.

                                  If it is not installed, please see http://www.ibm.com/Search/?q=Install+xlc&co=us&lo=any&sn=&lang=en&cc=US&en=utf&hpp=

                                  Thanks,
                                  Hussein
                                  • 44. Re: Upgrade 11i (11.5.10.2) to R12 (12.1.3)
                                    WF001
                                    Thanks for all to reply,

                                    I found the solution to avoid the xlC problem.
                                    - to set plsql_code_type = INTERPRETED in init file, and finishes the patch first. anyway , maybe not a good idea to use native plsql in 10g , you can use native sql after you upgrade to 11gR2

                                    But the next step, when I am applying the Merge patch 7303029 with Patch 6678700. After some time i got error

                                    Completed: file zxrentccmapping.sql on worker 7 for product zx username ZX.
                                    FAILED: file perdropallmodplsql.sql on worker 6 for product per username HR.
                                    Deferred: file perdropallmodplsql.sql on worker 6 for product per username HR. (Deferment number 1 for this job)
                                    Assigned: file perdropallmodplsql.sql on worker 6 for product per username HR.
                                    FAILED: file perdropallmodplsql.sql on worker 6 for product per username HR.

                                    There are now 133338 jobs remaining (current phase=A3):
                                    14 running, 0 ready to run and 133324 waiting.

                                    Deferred: file perdropallmodplsql.sql on worker 6 for product per username HR. (Deferment number 2 for this job)
                                    Assigned: file perdropallmodplsql.sql on worker 6 for product per username HR.
                                    FAILED: file perdropallmodplsql.sql on worker 6 for product per username HR.
                                    Completed: file EGOEXTDROP.sql on worker 2 for product ego username EGO.
                                    Completed: file perdrpindex.sql on worker 3 for product per username HR.
                                    Completed: file xlaaxtrg.sql on worker 5 for product xla username XLA.
                                    Completed: file wsm4377838.sql on worker 1 for product wsm username WSM.

                                    ************
                                    The log of AD worker 6 as below :

                                    Start time for statement below is: Fri Jan 04 2013 16:06:04

                                    DROP public synonym PAY_US_AFTER_TAX_DEDUCTIONS_V

                                    AD Worker error:
                                    The following ORACLE error:

                                    ORA-01031: insufficient privileges

                                    occurred while executing the SQL statement:

                                    DROP public synonym PAY_US_AFTER_TAX_DEDUCTIONS_V

                                    Error occurred in file

                                    $APPL_TOP/per/12.0.0/patch/115/sql/perdropallmodplsql.sql

                                    with arguments ''.

                                    Time when worker failed: Fri Jan 04 2013 16:06:04
                                    AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exiting.
                                    **************

                                    Any idea what should I do?

                                    Thanks
                                    Sam