Re: utl_file_dir showing up empty

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

Try alter system set utl_file_dir=blah scope=spfile;

The version number is *always* useful, and in this case particularly so: spfiles are used in preference to init.oras (if you have one) as a new feature in 9i, so you can fiddle with an init.ora for a month of Sundays and have precisely zero effect on the spfile, where it all counts.

Do a 'show parameter spfile' to verify that you are actually using an spfile.

Regards
HJR Received on Wed Aug 28 2002 - 03:03:03 CDT