Steps to Clean Nonexistent Nodes or IP Addresses from FND_NODES

Print this post When to Clean
------------------

After completing the cloning process, or implementing Autoconfig, the FND system tables have incorrect values.

If a clone was done, the OAM Dashboard reflects the target machine name and the source machine name although the

source machine is no longer being used.

In some cases, there are IP addresses from nonexistent machines in FND_NODES.

The Nodes in the OAM Dashboard are retrieved from the FND_NODES table.

Further investigation showed that the FND_NODES table had both node names and node_modes 'O' as activated.

SQL> select node_name, node_mode, support_cp, support_web, support_admin,support_forms from FND_NODES;

NODE_NAME              N S S S S
-----------------------------------------------
TARGET                     O Y Y Y Y
SOURCE                     O Y Y Y Y

How to Clean :
------------------

1) Always apply the latest cloning patches, to avoid all the bugs and fixes

2) SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
    COMMIT;
    EXIT;

3) Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers,to repopulate the required system tables.

Note that step two will delete all data from system tables such as
FND_NODES, FND_OAM_CONTEXT_FILES, etc.

The correct information for the current system will be repopulated when AutoConfig is run.