GEN0 Terminating the Instance Due to Error 495
(Doc ID 2439851.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]Information in this document applies to any platform.
Symptoms
In 12.2.0.1 Real Application Cluster, Instance terminate following ORA-00600 error.
alert_orcl2.log (inside <oracle base>/diag/rdbms/orcl/ORCL2/trace location):
2018-06-15T17:49:21.106469+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/orcl2_gen0_25929.trc (incident=52866) (PDBNAME=KACCD):
ORA-00600: internal error code, arguments: [ksbxic-5], [28], [], [], [], [], [], [], [], [], [], [] : internal error code, arguments: [ksbxic-5], [28], [], [], [], [], [], [], [], [], [], []
BugMatch Output
KACCD(3):Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL2/incident/incdir_52866/orcl2_gen0_25929_i52866.trc
.
.
2018-06-15T17:49:45.030165+08:00
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL2/trace/ORCL2_gen0_25929.trc:
ORA-00600: internal error code, arguments: [ksbxic-5], [28], [], [], [], [], [], [], [], [], [], [] : internal error code, arguments: [ksbxic-5], [28], [], [], [], [], [], [], [], [], [], []
BugMatch Output
ORA-06512: at "SYS.DBMS_PDB", line 33 : at "SYS.DBMS_PDB", line 33
ORA-06512: at "SYS.DBMS_PDB_EXEC_SQL", line 4 : at "SYS.DBMS_PDB_EXEC_SQL", line 4
Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL2/trace/ORCL2_gen0_25929.trc (incident=52869) (PDBNAME=CDB$ROOT):
ORA-495 [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/ORCL/ORCL2/incident/incdir_52869/ORCL2_gen0_25929_i52869.trc
2018-06-15T17:49:45.411678+08:00
Dumping diagnostic data in directory=[cdmp_20180615174945], requested by (instance=2, osid=4294993225 (GEN0)), summary=[incident=52868].
2018-06-15T17:49:52.327801+08:00
.
.
2018-06-15T17:49:52.542517+08:00
USER (ospid: 25929): terminating the instance due to error 495
2018-06-15T17:49:52.634757+08:00
System state dump requested by (instance=2, osid=4294993225 (GEN0)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/ORCL/ORCL2/trace/ORCL2_diag_25936_20180615174952.trc
2018-06-15T17:49:55.258888+08:00
License high water mark = 32
2018-06-15T17:49:57.751422+08:00
Instance terminated by USER, pid = 25929
2018-06-15T17:49:58.260790+08:00
USER (ospid: 28022): terminating the instance
2018-06-15T17:49:58.261344+08:00
Instance terminated by USER, pid = 28022
2018-06-15T17:50:01.854699+08:00
Adjusting the default value of parameter parallel_max_servers
from 320 to 296 due to the value of parameter processes (400)
Starting ORACLE instance (normal) (OS id: 28112)
orcl2_gen0_25929_i52866.trc (inside <oracle base>/diag/rdbms/orcl/ORCL2/incident/incdir_52866 location):
[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_gen0_25929.trc
[TOC00001]
ORA-00600: internal error code, arguments: [ksbxic-5], [28], [], [], [], [], [], [], [], [], [], []
[TOC00001-END]
[TOC00002]
========= Dump for incident 52866 (ORA 600 [ksbxic-5]) ========
*** 2018-06-15T17:49:21.178263+08:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=g87r5ctppn8bg) -----
ALTER TABLE AUDSYS.AUD$UNIFIED DROP PARTITION SYS_P1368
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
600000049cb63a40 33 package body SYS.DBMS_PDB.EXEC_AS_ORACLE_SCRIPT
40000004713916c0 4 procedure SYS.DBMS_PDB_EXEC_SQL
[TOC00004-END]
[TOC00003-END]
[TOC00005]
Call stack trace : <- kzan_run_ddl <- kzan_alter_uniaud<- drop_part <- kzan_cleanup_uniaud <- part <- kzan_purge_uniaud <- data <- kzam_ang_cleanup <- 4232 <- kzam_message_handle
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |