重慶思莊技術(shù)分享——19c GI 應(yīng)用19.20RU
19c GI 應(yīng)用19.20RU
1.下載OPATCH最新的版本
??su - grid? ?
??unzip -d $GRID_HOME/??p6880880_122010_Linux-x86-64.zip
??su - oracle
??unzip -d $ORACLE_HOME p6880880_122010_Linux-x86-64.zip
2.解壓19.20ru
? ?cd /u01/setup/ru
? ?unzip p35319490_190000_Linux-x86-64.zip
3.打補(bǔ)丁
??/u01/app/19.19.0/grid/OPatch/opatchauto apply /u01/setup/ru/35319490
4.補(bǔ)丁驗證??[grid@dbserver ~]$ cd $ORACLE_HOME/OPatch[grid@dbserver OPatch]$ ./opatch lspatches
35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096)
35332537;ACFS RELEASE UPDATE 19.20.0.0.0 (35332537)
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
??[root@dbserver ru]# su - oracle
pw[oracle@dbserver ~]$ pwd
/home/oracle
[oracle@dbserver ~]$ cd $ORACLE_HOME/OPatch
[oracle@dbserver OPatch]$ ./opatch lspatches
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)
OPatch succeeded.
4.修改數(shù)據(jù)字典
??su - oracle
??sqlplus /as sysdba
??sql>startup
??sql>exit
??cd $ORACLE_HOME/OPatch
??./datapatch -verbose
5.驗證
? ? 1? ?select PATCH_ID,PATCH_TYPE,DESCRIPTION,ACTION,ACTION_TIME,STATUS,TARGET_VERSION??from dba_registry_sqlpatch
??2*
??PATCH_ID PATCH_TYPE DESCRIPTION? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?ACTION? ?? ?? ? ACTION_TIME? ?? ?? ?? ?? ?? ???STATUS? ?? ?? ?? ?? ?TARGET_VERSION
---------- ---------- ------------------------------------------------------- --------------- ------------------------------ -------------------- ---------------
??35050341 INTERIM? ? OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)? ?? ???APPLY? ?? ?? ???15-JUL-23 03.20.52.778803 PM? ?SUCCESS? ?? ?? ?? ???19.1.0.0.0
??35042068 RU? ?? ?? ?Database Release Update : 19.19.0.0.230418 (35042068)? ?APPLY? ?? ?? ???15-JUL-23 03.20.52.765067 PM? ?SUCCESS? ?? ?? ?? ???19.19.0.0.0
??35320081 RU? ?? ?? ?Database Release Update : 19.20.0.0.230718 (35320081)? ?APPLY? ?? ?? ???19-JUL-23 11.11.53.712858 AM? ?SUCCESS? ?? ?? ?? ???19.20.0.0.0
