Problem

Verifying: If machine vsdmz01p.test.com is registered in domain....

ERROR: vsdmz01p already registered in domain

Verifying: If vsdmz01p is registered in AutoConfig tables....

ERROR: Some old configuration footprints still exists

Run ebs-delete-node before re-running add node

Solution

Source the application enviroment

[oracle@vserptest ~]$ cd /u01/oracle/PIAXDPD/

[oracle@vserptest PIAXDPD]$ . EBSapps.env run

1. Backup and truncate following table

fnd_oam_context_files

fnd_nodes

adop_valid_nodes tables

[oracle@vserptest ~]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Nov 22 12:32:21 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;

SQL> create table fnd_nodes_bk as select * from fnd_nodes;

SQL> create table adop_valid_nodes_bk as select * from adop_valid_nodes;

SQL> truncate table fnd_oam_context_files;

SQL> truncate table fnd_nodes;

SQL> truncate table adop_valid_nodes;

      

2.  Run AutoConfig on the DB tier followed by application tier:

Source RDBMS home

[oracle@vserptest ~]$ cd /u01/app/oracle/12.1.0.2/dbhome_1/

[oracle@vserptest dbhome_1]$ . TEST_vserptest.env

[oracle@vserptest dbhome_1]$ cd appsutil/scripts/TEST_vserptest/

[oracle@vserptest TEST_vserptest]$ ./adautocfg.sh

3.  Run Autoconfig on the rapplication tier.

Source the application enviroment

[oracle@vserptest ~]$ cd /u01/oracle/PIAXDPD/

[oracle@vserptest PIAXDPD]$ . EBSapps.env run

[oracle@vserptest PIAXDPD]$ cd $ADMIN_SCRIPTS_HOME

[oracle@vserptest scripts]$ ./adautocfg.sh

           

4.  After running Autoconfig on both DB and application tier, run the following queries to verify only valid node is shown in tables

SQL> select node_id, platform_code, support_db D, support_cp C, support_admin A, support_forms F, support_web W, node_name, server_id, server_address, domain, webhost, virtual_ip, status from fnd_nodes order by node_id;

SQL> select NAME,VERSION,PATH, STATUS from FND_OAM_CONTEXT_FILES;