NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Restarting a Crashed ADOP session

No comments
If an adop session is running and system crashes then it fails to update the status in the internal repository

If we try to run it adop again it will give the following error.

Error:
Error:Unable to continue as already another user is using adzdoptl.pl.
Previous session exist, cannot continue as per user input.

Solution:
We need to manually update the internal adop repository table for the latest session and making it  status to completed.

Run the following statement to find out the session that is in running state:

SQL>select adop_session_id from ad_adop_sessions where status='R';

Set the status to 'C' (Completed) for that session, to re-execute the phase that was interrupted/terminated.

SQL>update ad_adop_sessions set status='C' where status='R';

No comments :

Post a Comment