Clean FND_NODES

To clean fnd_nodes (After clone )

sqlplus apps/apps
exec FND_CONC_CLONE.SETUP_CLEAN;

Create new entries.

run afcpnode.sql script from $COMMON_TOP/admin/install/$CONTEXT_NAME directory after editing following two lines to have correct physical host name and domain name for CM Tier Node
DEFINE HOST_NAME=" "
DEFINE DOMAIN_NAME=" "

Run autoconfig

NOTE: Donot run this on production env. Oracle recommands a backup before you make any changes :