R12: How to change the hostname/IP address of an Applications Tier using AutoConfig

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: R12: How to change the hostname/IP address of an Applications Tier using AutoConfig




Solution:






1) Deregister the instance




first run the following sql:
select NAME, SERVER_TYPE from FND_APP_SERVERS;

Then run the following plsql using the info from the above sql:
exec FND_NET_SERVICES.remove_server('<SYSTEM_NAME'>, '<SERVER_NAME>');

# (The System name is the database name [select DB_NAME from FND_DATABASES;])

This plsql will need to be run twice to remove the apps & db server_type.
Then check the system has been deregistered by rerunning the first sql.




2) Stop all app services, db & lsnr




3) Change IP (ensure /etc/hosts has been updated)




4) Start db & lsnr



5) Run autoconfig on db, then apps tiers













References:




Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'

Get Oracle Certifications for all Exams
Free Online Exams.com