doubt about parameter files?
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 in this why happening like this? and ofter that i deleted p-file and try to startup the database with sp-file,but oracle is showing errors, even sp-file is 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.
Unable to create Pfile with someother location
While executing the below statement :
SQL> create pfile='/mnt/oracle/initARM.ora' from spfile;
I get the following error..
ORA-07391: fopen error, unable to open text file.
Kindly let me know is the syntax correct and what has to be dont orectify the error?
This is not in real time, i heard that pfile can also be created with someother location, so i tried doing so..?
Kindly suggest..
Thanks in Advance...!!!:)