Re: utl_file_dir showing up empty

Possibly the OP needs to read the concepts manual and understand the "concept" of spfile to understand that changing parameter in init.ora *might* not have any effect?

Anurag

"J Alex" <jalexanderssd_at_yahoo.com> wrote in message news:2RTa9.322429$s8.5668529_at_twister.tampabay.rr.com...
>
> "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 - 20:23:16 CDT