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!

Determining if a system is using SPFILE or PFILE

J.KiechleJun 12 2008 — edited Jun 12 2008

I installed Oracle 10gR2 software and created the database manually. i don't remember creating spfile from pfile. But now when i issue the below mentioned query, i can see that there is an SPFILE in the db. How can i check that the DB is using SPFILE rather than init.ora file in $ORACLE_HOME/dbs

SQL> show parameter spfile

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
spfile                               string                           /u01/app/oracle/product/10.2.0
                                                                      /db_1/dbs/spfileoratest75.ora

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2008

Added on Jun 12 2008

#general-database-discussions

6 comments

1,051 views