Re: Location of Trace file

[Tom Pall]

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 on Microsoft Window 2000 5.00.2195 Service Pack 3. I have no registry entry for a pfile or ifile.  Since I have no ifile, the query Show parameter ifile returns 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 line pfile it created in Oracle 8i.  It also looks like Oracle expects to find the 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 PM Subject: Re: Location of Trace file > I just built a new database for 8.1.6 on win2000. > In oracle\ora81\database there is init<sid>.ora file for the database. > This file contains only ifile=\oracle\admin\<sid>\pfile\init<sid>.ora. > > But - The registery entry for pfile point directly to: > \oracle\admin\<sid>\pfile\init<sid>.ora > > so ifile value is empty. > > If you are on windows check that values in the registery for oracle home. > Look for name=ora_<sid>_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 recipients of > > 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 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).