| Parameter changed at spfile [message #321472] |
Tue, 20 May 2008 06:30  |
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
