对于oracle11g RAC的升级大家应该比较熟悉,目前oracle12c市场上开始慢慢使用。oracle12c的升级和11g大致步骤相同,又略有不同。
今天我们就列出oracle 12C RAC 12.1.0.2 PSU升级到22646084 (12.1.0.2.160419)的详细步骤 。
经过执行发现,12c版本的升级已经不需要生产相应文件了。
1、设置环境变量:
grid用户:
PATH=${PATH}:/usr/bin:/bin:/sbin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
和oracle用户:
PATH=${PATH}:/usr/bin:/bin:/sbin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
2、oracle 和 grid用户都升级 opatch version
You must use the OPatch utility version 12.1.0.1.7 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 12.1 releases, which is available for download from My Oracle Support patch 6880880 by selecting ARU link for the 12.1.0.1.0 release. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.
安装好后默认的opatch version 是12.1.0.1.3
3、升级:
root用户执行:整个过程不需要手动关闭集群,会自动关闭和启动集群。两个节点依次执行,节点1升级grid,后节点2升级grid。节点1升级DB后节点2升级DB。
grid升级:
节点1:
冲突分析:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid -analyze
升级grid:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid
节点2:
冲突分析:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid -analyze
升级grid:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid
db升级:
节点1:
分析:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1 –analyze
升级:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1
节点2:
分析:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1 –analyze
升级:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1
今天我们就列出oracle 12C RAC 12.1.0.2 PSU升级到22646084 (12.1.0.2.160419)的详细步骤 。
经过执行发现,12c版本的升级已经不需要生产相应文件了。
1、设置环境变量:
grid用户:
PATH=${PATH}:/usr/bin:/bin:/sbin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
和oracle用户:
PATH=${PATH}:/usr/bin:/bin:/sbin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
2、oracle 和 grid用户都升级 opatch version
You must use the OPatch utility version 12.1.0.1.7 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 12.1 releases, which is available for download from My Oracle Support patch 6880880 by selecting ARU link for the 12.1.0.1.0 release. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.
安装好后默认的opatch version 是12.1.0.1.3
3、升级:
root用户执行:整个过程不需要手动关闭集群,会自动关闭和启动集群。两个节点依次执行,节点1升级grid,后节点2升级grid。节点1升级DB后节点2升级DB。
grid升级:
节点1:
冲突分析:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid -analyze
升级grid:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid
节点2:
冲突分析:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid -analyze
升级grid:
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/12.1.0/grid
db升级:
节点1:
分析:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1 –analyze
升级:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1
节点2:
分析:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1 –analyze
升级:
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatchauto apply /u01/media/22646084 -oh /u01/app/oracle/product/12.1.0/db_1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29582917/viewspace-2123557/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29582917/viewspace-2123557/