3 Replies Latest reply: Jan 30, 2011 10:50 AM by Hussein Sawwan-Oracle RSS

    oracle database upgrade from 9.2.0.8 to 11.2.0.2 in ebs 11i

    748183
      Hi friends,

      We are planing to upgrade our database from 9.2.0.8 to 11.2.0.2 in EBS 11.5.10.2 with OS upgradation from IBM AIX 5.3 to 6.1 & we are planning to implement "Oracle Applicaiton Tablespace Model".Hence I need suggestion from you ,we need to implenment this OATM before database & OS upgradation or not.


      Kinldy provide the suitable documents & direction to upgrade database & OS with OATM.


      Thanks,
      Rathinavel
        • 1. Re: oracle database upgrade from 9.2.0.8 to 11.2.0.2 in ebs 11i
          Hussein Sawwan-Oracle
          Hence I need suggestion from you ,we need to implenment this OATM before database & OS upgradation or not.
          I believe it does not matter if you convert to OATM before or after the DB/OS upgrade.
          Kinldy provide the suitable documents & direction to upgrade database & OS with OATM.
          For OATM, please see these docs.

          Note: 248857.1 - Oracle Applications Tablespace Model Release 11i - Tablespace Migration Utility
          Note: 269293.1 - Oracle Applications Tablespace Model FAQs
          Note: 418225.1 - OATM FAQ
          Note: 404954.1 - How to run OATM migration utility
          Note: 463271.1 - How to move objects left in the old tablespace after OATM migration?
          Note: 391483.1 - How to refresh Materialized Views after migrating to the OATM Model

          For upgrading the database from 9i to 11gR2, please refer to these docs (it is the same procedure if your database is OATM or not).

          11gR2 Database Certified with E-Business Suite 11i
          http://blogs.oracle.com/stevenChan/2009/10/db11gr2_certified_ebs11i.html

          Interoperability Notes - Oracle E-Business Suite Release 11i with Oracle Database 11g Release 2 (11.2.0) (Note: 881505.1)
          Database Initialization Parameters for Oracle Applications Release 11i (Note: 216205.1)
          SP2-1503 SP2-0152 with new 11.2 installation (Note: 974515.1)

          It is also worth reviewing these docs:

          Ad_parallel_compile: Ora-01031: Insufficient Privileges in adadmin / re-create grants and synonyms for APPS schema after upgrade from 10gR2 to 11gR2 (Note: 1148264.1)
          Adstats.sql Fails While Upgrading Database to 11gR2 (Note: 1232853.1)
          After RDBMS Upgrade To 11gR2 In An Applications 11i Environment: ORA-20000 DRG-100[51021],[Drwaf.C],[1605],[],[] ORA-4088 (Note: 1104963.1)
          Error PLS-00801: Internal Error [1401] When Compiling Invalid Apps Objects (Note: 784179.1)

          Thanks,
          Hussein
          • 2. Re: oracle database upgrade from 9.2.0.8 to 11.2.0.2 in ebs 11i
            748183
            Hi,

            As per this doc "Interoperability Notes - Oracle E-Business Suite Release 11i with Oracle Database 11g Release 2 (11.2.0) (Note: 881505.1)"
            how can i check whether we are using oracle portal 3.0.9 or not .


            Kinldy help me.

            Thanks,
            Rathinavel
            • 3. Re: oracle database upgrade from 9.2.0.8 to 11.2.0.2 in ebs 11i
              Hussein Sawwan-Oracle
              Please see these docs.

              Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i [ID 233436.1]
              How to Remove Oracle Portal 3.0.9 from E-Business Suite 11i [ID 312349.1]

              Thanks,
              Hussein