Oracle EBS IPアドレスの変更

前言
実はIPアドレスを修正するのはそんなに面倒ではありませんて、LinuxのIPアドレスを修正して、/etcc/hostsを配置して、それから直接表FND_を修正しますNODESのSERVER_ADDRESSの値は新しいIPアドレスです.そしてアプリケーションサーバを再起動すればログインできます.(この方法は親測で使用できます.autoconfigを実行してもテーブルのipアドレスが自動的に更新されます).
以下はautoconfigを使用した参考資料です.
Symptoms
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”
Cause
The IP address of the Instance is changed but DBA followed incorrect method.
Hence new IP address wasn’t propogated to FND_NODES resulting in error.
Solution
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.
Middle Tier

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.

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’.

Stop the Middle Tier Services.

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/_hostname.xml
removeserverNote: Replace _hostname.xml for the context file name under the $APPL_TOP/admin directory. Both must be entered in upper case.
In R12 context file location is $INST_TOP/appl/admin/_.xml.

Connect to SQL*Plus as apps user and run:

begin FND_NET_SERVICES.remove_server('', ''); 

end; 

/ 

commit; 

Note: Replace by the SID of the environment and by the hostname in the environment. Both must be entered in upper case.

Run AutoConfig on the Middle Tier to populate the FND_NODES.

Use following script to check if the change is reflected in FND_NODES table: spool fnd_nodes set pagesize 50 col node_name format a15 col server_id format a8 col server_address format a15 col platform_code format a4 col webhost format a12 col domain format a20 col virtual_ip format a12 set linesize 132 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; Now the FND_NODES should have correct IP Address value.

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.

Start the Middle Tier Services.

Database Layer

Look for the hardcoded old IP Address in the following files: 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. 2) Check if the parameter LOCAL_LISTENER and REMOTE_LISTENER parameter been set in Database Initialization file. 3) If its a Production Instance then its recommended to take the backup of the Database. 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. 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.