Re: Process trace file is unreadable

   Set umask before starting the Oracle database. The database processes will then inherit it.

Ian Dixon (iand_at_syntaxis.demon.co.uk) writes:
> When our developers so an 'alter session set sql_trace=true;', the
> trace file that gets written has an access mask of '-rw-rw----'.
> Since they now are unable to read the file, it is not much use to
> them. This happens using 7.1.6 under HP/UX 9.04. Oracle on our
> other HP wrote the trace files with world read. The only difference
> that I can see is that it is running 6.0.37.
>
> Oracle support suggested adding world read permission to the
> sqlplus executable. It didn't do any good (2nd wrong answer in the
> last 2 weeks :-( )
>
> I'm sure that I'm missing something obvious but what?
>
> TIA
>
> Ian
>
> ---------------------------------------------------------------------
> Ian Dixon email: ian_at_syntaxis.demon.co.uk
> Freelance Oracle Developer
> Reading, England
>

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##