Re: Problems with NetApp filer connected to Sun V440 via NFS when using Oracle
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: stephenbooth.uk@xxxxxxxxx
- Date: Tue, 04 Jan 2005 20:19:19 +0100
Stephen,
It's a while ago (2,5 years), but I remember some weird behaviour in an
AIX/Netapp combination. IIRC (I fired this customer 2 year ago), it had
to do with a 'mixed' setup on the Netapp end: mixing CIFS and NFS access
to the same volume caused problems alike the ones you noticed. After
separating CIFS and NFS the problems vanished. It was some time (and
versions) ago, but do you have mixed access to the volumes of your
filer?
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
Upcoming appearances:
* Jan 27, 2005: London, UKOUG Unix SIG: Data Guard Best Practices
* Feb 9-10, 2005: Denver, RMOUG Training Days: Data Guard
Performance Issues
* Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance
Issues
On Tue, 2005-01-04 at 19:10, stephen booth wrote:
> We have a bit of a wierd problem using a NetApp filer to hold the
> datafiles for an Oracle database (9.2.0.4) for a Sunfire V440 (Solaris
> 9 patched to the most recent patchset for Dec 04). I wondered if
> anyone else had come accross anything similar, given that (according
> to NetApp) their filers are used so commonly with Oracle.
>
> The filesystem on the filer is exported and mounted by the V440 via
> NFS (as per reccomendation by NetApp). With Oracle down the mount
> stays mounted indefinately (we've tried it for 3 weeks, about half
> with no traffic accross the link and the remainder with a file being
> repeatedly copied accross the link from the filer to the server and
> back again).
>
> With Oracle up the NFS connection seems to drop out non-fatally for a
> few minutes. Oracle just freezes, no messages in the alert log but we
> do get a few messages in the messages file (OS log) such as:
>
> Dec 22 14:18:22 XXXXXXXXX nfs: [ID 333984 kern.notice] NFS server
> filer not responding still trying
> Dec 22 14:21:53 XXXXXXXXX last message repeated 2 times
> Dec 22 14:29:17 XXXXXXXXX nfs: [ID 563706 kern.notice] NFS server filer ok
> Dec 22 14:29:17 XXXXXXXXX last message repeated 1 time
>
> After a while (could a few minutes or quarter of an hour, it varies)
> the connection comes back and oracle continues on as if nothing had
> happened.
>
> I've tried looking in v$waitstat to see if it is anything particular
> but nothing jumps out as having massively higher wait times than
> everything else. Although given that the connection drops out for
> several minutes it's likely that everything will get hit badly.
>
> Has anyone run accross this or something similar? If so, how did you solve
> it?
>
> Is there anything Oracle might be doing to cause this? The only thing
> that comes to mind is that Oracle is doing random access where as the
> copying the file back and forth is doing sequential access.
>
> Thanks
>
> Stephen
--
//www.freelists.org/webpage/oracle-l
Other related posts:
