Home » RDBMS Server » Server Administration » Different block size (Oracle 10.2.0 on Linux AS4)
Different block size [message #291740] Sun, 06 January 2008 09:08 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello Sir,

I want to create a tablespace with block size 4k in oracle 10g and after specifying db_4k_cache_ size=16m in parameter file at startup of our database it is showing error cannot start database with old and new parameter .

What could be the reason , bcos as per the books we can do it.



Regards,

Raja
Re: Different block size [message #291743 is a reply to message #291740] Sun, 06 January 2008 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't describe what you did, post it.
Post your session where you change the parameter, shutdown and restart the database.
Post the lines of alert.log where there is the startup and the error.

Regards
Michel
Re: Different block size [message #292815 is a reply to message #291740] Wed, 09 January 2008 23:22 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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.
Previous Topic: What is the Difference between Oracle Management Server Repository and the Stand Alone Mode?
Next Topic: concurrent/session
Goto Forum:
  


Current Time: Mon Dec 02 05:48:07 CST 2024