Re: Resource temporarily unavailable

From: Frank <frankbo_at_interaccess.nl>
Date: Fri, 13 Oct 2000 12:54:01 +0200
Message-ID: <8s6pkq$ras$1@porthos.nl.uu.net>

Oracle error 1242 blurs something about media failures, and corruption. From the name of the file, I gather it's a temporary tablespace datafile. Drop and recreate - as temporary tablespaces should be temporary, no data is stored permanently, making this a safe option.

About async i/o being switched off: did you simulate aio by using multiple writers?

--
Frank
sysdev <sysdev_at_mb.sympatico.ca> schreef in berichtnieuws
39E617F3.B0F7AADB_at_mb.sympatico.ca...


> Perhaps someone can help me with a problem that I have been

> experiencing. We are running 8.0.5 on an IBM RS6000 with AIX version

> 4.3.3. Lately, we have been experiencing instances where the database

> will shut itself down in the middle of a job. When the alert log is

> checked, the message is as follows:

>

> KCF: write/open error block=0x3d2b online=1

>           file=11 tmp02tcs.dbf

>           error=27063   'IBM AIX RISC System/6000 Error: 11: Resource

> temporarily unavailable.

> DBW0:terminating instance due to error 1242

>

> This occurs constantly while attempting index recreates. We were told

> the temporary work around was to set disk_async_io = False, which we

> tried and it works but the performance was quite poor. I am told by the

> AIX administrator that all current patches have been applied to the

> version of AIX. Ideas? What would make the databases start to crash like

> this after they have been working just fine for over 6 months. All our

> databases on the particular machine have been affected. Any help would

> be appreciated.

>

Received on Fri Oct 13 2000 - 05:54:01 CDT