This discussion is archived
7 Replies Latest reply: Aug 12, 2011 7:39 AM by 877189 RSS

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

877189 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points