標(biāo)題: 關(guān)于Specified value of sga_target is too small [打印本頁] 作者: sendqmail 時(shí)間: 2008-02-26 21:26 標(biāo)題: 關(guān)于Specified value of sga_target is too small 今天發(fā)現(xiàn)的兩個(gè)問題,也許這個(gè)問題是許多人都碰到過的，也許很多人已經(jīng)解決過的,也許..............
SQL> startup
ORA-00821: Specified value of sga_target 200M is too small, needs to be at least 208M
SQL> startup force
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
OS:
SQL> !uname -a
SunOS ORACLE 5.10 Generic_118855-33 i86pc i386 i86pc
DB:
SQL> select * from v$version where rownum<3;
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
由于錯(cuò)誤是提示sga_target太小了,我的第一反映就是去嘗試查找spfile的sga_target,發(fā)現(xiàn)這個(gè)值是很大的，在經(jīng)過一番努力查詢后,最后發(fā)現(xiàn)是spfile文件有問題,最后嘗試用pfile啟動(dòng)系統(tǒng)
SQL> startup pfile='/export/home/oracle/product/10.2/dbs/initora10g.ora'
ORACLE instance started.
Total System Global Area 511705088 bytes
Fixed Size 1281068 bytes
Variable Size 201327572 bytes
Database Buffers 301989888 bytes
Redo Buffers 7106560 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter sga_target;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
sga_target big integer
488M
最后,干脆重新創(chuàng)建spfile,
SQL> alter system set sga_target=308666624 scope=both
初步斷定第二個(gè)錯(cuò)誤是由于第一個(gè)錯(cuò)誤引起的,把那個(gè)問題搞定后就全部ok了,
SQL> startup force