Skip to Content
avatar image
Former Member

Database termination Problem

Hi every body ..plz help me on this..

We are facing database termination problem in ECC6 production syste.

Database: Oracle 10.2, O/S: Windows 2003. Spam :27, SP level 13.

Error is:

Errors in file f:\oracle\p02\saptrace\background\p02_ckpt_6520.trc:

ORA-00206: error in writing (block 3, # blocks 1) of control file

ORA-00202: control file: 'D:\ORACLE\P02\ORIGLOGB\CNTRL\CNTRLP02.DBF'

ORA-27072: File 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.

When we are performing backup then data base termination occuring freequently.

Give right solution as early as possible.

Thanks,

Nani.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Aug 25, 2008 at 04:37 AM

    Hello. Per Note Note 546006 - Problems with Oracle due to operating system errors :

    "This is caused by an external Oracle process that blocks a file that Oracle wants to access."

    Like antivirus or other ... Read note.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 25, 2008 at 04:38 AM

    Hi,

    Have a look at below snote which actually speaks about the oracle error codes

    Snote : 546006

    within the Snote it says :-

    " If you cannot access a database file (for instance a data file, control file or RedoLog) for whatever reason, an ORA-270xx appears. The actual cause comes from additional error messages (usually in the operating system) that occur on ORA-270xx. "

    And as per your last update

    " ORA-00206: error in writing (block 3, # blocks 1) of control file

    ORA-00202: control file: 'D:\ORACLE\P02\ORIGLOGB\CNTRL\CNTRLP02.DBF' "

    i think there is problem accessing the database control file. Hence you are facing the above problem.

    I think if you recreate your control file i think, it should resolve the problem.

    Hope it will be helpful to resolve your problem.

    Rgds

    Radhakrishna D S

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2008 at 04:43 AM

    I/O errors are caused by harddisk/driver problems. If your data resides on a SAN system open all call and let the vendor check the SAN and the driver/firmware versions.

    Markus

    Add comment
    10|10000 characters needed characters exceeded