I have had similar issues with the deferred migration jobs. I've tracked down my issue to missing database links. Can someone please confirm for me what database links need to exist in both the new, upgraded repository and the old repository?
select ERROR_MSG from mgmt_system_error_log where module_name = 'UPGRADE-MDM':
Error migrating all values partition (DBMS lock acquired):
SQL Error: ORA-01403: no data found... Stack Trace:
ORA-06512: at "SYSMAN.EM_METRIC_DATA__UPGTMPRL", line 205
ORA-06512: at "SYSMAN.EM_METRIC_DATA__UPGTMPRL", line 638
ORA-06512: at "SYSMAN.EM_METRIC_DATA__UPGTMPRL", line 1683
Line 205 shows:
SELECT DB_LINK INTO l_dblink_name
WHERE DB_LINK LIKE G_DB_LINK_NAME || '%'
AND USERNAME = MGMT_USER.GET_REPOSITORY_OWNER;
Interestingly, the comments for the procedure that contains the query from all_db_links says:
If the data source tables are remote, you must set up a database link in
The 11.2 repository that points to the 10.2 repository db instance. The
database link is expected to connect as SYSMAN and the link must be named:
I have no such link in either database.
1) what is the status of DDMP job in post upgrade console? Can you verify if evreything is migrated in the deatisl of this job through UI? If its failed then what does it say ?
2) do you have your old EM repository intact?
Donnt try any sql's with DDMP job you can end up spoiling your data migration.