This discussion is archived
11 Replies Latest reply: Oct 12, 2012 1:14 PM by Osama_Mustafa RSS

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

imran khan Journeyer
Currently Being Moderated
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

Legend

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