EBS Web登陆跳转 因游标数爆掉 报错

登陆错误信息如下：

详细错误信息：

Error Page

Exception Details.

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.

at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:279)

at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1300)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

at _OA._jspService(_OA.java:212)

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)

at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)

at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)

at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)

at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)

at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)

at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)

at _RF._jspService(_RF.java:225)

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)

at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)

at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

at java.lang.Thread.run(Thread.java:619)

## Detail 0 ##

而后得知 数据库游标数设置太小，爆掉了，解决方法如下：

1、将应用正常停掉

2、数据库修改参数

查看最大游标数

show parameter open_cursors;

查看当前打开的游标数目

select count(*) from v$open_cursor;

修改最大游标数

alter system set open_cursors=1000 scope=both;

然后重启数据库

3、正常启动应用，登陆测试 问题解决

(笔者原创文章，转载请注明出处：https://blog.csdn.net/LFCuiYs）谢谢！