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

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...