hi,i created database by using dbca tool,ofter that i created p-file from init.ora file.now my system having both p-file and sp-file,but when i startup the database system is starting with p-file.why its happening like this? if the sp-file available oracle should startup the database with sp-file ..but my why happening like this? and ofter that i deleted p-file and try to startup the database,but oracle is showing errors, even sp-file available.
like ORA-017108-failure in processing system parameters
and LRM-00109-could not open parameter file.
why happening like this ..sp-file is enough to start the datbase?
please send me the answers..iam learning dba ..
thanks.
Full Version: question about parameter files?
This page might help: http://www.dba-oracle.com/t_ora_01078_fail...meters_tips.htm
because your spfile isnt there
Hi,
As yo a missing spfile, it's likely a pathing issue, check you path environment
>> please send me the answers..
Who knows what you did? You could have done anything . . .
We are not psychic!
Oracle is the worlds most sophisticated database, it was not designed for the casual user.
Most folks start with a masters degree in CS or IT and take a month of training at Oracle University:
Read this: http://www.dba-oracle.com/t_how_to_become_an_oracle_dba.htm
As yo a missing spfile, it's likely a pathing issue, check you path environment
>> please send me the answers..
Who knows what you did? You could have done anything . . .
We are not psychic!
Oracle is the worlds most sophisticated database, it was not designed for the casual user.
Most folks start with a masters degree in CS or IT and take a month of training at Oracle University:
Read this: http://www.dba-oracle.com/t_how_to_become_an_oracle_dba.htm
QUOTE (gssr141 @ Mar 10 2010, 05:13 PM) 
hi,i created database by using dbca tool,ofter that i created p-file from init.ora file.now my system having both p-file and sp-file,but when i startup the database system is starting with p-file.why its happening like this? if the sp-file available oracle should startup the database with sp-file ..but my why happening like this? and ofter that i deleted p-file and try to startup the database,but oracle is showing errors, even sp-file available.
like ORA-017108-failure in processing system parameters
and LRM-00109-could not open parameter file.
why happening like this ..sp-file is enough to start the datbase?
please send me the answers..iam learning dba ..
thanks.
like ORA-017108-failure in processing system parameters
and LRM-00109-could not open parameter file.
why happening like this ..sp-file is enough to start the datbase?
please send me the answers..iam learning dba ..
thanks.
If the database starts on the pfile, then the spfile is missing or missnamed. Easy way to switch to spfile is to create a new one from the pfile and then restart the database. Use create spfile from pfile and the database will create it where it will look for it and correctly name it.
http://www.dba-oracle.com/tips_oracle_spfile_example.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.