Oracle 错误小记

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/hljlzc2007/article/details/5825872

昨天组内进行新产品的测试,我来搭建Oracle数据库,在启动数据库后,一切正常。今天早上,我发现机器很慢,重启机器后,然后重启Oracle,在执行sqlplus /nolog; connect / as sysdba; 的时候报如下的错误:
ERROR:
ORA-28056: Writing audit records to Windows Event Log failed
ORA-28056: Writing audit records to Windows Event Log failed

解决办法:

打开windows事件查看器,clear all logs,重新连接数据库,一切OK啦

 

window只知道记日志,也不说自动清理一下,小小的鄙视一下

展开阅读全文

oracle 错误

12-03

[code=java]rnJDBCExceptionReporter - SQL Error: 0, SQLState: nullrnJDBCExceptionReporter - Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)rnSettingsFactory - Could not obtain connection metadatarnorg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)rn at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)rn at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)rn at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)rn at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)rn at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)rn at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:777)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:703)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)rn at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)rn at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)rn at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)rn at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)rn at org.springframework.web.struts.ContextLoaderPlugIn.createWebApplicationContext(ContextLoaderPlugIn.java:354)rn at org.springframework.web.struts.ContextLoaderPlugIn.initWebApplicationContext(ContextLoaderPlugIn.java:295)rn at org.springframework.web.struts.ContextLoaderPlugIn.init(ContextLoaderPlugIn.java:225)rn at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:839)rn at org.apache.struts.action.ActionServlet.init(ActionServlet.java:332)rn at javax.servlet.GenericServlet.init(GenericServlet.java:160)rn at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)rn at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)rn at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)rn at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)rn at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)rn at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)rn at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)rn at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)rn at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)rn at java.util.concurrent.FutureTask.run(Unknown Source)rn at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)rn at java.lang.Thread.run(Unknown Source)rnCaused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connectionrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)rn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)rn at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)rn at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:413)rn at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:164)rn at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)rn at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)rn at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)rn at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)rn at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)rn at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)rn ... 40 morern[/code] 论坛

没有更多推荐了,返回首页