暂无图片
oracle 11.2.0.4 单实例 alert报 ORA-07445: 出现异常错误: 核心转储 ,后实例重启。求助
我来答
分享
用户5935
2020-03-23
oracle 11.2.0.4 单实例 alert报 ORA-07445: 出现异常错误: 核心转储 ,后实例重启。求助
暂无图片 15M

数据库实例异常重启时间为3.22日14:37分:39s
根据alert日志报错信息如下:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1CD000001FB8] [PC:0x2E235F5, kglScanReferences()+155] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_s000_4770.trc (incident=616620):
ORA-07445: 出现异常错误: 核心转储 [kglScanReferences()+155] [SIGSEGV] [ADDR:0x1CD000001FB8] [PC:0x2E235F5] [Address not mapped to object] []
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_616620/orac_s000_4770_i616620.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Mar 22 14:37:43 2020
Dumping diagnostic data in directory=[cdmp_20200322143743], requested by (instance=1, osid=4770 (S000)), summary=[incident=616620].
Sun Mar 22 14:37:50 2020
failed to start shared server
Sun Mar 22 14:38:32 2020
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1CD000001FB8] [PC:0x2E235F5, kglScanReferences()+155] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_4537.trc (incident=616436):
ORA-07445: exception encountered: core dump [kglScanReferences()+155] [SIGSEGV] [ADDR:0x1CD000001FB8] [PC:0x2E235F5] [Address not mapped to object] []
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_616436/orac_pmon_4537_i616436.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Mar 22 14:38:32 2020
Sweep [inc][616620]: completed
Sweep [inc2][616620]: completed
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_4537.trc:
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kglScanReferences()+155] [SIGSEGV] [ADDR:0x1CD000001FB8] [PC:0x2E235F5] [Address not mapped to object] []
PMON (ospid: 4537): terminating the instance due to error 602
Sun Mar 22 14:38:33 2020
System state dump requested by (instance=1, osid=4537 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_diag_4687_20200322143833.trc
Instance terminated by PMON, pid = 4537
Sun Mar 22 14:40:32 2020

3.16日的时候报错如下同样导致数据库实例重启:

Mon Mar 16 12:01:12 2020
Archived Log entry 40409 added for thread 1 sequence 103761 ID 0x4bd15c34 dest 1:
Mon Mar 16 12:04:27 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:05:27 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:07:09 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:08:09 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:09:43 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:10:43 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:12:16 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:13:16 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:13:48 2020
Error occured while spawning process S032; error = 601
Mon Mar 16 12:14:49 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:15:49 2020
PMON failed to acquire latch, see PMON dump
Mon Mar 16 12:16:21 2020
Error occured while spawning process S032; error = 601
Mon Mar 16 12:18:25 2020
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_145315.trc (incident=594660):
ORA-00445: background process “S032” did not start after 120 seconds
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_594660/orac_pmon_145315_i594660.trc
failed to start shared server
Mon Mar 16 12:18:26 2020
Dumping diagnostic data in directory=[cdmp_20200316121826], requested by (instance=1, osid=145315 (PMON)), summary=[incident=594660].
Mon Mar 16 12:21:25 2020
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_145315.trc (incident=594661):
ORA-00445: background process “S032” did not start after 120 seconds
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_594661/orac_pmon_145315_i594661.trc
failed to start shared server
Mon Mar 16 12:25:26 2020
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_145315.trc (incident=594662):
ORA-00445: background process “S032” did not start after 120 seconds
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_594662/orac_pmon_145315_i594662.trc
failed to start shared server
Mon Mar 16 12:31:28 2020
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_145315.trc (incident=594663):
ORA-00445: background process “S032” did not start after 120 seconds
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_594663/orac_pmon_145315_i594663.trc
failed to start shared server
Mon Mar 16 12:41:29 2020
Errors in file /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/trace/orac_pmon_145315.trc (incident=594664):
ORA-00445: background process “S032” did not start after 120 seconds
Incident details in: /u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_594664/orac_pmon_145315_i594664.trc
failed to start shared server
Mon Mar 16 13:07:56 2020
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 48
Number of processor cores in the system is 24
Number of processor sockets in the system is 2
CELL communication is configured to use 0 interface(s):

我来答
添加附件
收藏
分享
问题补充
11条回答
默认
最新
用户5935
上传附件:orac_pmon_4537.trc
暂无图片 评论
暂无图片 有用 0
用户5935
暂无图片 评论
暂无图片 有用 0
用户5935
上传附件:orac_s000_4770.trc
暂无图片 评论
暂无图片 有用 0
用户5935
上传附件:alert_0323.zip
暂无图片 评论
暂无图片 有用 0
JiekeXu
暂无图片

不知你数据库是标准版还是企业版,MOS上说是 BUG 8527473 ORA-00445: Background Process “xxxx” Did Not Start After 120 Seconds (Doc ID 1345364.1)

APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Linux x86
Linux on IBM Z
Linux x86-64

按照下面说法先查看下再看情况

image.png

暂无图片 评论
暂无图片 有用 0
Moone

需要关键的trace文件:
/u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_616620/orac_s000_4770_i616620.trc
/u01/app/oracle/admin/orac/diag/diag/rdbms/orac/orac/incident/incdir_616436/orac_pmon_4537_i616436.trc

暂无图片 评论
暂无图片 有用 0
用户5935
上传附件:incdir_616436.zip
暂无图片 评论
暂无图片 有用 0
用户5935
上传附件:incdir_616620.zip
暂无图片 评论
暂无图片 有用 0
用户5935

已上传

暂无图片 评论
暂无图片 有用 0
用户5935

标准版的

暂无图片 评论
暂无图片 有用 0

是这个SQL造成的:

ALTER TABLE KAD.T_EQUIP_REG ADD SOCKET_FLAG VARCHAR2(1) DEFAULT 0

看看是什么程序操作,解决一下。

暂无图片 评论
暂无图片 有用 1
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏