Re: Database Problem Or system

Posted by ErmanArslansOracleBlog on Mar 11, 2017; 5:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-Problem-Or-system-tp2334p2340.html

Okay , the version 9.2.0.6 is quite old.
We need to see the whole error. The end of this line -> "SVR4 Er..."
There should be something like: ORA-27072:skgfdisp: I/O error  SVR4 Error: 28:  blablabla...
The issue is most probably due to some OS level problem.
DBV-00102: (-2) tries to tell something to us, as well.

There are bugs recorded for this.

1)What do you have in alert log? Can you see the words after the SRVR4 Er...
2)What do you have in your OS logs? Do you have any IO errors reported at the same time?
3) What do you have in alert log and related oracle process trace files -- given in the alert log lines?
4)Try to following
  *) resize datafile and retry ->
  Resize the datafile using:
  alter database datafile datafile_name resize <1 block smaller>;
  If the resize fails with ORA-3297, it is also valid to resize the datafile to 1 block larger:
  alter database datafile datafile_name resize <1 block larger>;
  *) Un-mount the FS that contain the Datafile  --tell sysadmin to do this
      Run FSCK to fix the corrupted OS Blocks.  --tell sysadmin to do this
      Re-mount the FS   --tell sysadmin to do this
  *Ensure your fs is not %100 full