Scenario:
You notice below error on a Oracle DB server hosted on a Linux system if,
- your tablespace Extent DB file (.ddf) is over size of 2 GB on your Linux System
- you reached max file size of an Extent allowed for your tablespace
Weblog2.addRequest(testlaunch)
WelogEntry failed: action=launch remote=95.211.217.68 ref=null agent=Pingdom.com_bot_version_1.4_(http://www.pingdom.com/)
java.sql.SQLException: ORA-01653: unable to extend table APPINFRATABLE.WEBLOG_TEMP by 16158 in tablespace RAPP
ORA-27059: skgfrsz: could not reduce file size
Linux Error: 22: Invalid argument
Additional information: 1
ORA-27059: skgfrsz: could not reduce file size
Linux Error: 22: Invalid argument
Additional information: 1
ORA-27059: skgfrsz: could not reduce file size
Linux Error: 22: Invalid argument
Additional information: 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1209)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1321)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.AppInfraTable.site.WeblogEntry.create(WeblogEntry.java:82)
at com.AppInfraTable.site.WeblogEntry.update(WeblogEntry.java:174)
at com.AppInfraTable.site.Weblog2.addRequest(Weblog2.java:31)
at com.AppInfraTable.site.RunFront.doGet(RunFront.java:1981)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:392)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
FIX:
Add another file to the tablespace so that DB will continue to take updates. To add a new file, you can use ALTER TABLESPACE ADD DATAFILE with appropriate values for min and max values.
Example:
ALTER TABLESPACE GAPP
ADD DATAFILE ‘/u02/oracle/rbdb1/users03.dbf’
SIZE 10M
AUTOEXTEND ON
NEXT 50M
MAXSIZE 2048M
