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):
墨值悬赏

评论


