Everyday crashes on ORACLE 9.2 and windows XP professionnal

I have everyday crashes with an oracle datadase.

It comes from something that lock the control files and oracle cannot access again to this file.

Which windows XP process can do this ??

here is the logs (sorry it's in french) :
Wed Oct 22 15:03:04 2003
Errors in file c:\oracle\admin\swcsccp\bdump\swcsccp_ckpt_1132.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORACLE\ORADATA\SWCSCCP\CONTROL03.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 1453) Quota insuffisant pour terminer le service demandé.
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORACLE\ORADATA\SWCSCCP\CONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 1453) Quota insuffisant pour terminer le service demandé.
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORACLE\ORADATA\SWCSCCP\CONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 1453) Quota insuffisant pour terminer le service demandé.

et avant :
*** 2003-10-22 15:02:56.000
*** SESSION ID:(18.9777) 2003-10-22 15:02:56.000
Descripteur non valide
Descripteur non valide
Descripteur non valide
Descripteur non valide
Descripteur non valide
Descripteur non valide

What can happen at control files.

thanks a lot

Francois


fba_mainsysAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
Seems you have no free place on the disk. The disk is full.
0
schwertnerCommented:
fact: Oracle Server - Enterprise Edition
fact: MS WINDOWS 2000
symptom: Database crashes
symptom: ORA-00206: error in writing (block %s, # blocks %s) of controlfile
symptom: ORA-00202: controlfile: '%s'
symptom: ORA-27072: skgfdisp: I/O error
symptom: OSD-04008: WriteFile() failure, unable to write to file
symptom: O/S-Error: (OS 1453) Insufficient quota to complete the requested
service.
symptom: CKPT: terminating instance due to error 221
cause: The OS is unable to complete the write request from Oracle due to a
quota being enforced at the OS level.
This is basically raised by the OS and it is a Windows 2000 problem.



fix:

1. Check the properties of the drives used by Oracle (for holding the software
and the datafiles) under the quota tab and make sure you have quotas disabled
by clearing the 'Enable Quota Management' check box and apply.

2. If the above doesn't help then add more RAM.

0
fba_mainsysAuthor Commented:
1. the disk in not full 10 gigas left
2. I do a chkdsk all seem OK
3. Oracle take between 200 and 400 MB memory on 1GB and only oracle run on this machine, I think it's enough. Isn't it ?

Other ideas ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

schwertnerCommented:
Point 1. ??
0
fba_mainsysAuthor Commented:
1. No quota on the directory
???
It's maybe more an XP problem than a oracle problem ...
0
seazodiacCommented:
I had this problem before. the reason why you don't have Quota tab is that the drives are NOT in NTFS Format. That's right. YOu cannot enable quota management in FAT drive.

so what I did was to move all the files on that drive to the other disk temporarily, and then format the disk to NTFS format. and then move the files back. (of course, you have to shutdown the oracle database before doing any of these). Then enable the disk quota.

guess what? the problem is gone with the wind....

Hope this helps
0
fba_mainsysAuthor Commented:
It was the norton antivirus when it scans control files, oracle crashes because files where locked.
0
Computer101Commented:
PAQed, with points refunded (250)

Computer101
E-E Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.