Re: How am supposed to know which init file I am using pfile or spfile?
From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 27 Dec 2002 10:00:35 -0800
Message-ID: <130ba93a.0212271000.2c9109da_at_posting.google.com>
In the platform-specific default location, Oracle locates your initialization parameter file by examining filenames in the following order:
Date: 27 Dec 2002 10:00:35 -0800
Message-ID: <130ba93a.0212271000.2c9109da_at_posting.google.com>
The question is not that strange as you might think. Look here for more info. on this issue:
http://docs.oracle.com/cd_a97630/server.920/a96521/start.htm#5974
Especially this part:
In the platform-specific default location, Oracle locates your initialization parameter file by examining filenames in the following order:
spfile$ORACLE_SID.ora
spfile.ora
init$ORACLE_SID.ora
- Jusung Yang
EriK Miller <bopew2000_at_yahoo.com> wrote in message news:<20021227012927.37FD.BOPEW2000_at_yahoo.com>...
> Hi guys,
>
> I have a strange question here,
> How am I going to find out which init file my instance is using?
> Since I always start my instance by issue "startup" without any
> parameter, I am really sure which init file I am actually using.
>
> It may appears stupid and unnecessary, but I need know that.Thanks!
Received on Fri Dec 27 2002 - 19:00:35 CET