Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! How to find pfile
Hello Jonathan,
you are right for all but how do you explain it :
SQL*Plus: Release 3.3.4.0.0 - Production on Tue Mar 14 15:36:22 2000
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connecté à:
Oracle7 Server Release 7.3.4.4.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.4.0 - Production
SQL> col name for a20 SQL> col value for a50 SQL> select name,value from v$parameter where name='ifile'; NAME VALUE -------------------- -------------------------------------------------- ifile /usr/local/oracle/share/conf/init.ora
SQL> Olivier
In article <38d39fdf.18883983_at_netnews.worldnet.att.net>,
jonathan_at_gennick.com wrote:
> I'm fairly certain that the parameter file location is not
> recorded in the database. The pfile is actually read by the
> program used to start the database (Server Manager, Instance
> Manager, SQL*Plus, etc). The parameters are passed to the
> instance when it is started, but as far as I know, the
> parameter file name is not recorded anywhere.
>
> The default location, at least on systems that I've worked
> on, is $ORACLE_BASE/admin/SID/pfile. Actually, the default
> location is $ORACLE_HOME/dbs, but there's usually a symbolic
> link pointing to the other location.
>
> Jonathan
>
> _____________________________________________________
> jonathan_at_gennick.com
> http://gennick.com
> Brighten the Corner Where You Are
>
> On Mon, 13 Mar 2000 21:59:31 GMT, sjoshi_at_ingr.com wrote:
>
> > Quick question..is there an easy way to tell where an instance's
pfile
> >is located from within Oracle
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 14 2000 - 00:00:00 CST