Re: Location of Trace file
Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Productionon Microsoft Window 2000 5.00.2195 Service Pack 3.I have no registry entry for a pfile or ifile. Since I have no ifile, thequeryShow parameter ifilereturns a null string.oracle\ora92\database contains the file SPFILETOM.ORA (this is 9i,remember).oracle\admin\tom\pfile contains init.ora.9212002185826.TOM is the database sid.It looks like the Oracle installer for 9i did away with the single linepfile it created in Oracle 8i. It also looks like Oracle expects to findthe spfile ORACLE_HOME\database. ORACLE_HOME is defined in the registry.- Original Message -From: "Yechiel Adar" <[EMAIL PROTECTED]>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Monday, October 28, 2002 12:25 PMSubject: Re: Location of Trace file> I just built a new database for 8.1.6 on win2000.> In oracle\ora81\database there is init.ora file for the database.> This file contains only ifile=\oracle\admin\\pfile\init.ora.>> But - The registery entry for pfile point directly to:> \oracle\admin\\pfile\init.ora>> so ifile value is empty.>> If you are on windows check that values in the registery for oracle home.> Look for name=ora__pfile. The value points to the pfile.>> Yechiel Adar> Mehish> - Original Message -> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> Sent: Saturday, October 26, 2002 5:43 PM>>> > My query was executed on an Oracle installed, Oracle created Oracle 9i> > version 2 database on Windows 2000. Oracle really started following OFA> on> > Windows starting with version 8i.> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[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> > > root@fatcity.> > > com> > >> > >> > > October 25,> > > 2002 12:58 PM> > > Please> > > respond to> > > ORACLE-L> > >> > >> > >> > >> > >> > >> > > 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 VALUE> > > ---> > > ---> > > ---> > > ifile> > > file> > >> > > SQL> show parameter background_dump_dest> > >> > > NAME TYPE VALUE> > > ---> > > ---> > > ---> > > background_dump_dest string> C:\oracle\admin\tom\bdump> > > - Original Message -> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > > Sent: Friday, October 25, 2002 4:12 AM> > >> > >> > > > 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: http://www.orafaq.com> > > --> > > Author:> > > INET: [EMAIL PROTECTED]> > >> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> > > San Die
Re: Location of Trace file
I just built a new database for 8.1.6 on win2000. In oracle\ora81\database there is init.ora file for the database. This file contains only ifile=\oracle\admin\\pfile\init.ora. But - The registery entry for pfile point directly to: \oracle\admin\\pfile\init.ora so ifile value is empty. If you are on windows check that values in the registery for oracle home. Look for name=ora__pfile. The value points to the pfile. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, October 26, 2002 5:43 PM > My query was executed on an Oracle installed, Oracle created Oracle 9i > version 2 database on Windows 2000. Oracle really started following OFA on > Windows starting with version 8i. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, October 25, 2002 1:04 PM > > > > > > If you follow OFA, it works for NT ;-) > > > > > > > > > > > > "Tom Pall" > > list ORACLE-L <[EMAIL PROTECTED]> > > me.net> cc: > > Sent by: Subject: Re: 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, 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 TYPEVALUE > > --- > > --- > > --- > > ifile > > file > > > > SQL> show parameter background_dump_dest > > > > NAME TYPEVALUE > > --- > > --- > > --- > > background_dump_dest string C:\oracle\admin\tom\bdump > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, October 25, 2002 4:12 AM > > > > > > > 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: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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: Tom Pall > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
My query was executed on an Oracle installed, Oracle created Oracle 9i version 2 database on Windows 2000. Oracle really started following OFA on Windows starting with version 8i. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 1:04 PM > > If you follow OFA, it works for NT ;-) > > > > > > "Tom Pall" > > me.net> cc: > Sent by: Subject: Re: 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, 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 TYPEVALUE > --- > --- > --- > ifile > file > > SQL> show parameter background_dump_dest > > NAME TYPEVALUE > --- > --- > --- > background_dump_dest string C:\oracle\admin\tom\bdump > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, October 25, 2002 4:12 AM > > > > 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: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
If you follow OFA, it works for NT ;-) "Tom Pall" me.net> cc: Sent by: Subject: Re: 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, 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 TYPEVALUE --- --- --- ifile file SQL> show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 4:12 AM > 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
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: Friday, October 25, 2002 4:43 AM > Hi, >when I connect to internal using svrmgrl,it asks for password. > I do not know the password. > > > Regards, > Manoj. > > -Original Message- > Sent: Friday, October 25, 2002 1:44 PM > To: ORACLE-L > Cc: oraoraora; Manoj, COSLTEMP-G > > > 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: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
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 TYPEVALUE --- --- --- ifile file SQL> show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 4:12 AM > 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: http://www.orafaq.com > -- > Author: oraora oraora > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace 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, http://technet.orac.com). - Kirti -Original Message- [mailto:cosltemp-g.manoj@;orbitech.co.in] Sent: Friday, October 25, 2002 4:44 AM To: Multiple recipients of list ORACLE-L Hi, when I connect to internal using svrmgrl,it asks for password. I do not know the password. Regards, Manoj. -Original Message- Sent: Friday, October 25, 2002 1:44 PM To: ORACLE-L Cc: oraoraora; Manoj, COSLTEMP-G 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: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
BDY.RTF Description: RTF file
Re: Location of Trace file
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: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
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: Friday, October 25, 2002 3:08 AM > Hi , > I want to know the location of trace file.I do not know location of > init.ora. > How to get it. > > Thanks > Manoj > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
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 file.I do not know location of init.ora. How to get it. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Location of Trace file
Look in $ORACLE_HOME/dbs for init.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 DB Administrator Sokolovska uhelna, a.s. phone: +420 352 465417 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).