Tuesday, May 22, 2007

Error Message: "Total lru latches configured: 1; latches required for buffer pools = 2"

This occurred in one 8i database during failover to another sever with less CPUs.
Solution
1.This is due to CPU changed from 4 to 2 after permanently switch to another server, which affects db_block_lru_latches (default is CPU/2).
2.comment out init parameter buffer_pool_keep and alter affected table's buffer pool to DEFAULT.