DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Sunday, January 15, 2017

Oracle EBS R12 changing IP address

Oracle EBS R12 changing IP address

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

2)connect with sqlplus apps/apps and run the following
FND_NET_SERVICES.remove_server('<SID>', '<hostname>');

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

No comments: