Solved

Everyday crashes on ORACLE 9.2 and windows XP professionnal

Posted on 2003-10-23
9
1,756 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 47

Expert Comment

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

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 47

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

825 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