11.2.0.4 rac数据库打补丁:
环境说明:
[oracle@dbrac1 ~]$ cat /etc/issue
Red Hat Enterprise Linux Server release 6.7 (Santiago)
Kernel \r on an \m
[oracle@dbrac1 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.2 dbrac1
192.168.56.3 dbrac1-vip
10.10.10.10 dbrac1-priv
192.168.56.4 dbrac2
192.168.56.5 dbrac2-vip
10.10.10.11 dbrac2-priv
192.168.56.8 rac-scan
[oracle@dbrac1 ~]$
要打的补丁为:p27107360_112040_Linux-x86-64.zip,opatch工具包:p6880880_112000_Linux-x86-64.zip
节点一二都把上述两包放在/tmp下,且赋权限为chmod 777 *.zip
[root@dbrac1 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip
[root@dbrac1 tmp]#
一:升级OPatch
下载最新的opatch程序并替换GI_HOME和ORACLE_HOME下的OPatch目录
注意:rac1和rac2两个节点的grid和oracle都要升级OPatch版本
[grid@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[grid@dbrac1 ~]$
[oracle@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@dbrac1 ~]$
oracle用户替换,备份之前的OPatch目录:
[oracle@dbrac1 ~]$ cd $ORACLE_HOME
[oracle@dbrac1 dbhome_1]$
[oracle@dbrac1 dbhome_1]$ mv OPatch/ OPatch.bak
--解压:
[oracle@dbrac1 tmp]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
Archive: p6880880_112000_Linux-x86-64.zip
creating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/
inflating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchdiag
inflating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.pl
creating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/
忽略..............................................................................
[oracle@dbrac1 dbhome_1]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[oracle@dbrac1 dbhome_1]$
grid用户替换,备份之前的OPatch目录:
[grid@dbrac1 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/11.2.0/grid
[grid@dbrac1 ~]$ exit
logout
[root@dbrac1 tmp]#
[root@dbrac1 tmp]# cd /oracle/app/11.2.0/grid
[root@dbrac1 grid]#
[root@dbrac1 grid]# mv OPatch/ OPatch.bak
[root@dbrac1 grid]#
[root@dbrac1 tmp]# cd /tmp
[root@dbrac1 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip
[root@dbrac1 tmp]# unzip p6880880_112000_Linux-x86-64.zip -d /oracle/app/11.2.0/grid
Archive: p6880880_112000_Linux-x86-64.zip
creating: /oracle/app/11.2.0/grid/OPatch/
inflating: /oracle/app/11.2.0/grid/OPatch/opatchdiag
inflating: /oracle/app/11.2.0/grid/OPatch/opatch.pl
creating: /oracle/app/11.2.0/grid/OPatch/jlib/
省略............................................................
[root@dbrac1 grid]#
[root@dbrac1 grid]# chown -R grid:oinstall OPatch/
[root@dbrac1 grid]#
[root@dbrac1 grid]# su - grid
[grid@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[grid@dbrac1 ~]$
--节点2相同操作:
[root@dbrac2 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 May 15 09:45 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 May 15 09:45 p6880880_112000_Linux-x86-64.zip
[root@dbrac2 tmp]# su - oracle
[oracle@dbrac2 ~]$
[oracle@dbrac2 ~]$ cd $ORACLE_HOME
[oracle@dbrac2 dbhome_1]$ mv OPatch/ OPatch.bak
[oracle@dbrac2 dbhome_1]$
[oracle@dbrac2 dbhome_1]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip
省略..........................................
[oracle@dbrac2 dbhome_1]$
[oracle@dbrac2 dbhome_1]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[oracle@dbrac2 dbhome_1]$
[root@dbrac2 ~]# su - grid
[grid@dbrac2 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/11.2.0/grid
[grid@dbrac2 ~]$
[grid@dbrac2 ~]$ exit
logout
[root@dbrac2 ~]# cd /tmp
[root@dbrac2 tmp]# cd /oracle/app/11.2.0/grid
[root@dbrac2 grid]# mv OPatch/ OPatch.bak
[root@dbrac2 grid]#
[root@dbrac2 grid]# unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /oracle/app/11.2.0/grid
省略.................................
[root@dbrac2 grid]#
[root@dbrac2 grid]# chown grid:oinstall -R OPatch/
[root@dbrac2 grid]# su - grid
[grid@dbrac2 ~]$
[grid@dbrac2 ~]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[grid@dbrac2 ~]$
二:生成ocm文件
在rac1和rac2分别生成ocm.rsp文件。
su - oracle
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/oracle/ocm.rsp
[oracle@dbrac1 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1
[oracle@dbrac1 ~]$
[oracle@dbrac1 ~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/oracle/ocm.rsp
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:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
环境说明:
[oracle@dbrac1 ~]$ cat /etc/issue
Red Hat Enterprise Linux Server release 6.7 (Santiago)
Kernel \r on an \m
[oracle@dbrac1 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.2 dbrac1
192.168.56.3 dbrac1-vip
10.10.10.10 dbrac1-priv
192.168.56.4 dbrac2
192.168.56.5 dbrac2-vip
10.10.10.11 dbrac2-priv
192.168.56.8 rac-scan
[oracle@dbrac1 ~]$
要打的补丁为:p27107360_112040_Linux-x86-64.zip,opatch工具包:p6880880_112000_Linux-x86-64.zip
节点一二都把上述两包放在/tmp下,且赋权限为chmod 777 *.zip
[root@dbrac1 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip
[root@dbrac1 tmp]#
一:升级OPatch
下载最新的opatch程序并替换GI_HOME和ORACLE_HOME下的OPatch目录
注意:rac1和rac2两个节点的grid和oracle都要升级OPatch版本
[grid@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[grid@dbrac1 ~]$
[oracle@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@dbrac1 ~]$
oracle用户替换,备份之前的OPatch目录:
[oracle@dbrac1 ~]$ cd $ORACLE_HOME
[oracle@dbrac1 dbhome_1]$
[oracle@dbrac1 dbhome_1]$ mv OPatch/ OPatch.bak
--解压:
[oracle@dbrac1 tmp]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
Archive: p6880880_112000_Linux-x86-64.zip
creating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/
inflating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchdiag
inflating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.pl
creating: /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/
忽略..............................................................................
[oracle@dbrac1 dbhome_1]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[oracle@dbrac1 dbhome_1]$
grid用户替换,备份之前的OPatch目录:
[grid@dbrac1 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/11.2.0/grid
[grid@dbrac1 ~]$ exit
logout
[root@dbrac1 tmp]#
[root@dbrac1 tmp]# cd /oracle/app/11.2.0/grid
[root@dbrac1 grid]#
[root@dbrac1 grid]# mv OPatch/ OPatch.bak
[root@dbrac1 grid]#
[root@dbrac1 tmp]# cd /tmp
[root@dbrac1 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip
[root@dbrac1 tmp]# unzip p6880880_112000_Linux-x86-64.zip -d /oracle/app/11.2.0/grid
Archive: p6880880_112000_Linux-x86-64.zip
creating: /oracle/app/11.2.0/grid/OPatch/
inflating: /oracle/app/11.2.0/grid/OPatch/opatchdiag
inflating: /oracle/app/11.2.0/grid/OPatch/opatch.pl
creating: /oracle/app/11.2.0/grid/OPatch/jlib/
省略............................................................
[root@dbrac1 grid]#
[root@dbrac1 grid]# chown -R grid:oinstall OPatch/
[root@dbrac1 grid]#
[root@dbrac1 grid]# su - grid
[grid@dbrac1 ~]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[grid@dbrac1 ~]$
--节点2相同操作:
[root@dbrac2 tmp]# ll *.zip
-rwxrwxrwx 1 root root 779304336 May 15 09:45 p27107360_112040_Linux-x86-64.zip
-rwxrwxrwx 1 root root 52733900 May 15 09:45 p6880880_112000_Linux-x86-64.zip
[root@dbrac2 tmp]# su - oracle
[oracle@dbrac2 ~]$
[oracle@dbrac2 ~]$ cd $ORACLE_HOME
[oracle@dbrac2 dbhome_1]$ mv OPatch/ OPatch.bak
[oracle@dbrac2 dbhome_1]$
[oracle@dbrac2 dbhome_1]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip
省略..........................................
[oracle@dbrac2 dbhome_1]$
[oracle@dbrac2 dbhome_1]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[oracle@dbrac2 dbhome_1]$
[root@dbrac2 ~]# su - grid
[grid@dbrac2 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/11.2.0/grid
[grid@dbrac2 ~]$
[grid@dbrac2 ~]$ exit
logout
[root@dbrac2 ~]# cd /tmp
[root@dbrac2 tmp]# cd /oracle/app/11.2.0/grid
[root@dbrac2 grid]# mv OPatch/ OPatch.bak
[root@dbrac2 grid]#
[root@dbrac2 grid]# unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /oracle/app/11.2.0/grid
省略.................................
[root@dbrac2 grid]#
[root@dbrac2 grid]# chown grid:oinstall -R OPatch/
[root@dbrac2 grid]# su - grid
[grid@dbrac2 ~]$
[grid@dbrac2 ~]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
[grid@dbrac2 ~]$
二:生成ocm文件
在rac1和rac2分别生成ocm.rsp文件。
su - oracle
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/oracle/ocm.rsp
[oracle@dbrac1 ~]$ env|grep ORACLE_HOME
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1
[oracle@dbrac1 ~]$
[oracle@dbrac1 ~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/oracle/ocm.rsp
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:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y