5 Replies Latest reply: Dec 21, 2011 1:55 PM by Hussein Sawwan-Oracle RSS

    Oracle Support ORA-4031 Troubleshooting Tool problem - FILE VALIDATION FAIL

    906841
      Hi,
      Having problem while trying to use ORA-4031 Troubleshooting Tool on the Oracle Support site.

      I believe I upload all files correctly: db alert log, 4031 trace file and AWR report (HTML), answered YES to the question.
      But, get this error:

      "FILE VALIDATION FAILED: Fatal Error: missing 4031 information in the trace file. ..."

      However, the trace file has 4031 error information:

      (...)
      *** SERVICE NAME:(SYS$BACKGROUND) 2011-12-20 08:27:06.548
      *** SESSION ID:(546.1) 2011-12-20 08:27:06.548
      *** 2011-12-20 08:27:06.548
      AUTO SGA: Dumping stacks and disabling background sga tuning on error 604, simerr=0
      ORA-00604: error occurred at recursive SQL level 2
      ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select shared_pool_size_for_...","Typecheck","kgghteInit")
      ----- Call Stack Trace -----
      calling call entry argument values in hex
      location type point (? means dubious value)
      -------------------- -------- -------------------- ----------------------------
      ksedst+001c bl ksedst1 000000000 ? 646F33002040000 ?
      kmgsb_tune+0ce0 bl 03F5A418
      ksbcti+03d8 bl _ptrgl              
      ksbabs+025c bl ksbcti FFFFFFFFFFFD068 ? 000000006 ?
      70000004D63CBA0 ?
      kebm_mmon_main+02e4 bl 01FC6DA4
      ksbrdp+0408 bl _ptrgl              
      opirip+03fc bl 03F59B14
      opidrv+0448 bl opirip 110278B10 ? 41027B9D0 ?
      FFFFFFFFFFFF340 ?
      sou2o+0090 bl opidrv 3202AB38FC ? 440656000 ?
      FFFFFFFFFFFF340 ?
      opimai_real+0150 bl 01FC4EB4
      main+0098 bl opimai_real 000000000 ? 000000000 ?
      __start+0098 bl main 000000000 ? 000000000 ?

      --------------------- Binary Stack Dump ---------------------

      ========== FRAME [1] (ksedst+001c -> ksedst1) ==========
      Dump of memory from 0x0FFFFFFFFFFFBB70 to 0x0FFFFFFFFFFFBBE0
      FFFFFFFFFFFBB70 0FFFFFFF FFFFBBE0 42842228 00000000 [........B."(....]
      FFFFFFFFFFFBB80 00000001 000D9DE0 00000000 00000000 [................]
      FFFFFFFFFFFBB90 00000000 00000000 00000001 102242E8 [............."B.]
      FFFFFFFFFFFBBA0 00000000 00000000 0646F330 02040000 [.........F.0....]
      FFFFFFFFFFFBBB0 00000001 10000B00 00000001 05294C08 [.............)L.]
      FFFFFFFFFFFBBC0 00000000 0000025C 00000000 0000025C [.......\.......\]
      FFFFFFFFFFFBBD0 00000001 101902C0 0FFFFFFF FFFFBBE0 [................]
      ========== FRAME [2] (kmgsb_tune+0ce0 -> 03F5A418) ==========
      Dump of memory from 0x0FFFFFFFFFFFBBE0 to 0x0FFFFFFFFFFFBFE0
      FFFFFFFFFFFBBE0 0FFFFFFF FFFFCE60 00000000 00000000 [.......`........]
      FFFFFFFFFFFBBF0 00000001 04356164 00000000 00000000 [.....5ad........]
      (.... etc.)

      What am I doing wrong ?

      Oracle 10.2.0.3 (compatible=9.2.0) on AIX.

      Thanks.