ORA-03113: 通信通道的文件结尾和alert里的 ORA-07445: 出现异常错误

oyond 2018-04-09 06:32:52
今天开发的同事说执行loadjava注册的时候报了ORA-03113的错误,执行的语句是loadjava -r -f -u schema/密码@ip/服务名 json-20180409.jar,然后我打开alert日志,在本机执行的时候报了同样的错误,同时alert日志里报了一堆下面的错误:
Mon Apr 09 16:54:29 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x10A6BD708, joet_create_root_thread_group()+136] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/bjsde/a4sde2/trace/a4sde2_ora_32061.trc (incident=1268535):
ORA-07445: 出现异常错误: 核心转储 [joet_create_root_thread_group()+136] [SIGSEGV] [ADDR:0x8] [PC:0x10A6BD708] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/bjsde/a4sde2/incident/incdir_1268535/a4sde2_ora_32061_i1268535.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 09 16:54:33 2018
Dumping diagnostic data in directory=[cdmp_20180409165433], requested by (instance=2, osid=32061), summary=[incident=1268535].
Mon Apr 09 16:54:33 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x10A6BD708, joet_create_root_thread_group()+136] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/bjsde/a4sde2/trace/a4sde2_ora_32155.trc (incident=1268574):
ORA-07445: 出现异常错误: 核心转储 [joet_create_root_thread_group()+136] [SIGSEGV] [ADDR:0x8] [PC:0x10A6BD708] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/bjsde/a4sde2/incident/incdir_1268574/a4sde2_ora_32155_i1268574.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 09 16:54:33 2018
Sweep [inc][1268574]: completed
Sweep [inc][1268535]: completed
Sweep [inc2][1268535]: completed
Mon Apr 09 16:54:39 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x10A6BD708, joet_create_root_thread_group()+136] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/bjsde/a4sde2/trace/a4sde2_m000_32157.trc (incident=1268662):
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+136] [SIGSEGV] [ADDR:0x8] [PC:0x10A6BD708] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
根据alert里指向的trc文件,发现执行语句:
*** 2018-04-09 16:54:33.700
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=4h756dsat9bbr) -----
select dbms_java.handleMd5('///',29) from dual
我拿出这个语句单独执行,确实复现了上面描述的错误,有哪位大神遇到过吗?
PS:操作系统是Solaris 11.1 sparc,数据库是11.2.0.3.0的RAC
...全文
823 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
minsic78 2018-04-12
  • 打赏
  • 举报
回复
MOS Doc ID 1940340.1 看看是不是这个问题。
  • 打赏
  • 举报
回复
通信通道文件结尾,可以当着是session没了。重新取得连接就可以了

3,491

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧