Changing IP address for EBS 11i apps and DB server

Posted by raja on Jul 12, 2017; 9:32am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Changing-IP-address-for-EBS-11i-apps-and-DB-server-tp2944.html

Hi Erman

Just wanted to confirm from your side, i need to change the Ip address for (apps and Database)(hosted in two different servers). Is the below action plan correct:

                                               
        On Database Tier
1 select server_address,webhost from fnd_nodes; Note down the existing ip address by login through apps user
                                               
2 perl /oracle/app/oracle/test/product/10.2/db_1/appsutil/bin/adgentns.pl appspass=password contextfile=/oracle/app/oracle/test/product/10.2/db_1/appsutil/test_testing1.xml -removeserver De register the current database server
                                               
3 select server_address,webhost from fnd_nodes; Verify if it is returning null
                                               
        On Apps tier
                                               
4 cd /u10/app/prodcomn/admin/scripts Stop the application tier
        adstpall.sh apps/password
                                               
                                               
5 perl /u10/app/prodappl/ad/11.5.0/bin/adgentns.pl appspass=password contextfile=/u10/app/prodappl/admin/test_testing2.xml -removeserver Deregister the current application tier
                                               
6 sqlplus apps/appspassword
        "begin
FND_NET_SERVICES.remove_server('test', 'testing1');
end;
/
commit;
/
" For database server
                                               
        "begin
FND_NET_SERVICES.remove_server('test', 'testing2');
end;
/
commit;
/" For application tier
                                               
6 change the ip adddress in /etc/hosts and DNS server Unix team
                                               
6 verify the file /etc/sysconfig/network-scripts/ifcfg-eth0 Unix Team
                                               
7 cd /oracle/app/oracle/test/product/10.2/db_1/appsutil/scripts/test_testing1 Run autoconfig in database tier
                                               
        sh adautocfg.sh
                                               
8 cd /u10/app/prodcomn/admin/scripts/test_testing2 run autoconfig in application tier
                                               
        sh adautocfg.sh
                                               
9 bounce the database and restart the listener
                                               
        The listener.ora file should have the updated ip address for listening the connections.
                                               
10 cd /u10/app/prodcomn/admin/scripts/test_testing2 start the application tier
                                               
        adstrtal.sh apps/password
                                               
11 Verify the login