asked on

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

schwertner

Seems you have no free place on the disk. The disk is full.

schwertner

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.

fba_mainsys

ASKER

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 ?

schwertner

Point 1. ??

fba_mainsys

ASKER

1. No quota on the directory
???
It's maybe more an XP problem than a oracle problem ...

seazodiac

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

fba_mainsys

ASKER

It was the norton antivirus when it scans control files, oracle crashes because files where locked.

ASKER CERTIFIED SOLUTION

Computer101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial