Ok I have two database hence two pfiles. Now the first DB is 'test' and the other DB is 'abhi'
SQL> create spfile from pfile='/home/oracle/abhi/initabhi.ora';
File created.
SQL> create spfile from pfile='/home/oracle/test/inittest.ora';
File created.
but when i check the $ORACLE_HOME/dbs directory, spfileabhi.ora is not being created. Only spfiletest.ora is being created.. :-/
oracle@Stoners:~/oracle/product/10.2.0/db_1/dbs$ ls
hc_abhi.dat init.ora orapwabhi
hc_test.dat lkABHI spfiletest.ora
initdw.ora lkTEST
And is there any way i can start a database using the spfile directly? Or is it necessary to create a pointer to the spfile and starting the DB using that pointer?
Like is it possible to do
SQL>startup spfile='$ORACLE_HOME/dbs/spfileabhi.ora'
??
And 1 last that i would like to ask. When i just write SQL>startup does it choose the SPFile using the ORACLE_SID ??
Thank you :)