spfile Vs pfile in Oracle? File System Database

spfile - is Binary file
pfile - is txt file
location of spfile/pfile:
$ORACLE_HOME/dbs
create pfile from spfile:
create pfile from spfile;
create pfile='/tmp/initDEVDB.ora' from spfile;
create spfile from pfile:
create spfile from pfile;
create spfile from pfile='/tmp/initDEVDB.ora';
create spfile='/tmp/spfileDEVDB.ora' from pfile;
create spfile='/tmp/spfileDEVDB.ora' from pfile='/tmp/initDEVDB.ora';
startup instance only support with pfile not with spfile
startup pfile='/tmp/initDEVDB.ora';
startup spfile='/tmp/spfileDEVDB.ora';
Upcoming Batch Schedule link:
mallik034.blog...
#oracledba #oraclecarrers #oracleworld #oracle #database #training #onlinetraining #liveclasses
Regards,
Mallikarjun Ramadurg
WhatsApp: [phone]
Cell: [phone] / [phone]
Email: [e-mail]

[@meghakaradi]

❤

[@varunpandeyvarunlens]

Mallik ....
which parameter decide to go on dbs location and look spfile first.
can't we change it ?
database is idle then from where it is reading ?