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