Re: Oracle residing on a Network Attach Storage (Network Appliance)

From: Robert <robert.cote_at_banctec.ca>
Date: 12 Oct 2001 04:32:34 -0700
Message-ID: <665c72c5.0110120332.308914b2@posting.google.com>

Ron Reidy <ron_at_indra.com> wrote in message news:<3BC5EEA0.47A81DF7_at_indra.com>...
> Robert wrote:
> >
> > We are running Oracle 8i on a NAS (Network Appliance) and have problem
> > having reliability. The Oracle Database often goes down because of OS
> > 59 Network Error or OS 240 session canceled.
> >
> > This database run on Windows NT.
> >
> > Is anyone experiencing the same problem?
> >
> > any idea?
> >
> > Thanks
> What does your alert log say? What trace files are generated? Have you
> tried metalink?

Here is what we have in the alert log:

KCF: write/open error block=0x3dd14 online=1

     file=28 \\B1FILER\VOL1\IPS_ORA2\PROD\DB\LB_ITEM_ACTION_REQUISITION_01.DBF
     error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O

request.
Mon Oct 08 03:18:14 2001
Errors in file \\B1FILER\VOL1\IPS_ORA2\Prod\bdump\ipopLGWR.TRC: ORA-00345: redo log write error block 198648 count 775 ORA-00312: online log 5 thread 1:
'\\B1FILER\VOL1\IPS_ORA2\PROD\LOG\LOG1A.ORA'

ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 59) An unexpected network error occurred.

Mon Oct 08 03:18:14 2001
LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 306
Dump file \\B1FILER\VOL1\IPS_ORA2\Prod\bdump\ipopALRT.LOG

Sometimes the error is os 240 session canceled and the result is the same.

I did not find anything in Metallink. We run the same application on a Network Appliance on HP Ux and have no similar problem.

I was just wondering if any people had the same problem with Oracle database on a NAS with windows NT. Presently we are testing a direct cable connect between the NAS and the server with a gigabit adapter it seems more stable. Received on Fri Oct 12 2001 - 06:32:34 CDT