"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D6C0400.F41C543B_at_exesolutions.com...
> Kyle Pinches wrote:
>
> > I'm having an issue with using utl_file_dir... Even though I've added
> > it to the init$SID.ora file and restarted the database, it appears to
> > be getting set to a blank string (doing a "select * from v$parameter
> > where name='utl_file_dir'" or using "show parameter utl_file_dir"
> > returns a row, but there is nothing in the value). Also, the select
> > shows that the ISDEFAULT value of the parameter is true.
> >
> > Here's the line I'm using in init$SID.ora
> >
> > utl_file_dir=/var/opts/testdir
> >
> > I've tried moving the location to the beginning/middle/end of the
> > file, adding a / to the end of the directory, and adding quotes around
> > the path with no luck. I've also tried making a separate file with
> > only this line in it and using IFILE to include that file... The
> > init$SID.ora file I'm editing is definitely the one that's being read
> > (if I make other changes to it, those changes take effect). I've also
> > tried setting the utl_file_dir to '*', also with no luck.
> >
> > Has anyone else come across a situation like this?
> >
> > If it's useful, this is on Oracle9i Release 9.0.1.0.0 running on SuSe
> > 7.2
> >
> > Thanks in advance!
> > ~Kyle
>
> Who has privileges to read the files in /var/opt/testdir directory?
>
> You or Oracle?
>
> It must be Oracle.
>
It isn't showing up in his paremeter list after bouncing the db, which is a
different matter than not being able to write to the directory.
Received on Tue Aug 27 2002 - 18:22:38 CDT
