前言

其实修改IP地址没那么麻烦，只要修改好Linux的IP地址，配置好 /etcc/hosts，接下来就直接修改表FND_NODES的SERVER_ADDRESS的值为新的IP地址。然后重新启动应用服务器就可以登陆了。（该方法亲测可用。其实运行autoconfig也会自动更新该表的ip地址）。@H_502_4@

下面是参考资料，使用到了autoconfig：@H_502_4@

Symptoms @H_502_4@

Users are not able to Log into the E-Business Suite Instance. Trying to access the E-Biz Instance,statis page redirection to /OA_HTML/ApssLogin is resulting in “page can’t find”@H_502_4@

Cause@H_502_4@

The IP address of the Instance is changed but DBA followed incorrect method. @H_502_4@

Hence new IP address wasn’t propogated to FND_NODES resulting in error.@H_502_4@

Solution@H_502_4@

E-Business Suite Instance recognise host name of the node not IP address,but it does store the IP address in FND_NODES under SERVER_ADDRESS column. Follow the correct method of IP Address Change in E-Business Suite Instance.@H_502_4@

Middle Tier@H_502_4@

1. Change the IP address on the servers. Remember to check changes at all places depending on the Operating System e.g. /etcc/hosts in Linux. @H_502_4@

2. Ensure to change the entry for the hostname in the DNS lookup table i.e. specify the new IP address at the DNS server. Check it with ‘nslookup’. @H_502_4@

3. Stop the Middle Tier Services. @H_502_4@

4. Run the following command to remove the old IP address from the Oracle Applications tables:@H_502_4@

perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$APPL_TOP/admin/_hostname.xml @H_502_4@

removeserverNote: Replace _hostname.xml for the context file name under the $APPL_TOP/admin directory. Both must be entered in upper case. @H_502_4@

In R12 context file location is $INST_TOP/appl/admin/_.xml.@H_502_4@

1. Connect to sql*Plus as apps user and run: @H_502_4@

   begin FND_NET_SERVICES.remove_server('',''); 
   
   end; 
   
   / 
   
   commit;

   Note: Replace by the SID of the environment and by the hostname in the environment. @H_502_4@

   Both must be entered in upper case.@H_502_4@

2. Run AutoConfig on the Middle Tier to populate the FND_NODES.@H_502_4@

3. Use following script to check if the change is reflected in FND_NODES table:
   spool fnd_nodes @H_502_4@

   set pagesize 50 @H_502_4@

   col node_name format a15 @H_502_4@

   col server_id format a8 @H_502_4@

   col server_address format a15 @H_502_4@

   col platform_code format a4 @H_502_4@

   col webhost format a12 @H_502_4@

   col domain format a20 @H_502_4@

   col virtual_ip format a12 @H_502_4@

   set linesize 132 @H_502_4@

   select node_id,platform_code,support_db D,support_cp C,support_admin A,support_forms F,@H_502_4@

   support_web W,node_name,server_id,server_address,domain,webhost,virtual_ip @H_502_4@

   from fnd_nodes @H_502_4@

   order by node_id;@H_502_4@

   Now the FND_NODES should have correct IP Address value. @H_502_4@

4. For R12,follow Note 555214.1 OACORE Processes Won’t Start After Increasing Their Number In Oracle Applications Release 12 In Context.xml to purge the lock files. @H_502_4@

5. Start the Middle Tier Services. @H_502_4@

Database Layer@H_502_4@

1. Look for the hardcoded old IP Address in the following files:@H_502_4@

   a) listener.ora @H_502_4@

   b) tnsnames.ora (Local Naming) or check if any other naming method is used to resolve address. @H_502_4@

   Check if any of the parameter using the old IP Address. @H_502_4@

   2) Check if the parameter LOCAL_LISTENER and REMOTE_LISTENER parameter been set in Database Initialization file. @H_502_4@

   3) If its a Production Instance then its recommended to take the backup of the Database. @H_502_4@

   4) Please refer the Note 274476.1 and Note 363609.1 to have a detailed view to change the IP Address of the Database Server. @H_502_4@

   5) As the change is made at the OS (Operating System) level.Please ensure that the IP address gets reflected in the DNS server and also in the local host file.@H_502_4@