Steps 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
------------------ - - - - -
TESTSERVER O N Y N Y
APPSTEST01 O N Y N Y
APPSDEVP01 O N Y N Y
DEVP O Y Y Y Y
AUTHENTICATION O N N N N
GOLD_UAT O
GOLDTS O Y Y Y Y

7 rows selected.


NOTE:

Do not directly Delete from FND_NODES table because the
'support_' columns will be affected and will not
incorporate the correct information througout in OAM


Run The following Script.

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;


After Commit check the following Scripts. Now you got output no rows.
Then you run Autuconfig both Tiers

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


no rows selected


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

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



NODE_NAME N S S S S
-------------------- - - - - -
AUTHENTICATION O N N N N
GPLDTS O Y Y Y Y


Note:260887.1

2 comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.