我得到下面的错误，而连接到oracle数据库。
java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.07-09-2016 12:25:44 ERROR DBUtils:122 - loginUser Exception :java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:444)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:407)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:416)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.sne.dao.DBUtils.loginUser(DBUtils.java:55)
at com.sne.servlets.SELogin.doPost(SELogin.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:323)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1719)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)通过SQL Developer连接数据库时出错...
3条答案
按热度按时间6ovsh4lw1#
您必须通过删除archivelogs和备份来释放空间。
1.使用rman（恢复管理器）命令。只需在命令行中键入rman
1.连接到目标数据库
1.使用删除备份
delete backup;或仅包含以下内容的过时备份文件：delete obsolete;1.删除归档日志：
delete force copy of archivelog all;参考号：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=153283327861734&id=2340995.1&_afrWindowMode=0&_adf.ctrl-state=mku6itxsh_4
7vhp5slm2#
归档器负责获取联机重做日志，并在数据库恢复需要这些日志时将它们写到安全的地方。
目前他们无法做到这一点，所以他们正在阻止对数据库的任何操作，直到DBA将其全部整理出来。
jutyujz03#
因为Oracle存档已满。创建维护作业以执行日常清理。