OraFAQ Forum: Server Administration » spfile/pfile/idle instance

Home » RDBMS Server » Server Administration » spfile/pfile/idle instance

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

spfile/pfile/idle instance [message #57623]

Thu, 26 June 2003 05:19

Raj
Messages: 411
Registered: November 1998

Senior Member

if there is both spfile and pfile which file will be read pfile/spfile.What willhappen if one of them pfile/spfile
is deleted

and what is exatly meant for connected top idle instance and difrence betwen original instance

Report message to a moderator

Re: spfile/pfile/idle instance [message #57624 is a reply to message #57623]

Thu, 26 June 2003 05:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

spfile is binary version of pfile.
in regular databases you can start the database with either of them.
when options like RAC are used it is most recomnded to use spfile ( along with gsdctl) rather using dbstart/dbshut(which uses pfile) in individual nodes

Report message to a moderator

Re: spfile/pfile/idle instance [message #57629 is a reply to message #57623]

Thu, 26 June 2003 07:26

ctg
Messages: 146
Registered: July 2002

Senior Member

connected to idle instance
it means your database/instance is in shutdown mode.

as for the spfile/pfile
on startup oracle looks for spfile (binary parameter file) 1st
if it cant find then it looks for the pfile (text parameter file)

or you can explicitly tell it to look for the text file on startup with STARTUP PFILE=pathfilename

Report message to a moderator

Re: spfile/pfile/idle instance [message #57640 is a reply to message #57623]

Thu, 26 June 2003 12:42

Sanjay
Messages: 236
Registered: July 2000

Senior Member

1st spfile, 2nd pfile.

NOTE: When you make changes in the init.ora file, make sure you *delete* the spfile. Then again create the spfile after the changes in the init.ora file.

If you do not delete the spfile, then on startup it will find the spfile and startup with the old params as the current spfile is not yet a binary copy of the pfile. (unless you have deleted and created a new one as I have mentioned above)

I learned it the hard way.

Report message to a moderator

Previous Topic:	ora 1630 max # extents (%s) reached in temp segment in tablespace %
Next Topic:	Need help badly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 12:54:10 CST 2025