Re: oracle db error?help!!!

Your shared pool is not big enough.

 From oerr:

oerr ora 4031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"

// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *Action: If the shared pool is out of memory, either use the
//          dbms_shared_pool package to pin large packages,
//          reduce your use of shared memory, or increase the amount of
//          available shared memory by increasing the value of the
//          INIT.ORA parameters "shared_pool_reserved_size" and
//          "shared_pool_size".
//          If the large pool is out of memory, increase the INIT.ORA
//          parameter "large_pool_size".

--
Ron Reidy
Oracle DBA

James Hou wrote:


> I did some work about jsp & servlet program.I have a web server and a db

> server.

> web server environment:tomcat 4.18,redhat linux 7.2,512M memory

> db server enviroment:oracle 8.1.7 for linux,redhat linux 7.2,512M memory

> My db server always shutdown report some error message as below:

> Can anybody give me an hint about this error?

> 

> 

> 2003-04-15 08:19:05 StandardWrapperValve[jsp]: Servlet.service() for servlet

> jsp threw exception

> org.apache.jasper.JasperException: ORA-00604: error occurred at recursive

> SQL level 2

> ORA-04031: unable to allocate 4200 bytes of shared memory ("shared

> pool","TRIGGER$","sga heap","state objects")

> ORA-00604: error occurred at recursive SQL level 2

> ORA-04031: unable to allocate 4200 bytes of shared memory ("shared

> pool","SEQ$","sga heap","state objects")

> 

>  at

> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2

> 48)

>  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

>  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

>  at

> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application

> FilterChain.java:247)

>  at

> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh

> ain.java:193)

>  at

> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja

> va:260)

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:643)

>  at

> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>  at

> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja

> va:191)

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:643)

>  at

> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>  at

> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)

>  at

> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180

> )

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:643)

>  at

> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.

> java:170)

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:641)

>  at

> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172

> )

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:641)

>  at

> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>  at

> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java

> :174)

>  at

> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok

> eNext(StandardPipeline.java:643)

>  at

> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>  at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

>  at

> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)

>  at

> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne

> ction(Http11Protocol.java:386)

>  at

> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)

>  at

> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav

> a:530)

>  at java.lang.Thread.run(Thread.java:536)

> 

>