Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating an SPFile from PFile not working......!

825161Feb 26 2011 — edited Mar 1 2011
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 :)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2011
Added on Feb 26 2011
4 comments
2,991 views