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

Showing Answers 1 - 12 of 12 Answers

Aju Johnson

  • Apr 29th, 2005
 

No

  Was this answer useful?  Yes

hema

  • Jun 15th, 2005
 

yes

  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

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.

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)

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

rakesh

  • Jul 20th, 2013
 

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

ajay

  • 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