My Oracle Support Banner

GEN0 Terminating the Instance Due to Error 495 (Doc ID 2439851.1)

Last updated on SEPTEMBER 13, 2018

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.