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: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Fri, 27 Apr 2001 19:47:01 -0700
Message-ID: <F001.002F4C14.20010427194024@fatcity.com>

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).
Received on Fri Apr 27 2001 - 21:47:01 CDT

Original text of this message

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