Skip to Main Content
Forums

Database Software

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!

ORA-29902, ORA-13203,ORA-29400

440705Jan 6 2006 — edited Jan 11 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2006
Added on Jan 6 2006
#database-key-features, #spatial
1 comment
4,757 views