Saturday, October 18, 2008

After Cloning Apps could not start

Scenario:

1. After cloning and when we start the database and apps it start but when we see the log file in $APPLCSF/log

It shows the following error message

Error:

JSP Error
Exception:java.lang.RuntimeException: Cannot get Connection to the Database
at oracle.apps.fnd.sso.Utils.getConnection(Utils.java:190)
at _oa__html._fndvald._jspService(_fndvald.java:72)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
at oracle.jsp.JspServlet.service(JspServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:484)

Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Oracle HTTP Server Powered by Apache/1.3.19 Server at devpserv.sical.in Port 8272

Cause :

In the Pfile the parameter named PROCESS value is very less , So it cannot use all the process and so it starts killing the processes.

Solution:

1.Check the DB, it is not started and though it is started some process are killed.
2.Check $APPLCSF/log and check the files that are last updated. 3.There is a error that max no of connections ORA-
4.Now in the init parameter of database increase the process=400
5.change in the xml file of database and run autoconfig in database side.

No comments: