Re: utl_file and NFS - fails every 3rd read

This sounds like a DNS problem.

Your server likely has 3 NIC's installed, and DNS serves them up in round robin fashion.

One of the DNS entries is incorrect, and you see the problem every 3rd attempt.

Jared

On Tue, 23 May 2000, John Dunn wrote:

> I have a curious problem with utl_file.
>
> Platform is Oracle 8.0.5 on AIX 4.2.1
>
> The file is exported via NFS from another AIX server.
>
> When reading the file using utl_file I get an "invalid_operation" error, but
> curiously this error only occurs on every 3rd attempt to read the file!
> Reads 1, 2 , 4 and 5 are OK.
>
> This happens consistently.
>
> Any ideas?
>
> John
>
>
>
>
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue May 23 2000 - 11:59:13 CDT