0 Replies Latest reply: Aug 28, 2013 10:49 PM by mmaller0319 RSS

    XML DB Issue 7445

    mmaller0319

      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.