继续设置sga_target非正常值导致ORA-00093

最新推荐文章于 2023-03-29 12:43:26 发布

weixin_34283445

最新推荐文章于 2023-03-29 12:43:26 发布

阅读量188

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/nishenvip/blog/145876

版权

2019独角兽企业重金招聘Python工程师标准>>>

设置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

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.

转载于:https://my.oschina.net/nishenvip/blog/145876