Oracle EBS R12 changing IP address

Oracle EBS R12 changing
IP address

1)perl $AD_TOP/bin/adgentns.pl appspass=apps
contextfile=$APPL_TOP/admin/<SID>_hostname.xml -removeserver

2)connect with sqlplus
apps/apps and run the following

begin
FND_NET_SERVICES.remove_server(‘<SID>’,
‘<hostname>’);

end;
/
commit;
/

3) Run autoconfig on
application tier

4) Check fnd_nodes to
see ip ‘s are reflected…

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;

Look for the hardcoded old IP Address in the following files on the DB tier
a) listener.ora
b) tnsnames.ora (Local
Naming) or check if any other naming method is used to resolve address.

Check if any of the
parameter using the old IP Address

  • January 15, 2017 | 22 views
  • Comments