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

John Thorton 
Laury wrote:
Hi,
Does soneone know if there is a way to check if a BLOB image is either jpg, png, or gif?

yes, it is possible & MS Windows does it incessantly every second.

First you start with enumerating file content differences between the different image types.

Mike Kutz

Compare the "magic numbers".

https://en.wikipedia.org/wiki/List_of_file_signatures

Normally, I'd say "use Oracle MultiMedia data type ORD_IMAGE" -- but - that was deprecated/no longer supported.

MK

Laury

Hi, and inside a PL/SQL block?

Cookiemonster76

With great difficultly I suspect.

Why don't you just store the image type in a separate column when inserting the blob?

1 person found this helpful
Mike Kutz 
Laury wrote:
Hi, and inside a PL/SQL block?

Use the following:

  • TO_BLOB(HEXTORAW())
  • DBMS_LOB.SUBSTR()
  • DBMS_LOB.COMPARE()

Normally, you want to store the following data inside the table

  • actual BLOB data
  • MIMEType - This is what you actually need to determine "image/jpeg" vs "image/bmp" (never "file extension")
  • (opt)Filename -- or have a process to calculate it dynamically
  • (opt)BLOB size -- can be calculated dynamically with DBMS_LOB.GetLength().  This is required by most frameworks.  Storing the value in the table saves a few jiffies

I'm assuming that you need to find out what the MIMEType is.

MK

3 people found this helpful
Laury

@Cookiemonster76:

This is OK if know the image type before to store it in a table.

How can I get that type at the time I download that image?

@Mike:

Nice tips, but with these functions, how can I get the image type (jpeg, bmp,...)?

Kind Regards

cormaco
Answer

Here is a basic example:

Extract the first 3 bytes from the BLOB and compare it with 'FFD8FF'. According to the list of signatures in the link that Mike posted, this is then a JPG:

select case when dbms_lob.substr(product_image,3,1) = hextoraw('FFD8FF') then 'JPG' end as image_type from demo_product_info

You can extend this case expression for any other file type.

Marked as Answer by Laury · Sep 27 2020
1 person found this helpful
Mike Kutz 
Laury wrote:

@Mike:
Nice tips, but with these functions, how can I get the image type (jpeg, bmp,...)?
Kind Regards

Read the section "Magic Number in Files" to understand what you need to do.  (ie compare first n bytes to something)

https://en.wikipedia.org/wiki/Magic_number_(programming)

The "List of file signatures" has the something you need to compare to.

https://en.wikipedia.org/wiki/List_of_file_signatures

I leave it as an exercise to the student to create a function that discovers what the MIME Type is for a file based on a "short list" of "known image/* MIMETypes".

You may need to use one or more of the following:  (the student should read the documentation on such functions)

  • TO_BLOB(HEXTORAW()) -- static string to BLOB (I haven't tried comparing RAW to BLOB)
  • DBMS_LOB.SUBSTR() -- extract "first n bytes"
  • DBMS_LOB.COMPARE() -- compare BLOB to BLOB

Final hint:  IN OUT NOCOPY

Beyond that, you should post up "what you have tried".

My $0.02

MK

1 person found this helpful
Laury

Hi Mike,

I have seen your post, I will come back to it as soon as I can.

Kind Regards

Laury

Hi,

Thanks for all the answers.

@Mike:

You asked: Beyond that, you should post up "what you have tried".

At that stagem I had tried nothing. Just when dowmloading an image from the filesystem to the database using a PL/SQL procedure, I wanted to check what kind of image it was: PNG, JPG,...

So, in fact to be able to identify a mimetype.

I know it is possble when loading it through APEX...

You posted very interesting links, and I feel I am like a student :-)

@Cormaco:

Yes, you posted a quick solution, that is actually good enough for my needs.

@John:

Yes, that's possible... but you didn't explained how it can be catched by PL/SQL up.

Kind Regards

1 - 10
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,755 views