OATM tutorial part 6 Migration Status Reports



Last updated on September 13th, 2015 at 05:37 pm

The next space when execution of migration command happen would be to check and monitor it. How much it is completed

[applmgr] cd $APPL_TOP/admin
[applmgr] perl $FND_TOP/bin/fndtsmig.pl
Enter OATM configuration file or press enter to continue: <ENTER>
Enter APPL_TOP[/xyz/oracle/xyzappl]: <ENTER>
Enter FND_TOP[/xyz/oracle/xyzappl/fnd/11.5.0]: <ENTER>
Enter the Database Connect String[TEST]: <ENTER>
Enter the password for your ‘SYSTEM’ ORACLE schema: <SYSTEM-Password>
Please create log directory /xyz/oracle/xyzappl/admin/test/log to continue: Create the path
Enter the ORACLE APPS Schema name[APPS]: <ENTER>
Enter the password for APPS: <APPS-Password>
Enter the ORACLE Application Object Library [APPLSYS]: <ENTER>
================================================================

================================================================
CONNECT_STRING=TEST
FND_TOP=/xyz/oracle/xyzappl/fnd/11.5.0
APPLSYS_SCHEMA=APPLSYS
APPS_SCHEMA=APPS
APPL_TOP=/xyz/oracle/xyzappl
================================================================

Please review: press ‘Y’ to accept or ‘N’ to re-enter[Y]: <ENTER>
Oracle Applications Tablespace Migration Utility

Main Menu
1. Migration Sizing Reports
2. Create New Tablespaces
3. Generate Migration Commands
4. Execute Migration Commands
5. Run Migration Status Reports
6. Run Post Migration Steps
7. Run Customization Steps
8. Run Migration in Batch Mode

[Q]uit [N]ext

Please enter your option – 5

Migration Process Report

Run Migration Status Reports

1. Run migration progress report
2. Run migration error report

[Q]uit [B]ack [N]ext

Please enter your option – 1

Migration Error Report

Run Migration Status Reports

1. Run migration progress report
2. Run migration error report

[Q]uit [B]ack [N]ext
a) It will give us report how much it is completed in % term.
b) We should be able to monitor the migration through sqlplus also
SELECT status, module, sid, serial#
FROM v$session
WHERE module in
(‘TS_MIGRATE_SEQUENTIAL_OBJECTS’,
‘TS_MIGRATE_PARALLEL_OBJECTS’, ‘TS_MIGRATE_LONGS’,
‘TS_SIZING’, ‘TS_GEN_SCRIPT’, ‘TS_SET_DEFAULTS’,
‘TS_CREATE_TABLESPACE’, ‘TS_DISABLE_CMDS’,
‘TS_GENERATE_STATEMENTS’, ‘TS_POSTMIGRATION_STEPS’)
AND status <> ‘KILLED’;

We can run option 2 at time to find if any error happened in some objects

Migration Process Report

Run Migration Status Reports

1. Run migration progress report
2. Run migration error report

[Q]uit [B]ack [N]ext

Please enter your option – 2
Enter the Schema name[%] <Enter>

Migration Error Report

All the related OATM material are

OATM lesson 1

Migration sizing report

Generate Migration commands

Execute Migration command


Leave a Reply