Re: PFILE location in NT

From: <MHately_at_etech-uk.com>
Date: Tue, 03 Jul 2001 02:14:23 -0700
Message-ID: <F001.0033FB10.20010703020027@fatcity.com>

Hi,
sorry but no, there's not. You can see your ifile setting in v$parameter but the init.ora isn't available.

Regards,
Mike

|--------+-------------------------->


|        |          Shahid Nasir    |

|        |          <shahidnasir_at_emi|

|        |          rates.com>      |

|        |                          |

|        |          07/03/01 10:30  |

|        |          AM              |

|        |          Please respond  |

|        |          to ORACLE-L     |

|        |                          |

|--------+-------------------------->
  >---------------------------------------------------------------|
  |                                                               |
  |       To:     Multiple recipients of list ORACLE-L            |
  |       <ORACLE-L_at_fatcity.com>                                  |
  |       cc:     (bcc: Mike Hately/ETECH)                        |
  |       Subject:     PFILE location in NT                       |
  >---------------------------------------------------------------|

Hi all,
I have two parameter files in two different directories on the same machine. Is there a way I can find out which parameter file is being used by the database.

One way I tried was to make the changes in one file and see if it takes effect when the database is restarted. but I have more than 52 machines and it will be time consuming to do the same for all machines especially when these machines are on remote locations.

Thanks.
Shahid.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: MHately_at_etech-uk.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Jul 03 2001 - 04:14:23 CDT