Delete a node from application Tier in Oracle Apps R12.2

Description:

Delete the Secondary application Node from Application Tier, follow the below steps.

Note: This steps are ONLY for deletion of secondary application tier nodes. The primary application tier node cannot be deleted using these steps.

Sample Error:

We Try to add Node to application Tier below error are throw in log file.

Log File = INST_TOP/admin/log/clone/RCloneApplyAppstier_XXX.log

ERROR: ABCD entry is there in AD_NODES_CONFIG_STATUS
ERROR: ABCD entry is there in fnd_oam_context_files
ERROR: ABCD entry is there in ADOP_VALID_NODES
ERROR: ABCD entry is there in fnd_nodes
ERROR: ABCD already registered in AutoConfig tables
ERROR: Some old configuration footprints still exists
Run ebs-delete-node before re-running add node

Solution 

Execute below query and check node status:

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

Steps:

1. Login to the primary node.
2. Source the run file system.
3. Execute the ebs-delete-node option of the adProvisionEBS.pl script as follows

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-node -contextfile=$CONTEXT_FILE -hostname=<host_name of the deleted node>  -logfile=delete.log.

check the log file for the node deletion.