ORA-07445 exception encountered: core dump。幫忙看看。
資料庫版本:oracle 9.2.0.6.0
作業系統:Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
例行檢查的時候,發現後臺報警日誌有報錯。
分別有三次報錯,在最近
Thu May 1 00:20:49 2008
Errors in file /home/oracle/admin/md126/udump/md126_ora_4468.trc:
ORA-07445: exception encountered: core dump [lxmspax()+46] [SIGSEGV] [Address not mapped to object] [0x16E] [] []
Thu May 1 00:21:23 2008
Fri May 16 01:43:16 2008
Errors in file /home/oracle/admin/md126/bdump/md126_d002_9354.trc:
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Fri May 16 01:43:24 2008
Tue Jun 17 12:26:40 2008
Errors in file /home/oracle/admin/md126/bdump/md126_d000_9340.trc:
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Tue Jun 17 12:27:40 2008
因為我是月初接手的這個庫,所以,今天才發現問題又報了。
/home/oracle/admin/md126/bdump/md126_d000_9340.trc的節選部分:
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0xa0a1e72, nstimset()+224]
Registers:
%eax: 0x00000000 %ebx: 0x0aea8824 %ecx: 0x00007530
%edx: 0x0aec71a0 %edi: 0x00000005 %esi: 0x0c153420
%esp: 0xbfff99a0 %ebp: 0xbfff99d8 %eip: 0x0a0a1e72
%efl: 0x00010206
nstimset()+204 (0xa0a1e5e) mov 0x158(%ecx),%eax
nstimset()+210 (0xa0a1e64) movzw 0x14c(%ecx),%edi
nstimset()+217 (0xa0a1e6b) imul $0x1770,%edi,%ecx
nstimset()+223 (0xa0a1e71) push %ecx
> nstimset()+224 (0xa0a1e72) push (%eax)
nstimset()+226 (0xa0a1e74) push 0xc4(%edx)
nstimset()+232 (0xa0a1e7a) call 0xa2bb564
nstimset()+237 (0xa0a1e7f) add $12,%esp
nstimset()+240 (0xa0a1e82) test %eax,%eax
*** 2008-06-17 12:26:40.312
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+274 call ksedst() 1 ? 0 ? 0 ? 1 ? 65252C78 ?
7861 ?
ssexhd()+1113 call ksedmp() 3 ? 0 ? 0 ? 0 ? 0 ? 0 ?
__pthread_sighandle call 00000000 B ? B75CFC90 ? B75CFD10 ? 0 ?
r_rt()+122 0 ? 0 ?
nstimset()+224 signal 00000000 B ? B75CFC90 ? B75CFD10 ?
nstimexp()+650 call nstimset() C154DD0 ? C201450 ?
ltmdvp()+177 call 00000000 C16B4D0 ? C201450 ? C18F6E0 ?
1876A977 ? 1F9F9 ? C16B3A8 ?
C18F6E0 ?
ltmdrv()+89 call ltmdvp() C16B4D0 ? C16B3A8 ? 0 ? 0 ?
sltmdf()+32 call ltmdrv() C16B4D0 ? 0 ? 0 ?
sslsstehdlr()+560 call 00000000 E ? C16B4D0 ?
__pthread_sighandle call 00000000 E ? BFFF9C10 ? BFFF9C90 ? 0 ?
r_rt()+122 0 ? 0 ?
__GI___poll()+56 signal 00000000 E ? BFFF9C10 ? BFFF9C90 ?
__PGOSF27_ntevpque( call poll() C24D7B4 ? B8 ? EA60 ? 1 ?
)+225 50 ? 0 ?
ntevque()+162 call 00000000 C1551B8 ? EA60 ? BFFFA830 ?
AEA8824 ? 0 ? C154DD0 ?
nsevwait()+474 call ntevque() C1551B8 ? EA60 ? BFFFA830 ?
BFFFA930 ? C153420 ?
C154DD0 ?
ksnwait()+46 call nsevwait() C154DD0 ? AEB77A4 ? AEB77A8 ?
0 ? AEB77AC ?
ksliwat()+1772 call ksnwait() EA60 ? 0 ? AD3C717C ?
C194720 ? 0 ? 2 ?
kslwaitns()+29 call ksliwat() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ? 0 ?
kskthbwt()+83 call kslwaitns() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ? 0 ?
kslwait()+61 call kskthbwt() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ?
kmdmai()+1431 call kslwait() 1770 ? 144 ? 0 ? 1770 ? 0 ?
kmmrdp()+472 call kmdmai() A135616C ? 299D24E3 ? 1C ?
A0FF027F ? BFFFABDC ? E7F ?
opirip()+729 call kmmrdp() AEB485C ? BFFFB588 ? 13A46C ?
BFFFB6F0 ? 1 ? 1 ?
opidrv()+865 call opirip() 32 ? 0 ? 0 ?
sou2o()+30 call opidrv() 32 ? 0 ? 0 ?
main()+440 call sou2o() BFFFB6F0 ? 32 ? 0 ? 0 ?
57E710 ? 0 ?
__libc_start_main() call 00000000 1 ? BFFFB774 ? BFFFB77C ?
+170 57E518 ? 1 ? 8213EC0 ?
metalink如下說:
-- Problem Statement:
On 10.2.0.3 in Production:
While attempting cloning a production, the following error occurs:
ERROR
RMAN-03015: error occurred in stored script Memory Script
RMAN-10038: database session for channel ORA_AUX_SBT_TAPE_3 terminated unexpectedly
by checking the alert.log for target database we noticed the following error cause the session
termination with RMAN :
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28003.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x000000070] [] []
Tue Feb 19 13:28:10 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28005.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x000000040] [] []
Tue Feb 19 13:28:21 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28007.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x0000000D0] [] []
Tue Feb 19 13:28:37 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28009.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGBUS] [Invalid address
alignment] [0x6F6E647320776879] [] []
Cause
Issue is caused by Media Manager
ORA-7445 shows that process crashes in function 'CleanUpShMforRestore' which is a Media Manager
function
Solution
This is not an Oracle issue but concerns the Media Manager
Since the 'CleanUpShMforRestore' is a Media Manager function.
As such, please contact your Media Manager vendor concerning this issue.
Keywords
CORE~DUMP; CLONING.RTF; INVALID~ADDRESS;
作業系統:Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
例行檢查的時候,發現後臺報警日誌有報錯。
分別有三次報錯,在最近
Thu May 1 00:20:49 2008
Errors in file /home/oracle/admin/md126/udump/md126_ora_4468.trc:
ORA-07445: exception encountered: core dump [lxmspax()+46] [SIGSEGV] [Address not mapped to object] [0x16E] [] []
Thu May 1 00:21:23 2008
Fri May 16 01:43:16 2008
Errors in file /home/oracle/admin/md126/bdump/md126_d002_9354.trc:
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Fri May 16 01:43:24 2008
Tue Jun 17 12:26:40 2008
Errors in file /home/oracle/admin/md126/bdump/md126_d000_9340.trc:
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Tue Jun 17 12:27:40 2008
因為我是月初接手的這個庫,所以,今天才發現問題又報了。
/home/oracle/admin/md126/bdump/md126_d000_9340.trc的節選部分:
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0xa0a1e72, nstimset()+224]
Registers:
%eax: 0x00000000 %ebx: 0x0aea8824 %ecx: 0x00007530
%edx: 0x0aec71a0 %edi: 0x00000005 %esi: 0x0c153420
%esp: 0xbfff99a0 %ebp: 0xbfff99d8 %eip: 0x0a0a1e72
%efl: 0x00010206
nstimset()+204 (0xa0a1e5e) mov 0x158(%ecx),%eax
nstimset()+210 (0xa0a1e64) movzw 0x14c(%ecx),%edi
nstimset()+217 (0xa0a1e6b) imul $0x1770,%edi,%ecx
nstimset()+223 (0xa0a1e71) push %ecx
> nstimset()+224 (0xa0a1e72) push (%eax)
nstimset()+226 (0xa0a1e74) push 0xc4(%edx)
nstimset()+232 (0xa0a1e7a) call 0xa2bb564
nstimset()+237 (0xa0a1e7f) add $12,%esp
nstimset()+240 (0xa0a1e82) test %eax,%eax
*** 2008-06-17 12:26:40.312
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [nstimset()+224] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+274 call ksedst() 1 ? 0 ? 0 ? 1 ? 65252C78 ?
7861 ?
ssexhd()+1113 call ksedmp() 3 ? 0 ? 0 ? 0 ? 0 ? 0 ?
__pthread_sighandle call 00000000 B ? B75CFC90 ? B75CFD10 ? 0 ?
r_rt()+122 0 ? 0 ?
nstimset()+224 signal 00000000 B ? B75CFC90 ? B75CFD10 ?
nstimexp()+650 call nstimset() C154DD0 ? C201450 ?
ltmdvp()+177 call 00000000 C16B4D0 ? C201450 ? C18F6E0 ?
1876A977 ? 1F9F9 ? C16B3A8 ?
C18F6E0 ?
ltmdrv()+89 call ltmdvp() C16B4D0 ? C16B3A8 ? 0 ? 0 ?
sltmdf()+32 call ltmdrv() C16B4D0 ? 0 ? 0 ?
sslsstehdlr()+560 call 00000000 E ? C16B4D0 ?
__pthread_sighandle call 00000000 E ? BFFF9C10 ? BFFF9C90 ? 0 ?
r_rt()+122 0 ? 0 ?
__GI___poll()+56 signal 00000000 E ? BFFF9C10 ? BFFF9C90 ?
__PGOSF27_ntevpque( call poll() C24D7B4 ? B8 ? EA60 ? 1 ?
)+225 50 ? 0 ?
ntevque()+162 call 00000000 C1551B8 ? EA60 ? BFFFA830 ?
AEA8824 ? 0 ? C154DD0 ?
nsevwait()+474 call ntevque() C1551B8 ? EA60 ? BFFFA830 ?
BFFFA930 ? C153420 ?
C154DD0 ?
ksnwait()+46 call nsevwait() C154DD0 ? AEB77A4 ? AEB77A8 ?
0 ? AEB77AC ?
ksliwat()+1772 call ksnwait() EA60 ? 0 ? AD3C717C ?
C194720 ? 0 ? 2 ?
kslwaitns()+29 call ksliwat() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ? 0 ?
kskthbwt()+83 call kslwaitns() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ? 0 ?
kslwait()+61 call kskthbwt() 1770 ? 1 ? 144 ? 0 ? 1770 ?
0 ?
kmdmai()+1431 call kslwait() 1770 ? 144 ? 0 ? 1770 ? 0 ?
kmmrdp()+472 call kmdmai() A135616C ? 299D24E3 ? 1C ?
A0FF027F ? BFFFABDC ? E7F ?
opirip()+729 call kmmrdp() AEB485C ? BFFFB588 ? 13A46C ?
BFFFB6F0 ? 1 ? 1 ?
opidrv()+865 call opirip() 32 ? 0 ? 0 ?
sou2o()+30 call opidrv() 32 ? 0 ? 0 ?
main()+440 call sou2o() BFFFB6F0 ? 32 ? 0 ? 0 ?
57E710 ? 0 ?
__libc_start_main() call 00000000 1 ? BFFFB774 ? BFFFB77C ?
+170 57E518 ? 1 ? 8213EC0 ?
metalink如下說:
-- Problem Statement:
On 10.2.0.3 in Production:
While attempting cloning a production, the following error occurs:
ERROR
RMAN-03015: error occurred in stored script Memory Script
RMAN-10038: database session for channel ORA_AUX_SBT_TAPE_3 terminated unexpectedly
by checking the alert.log for target database we noticed the following error cause the session
termination with RMAN :
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28003.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x000000070] [] []
Tue Feb 19 13:28:10 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28005.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x000000040] [] []
Tue Feb 19 13:28:21 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28007.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGSEGV] [Address not
mapped to object] [0x0000000D0] [] []
Tue Feb 19 13:28:37 2008
Errors in file /oracle/admin/FSSIT/udump/fssit_ora_28009.trc:
ORA-07445: exception encountered: core dump [CleanUpShMforRestore()+164] [SIGBUS] [Invalid address
alignment] [0x6F6E647320776879] [] []
Cause
Issue is caused by Media Manager
ORA-7445 shows that process crashes in function 'CleanUpShMforRestore' which is a Media Manager
function
Solution
This is not an Oracle issue but concerns the Media Manager
Since the 'CleanUpShMforRestore' is a Media Manager function.
As such, please contact your Media Manager vendor concerning this issue.
Keywords
CORE~DUMP; CLONING.RTF; INVALID~ADDRESS;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/79499/viewspace-417661/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-07445: exception encountered: core dump [skgxpdmpctxException
- ORA-07445: exception encountered: core dump [kglpin()+527]Exception
- ORA-07445 exception encountered: core dump [kslgetl()+80]Exception
- ORA-07445: exception encountered: core dump [kgghtNumElements()Exception
- ORA-07445: exception encountered: core dump [ksxpunmap()+2742]Exception
- ORA-07445: exception encountered: core dump [qervwRowProcedure()+133]Exception
- ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [ksxpunmap()+2742] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [ptmak()+107]Exception
- ORA-07445: exception encountered: core dump [kglic0()+774]Exception
- ORA-07445: exception encountered: core dump [qkaqkn()+5390] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...ExceptionGse
- ORA-07445: exception encountered: core dump [__intel_new_memcpy()+5424]ExceptionIntelmemcpy
- move tablespace: ORA-07445:exception encountered: core dump [qcdlgtd()+182]Exception
- ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [CommonClientExit()+101] [SIGSEGV]ExceptionclientGse
- 報錯:ORA-07445: exception encountered: core dump [kkqtnloCbk()+111] [SIGSEGV]ExceptionQTGse
- ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not mapped to obExceptionGseAPP
- ORA-07445: exception encountered: core dump [PC:0x90000000D017E10]Exception
- ORA-07445: exception encountered: (一)Exception
- ORA-7445: exception encountered: core dump [kpodpals()+11332] [SIGSEGV]ExceptionGse
- 記一次ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not maExceptionIntelASTmemcpyGse
- 記一次ORA-07445: exception encountered: core dump [sdbgrfcvp_convert_pathinfo()+35] [SIGSEGV] [ADDR:0xFExceptionGse
- 11.2.0.1bug引發的報錯:ORA-07445: exception encounteredException
- 幫忙看看如何設定,跪謝!
- 大家幫幫忙,看看這個SQL怎麼寫!SQL
- 幫忙看看我得ejb客戶端客戶端
- 安裝出錯,請幫忙看看(轉)
- 監聽Session事件不能編譯,大家幫忙看看Session事件編譯
- ORA-07445: core dump [kpopfr()+673] [SIGFPE] [Integer divide by zero]IDE
- oracle10g中drop user造成ORA-07445 core dumpOracle
- 線上等,幫忙看看什麼錯,在mysql下跑MySql
- 高手請幫忙看看小弟寫的這個web service:Web
- jf6.2初學者問題,請大家幫忙看看
- 關於ldap的連線 得不到資訊,幫忙看看LDA
- 一個執行緒的問題。請大俠進來幫幫忙看看執行緒
- 求各位前輩幫忙看看連表查詢字首問題
- 在dom裡使用getXmlEncoding()出現異常請幫忙看看XMLEncoding