11 Replies Latest reply on May 6, 2020 12:14 AM by Glen Conway

    Could not start SQL Developer All of sudden from April 24 2020

    4241101

      I am using fedora linux desk top. Normally I start the SQLDeveloper using command-line. all of sudden, I could not start SQL developer from April 24, 2020. The startup get hang with empty UI screen. Below I output the debug log.

       

      Thank you!

       

      Daniel

       

      ]]

      Error occurred during execution of: [CALL, begin

        insert into sqldev_usage(id,status,created_on,usage_data)

         values (SQLDEV_USAGE_SEQ.nextval,'NEW',sysdate,/*in:body*/?);

      end;, [body, in, class java.io.InputStream]]with values: {1=weblogic.servlet.internal.ServletInputStreamImpl@10698838}

      ORA-01654: unable to extend index DBTOOLS.SQLDEV_USAGE_IDX1 by 8192 in tablespace USERS

      ORA-06512: at line 2

       

       

      java.sql.SQLException: ORA-01654: unable to extend index DBTOOLS.SQLDEV_USAGE_IDX1 by 8192 in tablespace USERS

      ORA-06512: at line 2

       

       

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)

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

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

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

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

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)

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

      at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)

      at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)

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

      at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4274)

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

      at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OracleCallableStatement$$$Proxy.executeUpdate(Unknown Source)

      at oracle.dbtools.common.stmt.jdbc.BindableCallImpl.execute(BindableCallImpl.java:85)

      at oracle.dbtools.rest.resource.generator.plsql.PLSQLGenerator.service(PLSQLGenerator.java:89)

      at oracle.dbtools.rest.resource.generator.ResourceGeneratorsProvider.generate(ResourceGeneratorsProvider.java:99)

      at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate.service(ModulesDispatcherDelegate.java:133)

      at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate.service(ModulesDispatcherDelegate.java:60)

      at oracle.dbtools.rest.resource.jdbc.JDBCResourceDispatcher.service(JDBCResourceDispatcher.java:81)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

      at oracle.dbtools.http.servlet.DispatchableServletBase.service(DispatchableServletBase.java:58)

      at oracle.dbtools.rest.resource.cache.CachedResourceDispatcher.service(CachedResourceDispatcher.java:59)

      at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:126)

      at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:239)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)

      at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:90)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:68)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:68)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:71)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:101)

      at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:64)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.url.mapping.RequestMapperImpl.doFilter(RequestMapperImpl.java:160)

      at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:92)

      at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:140)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.rt.authentication.apex.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:89)

      at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65)

      at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:98)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)

      at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

      at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

      at oracle.dbtools.http.filters.Filters.filter(Filters.java:67)

      at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82)

      at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:115)

      at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)

      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)

      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at oracle.apmaas.browser.jsp.BaseFilterWrapper$JspFilter.doFilter(BaseFilterWrapper.java:362)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3706)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3672)

      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:328)

      at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

      at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

      at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)

      at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)

      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)

      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)

      at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1705)

      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1665)

      at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)

      at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

      at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

      at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

      at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

      at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:652)

      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

      at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

      Caused by: Error : 1654, Position : 0, Sql = begin

        insert into sqldev_usage(id,status,created_on,usage_data)

         values (SQLDEV_USAGE_SEQ.nextval,'NEW',sysdate,:1 );

      end;, OriginalSql = begin

        insert into sqldev_usage(id,status,created_on,usage_data)

         values (SQLDEV_USAGE_SEQ.nextval,'NEW',sysdate,?);

      end;, Error Msg = ORA-01654: unable to extend index DBTOOLS.SQLDEV_USAGE_IDX1 by 8192 in tablespace USERS

      ORA-06512: at line 2

       

       

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

      ... 102 more

       

       

      [TE] dispatch start: 2020-04-27T23:39:31.504Z duration: 161ms

      [TE] POST /pls/apex/dbtools/usage/upload start: 2020-04-27T23:39:31.460Z duration: 207ms

       

       

      </pre>

      </div>