Upgrading Oracle database from 11.1.0.6 to 11.1.0.7 on AIX 6.1

# 摘要 这是一个  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 # 补丁描述 | 安装包 | 描述 | | --- | --- | | linux.x64_11gR1_clusterware.zip | 11.1.0.6 ClusterWare | | linux.x64_11gR1_database_1013.zip | 11.1.0.6 Database | | p6890831_111070_Linux-x86-64.zip | 11.1.0.7.0补丁包 | | 安装包 | 描述 | | --- | --- | | aix.ppc64_11gR1_clusterware.zip | 集群软件安装包 | | aix.ppc64_11gR1_database_1013_1of2.zip | 数据库软件安装包 | | aix.ppc64_11gR1_database_1013_2of2.zip | 数据库软件安装包 | | p6890831_111070_AIX5L_1of2.zip | 11.1.0.7.0补丁包 | | p6890831_111070_AIX5L_2of2.zip | 11.1.0.7.0补丁包 | | p9216848_111070_AIX5L.zip |  IBM已经报告：当OUI在基于硬件的新POWER7 上运行时，它会和AIX上的 IBM JDK/JRE 1.5 SR4 发生冲突 <br> 这会影响oracle数据库11gR1 版本11.1.0.6 和11.1.0.7 在POWER7 系统上的安装 | | p6880880_111000_AIX64-5L.zip | OPatch 11.1.0.12.9 | | p18522513_111070_AIX5L.zip | DATABASE PATCH SET UPDATE 11.1.0.7.20 (INCLUDES CPUJUL2014) (Patch) <br>p18522513_111070_AIX5L.zip  34.3 MB (35914542 bytes) <br>SHA-1   812F74834B11832D7C0184FA12D480ADF4AD2380 <br>SHA-256 221B69E8F63861DD7E3FE3ED45B5946F7097E82DD53DEA00C0063E91B5D85783 | # 安装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 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; ```