摘要

这是一个 Oracle database from 11.1.0.6 to 11.1.0.7 on AIX 6.1 在 power6 上的数据库。

安装Oracle 11.1.0.7.0补丁

Oracle 11.1.0.7.0 主要解决Oracle 11.1.0.6.0 的Bug。

11.1.0.X.0
11.1.0.X.0 TO 11.1.0.6.0
The BASE release of Oracle 11g Release 1 is 11.1.0.6.

11.1.0.X.0 TO 11.1.0.7.0

1. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOMEPatchset number is : Patch 6890831
2. Finish the post installation steps as per the patchset README (patch_note.htm).REFERENCE:Availability and Known issues for 11.1.0.7 Note 738538.1

11.1.0.X.0 TO 11.2.0.1.0

1. Install 11.2.0.1.0 softwareThe software can be downloaded from the following link :http://www.oracle.com/technology/software/products/database/index.htmlNote 169706.1: Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Upgrade the database to 11.2.0.1.0Note 419550.1: Different Upgrade Methods For Upgrading Your Database
   Note 837570.1: Complete Checklist for Manual Upgrades to 11gR2
   Note 870814.1: Complete checklist to upgrade the database to 11g R2 using DBUAREFERENCE:Availability and Known issues for 11.2.0.1

补丁描述

安装VNC Server

rpm -ivh tightvnc-server-1.3.10-2.aix6.1.ppc.rpm
rpm -ivh zlib-1.2.12-1.aix6.1.ppc.rpm
rpm -ivh libgcc-8.3.0-2.aix6.1.ppc.rpm
rpm -ivh libjpeg-9d-1.aix6.1.ppc.rpm

升级 opatch

step 1.获取opatch工具包：p6880880_111000_Linux-x86-64.zip
step 2.以root用户将补丁包上传到服务器上，然后赋权限，解压：

# chown oracle:dba p6880880_111000_Linux-x86-64.zip
# su - oracle

$ cd $ORACLE_HOME
$ mkdir -p OPatch_11.1.0.8.1
$ mv p6880880_111000_Linux-x86-64.zip ./OPatch_11.1.0.8.1
$ cd ./OPatch_11.1.0.8.1
$ chmod 755 -R OPatch

step 3.将新版本的opatch工具加入到oracle用户的环境变量PATH

export PATH=$ORACLE_HOME/OPatch_11.1.0.8.1/OPatch:$PATH
export LANG=C
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

step 4.检查当前opatch版本

opatch version

step 5.检查当前已经安装的补丁包：

opatch lsinventory -all

查询结果中如果包含如下关键字” Patch 9352179”，则表明数据库已经升级到11.1.0.7.3，不需要进行数据库升级，如果不包含如下信息，则表明数据库需要升级到11.1.0.7.3。

升级数据库

step 1.解压安装文件

unzip p6890831_111070_AIX5L_1of2.zip 
unzip p6890831_111070_AIX5L_2of2.zip 

step 2.关闭数据库和监听,如果还有asm,dbconsole都要关闭
step 3.运行清理内存,释放相关进程命令

/usr/sbin/slibclean

step 4.命令行安装

xhost +

su - oracle

export Display=127.0.0.1:0.0

cd /soft/11gpatch/Disk1

静默安装

./runInstaller -silent -responseFile /u01/oinsdir/Disk1/patchdbs.rsp

安装补丁，发现如下错误：

SEVERE: OUI-10091:There are no patches that need to be applied from the patchset Oracle
Database 11g Patch Set 1 11.1.0.7.0 

在安装过程中总是遇到如下提示：

Coping libocr10.so to /u01/app/oracle/product/10.2.0/libocr10.so(Cannotopen or remove a file containing a running program.)

使用ps命令却没有看到任何oracle用户进程在运行，并且使用lsof命令也没有查看到那个进程在打开这个文件。那说明是系统引用了这些动态链接库，于是用"slibclean”命令清一下系统的动态库，再Retry一次。

java.io.FileNotFoundException: /oracle/db/lib/libons.so (Cannot open or remove a file containing a running program.)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:205)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:128)
        at copyActionHelper.copyFile(copyActionHelper.java:1703)
        at copyActionHelper.copyFileFromStream(copyActionHelper.java:732)
        at copyActionHelper.copyFileFromJar(copyActionHelper.java:642)
        at copyActionHelper.copyGroupFromJar(copyActionHelper.java:365)
        at copyActionHelperux.installCopyGroupAction(copyActionHelperux.java:159)
        at sscopyGroupFromJarux.installAction(sscopyGroupFromJarux.java:89)
        at oracle.sysman.oii.oiis.OiisCompActions.doActionWithException(OiisCompActions.java:2107)
        at oracle.sysman.oii.oiis.OiisCompActions.doActionImpl(OiisCompActions.java:1764)
        at oracle.sysman.oii.oiis.OiisCompActions.copyGroupActionInner(OiisCompActions.java:1407)
        at oracle.sysman.oii.oiis.OiisCompActions.copyGroupAction(OiisCompActions.java:1248)
        at oracle.sysman.oii.oiis.OiisCompActions.doAction(OiisCompActions.java:870)
        at Patches.oracle.ons.v11_1_0_7_0.CompActions.doAction(Unknown Source)
        at Patches.oracle.ons.v11_1_0_7_0.CompInstallPhase1.doActionP1copyGroup0(Unknown Source)
        at Patches.oracle.ons.v11_1_0_7_0.CompInstallPhase1.stateChangeActions(Unknown Source)
        at Patches.oracle.ons.v11_1_0_7_0.CompActions.stateChangeActions(Unknown Source)
        at oracle.sysman.oii.oiif.oiifw.OiifwInstallPhaseWCCE$OiifwComponentIP1WCCE.performStateChangeActions(OiifwInstallPhaseWCCE.java:2186)
        at oracle.sysman.oii.oiif.oiifw.OiifwInstallPhaseWCCE$OiifwComponentInstallPhaseWCCE.doOperation(OiifwInstallPhaseWCCE.java:1352)
        at oracle.sysman.oii.oiif.oiifw.OiifwInstallPhaseWCCE$OiifwComponentIP1WCCE.doOperation(OiifwInstallPhaseWCCE.java:1926)
        at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
        at oracle.sysman.oii.oiif.oiifw.OiifwInstallPhaseWCCE.doOperation(OiifwInstallPhaseWCCE.java:851)
        at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
        at oracle.sysman.oii.oiif.oiifw.OiifwActionsPhaseWCDE.doOperation(OiifwActionsPhaseWCDE.java:619)
        at oracle.sysman.oii.oiif.oiifb.OiifbLinearIterator.iterate(OiifbLinearIterator.java:147)
        at oracle.sysman.oii.oiic.OiicInstallSession$OiicSelCompsInstall.doOperation(OiicInstallSession.java:4224)
        at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
        at oracle.sysman.oii.oiic.OiicPullSession.doOperation(OiicPullSession.java:1327)
        at oracle.sysman.oii.oiic.OiicSessionWrapper.doOperation(OiicSessionWrapper.java:291)
        at oracle.sysman.oii.oiic.OiicInstaller.run(OiicInstaller.java:578)
        at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:968)
        at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:905)

step 5.使用 oui 升级

./runInstaller

使用root用户执行脚本：

$ su – root
# /u01/app/oracle/product/11g/db/root.sh

该脚本执行过程中需要回答一些问题，在不同的平台上具体问的内容会有所不同，但只要在出现’……[yes]?’时输入’no’，出现’[y，n]’时输入y，出现其他问题时直接按回车即可。
出现类似如下信息，表示脚本执行成功。

Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/product/11g/db

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

step 6.升级数据库

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

step 7.编译失效对象

SQL> @?/rdbms/admin/utlrp.sql

step 8.检查是否升级成功用以下脚本

SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;