oracle db error???

I did some program about jsp & servlet.I have a web server and a db server. web server enviroment: 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 automatically.I find some error message in tomcat log as below:
Can anybody help about this program?

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)

thanks advance
James Hou Received on Mon Apr 14 2003 - 22:20:23 CDT