help Please --- Oracle errors

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Post Reply
Guest

help Please --- Oracle errors

Post by Guest » Thu Aug 28, 2003 4:00 pm

Hi Gurus,

We have this problem in all three (DEV, QA, PRD)SAP servers : this is the ORA alert log:

*** 2003-08-26 07:01:18.296
*** SESSION ID:(5.1) 2003-08-26 07:01:18.265
ORA-01110: data file 128: 'H:\ORACLE\xxxx\SAPDATA1\TEMP_6\TEMP.DATA6'
ORA-01115: IO error reading block from file 128 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
ORA-01110: data file 128: 'H:\ORACLE\xxxx\SAPDATA1\TEMP_6\TEMP.DATA6'
ORA-01115: IO error reading block from file 128 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
ORA-01171: datafile 128 going offline due to error advancing checkpoint
ORA-01115: IO error reading block from file 128 (block # 1)
ORA-01110: data file 128: 'H:\ORACLE\xxxx\SAPDATA1\TEMP_6\TEMP.DATA6'
ORA-17608: Message 17608 not found; product=RDBMS80; facility=ORA
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'H:\ORACLE\xxxx\SAPDATA1\CTRLxxxx.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.
*** 2003-08-28 04:25:06.171
error 221 detected in background process

****************************************


Could somebody please help

blue_teeth

Post by blue_teeth » Thu Aug 28, 2003 4:58 pm

Hmmm...I initially thought you are on crack!

All three Databases?

Commonsense tells me you are on MCOD where PSAPTEMP tablespace got fscked!


More details from your side, mate.

Cheers,
BT

oldsapguru
Posts: 5489
Joined: Wed Oct 23, 2002 6:08 pm
Location: Nashville via Manhattan
Contact:

Post by oldsapguru » Thu Aug 28, 2003 6:24 pm

But would you MCOD in that way? I mean, I MCOD all the DEV systems together, all the QAS systems together, etc. But never the three R/3 systems together, the three BW systems together, etc. I mean, if you lost one of those databases...

...you would be in really big trouble! So Guest, what happened?

Guest

Post by Guest » Thu Aug 28, 2003 8:21 pm

Thanks for the prompt reply

But I am not on MCOD. The error happening once in a while in our DEV database, QA database, PRD database. Also , not on TEMP always, different table spaces got errored. We are on Oracle 8.0.6.1 and NT with 4.6C

Every time after this error, oracle instance shutdown itself and I need to do a recover on that datafile to startup the DB again. We tried to use virus checker, nothing found.

bubu
Posts: 529
Joined: Mon Oct 21, 2002 7:42 am

Post by bubu » Thu Aug 28, 2003 8:26 pm

So I guess you're not using a raid system (that automatically corrects the disk problem)? ... Mmmm, seems you have to do a disk verification ...

Regards,

oldsapguru
Posts: 5489
Joined: Wed Oct 23, 2002 6:08 pm
Location: Nashville via Manhattan
Contact:

Post by oldsapguru » Thu Aug 28, 2003 8:32 pm

It seems very strange that is takes a hit in both the data file and the control file. I would say you need to do a scandisk or the equivalent on your H: drive.

If it happens often across all your systems, I have to think that your shutdown procedures are in error.

bubu
Posts: 529
Joined: Mon Oct 21, 2002 7:42 am

Post by bubu » Thu Aug 28, 2003 8:38 pm

If it happens often across all your systems, I have to think that your shutdown procedures are in error.
Yes, can happen specially with some UPS ... I guess you also don't have any HA or clustering on your Production system?

Regards,

nainesh
Posts: 553
Joined: Wed May 28, 2003 6:12 am
Location: !!!! Go COLTS !!!!
Contact:

Post by nainesh » Thu Aug 28, 2003 11:14 pm

Since this is happening on all your servers i would look for some common issue / point...

1. Check out if these errors are happening during your backup window..are u using any third party Backup software..Since this is a file locking issue...check to see if your backup software locks file during backup..

2. Check out the OS level error codes and see if any patches are available...

3. Possible bugs at Oracle Level..

dingbat
Posts: 141
Joined: Sun Oct 27, 2002 7:36 am
Location: UK

Post by dingbat » Fri Aug 29, 2003 1:35 am

This is either your backup product or your virus scanner. I've had it with both. Make sure you exclude all database files from filesystem backups, and similarly from any virus scanning template.
dingbat

Guest

Post by Guest » Fri Aug 29, 2003 8:22 am

Hi everybody,

Thanks for all of your input to resolve this issue. The problem was the backup jobs, I scheduled online backups (Veritas Backupexec) through SAP, DB13. But our network Admin. seems to be over protective, scheduled everyday file system backups on all live database servers(without my knowledge). Now you know what happened, when file system backup running for a datafile, same time, if a transaction needs that file, Oracle senses that file is used by another program, make it offline/and make it recover status.

Once more, I just want thak you all, and this forum is great!!

samir_basis
Posts: 53
Joined: Thu Mar 20, 2003 9:08 pm
Location: Marrakech, Morocco

Post by samir_basis » Fri Aug 29, 2003 2:55 pm

check the oss note 546006, it describe this kind of problems..

Post Reply