sga_target或shared_pool_size非正常值导致ORA-00093解决办法

shared_pool_size值一般设置为物理内存的5% 

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

SQL> startup nomount;
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
SQL> create pfile = '/se/2014_2_22_1.ora' from spfile;
File created.
SQL> !echo  '*.shared_pool_size=100M' >>'/se/2014_2_22_1.ora'; 
SQL> create spfile from pfile = '/se/2014_2_22_1.ora'; 
File created.
SQL> startup nomount;
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
SQL> exit 
Disconnected
[oracle@Znotz ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Feb 15 22:13:34 2014
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area  348127232 bytes
Fixed Size                  1260756 bytes
Variable Size             268436268 bytes
Database Buffers           71303168 bytes
Redo Buffers                7127040 bytes

----------------------------------------------------------------------------------------------

版权所有，如需转载，请注明出处，否则追加法律责任！

blog:http://blog.csdn.net/waycomecome

mail:waycomecome@gmail.com