安装oracle过程中死机,紧急求救:服务器上的oracle不定时死机!

环境:服务器硬件是自己组装的,4G内存/硬盘足够大

操作系统:windows 2003 server

数据库:oracle 9i 2.0.1.0

WEB server:tomcat 5.5

问题:系统每隔5-6个小时,oracle就会死掉,死掉的时候,用sqlplus都无法登录系统;此时如果重启tomcat,又能恢复正常;但是再隔5-6个小时,又会再次出现这种问题!tomcat报错如下:

java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=510)(EMFI=4))(ERROR=(BUF='32-bit Windows Error: 8: Exec format error'))))

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:418)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at SysClass.dbcommand.dbConnect(dbcommand.java:72)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:77)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)

at javax.servlet.http.HttpServlet.service(HttpServlet.java03)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)

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

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

at javax.servlet.http.HttpServlet.service(HttpServlet.java03)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java70)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)

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

oracle的spfile文件内容如下:

*.background_dump_dest='E:\oracle\admin\QUIK\bdump'

*.compatible='9.2.0.0.0'

*.control_files='E:\oracle\oradata\QUIK\CONTROL01.CTL','E:\oracle\oradata\QUIK\CONTROL02.CTL','E:\oracle\oradata\QUIK\CONTROL03.CTL'

*.core_dump_dest='E:\oracle\admin\QUIK\cdump'

*.db_block_size=8192

*.db_cache_size=104857600

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='QUIK'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=QUIKXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='QUIK'

*.java_pool_size=33554432

*.job_queue_processes=10

*.large_pool_size=8388608

*.open_cursors=800

*.pga_aggregate_target=25165824

*.processes=800

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=314572800

*.shared_pool_reserved_size=5016582

*.shared_pool_size=104857600

*.sort_area_size=524288

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='E:\oracle\admin\QUIK\udump'

曾经做过的修改:

这个问题困扰我好一段时间了,曾在网上找过一些方法,比如增加db_cache_size的大小,我将大小从32M增加到了100M,可是问题如故!请各位帮帮我,谢谢!

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:游动-白 设计师:我叫白小胖 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值