on 06-17-2008 9:53 AM
hi all,
i tried to change DB_BLOCK_BUFFER size from 0 to 30000.
i changed through brtools.
but
after restart it database not starting .
it showing "
cannot use both new and old parameters for buffer cache size specification"
how to do now.
please send complete commands, i am new for sql
Regards,
satish
Hello Satish,
>i tried to change DB_BLOCK_BUFFER size from 0 to 30000.
If you do that via BR*Tools the "new" paramter DB_CACHE_SIZE is set.
If you have set the "old" value DB_BLOCK_BUFFERS before - it is not reset and you will get this error.
It is also described in the oracle documentation:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams038.htm#I1010028
DB_BLOCK_BUFFERS cannot be combined with the dynamic DB_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error.
To resolve this problem:
shell> sqlplus "/ as sysdba"
SQL> ALTER SYSTEM RESET DB_BLOCK_BUFFERS SCOPE=SPFILE SID='*'
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
so you have to change it manually.
shell> sqlplus "/ as sysdba"
SQL> create pfile from spfile (if this command brings an error - ignore it!)
shell> cd $ORACLE_HOME/dbs/
shell> vi init<SID>.ora (delete the line with DB_BLOCK_BUFFERS)
shell> sqlplus "/ as sysdba"
SQL> create spfile from pfile;
SQL> startup
Regards
Stefan
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.