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.

Report message to a moderator

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: 68675
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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 68675
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 02:19:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.