Oracle 周末 报错ORA-04031

早上打开电脑，CRT满屏 4031，脑袋都炸了

Mon Mar 19 05:55:25 CST 2018
Errors in file /u01/app/oracle/admin/OMS10G/bdump/oms10g_cjq0_23214.trc:
ORA-00604: error occurred at recursive SQL level ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select timestamp, flags from...","sql area","tmp")

使用pl/sql查看数据库，报同样的错，无法登录

登录数据库服务器sqlplus / as sysdba ，可以登录，执行sql报同样的错，shutdown immediate，不能正常执行。

为了能够使测试正常运行，使出了最大的杀手锏

ps -ef|grep ora_smon

kill -9

最后sqlplus / as sysdba

startup

重启APP，正常运行。现在该去检查错误去了……

转载于:https://www.cnblogs.com/luhp1991/p/8600643.html