This content has been marked as final. Show 3 replies
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
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,[Drwaf.C],,, ORA-4088 (Note: 1104963.1)
Error PLS-00801: Internal Error  When Compiling Invalid Apps Objects (Note: 784179.1)