This discussion is archived
6 Replies Latest reply: May 6, 2011 10:49 AM by Hussein Sawwan-Oracle RSS

**Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12

user253724 Newbie
Currently Being Moderated
Hi Guys

I gone through the Doc ID 761570.1


And I have chosen to follow the PATH -C Which has two down times.

In the first down time planing to Upgrade the Database.

But.......

I had a question..

My current database is running on 32-bit. Target Database is planing to use the 64-bit


Will my application support.......

By keeping the application tier on 32-bit as it is and Upgrading the Database to a 64-bit 11gr2

Thanks guys for taking a look at my issue its very Urgent..


Thanks
Bhupesh...........
  • 1. Re: **Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    My current database is running on 32-bit. Target Database is planing to use the 64-bit

    Will my application support.......

    By keeping the application tier on 32-bit as it is and Upgrading the Database to a 64-bit 11gr2
    Yes.

    11gR2 11.2.0.2 Database Certified with E-Business Suite
    http://blogs.oracle.com/stevenChan/2010/11/db_11gr2_11202_ebs.html

    Frequently Asked Questions: Oracle E-Business Suite Support on x86-64 [ID 343917.1]

    Thanks,
    Hussein
  • 2. Re: **Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12
    user253724 Newbie
    Currently Being Moderated
    Hi

    Thanks for the reply.



    The problem is I want to use E-Business suite as below after my DB Upgrade

    DB Tier is : 64-Bit (11gR2)
    Apps Tier : 32-Bit (11.5.10.2)

    Will my apps tier(32-Bit) be able to communicate with 64-Bit DB Tier.

    Sure I will go through the refereed doc's as soon as possible.


    Thanks
    Bhupesh...................
  • 3. Re: **Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    The problem is I want to use E-Business suite as below after my DB Upgrade

    DB Tier is : 64-Bit (11gR2)
    Apps Tier : 32-Bit (11.5.10.2)

    Will my apps tier(32-Bit) be able to communicate with 64-Bit DB Tier.
    Yes (this is called Split Configuration) -- See (Using Oracle EBS with a Split Configuration Database Tier on 11gR2 [ID 946413.1]) for details.

    Thanks,
    Hussein
  • 5. Re: **Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12
    user253724 Newbie
    Currently Being Moderated
    Hi Hussen

    Hi

    I have upgraded the database from 10gr2 to 11gr2.

    In the alert log I finding these errors

    #####################################################
    Mon Apr 25 11:15:55 2011
    Errors in file /u02/oracle/diag/rdbms/gltst/gltst1/trace/gltst1_j000_6792.trc:
    ORA-12012: error on auto execute of job "SYS"."KWQICPOSTMSGDEL_1303744554"
    ORA-28031: maximum of 148 enabled roles exceeded
    Errors in file /u02/oracle/diag/rdbms/gltst/gltst1/trace/gltst1_j000_6792.trc:
    ORA-28031: maximum of 148 enabled roles exceeded
    ORA-12012: error on auto execute of job "SYS"."KWQICPOSTMSGDEL_1303744554"
    ORA-28031: maximum of 148 enabled roles exceeded

    ###########gltst1_j000_6792.trc###################
    *** 2011-04-25 11:15:55.038
    *** SESSION ID:(155.63) 2011-04-25 11:15:55.038
    *** CLIENT ID:() 2011-04-25 11:15:55.038
    *** SERVICE NAME:(SYS$USERS) 2011-04-25 11:15:55.038
    *** MODULE NAME:() 2011-04-25 11:15:55.038
    *** ACTION NAME:() 2011-04-25 11:15:55.038

    ORA-12012: error on auto execute of job "SYS"."KWQICPOSTMSGDEL_1303744554"
    ORA-28031: maximum of 148 enabled roles exceeded
    Unexpected error 28031 in job slave process
    ORA-28031: maximum of 148 enabled roles exceeded
    ORA-12012: error on auto execute of job "SYS"."KWQICPOSTMSGDEL_1303744554"
    ORA-28031: maximum of 148 enabled roles exceeded
    ###########################################################


    Under sys user these jobs are keeps on growing.


    I have looked into the metalink note : 1115495_1. And I am not using any streams, my database is for E-Business suite 11.5.10.2.

    Thanks
    Reddy
  • 6. Re: **Urgent*** Oracle E-business suite Upgrade 11.5.10.2 to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Reddy,

    Please see these docs.

    What to Check When Dealing With Ora-28031: Maximum Of 148 Enabled Roles Exceeded? [ID 778785.1]
    Complete Checklist for Manual Upgrades to 11gR1 [ID 429825.1] -- 2. Upgrade will fail with an "ORA-28031: maximum of 148 enabled roles exceeded"

    Thanks,
    Hussein

Legend

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