How to change IP address on EBS R12

1. Change IP address in /etc/hosts file

2. Stop Middle Tier Services:

$ cd $ADMIN_SCRIPTS_HOME    
$ ./adstpall.sh apps/apps  

3. Run the following command on apps tier (As applmgr):

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

4. Connect to SQL*Plus as apps user and run (As oracle):

SQL> begin 
        FND_NET_SERVICES.remove_server('', ''); 
        end; 
        / 
SQL> commit; 
       /

Note: Replace <SID> by the SID of the environment and <hostname> by the host name in the environment. Both must be entered in upper case.

5. Run AutoConfig on the Middle Tier to populate the FND_NODES table (As applmgr):

$ cd $ADMIN_SCRIPTS_HOME
$ ./adautocfg.sh

6. Use following script to check if the change is reflected in FND_NODES table:

 set pagesize 50 
 col node_name format a15 
 col server_id format a8 
 col server_address format a15 
 col platform_code format a4 
 col webhost format a12 
 col domain format a20 
 col virtual_ip format a12 
 set linesize 132 
 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 
 from fnd_nodes 
 order by node_id;

7. Start the Middletier Services.