Oraclemakeeasy | Solutions for databases



OATM ConversionThis section covers required steps to convert Oracle E-Business tablespaces to OATM format. Reset FPA user password using FNDCPASS commandFNDCPASS apps/$apps_password 0 Y system/$system_password ORACLE FPA fpa_pwdFix FPA Indexsqlplus fpa/fpa<<EOFspool deleting.logset serveroutput onexec dbms_aw.execute('aw delete FPAPJP');commit;spool offEOFEnabe CTXSYS Schema in Oracle Apps Logon to Oracle Applications with the System AdministratorResponsibility. Navigate to Security -> ORACLE -> RegisterQuery for CTXSYS schema and Set Privilege to “Enabled”.Disable Custom SchemasLogon to Oracle Applications with the System AdministratorResponsibility. Navigate to Security -> ORACLE -> RegisterQuery for XX% schema and Set Privilege to “External”.Run OATM Migration UtilityLogin to application tier as applmgr and run perl $FND_TOP/bin/fndtsmig.plMigration Sizing ReportsSelect Option 1. Migration Sizing ReportsSelect Option 2. Calculate total space required by each new tablespace to migrate all Oracle Application products.Please do not skip this step. Oracle Applications Tablespace Migration Utility Main Menu1. Migration Sizing Reports2. Create New Tablespaces3. Generate Migration Commands4. Execute Migration Commands5. Run Migration Status Reports6. Run Post Migration Steps7. Run Customization Steps8. Run Migration in Batch Mode[Q]uit [N]extPlease enter your option - 1 Migration Sizing ReportsThese reports are provided to help you gauge the space requirementsfor the new Tablespaces. Additionally, they will also help youdetermine the type of migration approach that best suits your needs1. Generate a Report with the list of all the Oracle Application product schemas that can be migrated2. Calculate total space required by each new tablespace to migrate all Oracle Application product schemas (relevant for a complete migration)3. Calculate total space required by each new tablespace to migrate each Oracle Application product schema (relevant for a schema-by-schema migration)4. Calculate total space required by each Oracle Applications schema, with details for each object5. Display Sizing Exception report[Q]uit [B]ack [N]extPlease enter your option - 2 This step will provide the complete migration space needed:Enter the Extent Allocation type A(Autoallocate) or U(niform Exten Size)[U]:Enter Uniform Extent Size for the Tablesapces in Kbytes[1024]:1. Migration Sizing Reports2. Create New Tablespaces3. Generate Migration Commands4. Execute Migration Commands5. Run Migration Status Reports6. Run Post Migration Steps7. Run Customization Steps8. Run Migration in Batch Mode[Q]uit [N]extPlease enter your option - 2 Create New Tablespaces1. Generate new tablespace creation script2. Create new tablespaces[Q]uit [B]ack [N]extPlease enter your option - 1*****************************************************************The utility will append a sequence number to the tablespace nameand a .dbf extension to generate the datafile names.Datafile size should not be greater than OS file size limit.Please edit the generated script to change the file name/size*****************************************************************Enter the Extent Allocation type A(utoallocate) or U(niform Extent Size)[U]: UEnter Uniform Extent Size for the Tablespaces in KBytes[1024]:Enter the absolute path for the datafiles directory: /d01/oracle/uatdb/uatdataThe directory /d01/oracle/uatdb/uatdata does not exist on this node.Please ensure that this directory is accessible from the database server.Do you still want to use this directory [N]: YEnter the Number of Datafiles for APPS_TS_TX_DATA tablespace[1]: 6Enter the Datafile Size for APPS_TS_TX_DATA tablespace (MB): 8000Enter the Number of Datafiles for APPS_TS_TX_IDX tablespace[1]: 7Enter the Datafile Size for APPS_TS_TX_IDX tablespace (MB): 7000Enter the Number of Datafiles for APPS_TS_SEED tablespace[1]: 2Enter the Datafile Size for APPS_TS_SEED tablespace (MB): 4000Enter the Number of Datafiles for APPS_TS_INTERFACE tablespace[1]: 2Enter the Datafile Size for APPS_TS_INTERFACE tablespace (MB): 3000Enter the Number of Datafiles for APPS_TS_SUMMARY tablespace[1]: 10Enter the Datafile Size for APPS_TS_SUMMARY tablespace (MB): 8000Enter the Number of Datafiles for APPS_TS_NOLOGGING tablespace[1]: 3Enter the Datafile Size for APPS_TS_NOLOGGING tablespace (MB): 5000Enter the Number of Datafiles for APPS_TS_ARCHIVE tablespace[1]: 2Enter the Datafile Size for APPS_TS_ARCHIVE tablespace (MB): 4000Enter the Number of Datafiles for APPS_TS_QUEUES tablespace[1]: 2Enter the Datafile Size for APPS_TS_QUEUES tablespace (MB): 3000Enter the Number of Datafiles for APPS_TS_MEDIA tablespace[1]: 1Enter the Datafile Size for APPS_TS_MEDIA tablespace (MB): 2000Enter the Number of Datafiles for APPS_TS_TOOLS tablespace[1]: 2Enter the Datafile Size for APPS_TS_TOOLS tablespace (MB): 3000Tablespace creation script /d02/oracle/uatappl/admin/uat/log/crtts.sql createdExecute the above script by connecting database server;Display Sizing Exception Report Selection Option 5 Display Sizing Exception reportCheck for the errors to know if any objects in error exist for all schemasInvalid Index Report Choose option 3 to Generate Migration Commands Perform Option 1 in order to find and correct any invalid indexes The error related to Index CTXSYS can be ignored as this index “DEFAULT_POLICY_ORACONTAINS” does not exist [oracle@testplan ~]$ cd $ORACLE_HOME/ctx/sample/script[oracle@testplan script]$ lsdrkorean.sql[oracle@testplan script]$ sqlplusSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 7 06:34:53 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter user-name: /as sysdbaConnected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> @drkorean.sqlList of indexes that use KOREAN_LEXER as top level lexer:List of indexes that use KOREAN_LEXER as a sub lexer:"CS"."CS_FORUM_MESSAGES_TL_N3"Migrate KOREAN_LEXER to KOREAN_MORPH_LEXERRebuild all indexes that use korean lexer as top level lexer:Reindex all documents that use KOREAN_LEXER as sub lexerreindexing : "CS"."CS_FORUM_MESSAGES_TL" finished.SQL> alter index cs.CS_FORUM_MESSAGES_TL_N3 rebuild;Generate Migration Commands Choose option 3 to Generate Migration Commands. Enter Option 2, which will generate the commands for schemas. After the Migration commands are generated, please check the logfile and make sure there are no errors in the logfile before proceedingExecute option to generate execution commands for all schemasBuild Migration commands for custom objectsExecute OATM from the applicationUse max workers possible for first runAfter sequential and parallel jobs complete, check for log file of long objects to verify if treads are still running. In case they die, kill LONG object migration job and restart migration again this time reducing parallel workersVerify Objects are migrated correctlyRun Post Migration Stepsa) Fix any unsusable indexes generating a script b) Check for any valid Domain indexes c) Verify any LOBs that didn’t get migrated You may see the following index. It is a known bug and use the following fix and rerun the script and make sure there are no exceptions. If there exceptions, use the generated command and manually migrate the LOB segments. AQ$_WF_CONTROL_D lob index didn’t get migrateFollowed note 418238.1sqlplus <apps_user>/<apps_pwd> @$FND_TOP/patch/115/sql/wfctqrec.sql <applsys_user> <applsys_pwd>Compile Invalid Objects using ADADMINGenerate JAR Files with Force Option=Yes using ADADMINGenerate all forms and reports using ADADMINGather Fixed Objects StatisticsEXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS( estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, options => 'GATHER AUTO' )ReferencesHow to run OATM migration utility (Doc ID 404954.1)Oracle Applications Tablespace Model Release 11i - Tablespace Migration Utility (Doc ID 248857.1)OATM Exception Report. How To Deal With Partitioned Objects. Ora-03207 [ID 396479.1]OATM Migration fails on AW objects like AW$ODPCODE, AW$XWDEVKIT, AW$ZPBCODE [ID 557011.1]How to manually move composite-partitioned table and index? [ID 1270700.1] ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download