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@emi|
| | rates.com> |
| | |
| | 07/03/01 10:30 |
| | AM |
| | Please respond |
| | to ORACLE-L |
| | |
|--------+-------------------------->
>---------------------------------------------------------------|
| |
| To: Multiple recipients of list ORACLE-L |
| <[EMAIL PROTECTED]> |
| 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: [EMAIL PROTECTED]
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: [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).
