: Re: Location of
Trace file
root@fatcity.
com
October 25,
2002 12:58 PM
Please
respond to
ORACLE-L
Show parameter ifile shows
uot;
[EMAIL PROTECTED]
Sent: Friday, October 25, 2002 1:04 PM
If you follow OFA, it works for NT ;-)
"Tom Pall"
tpall@realti
To: Multiple recipientsof list ORACLE-L
[EMAIL PROTECTED]
me.net
cc:
Sent by:
Subject: Re: Location of Trace file
: Location of
Trace file
root@fatcity.
com
October 25,
2002 12:58 PM
Please
respond to
ORACLE-L
Show parameter ifile shows the ifile address
Look in $ORACLE_HOME/dbs for initSID.ora file. It will be the file or
the link to the file there.
HTH,
Mike
[EMAIL PROTECTED] wrote:
Hi ,
I want to know the location of trace file.I do not know location of
init.ora.
How to get it.
Thanks
Manoj
--
Ing. Michal Zaschke
Hi
U can get the vale from the v$parameter for all the background process and
trace path
Ayyappan
-Original Message-
[mailto:cosltemp-g.manoj;orbitech.co.in]
Sent: Friday, October 25, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Hi ,
I want to know the location of trace
SQL select name, value from v$parameter where name='user_dump_dest';
NAME VALUE
--
user_dump_dest C:\oracle\admin\tom\udump
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Manoj,
svrmgrl show parameter ifile
will give u the location of init.ora and
svrmgrl show parameter background_dump_dest
svrmgrl show parameter user_dump_dest
will give u the location of alert and trace files respectively.
HTH.
Jp.
--
Please see the official ORACLE-L FAQ:
BDY.RTF
Description: RTF file
Ask your DBA. If you are the DBA, Oracle's Concepts Guide and Administration
Guide will address these and many other questions. Those guides can be read
(or searched) on-line at http://tahiti.oracle.com. It's all free (nominal
registration at Oracle Technology Network may be required,
Show parameter ifile shows the ifile address, not the pfile address.
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL show parameter ifile
NAME TYPE
The most common reason is that you are not logged on the system as the user
and group that owns the $ORACLE_HOME/bin/oracle executable. You also need to
have ORACLE_HOME and ORACLE_SID set appropriately.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
tpall@realtiTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
me.net cc:
Sent by: Subject: Re: Location of Trace file
12 matches
Mail list logo