设置sga_target非正常值导致ORA-00093解决
2013-07-22 15:32:58 我来说两句 作者：阿莱倪士
收藏 
我要投稿
我要投稿
设置sga_target非正常值导致ORA-00093解决
设置sga_target非正常值导致ORA-00093
新装了一台oracle服务器
装好后修改参数，结果一不小心
|
1
2
3
|
SQL> alter system set sga_target = 1320 scope = spfile;
System altered
|
sga_target漏了内存单位M
结果shutdown immediate再startup
|
1
2
|
SQL> startup;
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
|
解决办法
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
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.
|
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25458798/viewspace-1240161/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
创建pfile和spfile
下一篇：
Oracle 监听器日志配置与管理
请登录后发表评论
登录
全部评论
