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

    MapViewer with data from multiple schemas

    Oracle Community | 10 years ago | 578019
    java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
  3. 0

    Limitation in MapViewer

    Oracle Community | 1 decade ago | 448590
    java.sql.SQLException: ORA-29903: error in executing ODCIIndexFetch() routine ORA-13236: internal error in R-tree processing: [] ORA-13236: internal error in R-tree processing: [Recursive fetch error]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Is MapViewer 10.1.2 able to display 16bit grey scale images?

    Oracle Community | 9 years ago | 543828
    java.sql.SQLException: ORA-00923: FROM keyword not found where expected
  6. 0

    ORA-06553: PLS-907: cannot load library unit MD... | Oracle Community

    oracle.com | 8 months ago
    java.sql.SQLException: ORA-29900: operator binding does not exist ORA-06540: PL/SQL: compilation error ORA-06553: PLS-907: cannot load library unit MDSYS.SDO_3GL (referenced by MDSYS.SDO_FILTER)

    12 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
      OraclePreparedStatement.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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2973)
      11 frames
    3. oracle.sdovis.theme
      PredGeomThemeProducer.prepareData
      1. oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:498)
      2. oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:229)
      2 frames
    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