Solved

Everyday crashes on ORACLE 9.2 and windows XP professionnal

Posted on 2003-10-23
9
1,785 Views
Last Modified: 2007-12-19
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


0
Comment
Question by:fba_mainsys
9 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 9604858
Seems you have no free place on the disk. The disk is full.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 9604866
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
 

Author Comment

by:fba_mainsys
ID: 9604898
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Expert Comment

by:schwertner
ID: 9605529
Point 1. ??
0
 

Author Comment

by:fba_mainsys
ID: 9605818
1. No quota on the directory
???
It's maybe more an XP problem than a oracle problem ...
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9608156
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
 

Author Comment

by:fba_mainsys
ID: 11386426
It was the norton antivirus when it scans control files, oracle crashes because files where locked.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12203952
PAQed, with points refunded (250)

Computer101
E-E Admin
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle- set role and grant privileges 6 51
Oracle function to insert records? 15 66
error in my cursor 5 51
why truncate is faster than delete in oracle ? 4 51
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question