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> startupORA-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> startupORA-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.