Re: Location of Trace file

2002-10-28 Thread Yechiel Adar
: Re: Location of Trace file root@fatcity. com October 25, 2002 12:58 PM Please respond to ORACLE-L Show parameter ifile shows

Re: Location of Trace file

2002-10-28 Thread Tom Pall
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

Re: Location of Trace file

2002-10-26 Thread Tom Pall
: 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

Re: Location of Trace file

2002-10-25 Thread Michal Zaschke
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

RE: Location of Trace file

2002-10-25 Thread Ayyappan S
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

Re: Location of Trace file

2002-10-25 Thread Tom Pall
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:

Re: Location of Trace file

2002-10-25 Thread oraora oraora
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:

RE: Location of Trace file

2002-10-25 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

RE: Location of Trace file

2002-10-25 Thread Deshpande, Kirti
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,

Re: Location of Trace file

2002-10-25 Thread Tom Pall
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

Re: Location of Trace file

2002-10-25 Thread Tom Pall
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:

Re: Location of Trace file

2002-10-25 Thread Rajesh . Rao
tpall@realtiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] me.net cc: Sent by: Subject: Re: Location of Trace file