下面测试的是gi standalone 11.2.0.3手动升级到11.2.0.3.7
测试环境：os:rhel 5.8 db:11.2.03 sf:5.1
1,数据库软件
2,停数据库HOME
3,Save database home configuration
4,停gi与unlock gi home
5,更新opatch工具
6,grid目录打补丁
7,给rdbms打补丁
8,Restore database home configuration:
9,lock gi home与startup gi
10,Start database home on the node
11,更新数据字典
12,查看升级后的版本
1,安装数据库
本测试采用的一个全新的系统，采用silent的方式来安装的。
1.1 配置主机参数 [root@asm11g ~]# echo "fs.aio-max-nr = 1048576 > fs.file-max = 6815744 > kernel.shmall = 2097152 > kernel.shmmax = 11036870912 > kernel.shmmni = 4096 > kernel.sem = 250 32000 100 128 > net.ipv4.ip_local_port_range = 9000 65500 > net.core.rmem_default = 262144 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048586">>/etc/sysctl.conf 1.2 配置资源限制 [root@asm11g ~]# echo "oracle soft nproc 2047 > oracle hard nproc 16384 > oracle soft nofile 1024 > oracle hard nofile 65536 > grid soft nproc 2047 > grid hard nproc 16384 > grid soft nofile 1024 > grid hard nofile 65536">>/etc/security/limits.conf [root@asm11g ~]# tail -8 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 1.3 创建用户 [root@asm11g ~]# echo "session required pam_limits.so">>/etc/pam.d/login [root@asm11g ~]# tail -1 /etc/pam.d/login session required pam_limits.so [root@asm11g ~]# /usr/sbin/groupadd -g 501 oinstall [root@asm11g ~]# /usr/sbin/groupadd -g 502 dba [root@asm11g ~]# /usr/sbin/groupadd -g 504 asmadmin [root@asm11g ~]# /usr/sbin/groupadd -g 506 asmdba [root@asm11g ~]# /usr/sbin/groupadd -g 507 asmoper [root@asm11g ~]# /usr/sbin/useradd -u 501 -g oinstall -G dba,asmadmin,asmdba,asmoper grid /usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle [root@asm11g ~]# /usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle echo "oracle"|passwd grid --stdin [root@asm11g ~]# echo "oracle"|passwd oracle --stdin Changing password for user oracle. passwd: all authentication tokens updated successfully. [root@asm11g ~]# echo "oracle"|passwd grid --stdin Changing password for user grid. passwd: all authentication tokens updated successfully. [root@asm11g ~]# 1.4 配置yum资源库 [root@asm11g ~]# echo " > [RHEL5.6] > name = Enterprise Linux 5.5 DVD > baseurl=file:///media/Server/ > gpgcheck=0 > enabled=1">/etc/yum.repos.d/public-yum-el5.repo [root@asm11g ~]# tail -5 /etc/yum.repos.d/public-yum-el5.repo [RHEL5.6] name = Enterprise Linux 5.5 DVD baseurl=file:///media/Server/ gpgcheck=0 enabled=1 [root@asm11g ~]# [root@asm11g ~]# /bin/mount /dev/cdrom /media mount: block device /dev/cdrom is write-protected, mounting read-only 1.5 安装软件 [root@asm11g ~]# yum install sysstat unixODBC unixODBC-devel libaio-devel 1.6 创建asm磁盘的lv [root@asm11g ~]# vxprint -u|grep ^v v asmlv1 fsgen ENABLED 2g - ACTIVE - - v asmlv2 fsgen ENABLED 2g - ACTIVE - - v asmlv3 fsgen ENABLED 2g - ACTIVE - - v asmlv4 fsgen ENABLED 2g - ACTIVE - - v asmlv5 fsgen ENABLED 2g - ACTIVE - - [root@asm11g ~]# vxedit -g datadg set user=grid group=asmadmin asmlv{1,2,3,4,5} [root@asm11g ~]# ls -l /dev/vx/rdsk/datadg/* crw------- 1 grid asmadmin 199, 7000 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv1 crw------- 1 grid asmadmin 199, 7001 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv2 crw------- 1 grid asmadmin 199, 7002 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv3 crw------- 1 grid asmadmin 199, 7003 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv4 crw------- 1 grid asmadmin 199, 7004 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv5 1.7 配置.bash_profile [grid@asm11g ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH ORACLE_BASE=/u01/app/grid; export ORACLE_BASE ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_SID=+ASM export DISPLAY=192.168.111.1:0.0 stty erase ^h set -o vi 1.8 安装cvuqdisk软件 [root@asm11g rpm]# rpm -vih cvuqdisk-1.0.9-1.rpm Preparing... ########################################### [100%] Using default group oinstall to install package 1:cvuqdisk ########################################### [100%] 1.9 安装grid [grid@asm11g grid]$ ./runInstaller -silent -responseFile /home/grid/grid.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 23231 MB Passed Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-18_05-53-03PM. Please wait ...[grid@asm11g grid]$ [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-32018] The selected Oracle home is outside of Oracle base. CAUSE: The Oracle home selected was outside of Oracle base. ACTION: Oracle recommends installing Oracle software within the Oracle base directory. Adjust the Oracle home or Oracle base accordingly. You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2013-09-18_05-53-03PM.log The installation of Oracle Grid Infrastructure was successful. Please check '/u01/app/oraInventory/logs/silentInstall2013-09-18_05-53-03PM.log' for more details. As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/11.2.0/grid/root.sh As install user, execute the following script to complete the configuration. 1. /u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands Note: 1. This script must be run on the same system from where installer was run. 2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation). Successfully Setup Software. [root@asm11g ~]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. [root@asm11g ~]# /u01/app/11.2.0/grid/root.sh Check /u01/app/11.2.0/grid/install/root_asm11g_2013-09-18_17-56-14.log for the output of root script [root@asm11g ~]# /u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands Setting the invPtrLoc to /u01/app/11.2.0/grid/oraInst.loc perform - mode is starting for action: configure perform - mode finished for action: configure You can see the log file: /u01/app/11.2.0/grid/cfgtoollogs/oui/configActions2013-09-18_05-56-43-PM.log 1.10 配置asm [grid@asm11g ~]$ asmca -silent -configureASM -sysAsmPassword oracle -asmsnmpPassword oracle -diskString '/dev/vx/rdsk/datadg/*' -diskGroupName DATA -disk '/dev/vx/rdsk/datadg/asmlv1' -redundancy EXTERNAL -au_size 1 -compatible.asm 11.2 -compatible.rdbms 11.2 -compatible.advm 11.2 ASM created and started successfully. Disk Group DATA created successfully. [grid@asm11g ~]$ crsctl stat resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE asm11g ora.asm ONLINE ONLINE asm11g Started ora.ons OFFLINE OFFLINE asm11g -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE asm11g ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE asm11g 1.11 安装db [oracle@asm11g database]$ ./runInstaller -silent -responseFile /home/oracle/db.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 20213 MB Passed Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-18_06-43-20PM. Please wait ...[oracle@asm11g database]$ You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2013-09-18_06-43-20PM.log The installation of Oracle Database 11g was successful. Please check '/u01/app/oraInventory/logs/silentInstall2013-09-18_06-43-20PM.log' for more details. As a root user, execute the following script(s): 1. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh [root@asm11g OraInstall2013-09-18_05-42-30PM]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Check /u01/app/oracle/product/11.2.0/dbhome_1/install/root_asm11g_2013-09-18_18-46-16.log for the output of root script [root@asm11g OraInstall2013-09-18_05-42-30PM]# 1.12 配置监听 [grid@asm11g ~]$ srvctl add listener -l listener -o $ORACLE_HOME -p 1521 [grid@asm11g ~]$ crsctl status resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE asm11g ora.LISTENER.lsnr OFFLINE OFFLINE asm11g ora.asm ONLINE ONLINE asm11g Started ora.ons OFFLINE OFFLINE asm11g -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE asm11g ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE asm11g [grid@asm11g ~]$ crsctl start resource ora.LISTENER.lsnr CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'asm11g' CRS-2676: Start of 'ora.LISTENER.lsnr' on 'asm11g' succeeded 1.13 创建数据库 略
整个数据库安装已经完成，下面开始升级
2.停数据库HOME
[oracle@asm11g ~]$ srvctl stop home -o $ORACLE_HOME -s /tmp/oracle_home_stop.out [oracle@asm11g ~]$ cat /tmp/oracle_home_stop.out db-asm11g
如果有多个ORACLE_HOME需要在每一个目录中运行，这里注意-s后面给的文件名，我们在升级完成后需要用到，不过建议停数据库前，先手动停监听，再切日志，再kill掉用户进程，再切日志后，再停数据库。
srvctl stop listener -l listener sqlplus / as sysdba alter system switch logfile; alter system switch logfile; alter system switch logfile; alter system switch logfile; !ps -ef|grep LOCAL=NO|grep $ORACLE_SID|grep -v grep|awk '{print $2}'|xargs kill -9 alter system switch logfile; alter system switch logfile; alter system switch logfile; alter system switch logfile;
3,Save database home configuration
此步骤只有需要应用gi patch到rdbms的时候才需要
[oracle@asm11g ~]$ /tmp/16742216/16619898/custom/server/16619898/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME /tmp/16742216/16619898/custom/server/16619898/custom/scripts/prepatch.sh completed successfully.
如果有多个ORACLE_HOME目录的时候，需要在每一个ORACLE_HOME执行些操作。
4，停gi与unlock gi home
[root@asm11g 16619898]# $GRID_HOME/crs/install/roothas.pl -unlock Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Successfully unlock /u01/app/11.2.0/grid
5，更新opatch工具
[grid@asm11g ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/opatch [grid@asm11g ~]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME [grid@asm11g ~]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 11.2.0.3.4 OPatch succeeded.
6，grid目录打补丁
[grid@asm11g tmp]$ $ORACLE_HOME/OPatch/opatch napply /tmp/16742216/ -oh $ORACLE_HOME Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.3.0 Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-18_22-11-08PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16619898 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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: 7343696@qq.com Provide your My Oracle Support password to receive security updates via your My Oracle Support account. Password (optional): Unable to establish connection to Oracle Configuration Manager server. Hostname (https://ccr.oracle.com) is unknown. Unable to establish a network connection to Oracle. Specify the URL for an Oracle Support Hub in this format: http[s]://<OracleSupportHubHost>:<OracleSupportHubPort> If you do not wish to configure OCM through an Oracle Support Hub, enter NONE Oracle Support Hub URL: NONE Unable to establish a network connection to Oracle. If your systems require a proxy server for outbound Internet connections, enter the proxy server details in this format: [<proxy-user>@]<proxy-host>[:<proxy-port>] If you want to remain uninformed of critical security issues in your configuration, enter NONE Proxy specification: NONE Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/11.2.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '13343438' to OH '/u01/app/11.2.0/grid' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Verifying the update... Applying sub-patch '13696216' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Verifying the update... Applying sub-patch '13923374' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.network.listener, 11.2.0.3.0... Verifying the update... Applying sub-patch '14275605' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.client, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms.util, 11.2.0.3.0... Verifying the update... Applying sub-patch '14727310' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Verifying the update... Applying sub-patch '16056266' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.listener, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.rdbms.deconfig, 11.2.0.3.0... Verifying the update... Applying sub-patch '16619892' to OH '/u01/app/11.2.0/grid' ApplySession: Optional component(s) [ oracle.marvel, 11.2.0.3.0 ] , [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.xdk, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.xdk.parser.java, 11.2.0.3.0... Patching component oracle.xdk.rsf, 11.2.0.3.0... Verifying the update... Applying interim patch '16619898' to OH '/u01/app/11.2.0/grid' Patching component oracle.crs, 11.2.0.3.0... Patching component oracle.usm, 11.2.0.3.0... Verifying the update... Composite patch 16619892 successfully applied. Patch 16619898 successfully applied. Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-18_22-11-08PM_1.log OPatch succeeded.
7，给rdbms打补丁
如果有多个ORACLE_HOME，需要在每个ORACLE_HOME下面执行命令
[oracle@asm11g ~]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME [oracle@asm11g ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /tmp/16742216/16619898/custom/server/ -oh $ORACLE_HOME -id 16619898 Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-18-58PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 16619898 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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: 7343696@qq.com Provide your My Oracle Support password to receive security updates via your My Oracle Support account. Password (optional): Unable to establish connection to Oracle Configuration Manager server. Hostname (https://ccr.oracle.com) is unknown. Unable to establish a network connection to Oracle. Specify the URL for an Oracle Support Hub in this format: http[s]://<OracleSupportHubHost>:<OracleSupportHubPort> If you do not wish to configure OCM through an Oracle Support Hub, enter NONE Oracle Support Hub URL: NONE Unable to establish a network connection to Oracle. If your systems require a proxy server for outbound Internet connections, enter the proxy server details in this format: [<proxy-user>@]<proxy-host>[:<proxy-port>] If you want to remain uninformed of critical security issues in your configuration, enter NONE Proxy specification: NONE Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '16619898' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.3.0... Verifying the update... Patch 16619898 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-18-58PM_1.log OPatch succeeded. [oracle@asm11g ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /tmp/16742216/16619892 -oh $ORACLE_HOME Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-26-30PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Verifying the update... Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.oms.core, 10.2.0.4.4... Verifying the update... Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.network.listener, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Verifying the update... Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.client, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.precomp.common, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.rdbms.util, 11.2.0.3.0... Verifying the update... Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.oms.core, 10.2.0.4.4... Verifying the update... Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.network.listener, 11.2.0.3.0... Patching component oracle.network.rsf, 11.2.0.3.0... Patching component oracle.ovm, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sdo.locator, 11.2.0.3.0... Patching component oracle.rdbms.deconfig, 11.2.0.3.0... Verifying the update... Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.marvel, 11.2.0.3.0... Patching component oracle.precomp.common, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sysman.agent, 10.2.0.4.3... Patching component oracle.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.repository.core, 10.2.0.4.4... Patching component oracle.xdk, 11.2.0.3.0... Patching component oracle.xdk.parser.java, 11.2.0.3.0... Patching component oracle.xdk.rsf, 11.2.0.3.0... Verifying the update... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' Composite patch 16619892 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-26-30PM_1.log OPatch completed with warnings.
8 Restore database home configuration:
[oracle@asm11g ~]$ /tmp/16742216/16619898/custom/server/16619898/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora.. Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora.. Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/diskmon.bin Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnodes Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/osdbagrp Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/rawutl Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/ractrans Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/getcrshome Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/gnsd Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/crsdiag.pl Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libhasgen11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclsra11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libdbcfg11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocr11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocrb11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocrutl11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libuini11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/librdjni11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libgns11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libgnsjni11.so Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libagfw11.so
如果有多个ORACLE_HOME的时候，更新每一个ORACLE_HOME
9，lock gi home与startup gi
[root@asm11g ~]# $GRID_HOME/rdbms/install/rootadd_rdbms.sh [root@asm11g ~]# $GRID_HOME/crs/install/roothas.pl -patch Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params CRS-4123: Oracle High Availability Services has been started.
10，Start database home on the node
[oracle@asm11g ~]$ srvctl start home -o $ORACLE_HOME -s /tmp/oracle_home_stop.out
这里需要注意的是-s后面接的文件名，是第2步生成的文件名，如果有多个ORACLE_HOME的时候，需要启动每一个ORACLE_HOME
11 更新数据字典
[oracle@asm11g ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 18 22:36:26 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @?/rdbms/admin/catbundle.sql psu apply PL/SQL procedure successfully completed. SQL> PROMPT Updating registry... Updating registry... SQL> INSERT INTO registry$history 2 (action_time, action, 3 namespace, version, id, 4 bundle_series, comments) 5 VALUES 6 (SYSTIMESTAMP, 'APPLY', 7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'), 8 '11.2.0.3', 9 7, 10 'PSU', 11 'PSU 11.2.0.3.7'); 1 row created. SQL> COMMIT; Commit complete. SQL> SPOOL off SQL> SET echo off Check the following log file for errors: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ASM11G_APPLY_2013Sep18_22_36_45.log
12，查看升级后的版本
SQL> set lines 200
SQL> col comments for a40
SQL> select action,comments from dba_registry_history;
ACTION COMMENTS
------------------------------ ----------------------------------------
APPLY Patchset 11.2.0.2.0
APPLY Patchset 11.2.0.2.0
APPLY PSU 11.2.0.3.7
[oracle@asm11g ~]$ $ORACLE_HOME/OPatch/opatch lspatches
16619892;Database Patch Set Update : 11.2.0.3.7 (16619892)
16619898;Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)
(Gi Standalone) 11.2.0.3升级到11.2.0.3.7：等您坐沙发呢！