RAC 查询库 ORA-07445-[kgldon()+831]_BUG

一、现象

Mon Jul 23 15:13:40 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x318E487, kgldon()+831] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/qdb/qdb1/trace/qdb1_ora_1686.trc (incident=579118):
ORA-07445: exception encountered: core dump [kgldon()+831] [SIGSEGV] [ADDR:0x0] [PC:0x318E487] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/qdb/qdb1/incident/incdir_579118/qdb1_ora_1686_i579118.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

二、BUG

 

Bug 14259486 - ORA-7445 [kgldon] if fix for bug 12378705 present (文档 ID 14259486.8)

This fix also addresses the PLS-801 [pklsdlp:dependency verification] errors of bug 12378705.
For interim patches please use this fix instead of the fix for bug 12378705 .


Bug:14259486 (This link will only work for PUBLISHED bugs)

Bug 12378705 - PLS-801 raised on Active Data Guard database when calling a stored PL/SQL - superseded (文档 ID 12378705.8)

 

三、原因：使用 PLSQL 工具造成的

四、解决办法(不是长久的办法；也可以选择忽略----ORA-04031 也可以 按照下面方法解决)

30 06 * * * sh /home/oracle/flush/flush_shared_pool.sh > /dev/null 2>&1

[oracle@qdb1 trace]$ cat /home/oracle/flush/flush_shared_pool.sh
#!/bin/bash
source /home/oracle/.bash_profile
exec >> /home/oracle/flush/flush_shared_pool`date +%y%m%d%H`.log
sqlplus / as sysdba <<EOF
select sysdate from dual;
alter system flush shared_pool;
exit;
EOF