OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » spfile vs pfile. (Oracle 9.2.0.8 64 bit.)

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

spfile vs pfile. [message #279272]

Wed, 07 November 2007 10:16

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

hello all,
my db is started with spfile and i had to do some changes to pga_aggregate_Target .. i did this

alter system set pga_aggregate_target=new value scope=spfile;

and then did a

create pfile from spfile

and then checked to see if the new value is reflecting in pfile or not and then bounced the db couple of times ..

After the db is restarted , i see that new value is present .. but when the server is rebooted , its going back to the previous value .. what could be the issue. . ?

Thanks in advance,
vjeedigunta

Report message to a moderator

Re: spfile vs pfile. [message #279273 is a reply to message #279272]

Wed, 07 November 2007 10:28

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Are you starting instance with default location spfile or by manually pointing the path.

Report message to a moderator

Re: spfile vs pfile. [message #279275 is a reply to message #279272]

Wed, 07 November 2007 10:32

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

just saying startup thats all . no manual path ..

just figured out ..after the server reboot when i check show parameter spfile and pfile its showing blank ..

Report message to a moderator

Re: spfile vs pfile. [message #279276 is a reply to message #279272]

Wed, 07 November 2007 10:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

1>After the db is restarted , i see that new value is present ..
2>but when the server is rebooted , its going back to the previous value ..

What is done differently for each of the cases above?

>what could be the issue. . ?
Only do step #1 above & don't do #2

Report message to a moderator

Re: spfile vs pfile. [message #279297 is a reply to message #279276]

Wed, 07 November 2007 11:14

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Step #2 was done becuase of some outage and after that it was observed that value is reverting back .. not sure on what is the reason ..

Report message to a moderator

Re: spfile vs pfile. [message #279352 is a reply to message #279272]

Wed, 07 November 2007 20:53

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You are wrong in somewhere.

Report message to a moderator

Re: spfile vs pfile. [message #279353 is a reply to message #279352]

Wed, 07 November 2007 21:13

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I know

wanted to know where it went wrong ..

Report message to a moderator

Re: spfile vs pfile. [message #279450 is a reply to message #279272]

Thu, 08 November 2007 08:24

varu123
Messages: 754
Registered: October 2007

Senior Member

after creating pfile from spfile,create spfile from pfile again and reboot and see.

Report message to a moderator

Previous Topic:	how to find Index is local or global
Next Topic:	In all_indexes but not in all_objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 12:58:22 CST 2025