Home » RDBMS Server » Server Administration » how to find instance is started with which pfile (Startup pfile = ‘/home/oracle/initt1.ora’ ??????????)
how to find instance is started with which pfile [message #335282] Mon, 21 July 2008 12:51 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
oracle 9i, Windows / Linux

if one have created 2-3 initialization file. Are store on non-default location.

& instance is started with

Startup pfile = ‘/home/oracle/initt1.ora’

How to find instance is started with which pfile. A complete file location.

When I gave

Show parameter pfile ;

It gave me Spfile



Re: how to find instance is started with which pfile [message #335283 is a reply to message #335282] Mon, 21 July 2008 12:53 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
IT Guru wrote on Mon, 21 July 2008 10:51
oracle 9i, Windows / Linux

if one have created 2-3 initialization file. Are store on non-default location.

& instance is started with

Startup pfile = ‘/home/oracle/initt1.ora’

How to find instance is started with which pfile. A complete file location.

When I gave

Show parameter pfile ;

It gave me Spfile






There is NO way to have Oracle tell you.
Re: how to find instance is started with which pfile [message #335349 is a reply to message #335282] Mon, 21 July 2008 22:53 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
shouldn't it return Pfile.

SQL> startup pfile = '/home/oracle/initt1.ora'
ORACLE instance started.

Total System Global Area 97588624 bytes
Fixed Size 451984 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameters pfile ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
Re: how to find instance is started with which pfile [message #335350 is a reply to message #335349] Mon, 21 July 2008 22:57 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above


IT Guru wrote on Mon, 21 July 2008 20:53
shouldn't it return Pfile.

SQL> startup pfile = '/home/oracle/initt1.ora'
ORACLE instance started.

Total System Global Area 97588624 bytes
Fixed Size 451984 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameters pfile ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>



What is your point/question?
Previous Topic: Private_strands
Next Topic: how to find all undo tablespace
Goto Forum:
  


Current Time: Sun Dec 04 20:59:29 CST 2016

Total time taken to generate the page: 0.12459 seconds