This discussion is archived
1 Reply Latest reply: May 17, 2013 1:24 AM by Akanksha Sheoran Kaler RSS

Re: How to manually run DDMP (and a few other tidbits of info)

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

Some details:

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
FROM ALL_DB_LINKS
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:
NOTE:
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:
"EM_METRIC_MIG_LINK__UPGTMPDC"

I have no such link in either database.