Aju Johnson
Answered On : Apr 29th, 2005
No
Login to rate this answer.
hema
Answered On : Jun 15th, 2005
yes
Login to rate this answer.
Shrikant Pande
Answered On : Aug 24th, 2005
Yes : While starting database Oracle reads spfiledb.ora,spfile.ora,initdb.ora or init.ora file
Login to rate this answer.
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.
2 Users have rated as useful.
Login to rate this answer.
yes database can be started using Pfile(init.ora). In 9i either Pfile(init.ora) or Spfile is needed to start the database.
1 User has rated as useful.
Login to rate this answer.
Absolutely
1 User has rated as useful.
Login to rate this answer.
ravi
Answered On : 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)
1 User has rated as useful.
Login to rate this answer.
ravi
Answered On : 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
1 User has rated as useful.
Login to rate this answer.
Mohammed Abdul Afroze
Answered On : 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.ora file is there, then you
can open the database. Then later you can create a spfile from pfile.
Mohammed Abdul Afroze
1 User has rated as useful.
Login to rate this answer.
venu
Answered On : 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)
Login to rate this answer.
seshu
Answered On : Jan 8th, 2013
No its cannot possible. In any version we have by default one spfile. If Pfile is exitsted then you startup database.
Login to rate this answer.
