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

Chor Ling,

Go to the /dg1/oracle/niecomn/admin directory and run ls -al. If you see an arrow pointing to a directory description /dg1/oracle/nieora/8.1.6/rdbms/log, then it is a link.

Regards,

David A. BArbour
Oracle DBA, OCP

"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi David,
>
> How do I know whether the udump directory is a link to the
> nieora/8.1.6/rdbms/log directory? My OS is Unix & I am pretty new to Unix.
> Any advice ? TIA
>
> Regds,
> Chorling
> -----Original Message-----
> From: David A. Barbour [mailto:dbarbour_at_nucentrix.net]
> Sent: Friday, April 27, 2001 10:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Trace file does not reside in
> user_dump_dest. Why ?
>
> 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).
> --
> 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).