OraFAQ Forum: Server Administration » When we start database which file is accessed fist.

Home » RDBMS Server » Server Administration » When we start database which file is accessed fist.

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

When we start database which file is accessed fist. [message #468508]

Fri, 30 July 2010 07:00

zahidbashir
Messages: 34
Registered: September 2009

Member

Hello,
The question should rather sound very easy. I knew the answer but got confused. Is it pfile or spfile which is accessed first when database is started. I google it but the result was more confusion as some say pfile and some spfile. I guess its spfile.

Report message to a moderator

Re: When we start database which file is accessed fist. [message #468512 is a reply to message #468508]

Fri, 30 July 2010 07:28

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Normally you wouldn't have both.
Oracle will use the spfile by default but you can explicitly tell it to use the pfile instead:

startup pfile=<file name>

Report message to a moderator

Re: When we start database which file is accessed fist. [message #468530 is a reply to message #468512]

Fri, 30 July 2010 10:09

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends spfile or pfile depending on what you have, where you have them and which startup command you execute.

Regards
Michel

Report message to a moderator

Re: When we start database which file is accessed fist. [message #468598 is a reply to message #468530]

Sat, 31 July 2010 00:24

zahidbashir
Messages: 34
Registered: September 2009

Member

Thanks

Report message to a moderator

Re: When we start database which file is accessed fist. [message #468612 is a reply to message #468598]

Sat, 31 July 2010 02:55

ashy
Messages: 2
Registered: July 2010

Junior Member

Actually oracle will check the file in the following manner
spfile<sid>.ora
spfile.ora
pfile<sid>.ora
pfile

Report message to a moderator

Re: When we start database which file is accessed fist. [message #468616 is a reply to message #468612]

Sat, 31 July 2010 03:14

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which pfile can contain a reference to a spfile, the opposite is also true.

Regards
Michel

Report message to a moderator

Previous Topic:	How to know currently running databases in single server ?
Next Topic:	Undo Management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 07 16:47:25 CST 2026