OraFAQ Forum: Server Administration » how to find instance is started with which pfile

Home » RDBMS Server » Server Administration » how to find instance is started with which pfile (Startup pfile = ‘/home/oracle/initt1.ora’ ??????????)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find instance is started with which pfile [message #335282]

Mon, 21 July 2008 12:51

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

Report message to a moderator

Re: how to find instance is started with which pfile [message #335283 is a reply to message #335282]

Mon, 21 July 2008 12:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

IT Guru wrote on Mon, 21 July 2008 10:51

There is NO way to have Oracle tell you.

Report message to a moderator

Re: how to find instance is started with which pfile [message #335349 is a reply to message #335282]

Mon, 21 July 2008 22:53

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>

Report message to a moderator

Re: how to find instance is started with which pfile [message #335350 is a reply to message #335349]

Mon, 21 July 2008 22:57

BlackSwan
Messages: 26766
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

What is your point/question?

Report message to a moderator

Previous Topic:	Private_strands
Next Topic:	how to find all undo tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 22 16:34:50 CDT 2024