|
|
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
|
Locked
