一、问题描述

WEB端登录报错

查看apusic日志发现报错信息如下：

 ERROR WFD_JOB_WORKER_10]execute sql error: ORA-01552: cannot use

system rollback segment for non-system tablespace 'EAS_D_EAS860_STANDARD'

sql:UPDATE T_WFD_JOB_ENGINE SET "LAST_UPDATED_TIME" = ?, "LAST_MODIFIER" = ?, "IS_ACTIVE" = ?, "MASTER" = ? WHERE ("SERVER_ID" = ? AND "

IS_ACTIVE" = ?)

ksql:update T_WFD_JOB_ENGINE set "LAST_UPDATED_TIME"= ?,"LAST_MODIFIER"= ?,"IS_ACTIVE"= ?,"MASTER"= ? WHERE (("SERVER_ID" = ?) AND ("IS_

ACTIVE" = ?))

2021-11-07 21:24:03 INFO [con.out-Thread 265] WFD_JOB_WORKER_10:Error, 2021-11-07 21:24:03.054, cid: 79d3d50dade84e1da257ba4b2f5220de

        Failed to recall jobs from 13212@easap1!

详细信息: java.sql.SQLException: ORA-01552: cannot use system rollback segment for non-system tablespace 'EAS_D_EAS860_STANDARD'

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1039)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Unknown Source)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)

        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3689)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1066)

        at com.kingdee.bos.sql.shell.KDPreparedStatement.executeUpdate(KDPreparedStatement.java:358)

        at com.apusic.jdbc.adapter.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:100)

        at com.kingdee.wbos.kdb.KPreparedStatement.executeUpdate(KPreparedStatement.java:257)

        at com.kingdee.wbos.life.util.db.Table.execute(Table.java:291)

        at com.kingdee.wbos.life.util.db.Table.execute(Table.java:923)

        at com.kingdee.wbos.life.util.db.Table.batchUpdate(Table.java:866)

        at com.kingdee.wbos.life.util.job.core.ClusterMemberMonitor.setInactive(ClusterMemberMonitor.java:82)

        at com.kingdee.wbos.life.util.job.core.ClusterMemberMonitor.kickOut(ClusterMemberMonitor.java:87)

        at com.kingdee.wbos.life.util.job.core.ClusterMemberMonitor.refreshServers(ClusterMemberMonitor.java:65)

        at com.kingdee.wbos.life.util.job.core.ClusterMemberMonitor.execute(ClusterMemberMonitor.java:43)

        at com.kingdee.wbos.kdb.EasJobMonitor.execute(EasJobMonitor.java:25)

        at com.kingdee.wbos.life.util.job.core.ThreadWorker.execute(ThreadWorker.java:37)

        at com.kingdee.wbos.life.util.job.core.ThreadWorker.run(ThreadWorker.java:21)

        at com.kingdee.wbos.life.util.job.core.ThreadWorker.run(ThreadWorker.java:12)

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

二、解决办法

1.查看回滚段状态发现为offline。

 select segment_id, segment_name,status,tablespace_name from dba_rollback_segs;

2.针对现象修改undo_management参数为auto即可。

SQL>  alter system set undo_management=auto scope=spfile;

System altered.

3.重启。

4.查看回滚段状态，已修改为online

select segment_id, segment_name,status,tablespace_name from dba_rollback_segs;

5.测试登录客户端成功。