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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: Trace file does not reside in user_dump_dest. Why ?
CHAN Chor Ling Catherine (CSC) Fri, 27 Apr 2001 19:47:01 -0700
- Trace file does not reside in user_dump_des... CHAN Chor Ling Catherine (CSC)
- Re: Trace file does not reside in user... CHAN Chor Ling Catherine (CSC)
- RE: Trace file does not reside in user... Shevtsov, Eduard
- RE: Trace file does not reside in user... CHAN Chor Ling Catherine (CSC)
- Re: Trace file does not reside in user... David A. Barbour
- RE: Trace file does not reside in user... CHAN Chor Ling Catherine (CSC)
- RE: Trace file does not reside in user... Shevtsov, Eduard
- Re: Trace file does not reside in user... David A. Barbour
