由于数据库经常报ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapp
ed object] [0x2A978D8000] [] [],上metalink查询得知是bug 5868257,于是上metalink下载补丁包,具体操作步骤根据README.txt文件为准

OS version:red hat 4   database version:10204

操作如下

1.首先关闭和数据库有关的所有进程(数据库,监听器)

2.解压p5868257_10204_Linux-x86-64.zip,注意权限不要搞错了.

3.export OBJECT_MODE=32_64,这步干什么没搞清楚.

4.cd $ORACLE_HOME/OPatch

5../opatch apply 打补丁

6查看补丁包是否打上./opatch lsinventory

如果需要回滚补丁,可./opatch rollback -id 5868257(补丁号)

[oracle@hq-crm-test01 OPatch]$ ./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       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-27_18-51-30PM.log

ApplySession applying interim patch '5868257' to OH '/opt/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 = '/opt/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 "/opt/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@hq-crm-test01 OPatch]$ ./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       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-27_18-52-10PM.log

Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-04-27_18-52-10PM.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) :

Patch  5868257      : applied on Tue Apr 27 18:51:56 CST 2010
   Created on 5 Jun 2008, 23:04:30 hrs PST8PDT
   Bugs fixed:
     5868257

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@hq-crm-test01 OPatch]$ ./opatch rollback -id 5868257
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       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-27_18-52-52PM.log

RollbackSession rolling back interim patch '5868257' from OH '/opt/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 = '/opt/oracle/product/10.2.0/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch '5868257' for restore. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/opt/oracle/product/10.2.0/db_1/lib/libserver10.a"  with "lib/libserver10.a/updexe.o"
Running make for target ioracle
RollbackSession removing interim patch '5868257' from inventory

The local system has been patched and can be restarted.

OPatch succeeded.
[oracle@hq-crm-test01 OPatch]$ ./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       : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-04-27_18-53-11PM.log

Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-04-27_18-53-11PM.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.