R 12 Concurrent Manager Status: "System Hold, Fix Manager before resetting counters”

After migration/clone the environment getting the below errors for the CM's

 

Error: “System Hold, Fix Manager before resetting counters”.  

 

Solution:

    1) Shutdown the Apps Tier cleanly make sure there are no orphan sessions.

    

    2) go to cd $FND_TOP/bin

    run the below commands:

    $ adrelink.sh force=y link_debug=y "fnd FNDLIBR"

    $ adrelink.sh force=y link_debug=y "fnd FNDFS"

    $ adrelink.sh force=y link_debug=y "fnd FNDCRM"

    $ adrelink.sh force=y link_debug=y "fnd FNDSM"

    adrelink.sh force=y link_debug=y "fnd FNDSM"

    Check relink logs to make sure the relinks completes suuscessfully.

    Ex:

    adrelink is exiting with status 0

    End of adrelink session

    Date/time is  Mon Jul 23 10:50:24 EDT 2012

    **********************************************************

    Line-wrapping log file for readability ...

    Done line-wrapping log file.

    Original copy is  /apps/apps_st/appl/admin/log/adrelink.lsv

    New copy is /apps/apps_st/appl/admin/log/adrelink.log

   

    3) After running the relinks run the cmclean.sql to flush out the status of the CM's..

    SQL> conn apps/

    Connected.

    SQL> @cmclean.sql

    DOC>

    -----------------------------------------------------------------------

    Updates complete.

    Type commit now to commit these updates, or rollback to cancel.

    -----------------------------------------------------------------------

    SQL> commit;

    Commit complete.

   

    4) Now Restart the Apps teir:

    Now CM's came back online without any issue.