ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140]
程序员文章站
2022-05-11 13:43:07
...
问题描述:
客户一套单机10.2.0.5 on Linux , 我给了打了最后的PSU: 20299014(10.2.0.5.19)。 然后再dbca建库, 按以前11g的经验,是不需要再运行“ @catbundle.sql psu apply”
后面客户反应exp导数有报错:
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated unsuccessfully
查看此时的alert日志,有明显的报错:
Mon Nov 16 11:57:35 CST 2020
Errors in file /u01/app/oracle/admin/ora10/udump/ora10_ora_29931.trc:
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Mon Nov 16 11:57:39 CST 2020
Errors in file /u01/app/oracle/admin/ora10/udump/ora10_ora_29938.trc:
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Mon Nov 16 12:00:46 CST 2020
Errors in file /u01/app/oracle/admin/ora10/udump/ora10_ora_30014.trc:
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Mon Nov 16 12:01:37 CST 2020
Errors in file /u01/app/oracle/admin/ora10/udump/ora10_ora_30034.trc:
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Mon Nov 16 12:02:53 CST 2020
Errors in file /u01/app/oracle/admin/ora10/udump/ora10_ora_30041.trc:
ORA-07445: exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
原因分析:
在MOS找了一下,只有一个类似的,但版本对不上。不过它给了我思路,这个问题可能是打PSU引进来的。
查看数据库的PSU情况, dba_registry_history记录竟然是空!这跟11g不一样。看来10g打完PSU后,dbca建库还是要其他步骤要做。
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 20299014 : applied on Mon Nov 09 11:30:28 CST 2020
Unique Patch ID: 19074368
Created on 24 Jun 2015, 02:35:37 hrs PST8PDT
Bugs fixed:
alter session set nls_timestamp_format = "yyyy-mm-dd hh24:mi:ss.ff";
select * from dba_registry_history;
16:28:12 aaa@qq.com >
Session altered.
Elapsed: 00:00:00.01
16:28:12 aaa@qq.com >
no rows selected
解决方案:
按mos的说明,我们来执行“ @catbundle.sql psu apply”
16:31:11 aaa@qq.com > alter system set java_jit_enabled =FALSE;
alter system set java_jit_enabled =FALSE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
Elapsed: 00:00:00.02
16:31:12 aaa@qq.com > alter system set "_system_trig_enabled"=FALSE;
System altered.
Elapsed: 00:00:00.02
16:31:21 aaa@qq.com > alter system set JOB_QUEUE_PROCESSES=0;
System altered.
Elapsed: 00:00:00.01
16:31:26 aaa@qq.com > startup restrict
ORA-01081: cannot start already-running ORACLE - shut it down first
16:31:30 aaa@qq.com > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:31:51 aaa@qq.com > startup restrict
ORACLE instance started.
Total System Global Area 32212254720 bytes
Fixed Size 2155264 bytes
Variable Size 3019902208 bytes
Database Buffers 29175578624 bytes
Redo Buffers 14618624 bytes
Database mounted.
Database opened.
16:32:20 aaa@qq.com > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[aaa@qq.com:/home/oracle ora10]$ cd $ORACLE_HOME/rdbms/admin
[aaa@qq.com:/u01/app/oracle/product/10.2.0/db_1/rdbms/admin ora10]$ ora si
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Nov 16 16:32:46 2020
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
16:32:46 aaa@qq.com >
16:33:26 aaa@qq.com >
16:33:26 aaa@qq.com > @catbundle.sql psu apply
16:36:35 aaa@qq.com > alter system set "_system_trig_enabled"=TRUE;
System altered.
Elapsed: 00:00:00.03
16:39:53 aaa@qq.com > alter system set JOB_QUEUE_PROCESSES=10;
System altered.
Elapsed: 00:00:00.02
16:39:57 aaa@qq.com > startup force
此后再exp导数就不报错了。
上一篇: 常用H5标签之块元素
下一篇: 权限管理 —— 文件特殊权限