Oracle 12c RAC补丁升级:
数据库版本: 12.1.0.2.0
补丁版本: 12.1.0.2.210720OJVMPSU
GI-PSU:p32900185_121020_Linux-x86-64.zip
OPatch: p6880880_122010_Linux-x86-64.zip
路径:
GRID_HOME: /u01/app/12.1.0/grid
ORACLE_HOME: /u01/app/oracle/product/12.1.0/dbhome_1
GI: /u01/soft/32900185/32917447
DB: /u01/soft/32900185/32876425
--------------grid--------------
1.备份grid_home目录(必须)
2.安装OPatch工具后,修改环境变量
3.root打补丁
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/soft/32900185/32917447 -oh /u01/app/12.1.0/grid -analyze
/u01/app/12.1.0/grid/OPatch/opatchauto apply /u01/soft/32900185/32917447 -oh /u01/app/12.1.0/grid
4.检查补丁安装情况
opatch lspatches
opatch lsinv
opatch lsinventory
--------------oracle--------------
1.备份oracle_home目录(必须)
2.安装OPatch工具后,修改环境变量
3.oracle用户打补丁
cd /u01/soft/32900185/32876425
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply
4.检查补丁安装情况
opatch lspatches
opatch lsinv
opatch lsinventory
5.执行数据库脚本
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> @utlrp.sql
SQL> @?/rdbms/admin/catbundle.sql PSU apply
set lin 200
col BUNDLE_SERIES for a6
col ACTION_TIME for a35
col COMMENTS for a30
col VERSION for a12
select * from dba_registry_history;