Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Monday, July 23, 2012

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.







No comments: