6 Replies Latest reply: May 6, 2011 12:49 PM by Hussein Sawwan-Oracle RSS

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

    user253724
      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
          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
            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
              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
                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
                  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