Scripts to update the Concurrent Node Details when migrating from One server to other

If we are migrating from once server to other, or during DR switch over, we need to update the concurrent node server details. We can use below scripts to update the same.

Scripts:

update FND_CONCURRENT_REQUESTS set OUTFILE_NODE_NAME = 'NEW_SERVER' where OUTFILE_NODE_NAME = 'OLD_SERVER'; 
update FND_CONCURRENT_REQUESTS set LOGFILE_NODE_NAME = 'NEW_SERVER' where LOGFILE_NODE_NAME = 'OLD_SERVER'; 
commit;

update FND_CONCURRENT_QUEUES set NODE_NAME = 'NEW_SERVER' where NODE_NAME = 'OLD_SERVER'; 
commit;

update FND_CONCURRENT_REQUESTS set LOGFILE_NAME = REPLACE(LOGFILE_NAME, '/old_path/', '/new_path/') where LOGFILE_NAME like '/old_path/%';
update FND_CONCURRENT_REQUESTS set OUTFILE_NAME = REPLACE(OUTFILE_NAME, '/old_path/', '/new_path/') where OUTFILE_NAME like '/old_path/%';
commit;


update FND_CONC_REQ_OUTPUTS set FILE_NODE_NAME = 'NEW_SERVER' where FILE_NODE_NAME='OLD_SERVER';
update FND_CONC_REQ_OUTPUTS set FILE_NAME = REPLACE(FILE_NAME, '/old_path/', '/new_path/') where FILE_NAME like '/old_path/%';
commit;


Examples:

update FND_CONCURRENT_REQUESTS set OUTFILE_NODE_NAME = 'FOANEWAPP' where OUTFILE_NODE_NAME = 'OELOLD'; 

update FND_CONCURRENT_QUEUES set NODE_NAME = 'FOANEWAPP' where NODE_NAME = 'OELOLD'; 

update FND_CONCURRENT_QUEUES set TARGET_NODE = 'FOANEWAPP' where TARGET_NODE = 'OELOLD';
 
update FND_CONCURRENT_REQUESTS set LOGFILE_NODE_NAME = 'FOANEWAPP' where LOGFILE_NODE_NAME = 'OELOLD'; 

 commit;


update FND_CONCURRENT_REQUESTS set LOGFILE_NAME = REPLACE(LOGFILE_NAME, '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/', '/apps01/app/DEV/inst/apps/DEV_FOANEWAPP/logs/appl/conc/') where LOGFILE_NAME like '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/%';

 update FND_CONCURRENT_REQUESTS set OUTFILE_NAME = REPLACE(OUTFILE_NAME, '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/', '/apps01/app/DEV/inst/apps/DEV_FOANEWAPP/logs/appl/conc/') where OUTFILE_NAME like '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/%';
 commit;

 update FND_CONC_REQ_OUTPUTS set FILE_NODE_NAME = 'FOANEWAPP' where FILE_NODE_NAME='OELOLD';

 update FND_CONC_REQ_OUTPUTS set FILE_NAME = REPLACE(FILE_NAME, '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/', '/apps01/app/DEV/inst/apps/DEV_FOANEWAPP/logs/appl/conc/') where FILE_NAME like '/u01/oracle/PROD/inst/apps/DEV_OELOLD/logs/appl/conc/%';
 commit;





If you like please follow and comment