Home » RDBMS Server » Server Administration » spfile vs pfile. (Oracle 9.2.0.8 64 bit.)
spfile vs pfile. [message #279272] Wed, 07 November 2007 10:16 Go to next message
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
Re: spfile vs pfile. [message #279273 is a reply to message #279272] Wed, 07 November 2007 10:28 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Are you starting instance with default location spfile or by manually pointing the path.
Re: spfile vs pfile. [message #279275 is a reply to message #279272] Wed, 07 November 2007 10:32 Go to previous messageGo to next message
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 ..
Re: spfile vs pfile. [message #279276 is a reply to message #279272] Wed, 07 November 2007 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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
Re: spfile vs pfile. [message #279297 is a reply to message #279276] Wed, 07 November 2007 11:14 Go to previous messageGo to next message
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 ..
Re: spfile vs pfile. [message #279352 is a reply to message #279272] Wed, 07 November 2007 20:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You are wrong in somewhere.

Re: spfile vs pfile. [message #279353 is a reply to message #279352] Wed, 07 November 2007 21:13 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

I know Smile wanted to know where it went wrong ..

Re: spfile vs pfile. [message #279450 is a reply to message #279272] Thu, 08 November 2007 08:24 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
after creating pfile from spfile,create spfile from pfile again and reboot and see.
Previous Topic: how to find Index is local or global
Next Topic: In all_indexes but not in all_objects
Goto Forum:
  


Current Time: Sat Dec 03 08:12:00 CST 2016

Total time taken to generate the page: 0.15986 seconds