SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

4241101Apr 28 2020 — edited May 5 2020

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)