欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM 博客分类: 数据库 unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

程序员文章站 2024-03-14 13:12:46
...

 

转载请注明出处:http://www.pm-road.com/index.php/2015/01/15/341/

今天在调项目的时候,突然报了这样一个错误 :

unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

具体错误信息如下:

WARN – com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a78424 — Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (5). Last acquisition attempt exception:  – [21:30:31,771]com.mchange.v2.resourcepool.BasicResourcePool
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

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.receiveOauth(T4CTTIoauthenticate.java:785)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
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 com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

 

一看这个错误,发现是因为数据库的表空间不足造成的,

所以解决这种问题大概有三种办法

(1)更改system表空间的数据文件SYSTEM.dbf分配空间
alter database datafile ‘/u04/oradata/truth/system.dbf’ resize 2048M;   //因为数据量很大,而且表内有多个用户,所以扩容到了2G,另外前面的system.dbf这个名字可和当时创建数据库时命名空间一致;
(2)为system表空间另外新增一个数据文件
(3)把system表空间中的表移到非系统表空间
检查下是否有其他非系统表放在系统表空间下,
要是有的话,可以移到非系统表空间
alter table move tablespace tablespace_name

unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
            
    
    博客分类: 数据库 unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM