System Hold, Fix Manager before resetting counters
We have seen this error couple of times in the Concurrent manager Administer screen in our R12.1.3 QA instances.
OPP Concurrent Manager status : System Hold, Fix Manager before resetting counters
Solution:
1. Shutdown the Apps Tier cleanly make sure there are no sessions:
[applmgr@oracle ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@oracle scripts]$ ./adstpall.sh apps/*****
[applmgr@oracle ~]$ ps -ef | grep FNDLIBR
[applmgr@oracle ~]$ ps -ef | grep FNDSM
[applmgr@oracle ~]$ ps -ef | grep FNDCRM
[applmgr@oracle ~]$ ps -ef | grep FNDFS
[applmgr@oracle ~]$ ps -ef | grep applmgr
2. Stop the database.
[ora@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Dec 14 14:28:07 2021
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> shut immediate
3. Start the database.
[ora@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Dec 14 14:28:07 2021
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
4. To the appsTier go to $FND_TOP/bin and run the following relinks.
[applmgr@oracle ~]$ cd $FND_TOP/bin
$ 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"
5. Run the CMCLEAN.SQL script and commit..
SQL> @cmclean.sql
6. Execute the following SQL:
SQL> select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';
CONCURRENT_QUEUE_NAME
--------------------------------------------------------------------------------
FNDSM_ORACLE
SQL>
7. Now start the Apps tier:
[applmgr@oracle ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@oracle scripts]$ ./adstrtal.sh apps/*****
Check status of OPP Concurrent manager.
I hope issue got fix.
Comments