1 3 4 5 6 7 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
      • 60. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
        Hussein Sawwan-Oracle
        Creating a new record in XDO_LOBS: POXPOCOM_XML.rtf
        ORA-01691: unable to extend lob segment XDO.SYS_LOB0000207806C00010$$ by 1024 in
        tablespace XDOD
        You need to add more space.

        OERR: ORA 1691 unable to extend lob segment %s.%s by %s in tablespace %s [ID 48851.1]
        ORA-1691:Unable to Extend LOB Segment However the datafiles are auto extensible [ID 758346.1]

        Thanks,
        Hussein
        • 61. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
          user10994730
          I put those tablespaces in autoextend on maxsize unlimited for worker 3,4 and skipped worker 1,2.

          Now I do see process moving.

          Thanks.
          • 62. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
            user10994730
            Completed: file wshhrlsd.sql on worker 3 for product wsh username WSH.
            Assigned: file zxgnrlocpsd.sql on worker 3 for product zx username ZX.
            Completed: file zxgnrlocpsd.sql on worker 3 for product zx username ZX.
            Assigned: file zxhropsd.sql on worker 3 for product zx username ZX.
            Completed: file hraudpsdg.sql on worker 2 for product per username HR.
            Assigned: file zxreplocpsd.sql on worker 2 for product zx username ZX.
            Completed: file zxhropsd.sql on worker 3 for product zx username ZX.
            Completed: file zxreplocpsd.sql on worker 2 for product zx username ZX.
            Completed: file oklpostimportaad.sql on worker 4 for product okl username OKL.


            This where it is taking long time in worker 1 log. Almost an hour. Any idea?
            Since we r not using Oracle Process Manufacturing, can I skip the worker to save time?



            Start time for file is: Wed Mar 06 2013 14:34:22

            sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/gmf/12.0.0/patch/115/sql/gm
            fpostimportaad.sql

            Thanks

            Edited by: user10994730 on Mar 6, 2013 12:44 PM
            • 63. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
              user10994730
              Got these errors... Uploading log files.

              There are now 11728 jobs remaining (current phase=A176):
              3 running, 26 ready to run and 11699 waiting.

              Deferred: file rrsintegrator.ldt on worker 1 for product rrs username APPS.
              (Deferment number 2 for this job)
              Assigned: file glbwint.ldt on worker 1 for product gl username APPS.
              Program completed successfully

              FAILED: file pqpriwintg.ldt on worker 4 for product pqp username APPS.
              Deferred: file pqpriwintg.ldt on worker 4 for product pqp username APPS.
              (Deferment number 2 for this job)
              Assigned: file egobneintegrator.ldt on worker 4 for product ego username APPS.
              Program completed successfully

              FAILED: file gcsadentryintg.ldt on worker 3 for product gcs username APPS.
              Program completed successfully

              FAILED: file funicintegrator.ldt on worker 2 for product fun username APPS.
              Program completed successfully

              FAILED: file glbwint.ldt on worker 1 for product gl username APPS.
              Program completed successfully

              FAILED: file egobneintegrator.ldt on worker 4 for product ego username APPS.

              ATTENTION: All workers either have failed or are waiting:

              FAILED: file glbwint.ldt on worker 1.
              FAILED: file funicintegrator.ldt on worker 2.
              FAILED: file gcsadentryintg.ldt on worker 3.
              FAILED: file egobneintegrator.ldt on worker 4.

              ATTENTION: Please fix the above failed worker(s) so the manager can continue.

              oracle@hmf-hrm-001:/tmp>
              • 64. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                user10994730
                Resolved after increasing the BNE tablespace with autoextend on maxsize unlimited and the process moving forward.


                This is the error in following logfiles.
                for worker 1:
                /data/rel12/apps/apps_st/appl/admin/LNXRES/log/US_glbwint_ldt.log

                for worker 2:
                /data/rel12/apps/apps_st/appl/admin/LNXRES/log/US_funicintegrator_ldt.log

                for worker 3:
                /data/rel12/apps/apps_st/appl/admin/LNXRES/log/US_gcsadentryintg_ldt.log

                for worker 4:
                /data/rel12/apps/apps_st/appl/admin/LNXRES/log/US_egobneintegrator_ldt.log

                Error loading seed data for BNE_PARAM_LIST_ITEMS: PARAM_LIST_ASN = FUN, PARAM
                LISTCODE = FUN_SINGLE_BATCH, SEQUENCE_NUM = 1, ORA-01653: unable to extend ta
                ble BNE.BNE_PARAM_LIST_ITEMS by 128 in tablespace BNED
                ORA-06512: at "APPS.BNE_PARAM_LIST_ITEMS_PKG", line 33
                ORA-06512: at "APPS.BNE_PARAM_LIST_ITEMS_PKG", line 329
                ORA-01403: no data found

                Thanks.
                • 65. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                  Hussein Sawwan-Oracle
                  ORA-01653: unable to extend table BNE.BNE_PARAM_LIST_ITEMS by 128 in tablespace BNED
                  You need to add more space to this tablespace.

                  Thanks,
                  Hussein
                  • 66. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                    user10994730
                    Thanks Hussein,
                    The following r running for a while. Is it OK? We do not use these modules.

                    Control
                    Worker Code Context Filename Status
                    ------ -------- ----------------- -------------------------- --------------
                    1 Run AutoPatch R120 pl papostimportaad.sql Running
                    2 Run AutoPatch R120 pl Wait
                    3 Run AutoPatch R120 pl cstpostimportaad.sql Running
                    4 Run AutoPatch R120 pl appostimportaad.sql Running

                    Completed: file zxgeostructmig.sql on worker 2 for product zx username ZX.
                    Assigned: file zxinitialize.sql on worker 2 for product zx username ZX.
                    Completed: file zxinitialize.sql on worker 2 for product zx username ZX.
                    Assigned: file zxmastergeoseq.sql on worker 2 for product zx username ZX.
                    Completed: file zxmastergeoseq.sql on worker 2 for product zx username ZX.
                    Assigned: file zxmigrateouptp.sql on worker 2 for product zx username ZX.
                    Completed: file zxmigrateouptp.sql on worker 2 for product zx username ZX.
                    Assigned: file zxmigrateprdopt.sql on worker 2 for product zx username ZX.
                    Completed: file zxmigrateprdopt.sql on worker 2 for product zx username ZX.
                    Assigned: file zxmigregimes.sql on worker 2 for product zx username ZX.
                    Completed: file zxmigregimes.sql on worker 2 for product zx username ZX.
                    Assigned: file apwuprl1.sql on worker 2 for product ap username AP.
                    Completed: file apwuprl1.sql on worker 2 for product ap username AP.
                    Assigned: file apwuprl1.sql on worker 2 for product ap username AP.
                    Completed: file apwuprl1.sql on worker 2 for product ap username AP.
                    • 67. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                      Hussein Sawwan-Oracle
                      It is OK. Please also see (R12 patch seems to hang in adobjcmp.sql or appostimportaad.sql or fapostimportaad.sql [ID 748501.1]).

                      Thanks,
                      Hussein
                      • 68. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                        user10994730
                        Still the following are running.
                        Worker Code Context Filename Status
                        ------ -------- ----------------- -------------------------- --------------
                        1 Run AutoPatch R120 pl papostimportaad.sql Running
                        2 Run AutoPatch R120 pl Wait
                        3 Run AutoPatch R120 pl cstpostimportaad.sql Running
                        4 Run AutoPatch R120 pl appostimportaad.sql Running


                        As per the note:748501.1 if the following query returns one or more rows do rest of the steps in that note. There are Zero row so I will wait for few more hrs.

                        SQL> select object_name from dba_objects where object_name like 'XLA_00200_AAD_S_0000%' and status='INVALID';

                        no rows selected

                        SQL> exit
                        • 69. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                          Hussein Sawwan-Oracle
                          user10994730 wrote:
                          Still the following are running.
                          Worker Code Context Filename Status
                          ------ -------- ----------------- -------------------------- --------------
                          1 Run AutoPatch R120 pl papostimportaad.sql Running
                          2 Run AutoPatch R120 pl Wait
                          3 Run AutoPatch R120 pl cstpostimportaad.sql Running
                          4 Run AutoPatch R120 pl appostimportaad.sql Running


                          As per the note:748501.1 if the following query returns one or more rows do rest of the steps in that note. There are Zero row so I will wait for few more hrs.

                          SQL> select object_name from dba_objects where object_name like 'XLA_00200_AAD_S_0000%' and status='INVALID';

                          no rows selected

                          SQL> exit
                          If the query returns no rows then ignore the steps in the doc.

                          Thanks,
                          Hussein
                          • 70. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                            user10994730
                            Thanks Hussein.
                            This was only one left and was running more than 4 hrs. I had to fail this worker by following steps.

                            Worker Code Context Filename Status
                            ------ -------- ----------------- -------------------------- --------------
                            1 Run AutoPatch R120 pl Wait
                            2 Run AutoPatch R120 pl Wait
                            3 Run AutoPatch R120 pl cstpostimportaad.sql Running
                            4 Run AutoPatch R120 pl Wait


                            Run the "AD Controller Utility" (adctrl) and first failed the job and then tell the worker to quit, picking options:
                            4. Tell manager that a worker failed its job
                            and then
                            3. Tell worker to quit




                            Completed: file appostimportaad.sql on worker 4 for product ap username AP.
                            Completed: file papostimportaad.sql on worker 1 for product pa username PA.
                            FAILED: file cstpostimportaad.sql on worker 3 for product bom username BOM.
                            Deferred: file cstpostimportaad.sql on worker 3 for product bom username BOM.
                            (Deferment number 1 for this job)
                            Assigned: file cstpostimportaad.sql on worker 1 for product bom username BOM.

                            There are now 5410 jobs remaining (current phase=A245):
                            1 running, 0 ready to run and 5409 waiting.

                            Completed: file cstpostimportaad.sql on worker 1 for product bom username BOM.

                            Starting phase 246 (A246): upg+71

                            There are now 5409 jobs remaining (current phase=A246):
                            0 running, 7 ready to run and 5402 waiting.

                            Assigned: file cstupginit.sql on worker 1 for product bom username BOM.
                            Assigned: file lns120lnsprodtlins.sql on worker 2 for product lns username LNS
                            .
                            Assigned: file lns120rloantypesins.sql on worker 3 for product lns username LN
                            S.
                            Assigned: file OKLTRUPG.sql on worker 4 for product okl username OKL.
                            Completed: file cstupginit.sql on worker 1 for product bom username BOM.
                            Assigned: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Completed: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Assigned: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Completed: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Assigned: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Completed: file OKLTRUPG.sql on worker 1 for product okl username OKL.
                            Completed: file lns120lnsprodtlins.sql on worker 2 for product lns username LNS
                            .
                            Completed: file OKLTRUPG.sql on worker 4 for product okl username OKL.

                            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/admin/LNXRES/log> tail -f adwor
                            k003.log

                            Time when worker completed job: Thu Mar 07 2013 10:49:51

                            Time when worker started job: Thu Mar 07 2013 10:49:51

                            Start time for file is: Thu Mar 07 2013 10:49:51

                            sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/bom/12.0.0/patch/115/sql/cs
                            tpostimportaad.sql

                            oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/admin/LNXRES/log> tail -f adwor
                            k004.log
                            sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/okl/12.0.0/patch/115/sql/OK
                            LTRUPG.sql &un_okl &batchsize 1 4

                            PL/SQL procedure successfully completed.

                            Commit complete.

                            Time when worker completed job: Thu Mar 07 2013 14:32:17

                            racle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/admin/LNXRES/log> tail -f adwork
                            002.log
                            sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/lns/12.0.0/patch/115/sql/ln
                            s120lnsprodtlins.sql

                            PL/SQL procedure successfully completed.

                            Commit complete.

                            Time when worker completed job: Thu Mar 07 2013 14:32:12

                            sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/okl/12.0.0/patch/115/sql/OK
                            LTRUPG.sql &un_okl &batchsize 4 4

                            PL/SQL procedure successfully completed.

                            Commit complete.

                            Time when worker completed job: Thu Mar 07 2013 14:32:11

                            Control
                            Worker Code Context Filename Status
                            ------ -------- ----------------- -------------------------- --------------
                            1 Run AutoPatch R120 pl Wait
                            2 Run AutoPatch R120 pl Wait
                            3 Quit AutoPatch R120 pl lns120rloantypesins.sql Assigned
                            4 Run AutoPatch R120 pl Wait

                            Review the messages above, then press [Return] to continue.

                            oracle@hmf-hrm-001:/tmp>


                            Why is worker 3 is Quit and ssigned?
                            • 71. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                              Hussein Sawwan-Oracle
                              Why is worker 3 is Quit and ssigned?
                              Please check the worker log file for details about this script.

                              Thanks,
                              Hussein
                              • 72. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                jagadeesha
                                Hi,

                                Can you please check and let us know what is the wait event for this adworker session.

                                Cheers,
                                Jagadeesha
                                • 73. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                  user10994730
                                  there's a note which is new not yest published in MOS as per oracle supportfor that script too.
                                  Long Running Cstpostimportaad.sql while upgrade to R12.1.1 (Doc ID 1453612.1)

                                  as it says, you can skip it if it takes too long. I skipped this.

                                  Control
                                  Worker Code Context Filename Status
                                  ------ -------- ----------------- -------------------------- --------------
                                  1 Run AutoPatch R120 pl cstmtaupg.sql Running
                                  2 Run AutoPatch R120 pl cstmtaupg.sql Running
                                  3 Run AutoPatch R120 pl cstmtaupg.sql Running
                                  4 Run AutoPatch R120 pl cstmtaupg.sql Running

                                  Review the messages above, then press [Return] to continue.

                                  oracle@hmf-hrm-001:/tmp>


                                  Process is moving.
                                  Completed: file ponUpgAucItemPrc.sql on worker 1 for product pon username PON.
                                  Completed: file ponUpgAucItemPrc.sql on worker 3 for product pon username PON.
                                  Assigned: file ponUpgBidAttrVal.sql on worker 1 for product pon username PON.
                                  Assigned: file ponUpgBidAttrVal.sql on worker 3 for product pon username PON.
                                  Completed: file ponUpgAucItemPrc.sql on worker 2 for product pon username PON.
                                  Assigned: file ponUpgBidAttrVal.sql on worker 2 for product pon username PON.
                                  Completed: file ponUpgAucItemPrc.sql on worker 4 for product pon username PON.
                                  Assigned: file ponUpgBidAttrVal.sql on worker 4 for product pon username PO



                                  Now I ahve another issue.

                                  ATTENTION: Please fix the above failed worker(s) so the manager can continue.

                                  ATTENTION: Please fix the above failed worker(s) so the manager can continue.

                                  Completed: file pepkstu.sql on worker 3 for product per username HR.

                                  ATTENTION: All workers either have failed or are waiting:

                                  FAILED: file biv_b_age_h_sum_mv.xdf on worker 2.
                                  FAILED: file peehrgeo.sql on worker 4.


                                  Worker 3 has following.
                                  sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/sql/pe
                                  pkstu.sql &un_per &pw_per &index_tspace
                                  declare
                                  *
                                  ERROR at line 1:
                                  ORA-01408: such column list already indexed
                                  ORA-06512: at "SYS.DBMS_SQL", line 1199
                                  ORA-06512: at line 67



                                  Worker 4 has following.

                                  qlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/sql/pe
                                  pkstu.sql &un_per &pw_per &index_tspace
                                  declare
                                  *
                                  ERROR at line 1:
                                  ORA-01408: such column list already indexed
                                  ORA-06512: at "SYS.DBMS_SQL", line 1199
                                  ORA-06512: at line 67

                                  Time when worker failed: Thu Mar 07 2013 16:08:41

                                  Time when worker started job: Thu Mar 07 2013 16:08:41

                                  Start time for file is: Thu Mar 07 2013 16:08:41

                                  sql /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql &un_per
                                  &pw_per

                                  Start time for statement below is: Thu Mar 07 2013 16:08:41

                                  CONNECT HR/*****

                                  Connecting to HR......Connected successfully.

                                  Start time for statement below is: Thu Mar 07 2013 16:08:41

                                  ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
                                  HR_S_US_CITY_GEOCODES_PK

                                  AD Worker error:
                                  The following ORACLE error:

                                  ORA-02430: cannot enable constraint (HR_S_US_CITY_GEOCODES_PK) - no such constra
                                  int

                                  occurred while executing the SQL statement:

                                  ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
                                  HR_S_US_CITY_GEOCODES_PK

                                  Error occurred in file

                                  /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql

                                  with arguments '&un_per &pw_per'.

                                  Time when worker failed: Thu Mar 07 2013 16:08:42
                                  AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exit


                                  Please advise. Emailed you log files.

                                  Edited by: user10994730 on Mar 8, 2013 6:44 AM
                                  • 74. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                    Hussein Sawwan-Oracle
                                    Worker 3 has following.
                                    sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/per/12.0.0/patch/115/sql/pe
                                    pkstu.sql &un_per &pw_per &index_tspace
                                    declare
                                    *
                                    ERROR at line 1:
                                    ORA-01408: such column list already indexed
                                    ORA-06512: at "SYS.DBMS_SQL", line 1199
                                    ORA-06512: at line 67
                                    Do you have any custom indexes? -- GL Optimizer (RGOPTM) Errors With ORA-01408 And ORA-06512 [ID 789373.1]

                                    If yes, those indexes should be disabled before the upgrade.

                                    Thanks,
                                    Hussein
                                    1 3 4 5 6 7 Previous Next