Change of IP Address for the Oracle Apps R12/11i Server

Scenario
=======

Oracle Apps R12 was installed in the server name DOYENSYS and the ip was 192.168.5.33. Now the Organisation Planned to move the server to the data centre. After Moving the IP has been changed as the following 192.168.1.33.

Problem:
=======

While starting the apps Tier it starts and while opening the front end forms it gives the following error:


500 Internal Server Error

java.lang.NoClassDefFoundError
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2231)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4617)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4541)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2821)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)


Solution:
=======

Step 1 : Shut down apps,DB,listener.

Step 2 : edit the host file and put the local ip as the first entry. For ex :( 192.168.1.33 DOYENSYS ).

Step 3 : Start DB and Listener.

Step 4 : Check the ip which is in the FND_NODES table by using the following Query.

select NODE_NAME,SERVER_ADDRESS from fnd_nodes where node_name = upper('doyensys');

NODE_NAME SERVER_ADDRESS
------------------------------ ------------------------------
DOYENSYS 192.168.5.33

Step 5 : It show the old ip.

Step 6 : Run Autoconfig in apps Tier

Step 7 : Now Check the Query again.

select NODE_NAME,SERVER_ADDRESS from fnd_nodes where node_name = upper('uatartha');

NODE_NAME SERVER_ADDRESS
------------------------------ ------------------------------
DOYENSYS 192.168.1.33

Step 8 : Now start apps Tier.


Note id : How to Change IP Address in an Oracle Applications Environment ID 553318.1