Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-27072

Re: ORA-27072

From: Shibu <basher.shibu_at_acusis.com>
Date: Mon, 25 Feb 2002 03:43:21 -0800
Message-ID: <F001.00417571.20020225034321@fatcity.com>


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

  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:basher.shibu_at_acusis.com] 
      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: Shibu
  INET: basher.shibu_at_acusis.com

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: ListGuru_at_fatcity.com (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). Received on Mon Feb 25 2002 - 05:43:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US