Re: UTL_FILE_DIR failed on network drive ...

Hi,
the problem is that the Oracle NT service that the database is using has default os credentials of NT user system. This is a pure local os user who doesn't have any privileges to access network drives. The same problem occurs when trying to run Parallel Server on NT. In both cases the solution for me
was to let the OracleService<%ORACLE_SID%> service run under a different domain account with enough privileges to access drives from the network.

Hth,
Andre van Winssen

"hubertus" <funfack_at_windhager.de> schreef in bericht news:a03492ba.0204260536.339b53c_at_posting.google.com...
> Hi,
>
> writing on network-drives failed with utl_file_dir
>
> SERVER: W2K ORACLE: 8.1.6
> ORA.INI: UTL_FILE_DIR = *
> NETWORK-DRIVES: WINDOWS,SAMBA
>
> writing to local drives via ORACLE does fine.
> writing to network drives via notepad does fine.
> writing to network drives via ORACLE (SQL-PLUS) failed.
>
> EXAMPLE:
> declare f utl_file.file_type;
> begin
> f := utl_file.fopen('i:\','test.txt', 'W');
> utl_file.fclose(f);
> end;
>
> FAILURE:
> declare f utl_file.file_type;
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 101
> ORA-06512: at "SYS.UTL_FILE", line 157
> ORA-06512: at line 3
>
> Does someone knows about this error ?
>
> Tanks
> Hubertus
Received on Sat Apr 27 2002 - 13:00:07 CDT