Oracle-L: Re: Location of Trace file

From: <Rajesh.Rao_at_jpmchase.com>
Date: Fri, 25 Oct 2002 10:04:29 -0800
Message-ID: <F001.004F3EBF.20021025100429@fatcity.com>

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).

Received on Fri Oct 25 2002 - 13:04:29 CDT