做数据库恢复后,遇到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
解决