I got ” ORA-07445: exception encountered: core dump [kkqctdrvSU()+3845] [Address not mapped to object] ” error in Oracle database.
ORA-07445: exception encountered: core dump [kkqctdrvSU()+3845] [Address not mapped to object]
Details of error are as follows.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x28] [PC:0x3E1BE85, kkqctdrvSU()+3845] [flags: 0x0, count: 1] Errors in file /u01/app/oracle/diag/rdbms/MSDB/MSDB1/trace/MSDB1_ora_32392.trc (incident=5349510): ORA-07445: exception encountered: core dump [kkqctdrvSU()+3845] [SIGSEGV] [ADDR:0x28] [PC:0x3E1BE85] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/MSDB/MSDB1/incident/incdir_5349510/MSDB1_ora_32392_i5349510.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2021-05-11T01:15:58.571395+03:00 Dumping diagnostic data in directory=[cdmp_20210511011558], requested by (instance=1, osid=32392), summary=[incident=5349510]. Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x28] [PC:0x3E1BE85, kkqctdrvSU()+3845] [flags: 0x0, count: 1] Errors in file /u01/app/oracle/diag/rdbms/MSDB/MSDB8/trace/MSDB8_ora_165125.trc (incident=3329251): ORA-07445: exception encountered: core dump [kkqctdrvSU()+3845] [SIGSEGV] [ADDR:0x28] [PC:0x3E1BE85] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/MSDB/MSDB8/incident/incdir_3329251/MSDB8_ora_165125_i3329251.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2021-05-11T01:30:57.474141+03:00 Dumping diagnostic data in directory=[cdmp_20210511013057], requested by (instance=8, osid=165125), summary=[incident=3329251].
ORA-07445: exception encountered: core dump [kkqctdrvSU()+3845] [SIGSEGV]
This ORA-07445 error is related with the Oracle bug.
You can solve this bug as workaround as follows.
alter session set "_unnest_subquery" = false;
Or you should apply the following DB RU or upgrade to 20c.
The fix for 28133903 is first included in
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )