ORA-00604 ORA-04031错误

做数据库恢复后，遇到ORA-00604、 ORA-04031错误，

ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 80 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","sql area","opn: qkexrInitOpn")

 

 

参考如下文章，http://www.dbanotes.net/Oracle/Ora-04031.htm

折腾后问题解决了，备忘

 

1、关闭oracle服务进程

2、打开pfile，_db_handles_cached = 0 ，合理增加shared_pool_size大小

3、startup nomount from pfile='...';

4、create spfile from pfile='......';

5、重启instance

 

解决