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 <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> Sent: Friday, October 25, 2002 1:04 PM
>
>
> >
> > If you follow OFA, it works for NT ;-)
> >
> >
> >
> >
> >
> > "Tom Pall"
> > <tpall_at_realti To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> > me.net> cc:
> > Sent by: Subject: Re: Location of
> Trace file
> > root_at_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" <ORACLE-L_at_fatcity.com>
> > 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: Rajesh.Rao_at_jpmchase.com
> >
> > 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: ListGuru_at_fatcity.com (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: tpall_at_realtime.net
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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).