Home » RDBMS Server » Server Administration » LOcation of Pfile
LOcation of Pfile [message #194048] Wed, 20 September 2006 09:40 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
All,
Is there any way to get location of pfile which oracle used during startup ?I want to get this from SQL Plus. any idea ?
Re: LOcation of Pfile [message #194057 is a reply to message #194048] Wed, 20 September 2006 10:24 Go to previous messageGo to next message
gans_dba
Messages: 2
Registered: September 2006
Junior Member
pfile and spfile default location will be $ORACLE_HOME/dbs on unix.

THanks.
Re: LOcation of Pfile [message #194059 is a reply to message #194048] Wed, 20 September 2006 10:45 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
any chance to get it from SQL> ???
Re: LOcation of Pfile [message #194063 is a reply to message #194048] Wed, 20 September 2006 11:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>any chance to get it from SQL> ???
NO, not with any certainty.

[Updated on: Wed, 20 September 2006 11:29] by Moderator

Report message to a moderator

Re: LOcation of Pfile [message #194067 is a reply to message #194059] Wed, 20 September 2006 12:32 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I like Tom's Method.
http://asktom.oracle.com/pls/ask/f?p=4950:8:2033493233650153607::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6644781942843
As anacedant says, it is not **very reliable**.
You need to guess that if there is no output, it is probably using pfile.
sys@9i > startup
ORACLE instance started.

Total System Global Area  504858576 bytes
Fixed Size                   731088 bytes
Variable Size             167772160 bytes
Database Buffers          335544320 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
sys@9i > show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora
sys@9i > create pfile from spfile;

File created.

sys@9i > shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@9i > startup open pfile=initmutation.ora
ORACLE instance started.

Total System Global Area  504858576 bytes
Fixed Size                   731088 bytes
Variable Size             167772160 bytes
Database Buffers          335544320 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
sys@9i > show parameter spfile

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

[Updated on: Wed, 20 September 2006 12:32]

Report message to a moderator

Previous Topic: dropping a datafile from the tablespace.
Next Topic: strange job error
Goto Forum:
  


Current Time: Sun Dec 11 08:28:11 CST 2016

Total time taken to generate the page: 0.15584 seconds