Aju Johnson

• Apr 29th, 2005

 

No

hema

• Jun 15th, 2005

 

yes

Shrikant Pande

• Aug 24th, 2005

 

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

cmanne

 Profile Answers by cmanne 

• 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.

hussain

 Profile Answers by hussain 

• Apr 14th, 2006

 

yes database can be started using Pfile(init.ora). In 9i either Pfile(init.ora) or Spfile is needed to start the database.

cmanne

 Profile Answers by cmanne 

• Jul 29th, 2006

 

Absolutely

ravi

• 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)

ravi

• 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

 

Answer:

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
 

venu

• 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)

seshu

• Jan 8th, 2013

 

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

rakesh

• Jul 20th, 2013

 

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

manoj

• 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.

ajay

• Feb 5th, 2014

 

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

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)

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 )