그리드 패치

1. 패치파일 다운로드 - mos

2. 다운로드 받은 파일을 oracd 에 업로드

root 에서 oracd 자체를 777로 권한 변경을 한다.

chmod -R 777 /oracd

#############################
# 디렉토리의 소유자와 소유그룹을 변경

chown -R grid:dba /oracd

# 오라클 디렉토리의 권한 변경

chmod -R 775 /oracle
chmod -R 777 /oracd
##############################

[root@test ~]# cd /oracd
[root@test oracd]# ls -alrt
total 12294384

drwxrwxrwx.  2 oracle dba        4096 Oct 15 10:31 .

현재 권한 777 / 소유자 : 소유그룹 = oracle : dba

3. 업로드한 파일을 unzip

패치 압축을 풀 경로 생성 후 unzip 한다. read me 에 empty 라고 써 있었음.

[root@test oracle]# mkdir patch
![](https://velog.velcdn.com/images/hyeonseu/post/24869ec4-1e79-47cb-ab24-269a600a696a/image.png)

[root@test patch]# pwd
/oracle/app/oracle/patch

cd /oracd

unzip p36582629_190000_Linux-x86-64.zip -d /oracle/app/oracle/patch

[root@test ~]# cd /oracle/app/oracle
[root@test oracle]# ls
admin  audit  cfgtoollogs  checkpoints  diag  patch  product

[root@shdb1 oracle]# chmod -R 777 patch

4. 각 엔진의 OPatch 백업하고 688 unzip

mv OPatch/ OPatch_OLD/

unzip /oracd/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME - su - oracle

[oracle@test oracd]$ exit
logout
[root@test oracle]# su - grid
Last login: Mon Oct 14 12:19:00 KST 2024 on pts/2
[grid@test ~]$
[grid@test ~]$
[grid@test ~]$ cd $ORACLE_HOME
[grid@test grid]$ ls

권한 오류가 나서 권환을 바꿔주어야 함.

chmod -R 755 oracd

[grid@test oracd]$ ls -al
total 12294384
drwxrwxrwx.  2 oracle dba        4096 Oct 15 10:31 .
dr-xr-xr-x. 19 root   root       4096 Oct 14 11:07 ..

-rwxrwxrwx.  1 root   root 3445758071 Oct 15 10:36 p36582629_190000_Linux-x86-64                        .zip
-rwxrwxrwx.  1 oracle dba   134471443 Oct 14 11:11 p6880880_190000_Linux-x86-64.                        zip

[grid@test /]$ exit
logout
[root@test oracle]# cd
[root@test ~]# pwd


[root@test /]# chmod -R 777 oracd
[root@test /]# su - grid
Last login: Tue Oct 15 11:15:28 KST 2024 on pts/0
[grid@test ~]$ unzip /oracd/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
Archive:  /oracd/p6880880_190000_Linux-x86-64.zip
checkdir error:  cannot create /oracle/app/19c/grid/OPatch
                 Permission denied
                 unable to process OPatch/.
checkdir error:  cannot create /oracle/app/19c/grid/OPatch
                 Permission denied
                 unable to process OPatch/opatchauto.

이걸론 다 안되어서 또 바꿔줌

sudo chmod -R u+w /oracle/app/19c/grid/

sudo chown -R grid:dba /oracle/app/19c/grid

unzip /oracd/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME - su - grid

4-1. OPatch 폴더 권한변경

cd $GRID_HOME 
chmod -R 775 OPatch
cd $ORACLE_HOME
chmod -R 775 OPatch

5. 충돌체크

As the Grid home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36582781

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36587798

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36590554

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36648174

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36758186

For Oracle home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36582781
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/app/oracle/patch/36582629/36587798

6. 시스템 스페이스 체크

For Grid Infrastructure home, as home user:

Create file /tmp/patch_list_gihome.txt with the following content:

vi /tmp/patch_list_gihome.txt

/oracle/app/oracle/patch/36582629/36582781
/oracle/app/oracle/patch/36582629/36587798
/oracle/app/oracle/patch/36582629/36590554
/oracle/app/oracle/patch/36582629/36648174
/oracle/app/oracle/patch/36582629/36758186

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

For Oracle home, as home user:

Create file /tmp/patch_list_dbhome.txt with the following content:

vi /tmp/patch_list_dbhome.txt

/oracle/app/oracle/patch/36582629/36582781
/oracle/app/oracle/patch/36582629/36587798


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

7. opatchauto apply

The utility must be executed by an operating system (OS) user with root privileges, and it must be executed on each node in the cluster if the Grid home or Oracle RAC database home is in non-shared storage. The utility can be run in parallel on the cluster nodes except for the first (any) node.

To patch the Grid home and all Oracle RAC database homes of the same version:

# opatchauto apply /oracle/app/oracle/patch/36582629

패치 끝 !