This discussion is archived
1 2 3 4 5 6 12 Previous Next 173 Replies Latest reply: May 30, 2013 10:07 AM by Hussein Sawwan-Oracle Go to original post Branched to a new discussion. RSS
  • 45. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I am sorry to say that I have missed this step(Apply Patch 7303029 ) and went ahead and started applying upgrade driver(u6678700.drv ). It t ran and failed at this point.

    Completed: file XDPMIGFX.sql on worker 1 for product xdp username XDP.
    Completed: file RRSCRTYP.sql on worker 3 for product rrs username RRS.
    FAILED: file funmochk.sql on worker 4 for product fun username FUN.
    Deferred: file funmochk.sql on worker 4 for product fun username FUN. (Defer
    ment number 2 for this job)
    Assigned: file funmochk.sql on worker 1 for product fun username FUN.
    FAILED: file funmochk.sql on worker 1 for product fun username FUN.

    ATTENTION: All workers either have failed or are waiting:
    Please check the failed workers log files for details about the error.
    FAILED: file funmochk.sql on worker 1.

    ATTENTION: Please fix the above failed worker(s) so the manager can continue.
    Please see if (Does R12.1 Upgrade Require Multi-Org Even For Planning Instance? [ID 1083573.1]) is applicable.
    What is the impact?

    I have backup taken before this patch was applied.

    Can stop this and start applying 7303029 patch mention in eralier response?
    Apply Patch 7303029 using preinstall mode and see if you can restart the failed workers. If this does not help, then restore and apply this patch before running the main upgrade driver.

    Thanks,
    Hussein
  • 46. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    I have restored the database and started from following.

    As per the readme of 9179588:R12.AD.B from Oracle Applications Release Notes, Release 12.1.1 (Doc ID 798258.1)
    This is the step I re-did and emailed you log file.


    1. 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


    oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/au/12.0.0/patch/115/driver> admrgpch -d /data/rel12/apps/apps_st/appl/admin/LNXRES/merged -preinstall -master u6678700.drv

    Executing the merge of the patch drivers
    -- Processing file: /data/rel12/apps/apps_st/appl/admin/LNXRES/preinstall/u8969762.drv
    -- Done processing file: /data/rel12/apps/apps_st/appl/admin/LNXRES/preinstall/u8969762.drv
    -- Processing file: /data/rel12/apps/apps_st/appl/admin/LNXRES/preinstall/u7303029.drv
    -- Done processing file: /data/rel12/apps/apps_st/appl/admin/LNXRES/preinstall/u7303029.drv
    -- Processing file: u6678700.drv
    -- Done processing file: u6678700.drv
    3 unified drivers merged.

    Patch merge completed successfully

    Please check the log file at ./admrgpch.log.



    oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/admin/LNXRES/merged> ls -ltr
    total 80840
    -rw-r--r-- 1 oracle puppet 82693295 Feb 25 15:12 u_merged.drv

    Started U_merged.drv and this where process is right now.

    Skipping...
    Perform second half of mirrored copies for Specified driver
    since no such action is present for this driver file

    Skipping...
    Update Oracle Applications Java files for Specified driver
    since no such action is present for this driver file

    Skipping...
    Compile JSP files for Specified driver
    since no such action is present for this driver file
    or this APPL_TOP does not implement the "web" server type

    Number of invalid objects: 2

    Getting list of invalid objects in APPS schema.

    Invalid object reports are recorded in
    /data/rel12/apps/apps_st/appl/admin/LNXRES/log/02345_preenv.*
    Validating PL/SQL direct execute exceptions file ...

    Done validating PL/SQL direct execute exceptions file.

    JDBC connect string from AD_APPS_JDBC_URL is
  • 47. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    Thanks Hussein,

    I got the following error and I have emailed you the worker logs.

    Completed: file RRSCRTYP.sql on worker 2 for product rrs username RRS.
    Completed: file zpbctx.sql on worker 4 for product zpb username ZPB.
    FAILED: file funmochk.sql on worker 3 for product fun username FUN.
    Deferred: file funmochk.sql on worker 3 for product fun username FUN.
    (Deferment number 2 for this job)
    Assigned: file funmochk.sql on worker 1 for product fun username FUN.
    FAILED: file funmochk.sql on worker 1 for product fun username FUN.

    ATTENTION: All workers either have failed or are waiting:

    FAILED: file funmochk.sql on worker 1.

    ATTENTION: Please fix the above failed worker(s) so the manager can continue
  • 48. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I see this error in the logs:
    ORA-20000: Multi-Org architecture is not enabled. Please convert the target
    instance to enable Multi-Org before upgrading to Release 12
    ORA-06512: at line 19
    You need to enable multi-org on 11i instance before you run the R12 upgrade driver.

    Thanks,
    Hussein
  • 49. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    Hi Hussein,

    I can restore the database. How do I handle this?
    How can enable multi-org on HRMS 11i instance?
    Please give me direction.

    I see this in adadmin.

    Maintain Applications Database Entities
    ---------------------------------------------------

    1. Validate APPS schema

    2. Re-create grants and synonyms for APPS schema

    3. Maintain multi-lingual tables

    4. Check DUAL table

    5. Convert to Multiple Reporting Currencies

    6. Convert to Multi-Org

    7. Return to Main Menu










    Thanks.

    Edited by: user10994730 on Feb 26, 2013 7:37 AM
  • 50. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    You need to run "Convert to Multi-Org".

    FAQ - Multiple Organizations Architechure (Multi-Org) [ID 165042.1]
    Improved Convert to Multi-Org Process In Oracle Applications 11i [ID 208267.1]
    Use of Multiple Organizations In Oracle Applications Release 11i [ID 210193.1]
    Adadmin - Convert to Multi-Org Fails on Adworker [ID 183066.1]

    Thanks,
    Hussein
  • 51. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    As per the oracle support If you are on Family Pack K RUP 1 or later, then you need only to apply patch 5965493.

    We are on 11i HRMS Family Pack K Rollup 5.

    Applied 5965493

    Started enabling Multi org using adadmin and got this warning.

    Enabling Multi Org thru adadmin gave me following. I am uploading adadmin.log file too.

    AD_DEFERRED_JOBS table dropped.

    Re-enabling triggers in APPS...

    sqlplus -s APPS/***** @/data/lnxresappl/admin/LNXRES/out/orgcnvet_2344.sql

    Running sub driver "admocnv.drv"..

    Warning: File /data/lnxresappl/ar/11.5.0/patch/115/sql/arhmgmul.sql does not
    exist

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

    I have continued at this point.

    I do not see arhmgmul.sql in following directory.
    oracle@hmf-hrm-001:/data/lnxresappl/ar/11.5.0/patch/115/sql> ls -l arhmgmul*
    ls: cannot access arhmgmul*: No such file or directory


    As per the Error: The Order_type_id Column in The Hz_cust_accounts Table Must Be Null [ID 733760.1]

    SQL> SELECT multi_org_flag FROM fnd_product_groups WHERE product_group_id = 1;


    M
    -
    Y

    SQL> SQL> select multi_org_flag from fnd_product_groups;

    M
    -
    Y

    1 SELECT * FROM hz_cust_site_uses_all u WHERE EXISTS
    2 ( SELECT 1 FROM hz_cust_acct_sites_all site
    3 WHERE u.cust_acct_site_id = site.cust_acct_site_id
    4 AND EXISTS (SELECT 1
    5 FROM hz_cust_accounts acc
    6 WHERE (acc.primary_salesrep_id IS NOT NULL
    7 OR acc.order_type_id IS NOT NULL )
    8* AND site.cust_account_id = acc.cust_account_id) )
    SQL> /

    no rows selected


    Ran adadmin and see no Muti Org convertion option.

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

    Maintain Applications Database Entities
    ---------------------------------------------------

    1. Validate APPS schema

    2. Re-create grants and synonyms for APPS schema

    3. Maintain multi-lingual tables

    4. Check DUAL table

    5. Convert to Multiple Reporting Currencies

    6. Return to Main Menu




    Please advise If I am good to go.


    Thanks.

    Edited by: user10994730 on Mar 4, 2013 8:03 AM

    Edited by: user10994730 on Mar 4, 2013 8:07 AM
  • 52. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    You should be good to go. For the missing script, please see (Error: The Order_type_id Column in The Hz_cust_accounts Table Must Be Null [ID 733760.1]).

    Thanks,
    Hussein
  • 53. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    Thanks Hussein,

    I got the following errors while applying upgrade drivers.

    Assigned: file peaeiasd.sql on worker 3 for product per username HR.
    FAILED: file peaeiasd.sql on worker 3 for product per username HR.

    ATTENTION: All workers either have failed or are waiting:

    FAILED: file MSDODPCODE.sql on worker 1.
    FAILED: file hrorgasd.sql on worker 2.
    FAILED: file peaeiasd.sql on worker 3.
    FAILED: file hrleiasd.sql on worker 4.

    I did following for worker 1 error using Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292 Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE; ORA-33262: Analytic workspace ODPCODE does not exist. (Doc ID 1054417.1)

    do you have to bounce the database as per the Doc? After bouncing the database I can still continue with patching where it stopped?

    oracle@hmf-odb-001:~> sqlplus "/as sysdba"

    SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 6 09:50:22 2013

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


    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> select username ,account_status from dba_users where username like '%OLAP%';

    USERNAME ACCOUNT_STATUS
    ------------------------------ --------------------------------
    OLAPSYS EXPIRED & LOCKED

    SQL> alter user OLAPSYS identified by xxxxxxxx ACCOUNT UNLOCK;

    User altered.

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    oracle@hmf-odb-001:~> sqlplus

    SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 6 09:53:32 2013

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

    Enter user-name: apps
    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> begin
    2 dbms_aw.execute('aw create odpcode');
    3 end;
    4 /

    PL/SQL procedure successfully completed.

    SQL>


    Regarding other workers 2,3,4 I am following this R12.1: Upgrade Patch 6678700 Fails on APPS.HR_API_USER_HOOKS_UTILITY [ID 1174964.1] and I do not know which one I follow under following.

    PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS
    PER_ASG_AGGR.SET_PAYE_AGGR
    PER_US_ADD_LEG_HOOK.UPDATE_US_ADDRESS

    I mean which patches to apply after upgrade or do you I have to apply any patches reverting back to 11i start all over again?


    Emailed you the all the workers log files.



    Again I do appreciate your time and patience.

    Thanks.
  • 54. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Regarding other workers 2,3,4 I am following this R12.1: Upgrade Patch 6678700 Fails on APPS.HR_API_USER_HOOKS_UTILITY [ID 1174964.1] and I do not know which one I follow under following.

    PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS
    PER_ASG_AGGR.SET_PAYE_AGGR
    PER_US_ADD_LEG_HOOK.UPDATE_US_ADDRESS

    I mean which patches to apply after upgrade or do you I have to apply any patches reverting back to 11i start all over again?
    Apply all R12 patches after the upgrade. In the furture, please add those 11i user-hooks patches to your upgrade doc and make sure they are applied before upgrading to R12.

    Thanks,
    Hussein
  • 55. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    Thanks Hussein,

    I skipped those workers using hidden 8th option using adctrl.

    Enter your choice [1] : 8

    Enter the worker number(s)/range(s) or 'all' for all workers,
    or press [Return] to go back to the menu : all

    Status changed to 'Skip & restart' for worker 1.
    Status changed to 'Skip & restart' for worker 2.
    Status changed to 'Skip & restart' for worker 3.
    Status changed to 'Skip & restart' for worker 4.

    Still getting other errors and eamiled you the log files.


    ATTENTION: All workers either have failed or are waiting:

    FAILED: file peasgasd.sql on worker 1.
    FAILED: file peaddasd.sql on worker 2.
    FAILED: file LoadMap.class on worker 3.
    FAILED: file peaeirsd.sql on worker 4.

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


    Since worker 3 error is Oracle Exchange Marketplace. I can skip this module correct?
  • 56. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user10994730 wrote:
    Thanks Hussein,

    I skipped those workers using hidden 8th option using adctrl.

    Enter your choice [1] : 8

    Enter the worker number(s)/range(s) or 'all' for all workers,
    or press [Return] to go back to the menu : all

    Status changed to 'Skip & restart' for worker 1.
    Status changed to 'Skip & restart' for worker 2.
    Status changed to 'Skip & restart' for worker 3.
    Status changed to 'Skip & restart' for worker 4.

    Still getting other errors and eamiled you the log files.


    ATTENTION: All workers either have failed or are waiting:

    FAILED: file peasgasd.sql on worker 1.
    FAILED: file peaddasd.sql on worker 2.
    FAILED: file LoadMap.class on worker 3.
    FAILED: file peaeirsd.sql on worker 4.

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


    Since worker 3 error is Oracle Exchange Marketplace. I can skip this module correct?
    What is the error you get in the worker log file? If it is related to the module which are not used then you can skip it.

    Thanks,
    Hussein
  • 57. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    These are errors I was getting from worker 1,2,4 files.
    This was the same error we were getting before I skipped them 8th option using adctrl.

    ERROR at line 1:
    ORA-06501: PL/SQL: program error
    ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891
    ORA-06512: at line 1


    Thanks.
  • 58. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user10994730 wrote:
    These are errors I was getting from worker 1,2,4 files.
    This was the same error we were getting before I skipped them 8th option using adctrl.

    ERROR at line 1:
    ORA-06501: PL/SQL: program error
    ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891
    ORA-06512: at line 1


    Thanks.
    You need to skip them again.

    Thanks,
    Hussein
  • 59. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
    user10994730 Newbie
    Currently Being Moderated
    I did and I amgetting following errors.

    ATTENTION: All workers either have failed or are waiting:

    FAILED: file pephnasd.sql on worker 1.
    FAILED: file pereirsd.sql on worker 2.
    FAILED: file XDOLoader.class on worker 3.
    FAILED: file XDOLoader.class on worker 4.

    This is in worker 3 and 4.

    arget file: POXPOCOM_XML.rtf
    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


    Thanks.
1 2 3 4 5 6 12 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points