So what will be the best practice in cloning?
For example, I cloned by source instance from ERP to ERP2 server. I want everything the same even the SID, folder location and structure.
When do I run:
Do I need to run it mandatory after the cloning of database tier or appstier? or both?
What does this script do? Does it remove the old fnd node? or update ERP to ERP2?
If you are moving instance from server1 to server2, best thing do is running adcfgclone on both DB and Appl Tier. If everything goes smooth you may not have to run
Yeah, that is what I did always. That is the very essence of cloning
I even run adcfgclone many times because lots of error occured, Like unzip not found, adcrdb.sh missing, listener can not start becuase port is not updated.
Maybe the running many times messed up fnd nodes queueus. So the important is, I must check if the node is updated to new one like ERP2, if not, then run update
Analyzing your script:
create table fnd_concurrent_queues_bkp as select * from fnd_concurrent_queues;
update apps.fnd_concurrent_queues set node_name = 'ERP2' where node_name='ERP';
UPDATE fnd_concurrent_queues set target_node = 'ERP2';
The 3rd line can be written as > update apps.fnd_concurrent_queues set node_name = 'ERP2';
Because none other node_name is needed except ERP2 right?
I can run it again over and over and the result is always okay as long as you know your target NODE.
Node_name and Target_node must be egual.
yes that's correct