1 Reply Latest reply on Jan 11, 2006 1:48 PM by 10275

    ORA-29902, ORA-13203,ORA-29400

    440705
      I hope someone can help. I am querying spatial data through mapviewer but sometimes I get a whole bunch of errors (see below) whilst othertimes the same tables etc are fine. We are only working with a tiny amount of data as this is a development db. When running on OC4J standalone we did not recieve these errors, only since we have installed on the application server do we receive them. Any help greatly appriciated.

      TIA

      Chris

      06/01/06 17:26:31 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: WATER

      06/01/06 17:26:31 ERROR [oracle.sdovis.theme.pgtp] 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(DatabaseError.java:137)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)

      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)

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

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

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2973)

      at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:498)

      at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:229)

      at oracle.sdovis.Theme.prepareData(Theme.java:174)

      at oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)

      06/01/06 17:26:31 ERROR [oracle.sdovis.DBMapMaker] Message:Exception while querying theme: WATER

      Description: Nested exception is:

      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

      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(DatabaseError.java:137)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)

      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)

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

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

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2973)

      at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:498)

      at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:229)

      at oracle.sdovis.Theme.prepareData(Theme.java:174)

      at oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)

      06/01/06 17:26:31 WARN [oracle.sdovis.theme.DGTP] 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(DatabaseError.java:137)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)

      at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:430)

      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)

      at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:462)

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

      at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1270)

      at oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:241)

      at oracle.sdovis.Theme.prepareData(Theme.java:174)

      at oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)

      06/01/06 17:26:31 ERROR [oracle.sdovis.DBMapMaker] Message:null

      Description: Nested exception is:

      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

      there is lots more but thought the above would be enough