Re: utl_file_dir setting not working

From: Rotter Richard <rotter_at_aon.at>
Date: Tue, 18 Jan 2000 14:57:01 +0100
Message-ID: <388470d7$0$19614@SSP1NO17.highway.telekom.at>

hi,

Do you have chacked the read and write-Permissions on UNIX? Note, that Oracle wants to write and read the files with the user, starts the instance!

For example: If you start and stop your instance with the "oracle"-User on Solaris, the Oracle-User need to have read and write-Permision on the directory you set in the utl_file_dir-Parameter!

Rotter Richard
Oracle-DBA

real <real_at_yahoo.com> schrieb in im Newsbeitrag: 3883B274.49589856_at_yahoo.com...
> For some odd reason, the setting up of utl_file_dir is not working on
> our Oracle 8.0.5 Database -- Solaris 2.7.
>
> Here's what I have done:
>
> Setting in init<SID>.ora specifying directory
> Bounced instance.
> Recompiled sys schema (as a last ditch effort).
>
> I've checked the all_directories view, there is nothing there.
> I've checked in the sys.dir$ table (base table view queries) and nothing
> is there -- expected.
>
> We have this working on other servers, so I don't get what the problem
> is.
>
> Any ideas?
>
> Thanks in advance.
>
>
>
Received on Tue Jan 18 2000 - 07:57:01 CST