R12.2 Apps DBA. Powered by Blogger.

adop cleanup running long time

No comments :
Adop CLEANUP hung in EBSINT2 due a couple of errors in upgrading materialized views .
Post cutover , during cleanup, adop tried reported failure with the following exceptions (maybe due to private db_link in MV’s DDL as suggested by DocID: 1946296.1).
SQL                                                                                                                                                                         Error
--------------------------------------------------                          --------------------------------------------------
begin APPS.ad_zd_mview.upgrade('APPS','BIO_IDM_FLOOR_INFO_TAB'); end;      ORA-02019: connection description for remote database not found
begin APPS.ad_zd_mview.upgrade('APPS','BIO_IDM_BUILD_INFO_TAB'); end;      ORA-02019: connection description for remote database not found
When tried to query about those two objects, they are non-existent and nothing showed up.
And during the hung state ,some of the objects were locked. So ,here is the action plan followed to resolve issue.
1. Terminated the adop session
2. Updated ad_adop_sessions table with status='C' where status='R’ for the paticular session_id (because “adop –status” was showing the cleanup phase as still running)
3. Bounced the services on all nodes
4. Started cleanup phase in quick mode …it went on well

No comments :

Post a Comment

Note: only a member of this blog may post a comment.