LoveUnix » ORACLE等数据库 » 求救 ORA-07445 怎么解决？
2006-9-11 21:20
tomcatt
求救 ORA-07445 怎么解决？
Mon Sep 11 17:54:02 2006
Errors in file /oracle/admin/CCPCDB1/udump/ccpcdb1_ora_246916.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Mon Sep 11 17:54:02 2006
Errors in file /oracle/admin/CCPCDB1/udump/ccpcdb1_ora_246916.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
2006-9-11 21:31
闲云
:L
[[i] 本帖最后由 闲云 于 2006-9-11 21:43 编辑 [/i]]
[[i] 本帖最后由 闲云 于 2006-9-11 21:43 编辑 [/i]]
2006-9-11 21:55
tomcatt
现在就是没有头绪吗？只要运行那个SQL 就会报错，但是那个SQL语法应没有错。现在才晕。
2006-9-11 23:21
闲云
找找库中的非法数据库对象
2006-9-12 13:17
tomcatt
闲云 能否帮我下载这个补丁，谢谢？
Insert as Select -> ORA-07445
Ouch! We got a wonderful ORA-03113 running a PL/SQL procedure last week. Just two seconds after executing the routine via SQL-Plus the session was terminated with an ORA-03113 end-of-file on communications channel. This happen both on a linux box and an AIX system both running Oracel 9.2.0.6.
Infact the procedure was crashing wit a memory access vialotion. This could be seen after taking a look in the oracle alertlog.
Oracle support was able to analyse the problem and match it to a known bug 3256015 and suggest installing an available patch 3256015 - which we did... and hey presto the procedure works fine now.
Insert as Select -> ORA-07445
Ouch! We got a wonderful ORA-03113 running a PL/SQL procedure last week. Just two seconds after executing the routine via SQL-Plus the session was terminated with an ORA-03113 end-of-file on communications channel. This happen both on a linux box and an AIX system both running Oracel 9.2.0.6.
Infact the procedure was crashing wit a memory access vialotion. This could be seen after taking a look in the oracle alertlog.
Oracle support was able to analyse the problem and match it to a known bug 3256015 and suggest installing an available patch 3256015 - which we did... and hey presto the procedure works fine now.
2006-9-12 14:06
闲云
可是你并没有ORA-03113 错误
2006-9-12 14:08
闲云
下载了，不过我觉得还是要检查一下失效的对象
2006-9-12 15:06
tomcatt
太感谢你了！是有的ORA-03113 在客户端报！
2006-9-12 15:38
tomcatt
你说对了，还是没用。
2006-9-13 10:24
闲云
那个一长串的insert语句中，是否有失效的对象
页: [1]
查看完整版本: 求救 ORA-07445 怎么解决？
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.