Re: utl_file_dir showing up empty

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 27 Aug 2002 22:06:29 -0700
Message-ID: <92eeeff0.0208272106.41612e94@posting.google.com>

> Who has privileges to read the files in /var/opt/testdir directory?
>
> You or Oracle?
>
> It must be Oracle.
>
> Daniel Morgan

Oracle does not care (Atleast until 8.1.7.3), if utl_file_dir is valid or has permissions at startup. It uses whatever value is specified. *Only* after startup it will raise error on any call to UTL_FILE package if directory is invalid or Oracle does not have any permissions.

Your problem may be related to SPFILE being out of sync from your PFILE. In 9i, when database is started up by just using "SQL> startup" command, Oracle uses SPFILE parameters. Read more about new SPFILE feature in your 9i docs and how to sync your SPFILE and PFILE. In the meantime, try to force Oracle to startup by exclusively using your pfile parameters like,

SQL> startup pfile=<Full path and name to pfile>

//Rauf Sarwar Received on Wed Aug 28 2002 - 00:06:29 CDT