Home » RDBMS Server » Server Administration » where does the pfile go? (windows,oracle 10.2)
where does the pfile go? [message #585585] Tue, 28 May 2013 01:36 Go to next message
sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai
Junior Member
I use script "create pfile from spfile;" After I delete the file "inti.ora".
then I search the file "init.ora",but I can not find the file.
where does the pfile go?
Re: where does the pfile go? [message #585586 is a reply to message #585585] Tue, 28 May 2013 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The file is not named "init.ora" but "init<ISD>.ora".
It should be in %ORACLE_HOME%\database (or maybe %ORACLE_HOME%\dbs) where ORACLE_HOME is the one the instance (not yours).

Regards
Michel

[Updated on: Tue, 28 May 2013 01:57]

Report message to a moderator

Re: where does the pfile go? [message #585587 is a reply to message #585586] Tue, 28 May 2013 02:09 Go to previous messageGo to next message
sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai
Junior Member
Thanks Michel,I found it.

But, what does the file "init.ora" in "..10.2.0\admin\orcl\pfile" do?
Re: where does the pfile go? [message #585588 is a reply to message #585587] Tue, 28 May 2013 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing if you don't call it.

For instance, on my laptop, I have a pfile in %ORACLE_HOME%\database named init.MIKE.ora which contains only one line (I obfuscate the path):
ifile = %ORACLE_BASE%\Admin\MIKE\Pfile\init.ora 

which means that the actual parameter file is in the Admin directory but allows me to start the database without naming the actual parameter file in the "startup" command.

Regards
Michel

[Updated on: Tue, 28 May 2013 02:16]

Report message to a moderator

Re: where does the pfile go? [message #585591 is a reply to message #585588] Tue, 28 May 2013 02:38 Go to previous message
sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai
Junior Member
got it.

thanks again.
Previous Topic: Logwr Blocking Other session
Next Topic: close cursor
Goto Forum:
  


Current Time: Thu Mar 28 03:57:49 CDT 2024