Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: utl_file and NFS - fails every 3rd read

Re: utl_file and NFS - fails every 3rd read

From: Jared Still <jkstill_at_bcbso.com>
Date: Tue, 23 May 2000 09:59:13 -0700 (PDT)
Message-Id: <10506.106400@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US