System Hold Fix Manager before resetting counters

After migrating the environment to Exadata I was getting the below errors for the CM's


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"


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.