Thursday 26 April 2007

Step to Clean Nonexistent Nodes or IP Addresses from FND_NODES.

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

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

1) Retrieve the latest patch for the cloning tools.
(Currently 11i.ADX.F 3453499)

2) After applying the above patch to the system that is to
be cleaned, run the following in SQL*Plus:

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.
Profile - Oracle 11i AppsDBA
Over 7 years of experience as an Oracle Applications DBA managing Oracle Public Sector HRMS 11.5.10 and Oracle Financials 11i in Unix and Windows NT environments. Strong skills and experience with installing, patching, cloning and troubleshooting various Oracle E-Business Suite products in Oracle database 9i and 10g. Proactive in the different phases of architecture design, development, testing, maintenance, performance enhancement and postproduction support. Currently working as Oracle Application DBA at Warwickshire County Council.

------------------------------------------------------------------------------------------------------------------------------