设置sga_target非正常值导致ORA-00093解决
设置sga_target非正常值导致ORA-00093
新装了一台oracle服务器
装好后修改参数，结果一不小心
SQL> alter system set sga_target = 1320 scope = spfile;System altered
sga_target漏了内存单位M
结果shutdown immediate再startup
SQL> startup;ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
解决办法
SQL> create pfile = '/oracle/tmp_initoracle账号.ora' from spfile;File created.SQL> !echo '*.sga_target=200m' >> '/oracle/tmp_init.ora';SQL> create spfile from pfile = '/oracle/tmp_init.ora';File created.SQL> startup;ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0SQL> startupORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining options[oracle@CallCenter-Data tmp]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 24 23:44:51 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> startupORA-01031: insufficient privilegesSQL> connect sys / as sysdbaEnter password: Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 2021152 bytesVariable Size 1543506144 bytesDatabase Buffers 50331648 bytesRedo Buffers 14753792 bytesDatabase mounted.Database opened.