Wednesday 13 July 2016

How to Clean FND_NODES Table in Oracle Applications R12

Why we need to clean FND_NODES table after post cloning Step.
EXEC FND_CONC_CLONE.SETUP.CLEAN ?

Awnser :-

That way this table contains the IP Addresses of the source servers (apps and db) and when you clone your target servers have different IP Addresses that need to be populated in FND_NODES table.
Steps to Clean Nonexistent Nodes or IP Addresses from FND_NODES
How to Clean :
------------------

Run Application enviroment

$ Sqlplus apps/apps

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) Always apply the latest cloning patches, to avoid all the bugs and fixes

2)  Run Application enviroment
$ Sqlplus apps/apps
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
SQL> COMMIT;
SQL> EXIT;

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

Note :  Step two will delete all data from system tables such as

FND_NODES, FND_OAM_CONTEXT_FILES, etc. . . . . 

No comments:

Post a Comment