내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux6.8(64bit)
DB 환경 : Oracle Database 11.2.0.3
에러 : ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+504] [SIGSEGV] [ADDR:0x0] [PC:0x277BB9E] [SI_KERNEL(general_protection)] []
#최초 alert log 에 ORA-07445 발생
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | $ vi alert log Wed Aug 08 23:59:47 2018 Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x277BB9E, LpxFSMSaxSE()+504] [flags: 0x0, count: 1] Errors in file /oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/trace/MDMDB_ora_16406.trc (incident=224427): ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+504] [SIGSEGV] [ADDR:0x0] [PC:0x277BB9E] [SI_KERNEL(general_protection)] [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Wed Aug 08 23:59:49 2018 Sweep [inc][224427]: completed Wed Aug 08 23:59:49 2018 Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x277BB9E, LpxFSMSaxSE()+504] [flags: 0x0, count: 1] Errors in file /oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/trace/MDMDB_ora_16421.trc (incident=224492): ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+504] [SIGSEGV] [ADDR:0x0] [PC:0x277BB9E] [SI_KERNEL(general_protection)] [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. |
#trace file 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | $ vi MDMDB_ora_16406.trc Trace file /oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/trace/MDMDB_ora_16406.trc Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1 System name: Linux Node name: localhost.localdomain Release: 2.6.18-274.17.1.el5 Version: #1 SMP Tue Jan 10 17:25:58 EST 2012 Machine: x86_64 Instance name: MDMDB Redo thread mounted by this instance: 1 Oracle process number: 49 Unix process pid: 16406, image: oracle@localhost.localdomain *** 2018-08-08 23:59:47.388 *** SESSION ID:(2356.21181) 2018-08-08 23:59:47.388 *** CLIENT ID:() 2018-08-08 23:59:47.388 *** SERVICE NAME:(SYS$USERS) 2018-08-08 23:59:47.388 *** MODULE NAME:(httpd@www.mdmad---.com (TNS V1-V3)) 2018-08-08 23:59:47.388 *** ACTION NAME:() 2018-08-08 23:59:47.388 Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x277BB9E, LpxFSMSaxSE()+504] [flags: 0x0, count: 1] DDE: Problem Key 'ORA 7445 [LpxFSMSaxSE()+504]' was flood controlled (0x2) (incident: 224427) ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+504] [SIGSEGV] [ADDR:0x0] [PC:0x277BB9E] [SI_KERNEL(general_protection)] [] ssexhd: crashing the process... Shadow_Core_Dump = PARTIAL ksdbgcra: writing core file to directory '/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump' |
#core file to directory 확인
1 2 3 4 5 6 7 8 9 10 11 12 | [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ ls -al total 40 drwxr-x--- 10 oracle dba 4096 Aug 8 23:59 . drwxr-x--- 15 oracle dba 4096 Jan 18 2012 .. drwxr-x--- 2 oracle dba 4096 Aug 8 23:53 core_10313 drwxr-x--- 2 oracle dba 4096 Aug 8 23:53 core_10326 drwxr-x--- 2 oracle dba 4096 Aug 8 23:57 core_12998 drwxr-x--- 2 oracle dba 4096 Aug 8 23:57 core_13013 drwxr-x--- 2 oracle dba 4096 Aug 8 23:59 core_16406 drwxr-x--- 2 oracle dba 4096 Aug 8 23:59 core_16421 drwxr-x--- 2 oracle dba 4096 Aug 8 23:49 core_8459 drwxr-x--- 2 oracle dba 4096 Aug 8 23:49 core_8489 |
#폴더가 8개나 생겼지만 안에는 어떤 파일도 없음
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_16421 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_16421]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_16406 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_16406]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_12998 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_12998]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_13013 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_13013]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_10326 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_10326]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_10313 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_10313]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_8489 [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_8489]$ ls [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump]$ cd core_8459/ [oracle@/oracle/app/oracle/diag/rdbms/MDMDB/MDMDB/cdump/core_8459]$ ls |
해결 방법 : 메타링크 확인결과 11.2.0.3에서의 ORA-07445 [LpxFSMSaxSE()+504] 는 버그로 알려져있음
DB에도 별다른 문제가 없어서 버그로 판단하고 종결
원인 : 오라클 버그
참조 : 문서 ID 1288473.1