반응형
Patch전 사전 확인
[root@one19c ~]# cliadm update-dbcli
Job details
----------------------------------------------------------------
ID: fe8c68e7-4f63-41af-bebb-23b0901ffccb
Description: DcsCli patching
Status: Created
Created: September 26, 2022 11:17:59 AM KST
Message: Dcs cli will be updated
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.3.2.1.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.15.0.0.0 19.16.0.0
DB 19.15.0.0.0 19.16.0.0
[root@one19c ~]#
[root@one19c ~]# dbcli describe-latestpatch
componentType availableVersion
--------------- --------------------
gi 12.2.0.1.220719
gi 12.1.0.2.220719
gi 18.16.0.0.0
gi 19.16.0.0.0
gi 21.7.0.0.0
db 11.2.0.4.220719
db 12.2.0.1.220719
db 12.1.0.2.220719
db 18.16.0.0.0
db 19.16.0.0.0
db 21.7.0.0.0
[root@one19c ~]#
[root@one19c ~]# su - grid
Last login: Mon Sep 26 11:17:11 KST 2022
[grid@one19c ~]$ cd $ORACLE_HOME/OPatch
[grid@one19c OPatch]$ pwd
/u01/app/19.0.0.0/grid/OPatch
[grid@one19c OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.32
OPatch succeeded.
[grid@one19c OPatch]$ ./opatch lspatches -oh /u01/app/19.0.0.0/grid
33610957;OCW Interim patch for 33610957
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
33810130;JDK BUNDLE PATCH 19.0.0.0.220419
33911149;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33911149)
33815607;ACFS RELEASE UPDATE 19.15.0.0.0 (33815607)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@one19c OPatch]$ exit
[root@one19c ~]#
[root@one19c ~]# su - oracle
Last login: Mon Sep 26 11:20:21 KST 2022 on pts/0
[oracle@one19c ~]$ cd $ORACLE_HOME/OPatch
[oracle@one19c OPatch]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch
[oracle@one19c OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.30
OPatch succeeded.
[oracle@one19c OPatch]$ ./opatch lspatches -oh /u01/app/oracle/product/19.0.0.0/dbhome_1
34096213;Fix for Bug 34096213
33810360;CVE-2021-45943 REPORTED IN (OPEN SOURCE GEOSPATIAL FOUNDATION/GEOSPATIAL DATA ABSTRACTION LIBRARY/OPENGIS SIMPLE FEATURES REFERENCE IMPLEMENTATION (GDAL/OGR)/3.3.0)
34088989;ONE-OFF REQUEST FOR DELETE DIR FOR SUPTOOLS/TFA + SUPTOOLS/ORACHK + SUPTOOLS/ORACHK.ZIP FROM DB PSU/BP/RU/RUR
33809062;TRACKING BUG FOR REGRESSION RTI 24544369 CAUSED BY PKNAGGS_BUG-32472737 APPROVED/INCLUDED IN 21.0.0.0 ADBSBP
33613829;RDBMS - DSTV37 UPDATE - TZDATA2021E
32327201;RDBMS - DSTV36 UPDATE - TZDATA2020E
31335037;RDBMS - DSTV35 UPDATE - TZDATA2020A
30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937
33808367;OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)
31732095;UPDATE PERL IN 19C DATABASE ORACLE HOME TO V5.32
33810130;JDK BUNDLE PATCH 19.0.0.0.220419
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
OPatch succeeded.
[oracle@one19c OPatch]$ exit
logout
[root@one19c ~]#Oracle GRID Patch
[root@one19c ~]# dbcli update-server -h
Usage: update-server [options]
Options:
--component, -c
Component to update
--help, -h
get help
--json, -j
json output
--local, -l
Update Server Components Locally
--node, -n
Node to be updated
--precheck, -p
Only Analyze the patch
--version, -v
Version to be updated
[root@one19c ~]#
[root@one19c ~]# dbcli update-server -p
{
"jobId" : "88bb70c4-c738-43f2-875d-c643213ebc36",
"status" : "Created",
"message" : null,
"errorCode" : "",
"reports" : [ ],
"createTimestamp" : "September 26, 2022 11:24:33 AM KST",
"resourceList" : [ ],
"description" : "Server Patching Prechecks",
"updatedTime" : "September 26, 2022 11:24:33 AM KST",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli update-server
{
"jobId" : "2fd66f64-23ae-4db4-999d-2467d1c35981",
"status" : "Created",
"message" : null,
"errorCode" : "",
"reports" : [ ],
"createTimestamp" : "September 26, 2022 11:25:26 AM KST",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "September 26, 2022 11:25:26 AM KST",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 2fd66f64-23ae-4db4-999d-2467d1c35981
Job details
----------------------------------------------------------------
ID: 2fd66f64-23ae-4db4-999d-2467d1c35981
Description: Server Patching
Status: Waiting
Created: September 26, 2022 11:25:26 AM KST
Progress: 0%
Message:
Error Code:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 2fd66f64-23ae-4db4-999d-2467d1c35981
Job details
----------------------------------------------------------------
ID: 2fd66f64-23ae-4db4-999d-2467d1c35981
Description: Server Patching
Status: Success
Created: September 26, 2022 11:25:26 AM KST
Progress: 100%
Message:
Error Code:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching September 26, 2022 11:29:14 AM KST September 26, 2022 11:30:31 AM KST Success
Server Patching September 26, 2022 11:30:31 AM KST September 26, 2022 11:49:45 AM KST Success
[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.16.0.0.0 up-to-date
DB 19.15.0.0.0 19.16.0.0
[root@one19c ~]#Oracle Database Patch
[root@one19c ~]# dbcli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612 OraDB19000_home1 19.15.0.0.0 /u01/app/oracle/product/19.0.0.0/dbhome_1 Configured
[root@one19c ~]#
[root@one19c ~]# dbcli update-dbhome -h
Usage: update-dbhome [options]
Options:
--cloneOcid, -o
clone OCID
--cloneType, -cc
Clone type
--cloneVersion, -cv
cloneVersion
* --dbhomeid, -i
Db home to be updated
--help, -h
get help
--json, -j
json output
--local, -l
Update Db home Locally
--node, -n
Node to be updated
--parUrl, -pu
par Url
--precheck, -p
Only Analyze the patch
--sha256sum, -ss
sha256sum
--version, -v
Patch version to be updated
[root@one19c ~]#
[root@one19c ~]# dbcli update-dbhome -i 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612
{
"jobId" : "9ab958f6-93bb-4238-b996-5b97f039ab1f",
"status" : "Created",
"message" : null,
"errorCode" : "",
"reports" : [ ],
"createTimestamp" : "September 26, 2022 12:28:26 PM KST",
"resourceList" : [ ],
"description" : "Database inplace image patching with dbhomeId : 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612",
"updatedTime" : "September 26, 2022 12:28:27 PM KST",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 9ab958f6-93bb-4238-b996-5b97f039ab1f
Job details
----------------------------------------------------------------
ID: 9ab958f6-93bb-4238-b996-5b97f039ab1f
Description: Database inplace image patching with dbhomeId : 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612
Status: Success
Created: September 26, 2022 12:28:26 PM KST
Progress: 100%
Message:
Error Code:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Precheck DBHome patching tasks September 26, 2022 12:28:27 PM KST September 26, 2022 12:31:53 PM KST Success
DBHome patching September 26, 2022 12:31:53 PM KST September 26, 2022 12:44:18 PM KST Success
Post DBHome patching tasks September 26, 2022 12:44:18 PM KST September 26, 2022 12:49:31 PM KST Success
[root@one19c ~]#
[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.16.0.0.0 up-to-date
DB 19.16.0.0.0 up-to-date
[root@one19c ~]#Patch결과 확인
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.16.0.0.0 up-to-date
DB 19.16.0.0.0 up-to-date
[root@one19c ~]#
[root@one19c ~]# su - grid
Last login: Mon Sep 26 13:02:52 KST 2022 on pts/0
[grid@one19c ~]$ cd $ORACLE_HOME/OPatch
[grid@one19c OPatch]$ pwd
/u01/app/19.0.0.0/grid/OPatch
[grid@one19c OPatch]$ ./opatch lspatches -oh /u01/app/19.0.0.0/grid
34122773;OCW Interim patch for 34122773
34113634;JDK BUNDLE PATCH 19.0.0.0.220719
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
34318175;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34318175)
34139601;ACFS RELEASE UPDATE 19.16.0.0.0 (34139601)
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@one19c OPatch]$
[grid@one19c OPatch]$ exit
logout
[root@one19c ~]# su - oracle
Last login: Mon Sep 26 13:03:09 KST 2022
[oracle@one19c ~]$ cd $ORACLE_HOME/OPatch
[oracle@one19c OPatch]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch
[oracle@one19c OPatch]$ ./opatch lspatches -oh /u01/app/oracle/product/19.0.0.0/dbhome_1
33303486;UNPLUG/PLUG A PLUGGABLE DATABASE MOVE DO A COPY AND NEED DOUBLE SPACE IN ASM.
29780459;INCREASE _LM_RES_HASH_BUCKET AND BACK OUT CHANGES FROM THE BUG 29416368 FIX
34006650;DSTV38 UPDATE - TZDATA2022A - NEED OJVM FIX
34006614;RDBMS - DSTV38 UPDATE - TZDATA2022A
33613829;RDBMS - DSTV37 UPDATE - TZDATA2021E
34113634;JDK BUNDLE PATCH 19.0.0.0.220719
32327201;RDBMS - DSTV36 UPDATE - TZDATA2020E
31335037;RDBMS - DSTV35 UPDATE - TZDATA2020A
30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
34086870;OJVM RELEASE UPDATE: 19.16.0.0.220719 (34086870)
34160635;OCW RELEASE UPDATE 19.16.0.0.0 (34160635)
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
OPatch succeeded.
[oracle@one19c OPatch]$
[oracle@one19c OPatch]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 26 13:05:59 2022 Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A10
SQL> COLUMN STATUS FORMAT A10
SQL> COLUMN DESCRIPTION FORMAT A60
SQL> COLUMN VERSION FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
2 ,ACTION ,STATUS ,DESCRIPTION ,SOURCE_VERSION ,TARGET_VERSION ,PATCH_ID
3 FROM DBA_REGISTRY_SQLPATCH
4 ORDER BY ACTION_TIME;
ACTION_TIME ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
-------------------- ---------- ---------- ------------------------------------------------------------ --------------- --------------- ----------
20220501 20:01:24 APPLY SUCCESS OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367) 19.1.0.0.0 19.1.0.0.0 33808367
20220501 20:01:24 APPLY SUCCESS Database Release Update : 19.15.0.0.220419 (33806152) 19.1.0.0.0 19.15.0.0.0 33806152
20220926 12:48:24 ROLLBACK SUCCESS OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367) 19.16.0.0.0 19.16.0.0.0 33808367
20220926 12:48:26 APPLY SUCCESS OJVM RELEASE UPDATE: 19.16.0.0.220719 (34086870) 19.15.0.0.0 19.15.0.0.0 34086870
20220926 12:48:26 APPLY SUCCESS Database Release Update : 19.16.0.0.220719 (34133642) 19.15.0.0.0 19.16.0.0.0 34133642
SQL> exit
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@one19c OPatch]$반응형