Sunday, April 6, 2008

How to Change IP Address in an Oracle Applications Environment

Print this post

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/<SID>_hostname.xml -removeserver

replace <SID>_hostname.xml for the context file name under the $APPL_TOP/admin directory;

then connect to SQL*Plus as apps user and run:

begin
FND_NET_SERVICES.remove_server('<SID>', '<hostname>');
end;
/
commit;
/

replace <SID> by the SID of the environment and <hostname> by the hostname in the environment. Both must be entered in upper case.

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');

6 comments:

Gaurav said...

Oracle Apps doesn't use IP address

Famy Rasheed said...

Hi Gaurav,

Hope u are not aware of fnd_nodes tables. Just query and see if there is any IP Information in that table. This is to populate apps tables with proper IP.

Sami said...

Though IP column is there in FND_NODES table still you will notice that even if the value is wrong it won't affect the application. You can directly update the FND_NODES table to update it with correct ip address and it will work. No need of all the long process that you mentioned.

vasu said...

Dear Famy,

AS gourav said, You can change the IPaddress of the server. and keep the server anywhere in the domain it will work. only thing is you have to change the ipaddress of the server in /etc/hosts of the server.

If you tnsentry is populated with ip insted of hostname, may be your steps resolves the issue.

any ways thanks for the update.

Keep up the good work.

Vasu

tqadir said...

This is a reply to Vasu's comment.
Rapid install never uses IP in tnsnames.ora. If somebody is using an IP in the tnsnames.ora, its very bad implemenatation.
Just my two cents!

raghu said...

Hi All,

As Per my Knowledge Ip Address wills stroe in the FND_NODES..

But no need of run adgentns.pl

After changing the IP Address, everything is fine (without running autoconfig). But the OAM is displaying the old IP address.

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
SQL> COMMIT;
Run AutoConfig (This step has to be done to populate FND_NODES with the new IP addresses)

Regards

Rahul