We can follow below steps to change IP address in Oracle Application/EBS environment
Steps:
1. Change the IP Address in the Server.
2. Verify the current ip address setup in the Oracle Applications environment. Connect as apps user into SQL*Plus and run:
select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('&hostname');
3. Run the following command to remove the old ip address from the Oracle Applications tables:
perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$APPL_TOP/admin/
then connect to SQL*Plus as apps user and run:
begin
FND_NET_SERVICES.remove_server('&SID
end;
/
commit;
/
replace
4. Run autoconfig to populate the values using the new IP Address.
5. Confirm the ip address has been changed to the new value changed in the step 1:
select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('&hostname');
Post a Comment
Post a Comment