ORA-00604,ORA-04031

今天打开oracle数据库的时候出现了如下错误:[@more@]

Errors in file d:appdiagrdbmstesttesttracetest_cjq0_4368.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select procedure#,entrypoint...","SQLA","tmp")

不能shutdown immediate

SQL> shutdown immediate
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ index(idl_sb4$ i_...","SQLA","tmp")

只好shutdown abort

SQL> shutdown abort;
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 626327552 bytes
Fixed Size 2178336 bytes
Variable Size 591397600 bytes
Database Buffers 25165824 bytes
Redo Buffers 7585792 bytes
Database mounted.

最后修改sga_target之后，既可以把数据库启动.

SQL> alter system set sga_target=580m;
alter system set sga_target=580m
*
ERROR at line 1:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-00839: 无法将 SGA_TARGET 修改为指定的值


SQL> alter system set sga_target=580m scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: 数据库未打开


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 830930944 bytes
Fixed Size 2180304 bytes
Variable Size 381684528 bytes
Database Buffers 440401920 bytes
Redo Buffers 6664192 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:UsersFounder>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 2月 20 09:22:00 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "SYS"
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1060237/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1060237/