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 »

Last updated on September 17th, 2017 at 12:36 pmOracle applications tablespace Migration The next space after generation of migration command would be executing the commands.Here is  the final Oracle applications tablespace Migration happens 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 … Continue reading Oracle applications tablespace Migration Tutorial part 5 »

Last updated on September 17th, 2017 at 12:24 pmThe 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 the … Continue reading OATM migration R12 Tutorial part 4 »

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 »

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 »

Last updated on September 17th, 2017 at 12:17 pmOATM  stands for Oracle Applications 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 indexes … Continue reading Oracle Applications tablespace model (OATM) Lesson -1 »