Case A: Removing a Node that not available for access (Physically not Available) and has been removed and destroyed.

Case B: Removing a Node that still has available for access (Physically Available) and want to be remove.

===================Steps for Case A==================================

Step 1: Shutdown Application services from all nodes

Step 2: De-register the services by executing bellow command.

System_Name ---à>>>>SID

Server_name-----à>>>>>Node_Name

begin
FND_NET_SERVICES.remove_server('SYSTEM_NAME','SERVER_NAME');
end;
/

commit;

Step 3: Clean the FND_NODES tables

exec fnd_conc_clone.setup_clean;

commit;

Step 4: Run adautocfg.sh on all nodes (DB and APPS) to re-register them.

=================End of Cease A=================================

===================Steps for Case B==============================

Step 1: Shutdown Application services from all nodes

Step 2: De-register the services by executing bellow command.

perl $AD_TOP/bin/adgentns.pl contextfile=$CONTEXT_FILE -removeserver

commit;

Step 3: Clean the FND_NODES tables

exec fnd_conc_clone.setup_clean;

commit;

Step 4: Run adautocfg.sh on all nodes (DB and APPS) to re-register them.

=====================End of Cease A===============================