java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-29400: data cartridge error ORA-04031: unable to allocate 76 bytes of shared memory ("shared pool","SELECT diminfo, nvl(srid,-1)...","Typecheck","qksxaAddList:xa") ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

Oracle Community | 440705 | 1 decade ago
  1. 0

    ORA-29902, ORA-13203,ORA-29400

    Oracle Community | 1 decade ago | 440705
    java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-29400: data cartridge error ORA-04031: unable to allocate 76 bytes of shared memory ("shared pool","SELECT diminfo, nvl(srid,-1)...","Typecheck","qksxaAddList:xa") ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
  2. 0

    Map Viewer Connection Timeouts after Inactivity

    Oracle Community | 1 decade ago | 409679
    java.sql.SQLException: ORA-01012: not logged on
  3. 0

    MapViewer generates ORA-13226:inteface not supported without a spatial indx

    Oracle Community | 1 decade ago | 495194
    java.sql.SQLException: ORA-132 26: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 468 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Select the Oracle java - ORA-00905: not found keyword

    Stack Overflow | 11 months ago | Paulo Silva
    java.sql.SQLException: ORA-00905: not found keyword
  6. 0

    Error while updating user Organization

    Oracle Community | 9 years ago | chii
    java.sql.SQLException: ORA-00921: unexpected end of SQL command

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-29400: data cartridge error ORA-04031: unable to allocate 76 bytes of shared memory ("shared pool","SELECT diminfo, nvl(srid,-1)...","Typecheck","qksxaAddList:xa") ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
      6. oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:430)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)
      8. oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:462)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1270)
      10 frames
    3. oracle.sdovis.theme
      DynGeomThemeProducer.prepareData
      1. oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:241)
      1 frame
    4. oracle.sdovis
      DBMapMaker$LoadThemeData.run
      1. oracle.sdovis.Theme.prepareData(Theme.java:174)
      2. oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)
      2 frames