Oracle10.2 补丁安装（转载略有修改）

最新推荐文章于 2024-03-05 14:59:27 发布

李啸林

最新推荐文章于 2024-03-05 14:59:27 发布

阅读量615

点赞数

分类专栏： oracle 文章标签： oracle 10g 补丁

oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1.修改p6880880_102000_Linux-x86-64.zip文件权限，
chown oracle:oinstall p6880880_102000_Linux-x86-64.zip

2.用oracle用户将p6880880_102000_Linux-x86-64.zip解压到$ORACLE_HOME目录下（提示有文件重复的话，选择全覆盖）
unzip -x p6880880_102000_Linux-x86-64.zip
3.opatch lsinventory查看opatch的版本，及安装的补丁
$ORACLE_HOME/OPatch/opatch lsinventory

4.解压p5689937_10201_Linux-x86-64.zip到/tmp目录下
chown -R oracle:dba 5689937
su - oracle
5.oracle用户下cd /tmp/5689937
6.打补丁
关闭监听关闭数据库
chmod u+w /home/oracle/product/10.2.0/db_1/sysman/jlib/*
$ORACLE_HOME/OPatch/opatch apply

Verifying the update...
Inventory check OK: Patch ID 5689937 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5689937 are present in Oracle Home.

--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
**                                ATTENTION                                   **
**                                                                            **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation)         **
** instructions noted in the Readme accompanying this patch, have been        **
** successfully completed.                                                    **
**                                                                            **
********************************************************************************
********************************************************************************

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

Execution of 'sh /tmp/5689937/custom/scripts/post -apply 5689937 ':

Return Code = 0

本地系统已打补丁, 可以重新启动。

OPatch succeeded.

cd $ORACLE_HOME

7.SQL> @?/cpu/CPUJan2007/catcpu.sql
SP2-0310: unable to open file "MODPLSQL/modplsqlcpu.sql"
No. of Invalid Objects is :19
Please refer to README.html to for instructions on validating these objects

PL/SQL procedure successfully completed.

Logfile for the current catcpu.sql session is : APPLY_YKSJ_29Sep2018_10_17_39.log

8.SQL> @?/rdbms/admin/utlrp.sql
9.opatch lsinventory查看是否安装了补丁

已安装的顶级产品 (1):

Oracle Database 10g 10.2.0.1.0
此 Oracle 主目录中已安装 1 个产品。

中间补丁程序 (1) :

Patch 5689937      : applied on Sat Sep 29 10:03:08 CST 2018
   Created on 8 Jan 2007, 13:14:29 hrs US/Eastern
   Bugs fixed:
     4671216, 4925103, 4604970, 4616376, 5689937, 4288876, 5225798, 5694720
     4754888, 4750469, 4369235, 4751931, 4966716, 5049080, 5242648, 4348230
     5490846, 4630549, 5490936, 5049088