R12.2 Adop Cutover Failed with ORA-01422: exact fetch returns more than requested number of rows
[ERROR] Failed to execute SQL statement :declare
result varchar2(10);
begin
ad_zd_adop.cutover;
exception when others then
update ad_adop_sessions set status='F'
where adop_session_id=26;
commit;
raise_application_error(-20001,'Error while calling ad_zd_adop.cutover.' || sqlerrm);
end;
[ERROR] Error Message :
[ERROR] ORA-20001: Error while calling ad_zd_adop.cutover.ORA-01422: exact fetch returns more than requested number of rows
[ERROR] ORA-06512: at "APPS.AD_ZD_LOG", line 78
[ERROR] ORA-06512: at "APPS.AD_ZD", line 17
[ERROR] ORA-06512: at "APPS.AD_ZD", line 61
[ERROR] ORA-01422: exact fetch returns more than requested number of rows
[ERROR] ORA-06512: at line 9 (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Error occurred while performing database cutover
[UNEXPECTED]Cutover phase completed with errors/warnings. Please check logfiles
Solution:
Please use the following workaround.
1. Bounce the Database completely, ensure that all RAC nodes are down.
2. Update ADOP Repository with the below SQLs :
Take a backup of table.
1) update ad_adop_sessions set cutover_status='3' where adop_session_id=<session id> and node_name=<host name>;
2) update ad_adop_sessions set abort_status='X' where adop_session_id=<session id>;
3. After commit, restart Cutover using the same command.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.