今天開發的同事說執行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
uj5u.com熱心網友回復：
通信通道檔案結尾，可以當著是session沒了。重新取得連接就可以了uj5u.com熱心網友回復：
MOS Doc ID 1940340.1看看是不是這個問題。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/69679.html
標籤：高級技術