ORA-00381 错误解决

数据库启动时报错

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

查oracle官方文档

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}) AND one or more of {DB_BLOCK_BUFFERS, BUFFER_POOL_KEEP, BUFFER_POOL_RECYCLE}. This is illegal.

Action: Use EITHER the old (pre-Oracle 9.0.0) 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.

打开initBWP.ora文件发现，参数文件中同时存在*.db_cache_size=5452595200和*.db_block_buffers=0两个参数，而这个参数在oracle 9i中是不允许同时存在的。删除*.db_block_buffers=0这一行后重新启动数据库正常，

orabwp> sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Sat Apr 12 01:02:17 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup pfile=/oracle/BWP/920_64/dbs/initBWP.ora nomount
ORACLE instance started.

Total System Global Area 6410965696 bytes
Fixed Size                   746176 bytes
Variable Size             956301312 bytes
Database Buffers         5452595200 bytes
Redo Buffers                1323008 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE