Tag Archives: OATM

OATM tutorial part 6 Migration Status Reports

Last updated on September 13th, 2015 at 05:37 pmThe 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: … Continue reading OATM tutorial part 6 Migration Status Reports »

OATM Tutorial part 5 Execute Migration Commands

Last updated on September 13th, 2015 at 05:40 pmThe next space after generation of migration commmand would be executing the commands We need to follow below things before moving on this steps 1) Take a full backup of the database 2) The migration is very I/O intensive,So we need to make sure everything is good from OS and network perspective 3) Check all the database … Continue reading OATM Tutorial part 5 Execute Migration Commands »

OATM Tutorial part 4 Generate Migration commands

Last updated on September 13th, 2015 at 05:43 pm  The next space after tablespace creation would be generating migration commands [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 … Continue reading OATM Tutorial part 4 Generate Migration commands »

OATM tutorial Part 3 : Create New Tablespaces

Last updated on September 13th, 2015 at 05:45 pmCreate New Tablespaces Now we will need to create the new tablespace where data will be migrated 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 … Continue reading OATM tutorial Part 3 : Create New Tablespaces »

OATM Tutorial Part 2 Migration Sizing report

Last updated on September 13th, 2015 at 05:47 pmMigration Sizing report First step of OATM migration is to determine the Migration Sizing requirement through Option 1 of the OATM menu We need to run the OATM utlity through application manager OS owner. In this case we are assuming that to be applmgr [applmgr] cd $APPL_TOP/admin [applmgr] perl $FND_TOP/bin/fndtsmig.pl Enter OATM configuration file or press enter … Continue reading OATM Tutorial Part 2 Migration Sizing report »

OATM Lesson -1

Last updated on July 18th, 2015 at 05:04 pm OATM  stands for Oracle Application tablespace model. As per this new model, All the tables ,view etc are catagorized in followings  types Tablespace Type Usage TRANSACTION_TABLES (APPS_TS_TX_DATA )        Tables that contain transaction data TRANSACTION_INDEXES (APPS_TS_TX_IDX )        Indexes on transaction tables (separated to simplify rebuilds and recovery) REFERENCE (APPS_TS_SEED) Reference/setup data and indexes INTERFACE (APPS_TS_INTERFACE ) Interface/temporary data and … Continue reading OATM Lesson -1 »