applying database PSU 10.2.0.4.12 on AIX

Maclean Liu(刘相兵

applying  database PSU 10.2.0.4.12 on AIX

1. 在AIX 10.2.0.4 APPLY 应用 10.2.0.4.12 PSU，所 需要下载的补丁包包括：

p6880880_102000_AIX64-5L.zip    ==》AIX上 10gR2最新的OPatch工具
p9352164_10204_AIX5L.zip            ==》10.2.0.4.4 PSU
p12879933_10204_AIX5L.zip         ==》10.2.0.4.12 PSU

unzip p6880880_102000_AIX64-5L.zip
mv /oracle/app/oracle/product/10.2.0/OPatch /oracle/app/oracle/product/10.2.0/OPatch_old
cp -r OPatch /oracle/app/oracle/product/10.2.0

unzip p9352164_10204_AIX5L.zip
unzip p12879933_10204_AIX5L.zip


PSU 10.2.0.4.12 和 PSU 10.2.0.4.4  存在overlay ，需要在10.2.0.4.4的基础上才能安装 10.2.0.4.12 (PSU 10.2.0.4.12 is packaged as an overlay patch which requires that the 10.2.0.4.4 Patch Set Update has been installed. Check that PSU 10.2.0.4.4 is installed by ensuring that the OPatch inventory includes the PSU 10.2.0.4.4 tracking bug (9352164).)


2. 关闭DB HOME $ORACLE_HOME上所有的数据库实例

sqlplus /nolog
conn / as sysdba;
shutdown immediate;

3. 解压相关的补丁包， 替换OPatch为最新版本

unzip p12879933_10204_AIX5L.zip
unzip p6880880_102000_AIX64-5L.zip
unzip p12879933_10204_AIX5L.zip

mv /oracle/app/oracle/product/10.2.0/OPatch /oracle/app/oracle/product/10.2.0/OPatch_old
cp -r OPatch /oracle/app/oracle/product/10.2.0


opatch
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

确认opatch版本为 10.2.0.5.1




4. 安装 10.2.0.4.4 PSU 补丁

opatch apply <UNZIP_LOCATION>/9352164
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/product/10.2.0
Central Inventory : /oracle/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /oracle/app/oracle/product/10.2.0/oui
Log file location : /oracle/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-05-03_22-38-19PM.log

Patch history file: /oracle/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9352164' to OH '/oracle/app/oracle/product/10.2.0'
Execution of 'sh /tmp/9352164/custom/scripts/init -apply 9352164 ':


Running make for target idgmgrl
Running make for target ioracle
Running make for target client_sharedlib
Running make for target itnslsnr
Running make for target iwrap
ApplySession adding interim patch '9352164' to inventory

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

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

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

Execution of 'sh /tmp/9352164/custom/scripts/post -apply 9352164 ':
--------------------------------------------------------------------------------
OPatch Session completed with warnings.

OPatch completed with warnings.





5. 启动数据库实例，并 运行10.2.0.4.4 相关的catbundle.sql 脚本

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> -- Execute the next statement only if this is the first 10.2.0.4 PSU applied in the Oracle home.
SQL> @utlrp.sql
SQL> QUIT


6. apply 10.2.0.4.12 PSU 补丁

opatch apply <UNZIP_LOCATION>/12879933
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/product/10.2.0
Central Inventory : /oracle/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /oracle/app/oracle/product/10.2.0/oui
Log file location : /oracle/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-05-03_22-46-40PM.log

Patch history file: /oracle/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '12879933' to OH '/oracle/app/oracle/product/10.2.0'

Running prerequisite checks...
Patch 12879933: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.4.0 ] , [ oracle.network.cman, 10.2.0.4.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.4.0 ]

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y

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 = '/oracle/app/oracle/product/10.2.0')


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 '12879933' for restore. This might take a while...
Backing up files affected by the patch '12879933' for rollback. This might take a while...
Execution of 'sh /tmp/12879933/custom/scripts/pre -apply 12879933 ':


7.  启动数据库实例，并 运行10.2.0.4.12 相关的catbundle.sql 脚本

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql opsu apply
SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.4 or this is the first PSU applied since 10.2.0.4.8.
SQL> @utlrp.sql
SQL> QUIT


8. 通过 opatch lsinventory 命令和 registry$history 表确认PSU安装正确

9. 重启数据库实例，并启动 应用程序APP