一、下载1204补丁，p6810189_10204_Linux-x86.zip，解压。
二、配置ORACLE_HOME 、ORACLE_SID 环境变量，如 devdb1
三、Stopping All Processes for an Oracle RAC Installation
3.1 停止数据库相关进程。
$ emctl stop dbconsole
$ isqlplusctl stop
3.2 停止所有节点的rac服务
$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]
$ srvctl stop database -d db_name
$ srvctl stop asm -n node
$ srvctl stop listener -n node [-l listenername]
四、备份ORACLE_HOME目录、RAC_HOME目录、备份数据。
五、以Oracle用户运行补丁安装程序./runInstaller
根据提示进行安装：
On the Welcome screen, click Next.
In the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next. If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears. On the Summary screen, click Install. This screen lists all of the patches available for installation.
Note: If you are applying this patch set to an Oracle Clusterware installation, then complete all of the steps displayed on the Oracle Universal Installer screen. The Oracle Clusterware installation instructions displayed on the Oracle Universal Installer screen are also available in the CRS_home/install/readme.txt file.
When applying this patch set on an Oracle Clusterware home, Oracle Universal Installer prompts you to run the root102.sh script from $ORACLE_HOME/install. You must run this script as the root user on all nodes.
注：首先在2中先升级crs目录下的程序，并在每个节点上进行如下操作：
1）. Log in as the root user.
2）. As the root user, perform the following tasks:
a. Shutdown the CRS daemons by issuing the following command:# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
b. Run the shell script located at:# /u01/app/oracle/product/10.2.0/crs_1/install/root102.sh
This script will automatically start the CRS daemons on the patched node upon completion.
3). After completing this procedure, proceed to the next node and repeat.
其次，重新运行补丁程序，在2中升级db目录下的程序。
When prompted, run the $ORACLE_HOME/root.sh script as the root user.
If you are applying the patch set to an Oracle RAC installation, then run the root.sh script on each node of the cluster. 注：执行配置脚本：以 root 用户身份执行下面的脚本。
在rac1 上执行 /u01/app/oracle/product/10.2.0/db_1/root.sh
在rac2 上执行 /u01/app/oracle/product/10.2.0/db_1/root.sh
六、Postinstallation Tasks
Upgrading Oracle Database 10g Release 10.2.0.x to Oracle Database 10g Release 10.2.0.3
Upgrading a Release 10.2 Database using Oracle Database Upgrade Assistant
After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:
Log in as the Oracle software owner user.
Set the values for the environment variables $ORACLE_HOME, $ORACLE_SID and $PATH.
For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.
For Oracle single-instance installations, start the listener as follows:
$ lsnrctl startRun Oracle Database Upgrade Assistant either in the interactive mode:
Enter the following command from the command prompt:
$ dbua
Complete the following steps displayed in the Oracle Database Upgrade Assistant screen:
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle database that you want to update, then click Next.
Note:For Oracle RAC, enter the SYS password to do the upgrade
On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.
On the Summary screen, check the summary, then click Finish.
On the End of upgradation screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.
安装过程中有一个组件出现升级错误，查看为执行emca的升级脚本错误，不知道为何。其他等运行正常，且两个节点均能够启动。
评论