Solved

Everyday crashes on ORACLE 9.2 and windows XP professionnal

Posted on 2003-10-23
9
1,805 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: 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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

728 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