OraFAQ Forum: Server Administration » where does the pfile go?

Home » RDBMS Server » Server Administration » where does the pfile go? (windows,oracle 10.2)

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

where does the pfile go? [message #585585]

Tue, 28 May 2013 01:36

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?

Report message to a moderator

Re: where does the pfile go? [message #585586 is a reply to message #585585]

Tue, 28 May 2013 01:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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?

Report message to a moderator

Re: where does the pfile go? [message #585588 is a reply to message #585587]

Tue, 28 May 2013 02:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

sky-qin
Messages: 13
Registered: May 2013
Location: Shanghai

Junior Member

got it.

thanks again.

Report message to a moderator

Previous Topic:	Logwr Blocking Other session
Next Topic:	close cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:49:55 CST 2024