Re: Adding Nodes

Posted by ErmanArslansOracleBlog on May 12, 2017; 4:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adding-Nodes-tp2595p2701.html

You don't have these two records in ad_timestamps table.

INSTANTIATED_CURRENT_VIEW_SNAPSHOT
BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT

This is strange.. Because the update in adadmrat.sql tries to update these..

update ad_timestamps
    set attribute = l_new_apps_system_name || '*' || l_new_appltop_name
    where type in ('INSTANTIATED_CURRENT_VIEW_SNAPSHOT',
                   'BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT')
    and attribute = l_new_apps_system_name || '*' || l_old_appltop_name;

addnode.pl should add these actually.


Anyways, take backup of ad_appl_tops and ad_timestamps.
Modify adadmrat.sql script.
put a commit one line above the following;

commit <<--put commit here- >>
update ad_timestamps
    set attribute = l_new_apps_system_name || '*' || l_new_appltop_name
    where type in ('INSTANTIATED_CURRENT_VIEW_SNAPSHOT',
                   'BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT')
    and attribute = l_new_apps_system_name || '*' || l_old_appltop_name;

retry... Send me the output of ad_appl_tops and ad_timestamps after that.