今天同事发现应用程序前台报错ORA-03113: 通信通道的文件结束，在查看警报日志时发现以下报错：
Errors in file /u/oracle/admin/resvdb/udump/resvdb_ora_25090.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2AB538AF6000] [] []
Errors in file /u/oracle/admin/resvdb/udump/resvdb_ora_25171.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2B2BF43FA000] [] []
查看udump下日志发现具体报错信息：
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x2ab538af6000, PC: [0x2ab536d1f608, _intel_fast_memcpy.A()+10]
*** 2010-06-23 02:56:04.129
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2AB538AF6000] [] []
*** SESSION ID:(317.607) 2010-06-23 10:44:18.117
Exception signal: 11 (SIGSEGV), code: 2 (Invalid permissions for mapped object), addr: 0x2b2bf43fa000, PC: [0x2b2bf1c7e608, _intel_fast_memcpy.A()+10]
*** 2010-06-23 10:44:18.127
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2B2BF43FA000] [] []
登陆metalink发现属于oracle bug（BUG 5868257 ）
解决方法下载patch（Patch 5868257）
下载后的文件p5868257_10204_Linux-x86-64.zip
传到服务器unzip解压缩，打补丁过程如下（注意打补丁时候要shutdown数据库）：
[oracle@pl-br-d01 ~]$ cd /u/software/patch/5868257/
[oracle@pl-br-d01 5868257]$ ls-ltr
-bash: ls-ltr: command not found
[oracle@pl-br-d01 5868257]$ ls -ltr
total 28
-rw-rw-rw- 1 oracle oinstall 5128 Jun62008 README.txt
drwxr-xr-x 4 oracle oinstall 4096 Jun62008 etc
drwxr-xr-x 3 oracle oinstall 4096 Jun62008 files
[oracle@pl-br-d01 5868257]$ opatch lsinventory
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.All rights reserved.
Oracle Home : /u/oracle/product/10.2.0/db_1
Central Inventory : /u/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version: 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location: /u/oracle/product/10.2.0/db_1/oui
Log file location : /u/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-06-23_11-34-31AM.log
Lsinventory Output file location : /u/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-06-23_11-34-31AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3
10.2.0.4.0
There are 2 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@pl-br-d01 5868257]$ opatch apply
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.All rights reserved.
Oracle Home : /u/oracle/product/10.2.0/db_1
Central Inventory : /u/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version: 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location: /u/oracle/product/10.2.0/db_1/oui
Log file location : /u/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-06-23_11-34-51AM.log
ApplySession applying interim patch '5868257' to OH '/u/oracle/product/10.2.0/db_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u/oracle/product/10.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5868257' for restore. This might take a while...
Backing up files affected by the patch '5868257' for rollback. This might take a while...
Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/u/oracle/product/10.2.0/db_1/lib/libserver10.a"with "lib/libserver10.a/updexe.o"
Running make for target ioracle
ApplySession adding interim patch '5868257' to inventory
Verifying the update...
Inventory check OK: Patch ID 5868257 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5868257 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@pl-br-d01 5868257]$ opatch lsinventory
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.All rights reserved.
Oracle Home : /u/oracle/product/10.2.0/db_1
Central Inventory : /u/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version: 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location: /u/oracle/product/10.2.0/db_1/oui
Log file location : /u/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-06-23_11-35-16AM.log
Lsinventory Output file location : /u/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-06-23_11-35-16AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3
10.2.0.4.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch5868257: applied on Wed Jun 23 11:35:12 CST 2010
Created on 5 Jun 2008, 23:04:30 hrs PST8PDT
Bugs fixed:
5868257
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@pl-br-d01 5868257]$
补丁更新完成后，启动数据库，问题解决:)
|
