see DBWR trace file

[Stephen Badgett]

Hi Yogeeraj

The problem is fixed now.

The DBWR trace file gave me nothing as to what the problem was and the trace function did not seem to be turned on or is at a low setting. Is the trace adjusted in the init.ora file?

Steve

[Stephen Badgett]

Hi T G Manikandan,

Thank you for your input.

The issue has been fixed.

I also looked in the alert.log file and see this but this is in a past for now and I will keep an eye out for other clues

ORA-00202: controlfile: 'ora_control5'
ORA-27037: unable to obtain file status


Steve

[Stephen Badgett]

Hi Printaporn

Ok, I wont use DBCA.

Steve

[Stephen Badgett]

Hi Sanjay Kumar Suri,

The DBCA, delete datafile operation did have problems at the end and I did not get a screen print of them but I thought it was asking me if I wanted to continue anyway and I did, BAD MOVE!

Any way the problem is fixed :)

Steve

[Stephen Badgett]

Thank you twang for your help in understanding the processes better.
The issue has be fixed.

Steve

[Stephen Badgett]

Hi Joseph Loo

This was the anser, thank you


Steve