Oracle Single 환경에 OCW Patch 를 적용해야 할까?

Oracle Single 환경에 OCW Patch 를 적용해야 할까?

기본적으로 19.3 버전을  초기 설치하게 되면 non RAC / non ASM 환경임에도 
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 해당 패치가 같이 설치가 된다.

이후 Patch 관리를 해줘야 할 떄, Database RU 외에 OCW (Grid)도 같이 해 줘야 하나? 하는 의문이 생긴다.

-> 결론부터 말하면 선택사항이며 오라클에서는 보안패치가 포함되어 있기 때문에 같이 해줄것을 권장하고 있다.
-> 같이 관리해 주고 싶다면 GI RU 를 받아서 OCW와 DB RU를 개별적으로 Patch 적용해 주면 된다.

==========================================================================

APPLIES TO:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

GOAL

Is it or not necessary to apply OCW patches on my ORACLE_HOME even if I don't use ASM, RAC or CLUSTERWARE?

It is optional, but even if no GI Stack (ASM, Clusterware or RAC) is used inside the server, it is recommended not to ignore the security patches of the installed components. And apply the most recent OCW Patch.

From version 19c onwards, the Patch 29585399 OCW RU is included from the initial installation.  

[oracle@localhost ~]$ opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242) 

OPatch succeeded. 

 

SOLUTION

To apply the latest OCW patch, it is necessary to do it manually. This must be done by downloading the latest GI RU patch, unzipping it and placing it in the directory corresponding to the OCW and apply it using "opatch apply". 

Applying OCW and DB RUs 

Patch 35319490: GI RELEASE UPDATE 19.20.0.0.0.0 will be used.

You can download it from the following link:
https://updates.oracle.com/download/35319490.html 

NOTE: For rollback, installation, and post-installation instructions refer to README of the respective patches.

[oracle@localhost ~]$ unzip p35319490_190000_Linux-x86-64.zip

[oracle@localhost ~]$ cd 35319490/35320149 ◄◄◄ OCW Patch ID

[oracle@localhost ~]$ opatch apply

Patch 35320149 successfully applied.
OPatch succeeded.

[oracle@localhost ~]$ cd cd 35319490/35320081 ◄◄◄ DB RU Patch ID

[oracle@localhost ~]$ opatch apply

Patch 35320081 successfully applied.
OPatch succeeded.

Proceed to start the database and execute datapatch

SQL> startup
SQL> exit

[oracle@localhost ~]$ datapatch -verbose
SQL Patching tool complete on Sat Aug 26 21:29:07 2023 

[oracle@localhost ~]$ opatch lspatches

35320081;Database Release Update : 19.20.0.0.230718 (35320081)
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)

OPatch succeeded.

[oracle@localhost ~]$

 

Already updated OCW and DB Release Update to the latest version