| rajesh |
Posted: May 13, 2008 02:02:23 AM |
Total Post: 26
Joined: May, 2008
|
I want to create 2 tablespaes with different block sizes.
I configured in init.ora file db_2k_cache_size = 4m and db_4k_cache_size=4m
When I startup it is thorowing following error:
ORA-00381 : Can not use both new & old parmeters for buffer cache size specification.
Can anybody help me in this
PYB |
|
|
 Gitesh |
| Posted: May 13, 2008 02:30:31 AM |  |
|
Total Post: 322
Joined: May, 2005
|
What is the oracle version? If it is 9i then remove db_block_buffers parameters and convert it value in to db_cache_size.
|
|
|
|
|
| rajesh |
| Posted: May 13, 2008 02:47:00 AM | |
|
Total Post: 26
Joined: May, 2008
|
The version is oracle 10g
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 13, 2008 02:53:51 AM | |
|
Total Post: 128
Joined: Apr, 2008
|
the assign memory must be >= 48 M ....
TO understand batter please go through the topic:
http://sharear.blogspot.com/2008/04/use-multiple-blocksizes-in-oracle.html
|
|
|
|
|
| dbavinod |
| Posted: May 13, 2008 04:15:32 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
check instance is starting with pfile or spfile if spfile create pfile and try
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 05:13:21 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
ORA-00381: cannot use both new and old parameters for buffer cache size specification
Cause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32), db_cache_advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_recycle }. This is illegal.
Action: Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don't specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
