Unable to locate shared memory

[Mandy Yan]

My application is run on WebSphere Advanced Single Server. The following error occurs suddenly.
Does anyone have idea on the problem?
Thanks!
--------------------------------------------------
Error Details : javax.servlet.ServletException: ORA-04031: unable to allocate 72048 bytes of shared memory ("large pool","unknown object","hash-join subh","kllcqc:kllcqslt")
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:609)
at eng.readonly_5F_version._SearchClaimResult_jsp_0._jspService(_SearchClaimResult_jsp_0.java:692)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:301)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:445)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:579)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:137)
--------------------------------------------------

[Paresh Sharma]

hi,
cud u pls specify where is the repository of websphere...is it on oracle??

[Baba Batsha]

Check with your DBA

[Mandy Yan]

Would you mind telling me exactly what "repository" of WebSphere is?
Thanks a lot!

[Paresh Sharma]

When we install websphere, we need to specify a database where we need to store the configurations of websphere itself. i am refering repository as this datastore.it can be oracle /DB2.
the error that you are getting is probably because the tablespace allocated to the repository is not sufficient. plus there are some tables where you would need to increase the max extents. this problem can be ideally handled by a DBA who should increase the tablespace and check the scenario again.
hope it helps!!

[Rahul Mahindrakar]

"repository" is where the administrative server tries to find its configuration information. This is similar to the config.xml file for weblogic 6x. Thus in version 3.5 of WAS was a database. However in 4.0 it can be a database or a XML file based on which edition of WAS 4.0 you are using.

[Mandy Yan]

I use WebSphere Advanced Single Server 4.0.
I saw that there is a "server-cfg.xml" file.
The "unable to allocate shared memory" problem has occurred occasionally for several times.
Does anyone know what my problem is?
[ July 17, 2002: Message edited by: Mandy Yan ]
[ July 17, 2002: Message edited by: Mandy Yan ]

[Mandy Yan]

I would like to ask what the problem in oracle will cause "unable to allocate shared memory" problem?
Thanks.

[Baba Batsha]

On what platform your Oracle is running?.
I have come accross tuning shared memory tuning on SuSE 7.2 for Oracle 8i

[Mandy Yan]

I use WebSphere Advanced Single Server 4.0 with Oracle 9i on Windows 2000 platform.
Would you mind telling me how you tune the shared memory?
Thanks a lot!

[Kyle Brown]

This is not a WebSphere problem. This is an oracle problem. Look up the error code ORA-04031 in the Oracle docs and follow the instructions given there. A 15-second Google search yielded the following hits:
http://www.cryer.co.uk/brian/oracle/ORA04031.htm
http://www.oracle.com/oramag/oracle/02-jul/index.html?o42tuning.html
Kyle
[ July 19, 2002: Message edited by: Kyle Brown ]

[Baba Batsha]

good shot Kyle!
It is an Oracle issue.
Many Oracle DBAs are aware of this..thats why I said in my previous post to check with your DBA.
By reading the link you posted...we does not have to be a DBA to do this..