How To Use OATM Tool to Migrate 12.2 EBS Database Objects into New Tablespaces Defined with Linux Bigfiles or Big Extents Space Management, or How To Reorganize the Database? (Doc ID 2064005.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Goal

Clarify options to use OATM on 12.2.2+ to implement a database reorganization or migration of EBS objects into a different tablespace (with Linux bigfiles or bigger size extent management than default 128K extents).

The 12.2 documentation   https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T432724.htm#oatm_utility_intro

The above explains how to introduce new tablespaces with bigger size extent management (1M), and how to migrate objects from an old tablespace into a new one using the OATM tool.

The goal is to migrate EBS 12.2 database objects to a new tablespace using Linux Bigfiles management or to other tablespaces with bigger extents than the default 128K (provided by Rapid Install for a new 12.2 install).  However when using the OATM process, many issues may be encountered including database catalog kernel corruption.

For example, on a 12.2.3 instance with 11.2.0.4.5 Database. When running the OATM report after migration there are multiple ORA-errors:

5. Display Sizing Exception report

Schema Object Error Code Population Date
------------------------------ ------------------------------ -------------------------------------------------- ---------------
APPS(Unclassfiled objects) AW$ODPCODE ORA-03207: subpartitioned type must be specified f 17-MAR-15
  or composite object
APPS(Unclassfiled objects) SYS_IL0000445661C00004$$ ORA-03207: subpartitioned type must be specified f 17-MAR-15
  or composite object
CSP(Classfiled objects) SYS_IL0000499345C00023$$ ORA-00600: internal error code, arguments: [ktsirc 17-MAR-15
  info_num1], [0], [0], [0], [], [], [], [], [], [],
  [], []
EAM(Classfiled objects) SYS_IL0000499482C00001$$ ORA-00600: internal error code, arguments: [ktsirc 17-MAR-15
  info_num1], [0], [0], [0], [], [], [], [], [], [],
  [], []

EGO(Classfiled objects) EGO_MTL_SY_ITEMS_EXT_B ORA-03207: subpartitioned type must be specified f 17-MAR-15
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.