Re: init.ora -- which one was database started with?

From: <saropani_at_my-dejanews.com>
Date: Tue, 26 May 1998 04:56:36 GMT
Message-ID: <6kdi24$bku$1@nnrp1.dejanews.com>

In article <6kbqth$t1p$7_at_gte2.gte.net>, johnvue_at_gte.net wrote:
>
> Is there a way to know what init.ora file the database was started
> with?
>

Hi,

The first initialization parameter file is taken from $ORACLE_HOME/dbs. It's name is initSID.ora. However, this file may include one or more parameter files. To see this file we can use Server Manager.

$ svrmgrl
SVRMGR> connect internal;
Connected.
SVRMGR> show parameter ifile

NAME                         TYPE    VALUE
---------------------------  ------  --------
ifile                        file     /ora/admin/TEST/configTEST.ora

Regards,
Saravanan
(saro_at_psoux141.sgp.hp.com)

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 23:56:36 CDT