Is anybody running a copy command or a backup program which is locking the
file ?
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Shibu" <[EMAIL PROTECTED]> 25/02/2002 07:43 PM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: Re: ORA-27072
Hi abhijit....
when i restart the database it goes fine and again it goes down after
10-12 hours of working continiously ......
Is this a bug ?? The version is as given below .
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
regards,
shibu
----- Original Message -----
From: Abhijit
To: Multiple recipients of list ORACLE-L
Sent: Monday, February 25, 2002 3:58 PM
Subject: Re: ORA-27072
I think It's hitting the bug of 8.1.7.2.
Is the database gets opened normally after it goes down intermittantly ?
or does it gives the error whilt opening also ?
What 's the exact verion/release of 8.1.7 ? try applying the latest patch
.
Hallas John wrote:
Have a word with your sysadmin. See if I can find out what/who is
using that fileAre all datafiles/control files and redo log etc owned
by the same user (Oracle) and with the same permissionsSeems odd that
it appears to be random across a number of filesHTH John
-----Original Message-----
From: Shibu [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2002 06:18
To: Multiple recipients of list ORACLE-L
Subject: ORA-27072
Hi all.......... My database is going down frequently showing
this error in alertfile . This is happening to different
datafiles and controlfiles.What are the possibilities that cause
this error ? How can i avoid this error ? oracle 8.1.7 in win2k
Errors in file C:\oracle\admin\acusis\bdump\acusisCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\ORADATA\CONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file. regards, shibu
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended
to be
for the use of the individual(s) or entity named above. If you are
not the
intended recipient be aware that any disclosure, copying,
distribution or
use of the contents of this information is prohibited. If you have
received
this electronic message in error, please notify us by telephone or
email
(to the numbers or address above) immediately.
=========================================================
*********************************************************
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.
*********************************************************
Visit us at http://www.mahindrabt.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
