遭遇数据库宕机的问题，影响应用

####<2011-6-22 上午11时28分15秒 CST> <Error> <HTTP> <chnweb1> <mgserver1> <ExecuteThread: '192' for queue: 'weblogic.kernel.Default'
> <<WLS Kernel>> <> <BEA-101017> <[ServletContext(id=18612290,name=MgWebApp,context-path=)] Root cause of ServletException.
java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:293)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
        at com.sitech.crmpd.core.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:23)
        at com.sitech.crmpd.core.taglib.support.PageListUtil.query(PageListUtil.java:52)
        at com.sitech.crmpd.core.taglib.PageListInfoTag.doStartTag(PageListInfoTag.java:64)
        at jsp_servlet._npage._common._business.__billmodechange_pre._jspService(footer.jsp:673)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
        at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.sitech.crmpd.echn.filter.rstrt.RstrtFilter.doFilter(RstrtFilter.java:110)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.sitech.crmpd.logstat.AccessFilter.doFilter(AccessFilter.java:93)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at com.sitech.crmpd.echn.filter.priv.UrlPrivFilter.doFilter(UrlPrivFilter.java:178)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
--More--(41%)

评论

1 楼 zhile005 2011-06-22  

数据库应该做HA或者RAC的。