This discussion is archived
0 Replies Latest reply: Aug 28, 2013 8:49 PM by mmaller0319 RSS

XML DB Issue 7445

mmaller0319 Newbie
Currently Being Moderated

Hi Experts,

.Its a case of ORA-7445.

 

We have got ourselves into a situation where Oracle support is also not able to help us after 3 months of case being open.

We are still trying with them but now i am also looking into forums for any help.

 

Here is the issue.

 

We have XMLDB component installed for our Tibco Application.

 

Once in a week,at random times ,Tibco starts seeing timeouts and we start seeing row lock contention wait events for a below insert statement

 

INSERT 

INTO xml_default

   (

      doc_id, 

      static_id, 

      xml_doc,

      app_id,

      doc_type,

      requestor_id,

      created_date,

      last_updated_date,

      created_by,

      last_updated_by

   ) 

   VALUES 

   (

      :v0,

      :v1,

      XMLType(bfilename('XMLDIR_NEW',:v2), nls_charset_id('AL32UTF8')),

      :v3,

      :v4,

      :v5,

      sysdate,

      sysdate,

      :v6,

      :v7

   )

 

 

Tibco App claims all inserts are auto committed.

When that happens we see the below in alert log being flooded.

 

ORA-07445: exception encountered: core dump [kgghash()+96] [SIGSEGV] [ADDR:0x1600000001] [PC:0x1001A40E0] [Address not mapped to object] []

 

ORA-07445: exception encountered: core dump [qmtxRemoveRef()+244] [SIGSEGV] [ADDR:0x48] [PC:0x10199AF34] [Invalid permissions for mapped object] []

 

 

The only way we get around the issue is we bounce the database and the listener.Its becoming a regular fact that now we are boucing production once a week .

 

Has anyone seen issues like above and is there anything we can do from Database level.?

 

Kindly suggest if someone has seen such issues.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points