设置sga_target非正常值导致ORA-00093解决
设置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_init.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 0 SQL> startup ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@CallCenter-Data tmp]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 24 23:44:51 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> startup ORA-01031: insufficient privileges SQL> connect sys / as sysdba Enter password: Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2021152 bytes Variable Size 1543506144 bytes Database Buffers 50331648 bytes Redo Buffers 14753792 bytes Database mounted. Database opened.