11 Replies Latest reply: Oct 12, 2012 3:14 PM by Osama_Mustafa RSS

    Unable to write trace files in Background dump destination in oracle 10g

    imran khan
      Hi All,

      OS version : RHEL 5.7
      DB version : 10.2.0.4
      cluster : 2 node RAC database

      Today I faced a strange behaviour for one of our production database. Its a 2-node rac database. On the first node there is no auto generation of trace files in the BAckground dump destination. I am able to see trace files of second in its background dump dest. But the strange behaviour occurs on the first node. I see only Alert log file in the background dump dest . Inspite of getting an error which shows trace file generated but no file occurs in the bdump. The following is the error but physically there no trace file generated:
      Errors in file /oracle/db/admin/<sid>/bdump/<sid>j0011558.trc:
      ORA-12012: error on auto execute of job 94377
      ORA-12008: error in materialized view refresh path
      Can anyone have any idea for this strange behaviour. There are no maintenance script for removal of trace files.

      Regards,
      Imran Khan