7 Replies Latest reply: Aug 12, 2011 9:39 AM by 877189 RSS

    DMU stops at step 5 of conversion - Execute Post-Conversion Tasks

    877189
      Hi,

      I am using DMU to convert 11.2.0.2 database with Oracle Applications 11.5.10.2
      I have completed all the pre-reqs steps before conversion like scanning, cleansing the data.

      During Conversion

      Steps 1 to 4 completed successfully.

      1) Execute Pre-Conversion Tasks
      2) Convert application Tables
      3) Convert system Tables
      4) Alter Database Character Set to UTF8

      Status of Step 5 is
      5) Execute Post-Conversion Tasks – with Red X Mark
      In the details section, message: "Enable or create triggers, constraints and indexes that were previously disabled or dropped"

      Manual steps performed as the DMU had failed in step 5:

      1) Manually enabled the triggers
      2) Indexes rebuilt (Indexes unuasble were listed in the alert log file)
      3) Recompiled Invalid objects


      Status of Database:

      SQL> select * from v$instance;

      INSTANCE_NUMBER INSTANCE_NAME
      --------------- ----------------
      HOST_NAME
      ----------------------------------------------------------------
      VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
      ----------------- --------- ------------ --- ---------- ------- ---------------
      LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
      ---------- --- ----------------- ------------------ --------- ---
      1 UPGAPPS
      prod-fin-db03
      11.2.0.2.0 09-AUG-11 OPEN NO 1 STOPPED
      RESTRICTED NO ACTIVE PRIMARY_INSTANCE NORMAL NO


      SQL> SELECT value FROM NLS_DATABASE_PARAMETERS WHERE parameter='NLS_CHARACTERSET';

      VALUE
      --------------------------------------------------------------------------------
      UTF8

      SQL> select distinct(nls_charset_name(charsetid)) CHARACTERSET,
      decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKNOWN'),
      9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKNOWN'),
      96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKNOWN'),
      8, decode(charsetform, 1, 'LONG', 'UNKNOWN'),
      112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKNOWN')) TYPES_USED_IN
      from sys.col$ where charsetform in (1,2) and type# in (1, 8, 9, 96, 112)
      order by CHARACTERSET, TYPES_USED_IN
      /

      CHARACTERSET TYPES_USED_IN
      ---------------------------------------- -------------
      AL16UTF16 NCHAR
      AL16UTF16 NCLOB
      AL16UTF16 NVARCHAR2
      UTF8 CHAR
      UTF8 CLOB
      UTF8 LONG
      UTF8 VARCHAR2

      7 rows selected.


      DMU doesnt do anything even if I click on continue/resume button.

      Can I click on "Abort" button in DMU and then proceed with restarting the Database.


      Regards,
      Jaggi