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.
打开initora10g.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
阅读(2473) | 评论(0) | 转发(0) |
