cancel
Showing results for 
Search instead for 
Did you mean: 

Database termination Problem

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

markus_doehr2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Radha krishna,

I am very new to basis. can you send me process that how to create controle files?

thanks

nani.

Former Member
0 Kudos

Hi,

For better protection of the control file, Oracle is able to mirror this file, that means to keep several copies of it in different locations and modify them simultaneously. In SAP installations, the control file is stored in three copies ( which must be created on three physically separate disks. )

As per my knowledge the location of the control files and of the offline redologs is configured in the Oracle profile init<DBSID>.ora

I think u can copy one of the three copies other than the current corrupted one to recover your control file.

I hope this work.

Rgds

Radhakrishna D S

Former Member
0 Kudos

Hi,

thanks alot......really very helpfull answer..........i am very thankfull to u.

thanks,

Nani

Former Member
0 Kudos

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.