| LOcation of Pfile [message #194048] |
Wed, 20 September 2006 09:40  |
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 #194067 is a reply to message #194059] |
Wed, 20 September 2006 12:32  |
 |
Mahesh Rajendran
Messages: 10707
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
