cancel
Showing results for 
Search instead for 
Did you mean: 

cannot use both new and old parameters for buffer cache size specification

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi ,

thnks for reply,

if i give like commands...it says oracle not available.

what i need to do now.

please give complete commands

Regards,

satish

stefan_koehler
Active Contributor
0 Kudos

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