oracle 10 补丁安装步骤,oracle 10g rac 10.2.0.3补丁安装

[@more@]

rac环境:基于文档进行的环境配置.

注：升级参照补丁的README进行的

一、Download and Extract the Installation SoftwareDownload the p5337014_10203_LINUX.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

Enter the following command to unzip and extract the installation files:$ unzip p5337014_10203_LINUX.zip

二、Set the ORACLE_HOME and ORACLE_SID Environment Variables

Enter the following commands to set the ORACLE_HOME and ORACLE_SID environment variables: (已经配置，可略)

In these examples, Oracle_home is the Oracle home directory where the Oracle Database 10g installation that you want to upgrade is installed, and sid is the system identifier of the database that you want to upgrade. For Oracle RAC installations, sid is generally the sid prefix and the instance number. For example, devdb1.

三、Stopping All Processes for an Oracle RAC Installation

1、Shut down the following Oracle Database 10g processes before installing the patch set:

A、Shut down all processes in the Oracle home on each node that might be accessing a database, for example Oracle Enterprise Manager Database Control or iSQL*Plus:

$ emctl stop dbconsole

$ isqlplusctl stop

B、Shut down all services in the Oracle home on each node that might be accessing a database:

$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]C、Shut down all Oracle RAC instances on the nodes, which run from the Oracle home on which you are going to apply the patch set. To shut down all Oracle RAC instances for a database, enter the following command where db_name is the name of the database:$ srvctl stop database -d db_nameD、If Automatic Storage Management instance is present, then shut down all Automatic Storage Management instances on all nodes. To shut down an Automatic Storage Management instance, enter the following command where node is the name of the node where the Automatic Storage Management instance is running: $ srvctl stop asm -n nodeE、Stop any listeners that are running from the Oracle home that you are patching on all nodes. To stop the listener running on a node, enter the following command, where node is the name of the node where the listener is running: $ srvctl stop listener -n node [-l listenername]四、Back Up the SystemOracle recommends that you create a backup of the Oracle Database 10g installation before you install the patch set.五、Installing the Oracle Database 10g Patch Set InteractivelyLog in as the oracle user.运行补丁安装程序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 start

Run 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的升级脚本错误，不知道为何。其他等运行正常，且两个节点均能够启动。