pat98's always & forever

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

공식적인 방법은 아니니 에디션별 기능 등을 quick 하게 테스트 해야 할 경우 해 볼수 있겠다.

- Enterprise -> Standard 로 변경. shutdown 후 relink

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk edition_standard ioracle

Connected to:

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

select * from v$option where parameter='Partitioning';

PARAMETER            VALUE          CON_ID

-------------------- ---------- ----------

Partitioning         FALSE                0

- Standard -> Enterprise 로 변경. shutdown 후 relink

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk edition_enterprise ioracle

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

PARAMETER            VALUE          CON_ID

-------------------- ---------- ----------

Partitioning         TRUE                0

- 현재  ins_rdbms.mk 화일에 code 되어 있는 내용은 아래와 같음

grep -i edi /oracle/app/oracle/product/19.0.0/rdbms/lib/ins_rdbms.mk

edition_corestandard:

        $(SILENT)$(ECHO) "Deploying Oracle Database Core Standard Edition"

edition_coreenterprise:

        $(SILENT)$(ECHO) "Deploying Oracle Database Core Enterprise Edition"

edition_standard:

        $(SILENT)$(ECHO) "Deploying Oracle Database Standard Edition"

edition_enterprise:

        $(SILENT)$(ECHO) "Deploying Oracle Database Enterprise Edition"

edition_highperf:

        $(SILENT)$(ECHO) "Deploying Oracle Database Enterprise Edition High Performance"

edition_extremeperf:

        $(SILENT)$(ECHO) "Deploying Oracle Database Enterprise Edition Extreme Performance"

edition_express:

        $(SILENT)$(ECHO) "Deploying Oracle Database Express Edition"