oracle rac patch

1. patch 용어

- Update - Release Update                (예. 18.6 -> 18.7)

- Revision -Release Update Revision    (예. 18.6.0 -> 18.6.1)

- Final CPU is the last quarter that a product is supported in the CPU program as per the Premier Support

  and Extended Support policies. 

- NA Not Applicable

- OR On-Request. The patch is made available through the On-Request program

- PSU - Patch Set Update

- SPU - Security Patch Update

 

2. patch

- patch conflict check (grid, oracle 각각 진행)

  $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir  ./29757256

 

- space check

cat > /tmp/patch_list_gihome.txt

<UNZIPPED_PATCH_LOCATION>/29708703/29757256

<UNZIPPED_PATCH_LOCATION>/29708703/29782099

<UNZIPPED_PATCH_LOCATION>/29708703/29782169

 

  $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

 

- patch 진행 (root에서 진행)

  patch 가능여부 체크

  $GRID_HOME/OPatch/opatchauto apply <UNZIPPED_PATCH_LOCATION>/29708703 -analyze

  patch 진행

  opatchauto apply <UNZIPPED_PATCH_LOCATION>/29708703

 

- db 정보 update

  cd $ORACLE_HOME/OPatch

  ./datapatch -verbose