OraFAQ Forum: Server Administration » PFILE or SPFILE (Oracle 9i)

Home » RDBMS Server » Server Administration » PFILE or SPFILE (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PFILE or SPFILE (Oracle 9i) [message #60347]

Mon, 02 February 2004 22:50

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

Which is the simplest way to check in a new company�which initialization parameter (PFILE or SPFILE?) file they are using on their Oracle server?

Is it ok to just check in the $ORACLE_HOME/dbs/... and see if there is not any spfileSID.ora or spfile.ora file so Oracle (and they) are using a PFILE file?

Many thanks!!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: PFILE or SPFILE (Oracle 9i) [message #60354 is a reply to message #60347]

Tue, 03 February 2004 03:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

by default Oracle 9i uses spfile.
and it is not nessarily the pfile should be in $ORACLE_HOME/dbs OR $ORACLE_BASE/admin/< sid >/pfile.
though Oracle recomends it ( as of OFA) most people simply dont follow that.
first login to the database and check

dbadmin@republic_lawp1 > show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /dev/vx/rdsk/prod/spfile

later check both the locations of pfile
$ORACLE_HOME/dbs and
$ORACLE_BASE/admin/< sid >/pfile
edit the pfile.
if you see like this,
the initsid.ora is pointing to spfile.

bash-2.03$ cat initlawp1.ora
SPFILE='/dev/vx/rdsk/prod/spfile'
bash-2.03$

then, ur database is using the SPFILE.
---May be ..someone has another better method to check??

Report message to a moderator

Re: PFILE or SPFILE (Oracle 9i) [message #60355 is a reply to message #60354]

Tue, 03 February 2004 04:02

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Thank you so much!

Best regards,

Patrick Tahiri.

Report message to a moderator

Re: PFILE or SPFILE (Oracle 9i) [message #60356 is a reply to message #60354]

Tue, 03 February 2004 04:25

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Maybe something like this ?

SQL>  SELECT DECODE(SP.CNT,0,'PFILE','SPFILE') "Parameter_File"  
  2  from
  3  ( SELECT COUNT(*) CNT FROM V$SPPARAMETER WHERE VALUE IS  NOT NULL) SP;

Parame
------
PFILE

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

-- On another database,that uses spfile
SQL> SELECT DECODE(SP.CNT,0,'PFILE','SPFILE') "Parameter_File"   
  2  FROM
  3  ( SELECT COUNT(*) CNT FROM V$SPPARAMETER WHERE VALUE IS  NOT NULL) SP;

Parame
------
SPFILE

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora

-Thiru

Report message to a moderator

Previous Topic:	ORA-060 - User Trace file
Next Topic:	2 databases with same SID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 21:52:04 CST 2025