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: Trace file does not reside in user_dump_dest. Why ?

Re: Trace file does not reside in user_dump_dest. Why ?

From: David A. Barbour <dbarbour_at_nucentrix.net>
Date: Fri, 27 Apr 2001 09:54:00 -0700
Message-ID: <F001.002F41CE.20010427064118@fatcity.com>

Catherine,

Just a WAG, but could the udump directory be a link to the nieora/8.1.6/rdbms/log directory?

David A. Barbour
Oracle DBA, OCP

"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi Ed,
>
> SQL> select name, value
> 2 from v$parameter
> 3 where name like '%user_dump%';
>
> NAME VALUE
> ---------------------------------------- --------------------------------
> user_dump_dest /dg1/oracle/niecomn/admin/udump
>
> The user_dump_dest is /dg1/oracle/niecomn/admin/udump but the trace file is
> dumped into another directory /dg1/oracle/nieora/8.1.6/rdbms/log.
> The unix permission for /dg1/oracle/niecomn/admin/udump &
> /dg1/oracle/nieora/8.1.6/rdbms/log is the same.
>
> I just don't understand why the trace file is not located in user_dump_dest.
>
> Puzzled,
> New bee
> -----Original Message-----
> From: Shevtsov, Eduard [mailto:EShevtsov_at_flagship.ru]
> Sent: Thursday, April 26, 2001 6:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Trace file does not reside in
> user_dump_dest. Why ?
>
> Hi
>
> have you got unix permissions to write to this directory?
> Try to logon as oracle owner and check it by writing any
> small file there.
>
> Also look at the output of the query
>
> select name, value
> from v$parameter
> where name like '%user_dump%';
>
> It will show your actual user dump directory
>
> HTH
>
> Ed
>
> >
> >
> > Hi,
> >
> > I forget to mention that when I show parameter dest* in
> > server manager , the
> > user_dump_dest is pointing to the right directory
> > /dg1/oracle/niecomn/admin/udump.
> >
> > My earlier email :
> > I issue the command "alter database backup
> > controlfile to
> > trace", expecting my trace file to reside in the
> > user_dump_dest directory.
> >
> > connect / as sysdba;
> > startup
> pfile=/dg1/oracle/nieora/8.1.6/dbs/initNIE.ora
> >
> > In the startup file,
> > User_dump_dest =
> /dg1/oracle/niecomn/admin/udump
> >
> > However, the trace file resides in another
> directory
> > /dg1/oracle/nieora/8.1.6/rdbms/log.
> >
> > I am very... very puzzled. Could the gurus
> explain this
> > phenomenon ? Thanks.
> >
> > Regds,
> > New Bee
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: CHAN Chor Ling Catherine (CSC)
> > INET: clchan_at_nie.edu.sg
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be removed
> from). You may
> > also send the HELP command for other information (like
> subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: dbarbour_at_nucentrix.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 27 2001 - 11:54:00 CDT

Original text of this message

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