Can you start a database without SPfile in oracle 9i?

Showing Answers 1 - 16 of 16 Answers

Aju Johnson

  • Apr 29th, 2005


  Was this answer useful?  Yes


  • Jun 15th, 2005


  Was this answer useful?  Yes

Shrikant Pande

  • Aug 24th, 2005

Yes : While starting database Oracle reads spfiledb.ora,spfile.ora,initdb.ora or init.ora file

  Was this answer useful?  Yes


  • Jan 4th, 2006

Yes it is possible to start the database using init.ora file only. The main advantage of using the SPFILE.ora is only to make changes to the dynamic initialization parameters without restarting the database using the SCOPE option. The changes will be stored in the spfile only and if you start the database using "pfile" option those changes wont be applicable to the database.


  • Nov 21st, 2006

yes you can

SPfile is a Parameter file in binary form of init.ora file (in Pfile)

While issuing startup command give the scope of pfile(path of init.ora file),

If you don't have spfile everytime to startup of database you have to issue the startup command with pflie.

But if you have spfile you need not to issue the pflie(path of init.ora file)


  • Dec 27th, 2006

Yes, we can with pfile (init.ora)

But for that every-time we need to call pfile to startup the database, that's why we need spfile to startup a database

Mohammed Abdul Afroze

  • Mar 25th, 2007


Yes, We can start a database without spfile. It is not necessary that the
database should be open with spfile. If  init<sid>.ora file is there, then you
can open the database. Then  later you can create a spfile from pfile.

Mohammed Abdul Afroze


  • Sep 1st, 2012

In Oracle 10g, the database is started automatically using pfile (if there is no spfile) when we issue the startup command.

We dont need to specify to Oracle to use pfile always.(Linux OS)

  Was this answer useful?  Yes


  • Jan 8th, 2013

No its cannot possible. In any version we have by default one spfile. If Pfile is exitsted then you startup database.

  Was this answer useful?  Yes


  • Jul 20th, 2013

Yes, I can start a database without spfile. But pfile is mandatory.

  Was this answer useful?  Yes


  • Jan 22nd, 2014

It is not possible to start a database without a spfile,but we can create pfile from spfile or if a pfile is present already we can start.

  Was this answer useful?  Yes


  • Feb 5th, 2014

we can start the database but we required spfile or pfile mandatory

  Was this answer useful?  Yes

Saddam Mulla

  • Mar 2nd, 2014

Yes we can start oracle database without spfile but required pfile
(Spfile is a system file and pfile is a manual crest file)

  Was this answer useful?  Yes

syed fahad

  • Sep 13th, 2014

Yes we can start the database ( pfile is a txt file and spfile is a binary file in 9i spfile is not used by oracle only pfile is maintain to start the database )

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions