Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: alter system set user_dump_dest='/newdir' not working

Re: alter system set user_dump_dest='/newdir' not working

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 7 Dec 2005 22:42:22 +0000
Message-ID: <be592d550512071442r14a6824ap1ef628da83a1e2b9@mail.gmail.com>


can oracle write to the new directory?

On 12/7/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> 9.2.0.5, AIX 5.2
>
> I'm able to execute the command with no errors, and get the "System
> altered" confirmation message, but then when I try to create a trace file (
> e.g. set sql_trace=true), no file gets created - not in the original udump
> directory or the new one. When I alter the parameter back to its original
> value, then I am able to create trace files in the original udump directory
> once again. Anyone else seen this and know of a solution (other than
> changing it in the pfile/spfile and bouncing the database)?
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 07 2005 - 16:42:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US