Parameter changed at spfile [message #321472] |
Tue, 20 May 2008 06:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_das
Messages: 64 Registered: February 2008
|
Member |
![babai.74.cal@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
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.
|
|
|
|
|
|
|
|