Home » RDBMS Server » Server Administration » Parameter changed at spfile (9.0.2.6 AIX)
Parameter changed at spfile [message #321472] Tue, 20 May 2008 06:30 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

I changed dynamically the db_cache_size=128M.

sql> alter system set db_cache_size=128M scope=spfile;

Now,when I shutdown and startup the database I am getting an oracle error. The below are the same:-

SQL> startup
ORA-00381: cannot use both new and old parameters for buffer cache size specification.

As when I am specifying the
sql> startup pfile='<>'; command it works.

As the parameter changed at spfile and now when I firing the command startup, oracle will automacally search for spfile not for pfile.

So, Why I am getting this error?

Please help.
Re: Parameter changed at spfile [message #321474 is a reply to message #321472] Tue, 20 May 2008 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't have db_cache_size and db_block_buffer set at the same time.

Regards
Michel
Re: Parameter changed at spfile [message #321475 is a reply to message #321472] Tue, 20 May 2008 06:53 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

could you please let me know the reason?

As my db_cache_size is 0
and db_block_buffers is 50000.

pokhraj
Re: Parameter changed at spfile [message #321479 is a reply to message #321472] Tue, 20 May 2008 07:12 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi ,

I got my answer.The below are the same:-


The DB_BLOCK_BUFFERS parameter is deprecated in favor of the DB_CACHE_SIZE parameter. Oracle recommends that you use DB_CACHE_SIZE instead. Also, DB_BLOCK_BUFFERS cannot be combined with the new dynamic DB_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error. DB_BLOCK_BUFFERS is retained for backward compatibility.
Re: Parameter changed at spfile [message #321480 is a reply to message #321475] Tue, 20 May 2008 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because:
Quote:
ORA-00381: cannot use both new and old parameters for buffer cache size specification.

They have both the same function: size the buffer cache and you can only have one value for a size, doesn't it.

Regards
Michel
Re: Parameter changed at spfile [message #321483 is a reply to message #321472] Tue, 20 May 2008 07:17 Go to previous message
pokhraj_das
Messages: 64
Registered: February 2008
Member


Great.Thanx for your support.

Pokhraj
Previous Topic: Memory Question
Next Topic: Patches for Standard Edition
Goto Forum:
  


Current Time: Sat Dec 10 06:40:53 CST 2016

Total time taken to generate the page: 0.16388 seconds