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 JUNE 26, 2017

Applies to:

Oracle Application Object Library - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

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

Oracle E-Business Suite Setup Guide
Release 12.2
Part Number E22953-13

Oracle Applications Tablespace Model

Re-migration steps

 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms