Saturday 7 April 2018

EBS : Concurrent manager not starting after cloning R12.1

Error:

CONC-SM TNS FAIL
Routine AFPEIM encountered an error while starting concurrent manager STANDARD


Solution:
Step 1:

Stop the Concurrent Manager

Step 2:

SQL> select count(*) from fnd_nodes;

  COUNT(*)
----------
         2

SQL> select unique(node_name) from fnd_concurrent_queues;

NODE_NAME
------------------------------
PROD
DEV

SQL> update fnd_concurrent_queues set node_name='DEV' where node_name='PROD';

43 rows updated.

SQL> commit;

Commit complete.

Step 3:

Start the Concurrent Manager

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...