Adop Phase=prepare Failed While Synchronizing Snapshots (Doc ID 2022760.1)
SYMPTOMSOn Orace Applications 12.2.4 version,
when attempting to run adop phase=prepare, the following error occurs:
Executing "adop" action in all nodes
Remote execution results xml output file = /fs_ne/EBSapps/log/adop/8/prepare_20150619_121220/ABCD_yqz123/remote_execution_result_20150619_122924.xml
[ERROR] Node: "qctebsts2app2" Status: "failed"
[ERROR] Node: "qctebsts2app1" Status: "failed"
[ERROR] Remote execution failed on Node: "qctebsts2app1".
[ERROR] Remote execution failed on Node: "qctebsts2app2".
[UNEXPECTED]Remote execution on all the nodes returned failure.
[UNEXPECTED]So, Unable to continue.
[UNEXPECTED]Error: While executing "adop" on all other nodes.
[UNEXPECTED]Execution failed when performing remote action.
The following steps to reproduce the problem:
1. Set the environment.
2. Execute the command adop phase=prepare.
3. The error is shown in the adop log file.
CAUSE
Synchronizing Snapshots failed and that is the root cause for prepare phase failure.
The remote_execution_result_20150619_122924.xml file shows following error.
Synchronizing Snapshots...
[ERROR] Failed to execute SQL statement :
begin
ad_zd_adop.sync_snapshots(342);
exception
when others then
update ad_adop_sessions set status='F'
where adop_session_id=8;
commit;
raise_application_error(-20001,'Error while calling ad_zd_adop.sync_snapshots.' || sqlerrm);
end;
This was the root cause for prepare phase failure.
SOLUTION
Execute the following steps to resolve the issue.
1. Execute the following script from SQL command prompt:
begin
ad_zd_adop.sync_snapshots(342);
exception when others then
raise_application_error(-20001,'Error while calling ad_zd_adop.sync_snapshots.' || sqlerrm);
end;
end;
/
2. Execute the adop phase=prepare again.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.