본문 바로가기
카테고리 없음

오라클 11g RAC PSU 롤링 패치

by 딘스톤 2023. 11. 7.

1. 기존 패치 내역을 확인합니다.

-- 1번 노드

SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A20
SQL> COLUMN NAMESPACE FORMAT A20
SQL> COLUMN VERSION FORMAT A10
SQL> COLUMN COMMENTS FORMAT A30
SQL> COLUMN BUNDLE_SERIES FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME,
     ACTION,NAMESPACE,VERSION,ID,COMMENTS,BUNDLE_SERIES
     FROM DBA_REGISTRY_HISTORY
     ORDER BY ACTION_TIME
     /
     
ACTION_TIME          ACTION  NAMESPACE      VERSION    ID  COMMENTS                BUNDLE_SER
-------------------- ------- -------------- ---------- --- ----------------------- -------------
20130824 12:03:45    APPLY   SERVER         11.2.0.4   0   Patchset 11.2.0.2.0     PSU
20231022 04:04:28    APPLY   SERVER         11.2.0.4   0   Patchset 11.2.0.2.0     PSU

 

-- 2번 노드 

SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A20
SQL> COLUMN NAMESPACE FORMAT A20
SQL> COLUMN VERSION FORMAT A10
SQL> COLUMN COMMENTS FORMAT A30
SQL> COLUMN BUNDLE_SERIES FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME,
     ACTION,NAMESPACE,VERSION,ID,COMMENTS,BUNDLE_SERIES
     FROM DBA_REGISTRY_HISTORY
     ORDER BY ACTION_TIME
     /
     
ACTION_TIME          ACTION  NAMESPACE    VERSION    ID  COMMENTS             BUNDLE_SER
-------------------- ------- ------------ ---------- --- -------------------- ------------
20130824 12:03:45    APPLY   SERVER       11.2.0.4   0   Patchset 11.2.0.2.0  PSU
20231022 04:04:28    APPLY   SERVER       11.2.0.4   0   Patchset 11.2.0.2.0  PSU

 

2. OPatch 버전 확인

-- 1번 노드

# GRID
[root@rac1 ~]# $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.4

# ORACLE
[root@rac1 ~]# $DB_HOME/OPatch/opatch version -oh $DB_HOME
OPatch Version: 11.2.0.3.4

 

-- 2번 노드 

# GRID
[root@rac2 ~]# $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.4


# ORACLE
[root@rac2 ~]# $DB_HOME/OPatch/opatch version -oh $DB_HOME
OPatch Version: 11.2.0.3.4

 

 

3. 최신 OPatch 파일 업로드

-- 1번 노드

# OPatch 패치 파일을 업로드 디렉토리를 생성합니다.
[root@rac1 ~]# mkdir media
[root@rac1 ~]# cd media
[root@rac1 media]# pwd
/root/media

# OPatch 패치 파일을 업로드 한 후 확인합니다.
[root@rac1 media]# ll
합계 1413924
-rw-r--r--. 1 root root 128433424 2023-11-05 16:00 p6880880_112000_Linux-x86-64.zip

 

-- 2번 노드

# OPatch 패치 파일을 업로드 디렉토리를 생성합니다.
[root@rac2 ~]# mkdir media
[root@rac2 ~]# cd media/
[root@rac2 media]# pwd
/root/media

# OPatch 패치 파일을 업로드 한 후 확인합니다.
[root@rac2 media]# ll
합계 1413920
-rw-r--r--. 1 root root 128433424 2023-11-05 16:01 p6880880_112000_Linux-x86-64.zip

 

4. OPatch 최신버전으로 교체

-- 1번 노드

# GRID
[root@rac1 media]# cd $GRID_HOME
[root@rac1 grid]# mv OPatch/ OPatchbak
[root@rac1 grid]# unzip /root/media/p6880880_112000_Linux-x86-64.zip
[root@rac1 grid]# chown -R grid:oinstall OPatch
[root@rac1 grid]# chmod 755 OPatch
[root@rac1 grid]# $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.44


# ORACLE
[root@rac1 ~]# cd $DB_HOME
[root@rac1 db_1]# mv OPatch/ OPatchbak
[root@rac1 db_1]# unzip /root/media/p6880880_112000_Linux-x86-64.zip
[root@rac1 db_1]# chown -R oracle:oinstall OPatch
[root@rac1 db_1]# chmod 755 OPatch
[root@rac1 db_1]# $DB_HOME/OPatch/opatch version -oh $DB_HOME
OPatch Version: 11.2.0.3.44

 

-- 2번 노드

# GRID
[root@rac2 media]# cd $GRID_HOME
[root@rac2 grid]# mv OPatch/ OPatchbak
[root@rac2 grid]# unzip /root/media/p6880880_112000_Linux-x86-64.zip
[root@rac2 grid]# chown -R grid:oinstall OPatch
[root@rac2 grid]# chmod 755 OPatch
[root@rac2 grid]# $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.44

# ORACLE
[root@rac2 ~]# cd $DB_HOME
[root@rac2 db_1]# mv OPatch/ OPatchbak
[root@rac2 db_1]# unzip /root/media/p6880880_112000_Linux -x86-64.zip
[root@rac2 db_1]# chown -R oracle:oinstall OPatch
[root@rac2 db_1]# chmod 755 OPatch
[root@rac2 db_1]# $DB_HOME/OPatch/opatch version -oh $DB_HOME
OPatch Version: 11.2.0.3.44

 

5. 기존 invalid object 확인

-- 1번 노드

SYS @ racdb1 > select count(*) from dba_objects where status!='VALID';

COUNT(*)
----------
 0

 

-- 2번 노드

SYS @ racdb2 > select count(*) from dba_objects where status!='VALID';

COUNT(*)
----------
 0

 

5. 기존 invalid object 확인

-- 1번 노드

# GRID
[root@rac1 ~]# su - grid
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
이 Oracle 홈에 설치된 Interim 패치가 없습니다.

# ORACLE
[root@rac1 ~]# su - oracle
[oracle@racdb1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
이 Oracle 홈에 설치된 Interim 패치가 없습니다.

 

-- 2번 노드

# GRID
[root@rac2 grid]# su - grid
[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
이 Oracle 홈에 설치된 Interim 패치가 없습니다 "/u01/app/11.2.0/grid".

# ORACLE
[root@rac2 grid]# su - oracle
[oracle@racdb2 ~]$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
이 Oracle 홈에 설치된 Interim 패치가 없습니다 "/u01/app/oracle/product/11.2.0/db_1".

 

6. DB 종료

-- 1번 노드

SYS @ racdb1 > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

 

7. GRID 종료

-- 1번 노드

[root@rac1 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'
CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2676: Start of 'ora.cvu' on 'rac2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'rac2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2676: Start of 'ora.oc4j' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/11.2.0/grid

 

8. GRID 패치

8-1.  PSU 패치 파일 업로드 및 UNZIP

-- 1번 노드

# PSU 패치 파일을 업로드 할 디렉토리 생성합니다.
[grid@+ASM1 ~]$ mkdir media
[grid@+ASM1 ~]$ cd media

# PSU 패치 파일 업로드한 후 unzip 합니다.
[grid@+ASM1 media]$ unzip p31718723_112040_Linux-x86-64.zip

 

8-2.  OCW 패치

-- 1번 노드

[grid@+ASM1 media]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /home/grid/media/31718723/29938455
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-20-50오후_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-20-55오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29938455

계속하겠습니까? [y|n]
Y <-- [y 입력]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y  <-- [y 입력]
User Responded with: Y
Backing up files...
OH '/u01/app/11.2.0/grid'에 Interim 패치 '29938455'을(를) 적용하는 중

oracle.crs, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29938455 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-20-55오후_1.log

OPatch succeeded.

 

8-3.  ACFS 패치

-- 1번 노드

[grid@+ASM1 media]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /home/grid/media/31718723/29509309
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-23-13오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29509309

계속하겠습니까? [y|n]
Y  <-- [y 입력]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y  <-- [y 입력]
User Responded with: Y
Backing up files...
OH '/u01/app/11.2.0/grid'에 Interim 패치 '29509309'을(를) 적용하는 중

oracle.usm, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29509309 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-23-13오후_1.log

OPatch succeeded.

 

8-4. DB PSU 패치

-- 1번 노드

[grid@+ASM1 media]$ $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /home/grid/media/31718723/31537677
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_17-25-29오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677

계속하겠습니까? [y|n]
Y  <-- [y 입력]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y  <-- [y 입력]
User Responded with: Y
Backing up files...

 

9. GRID 패치 버전 확인

-- 1번 노드

[grid@+ASM1 media]$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME

31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)
29509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309)
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

 

10.  PSU 패치 파일 업로드 및 UNZIP

-- 1번 노드

# PSU 패치 파일을 업로드 할 디렉토리 생성합니다.
[oracle@racdb1 ~]$ mkdir media
[oracle@racdb1 ~]$ cd media

# PSU 패치 파일 업로드한 후 unzip 합니다.
[oracle@racdb1 media]$ unzip p31718723_112040_Linux-x86-64.zip

 

11. DB 패치 

11-1. DB 패치 전 사전 확인

-- 1번 노드

[oracle@racdb1 media]$ /home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh completed successfully.

 

11-2.  OCW 패치

-- 1번 노드

[oracle@racdb1 media]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /home/oracle/media/31718723/29938455/custom/server/29938455
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_17-34-28오후_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_17-34-34오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29938455

계속하겠습니까? [y|n]
Y <-- [y 입력]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/oracle/product/11.2.0/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [y 입력]
User Responded with: Y
Backing up files...
OH '/u01/app/oracle/product/11.2.0/db_1'에 Interim 패치 '29938455'을(를) 적용하는 중

oracle.rdbms, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29938455 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_17-34-34오후_1.log

OPatch succeeded.

 

11-3. DB PSU 패치

-- 1번 노드

[oracle@racdb1 media]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/oracle/media/31718723/31537677
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_17-37-04오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677

계속하겠습니까? [y|n]
Y <-- [y 입력]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/oracle/product/11.2.0/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [y 입력]
User Responded with: Y

 

12.  패치  확인

-- 1번 노드

[oracle@racdb1 media]$ /home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

Reading /u01/app/oracle/product/11.2.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/11.2.0/db_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/crsdiag.pl
Postpatch completed successfully

 

13. DB 패치버전 확인

-- 1번 노드

[oracle@racdb1 media]$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME

31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

 

14. 패치 마무리

-- 1번 노드

- rootcrs.pl 스크립트 입력시 grid 기동됩니다.

- rootadd_rdbms.sh 는 relink 작업을 해주는 스크립트 입니다.

[root@rac1 ~]# $GRID_HOME/crs/install/rootcrs.pl -patch
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

 

15. DB OPEN

-- 1번 노드

SQL> startup

ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2253784 bytes
Variable Size            1090522152 bytes
Database Buffers          553648128 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.

 

16. DB 종료

-- 2번 노드

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

 

17. GRID 종료

-- 2번 노드

[root@rac2 ~]# $GRID_HOME/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2'
CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2'
CRS-2676: Start of 'ora.cvu' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.rac2.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac1'
CRS-2676: Start of 'ora.rac2.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'rac1'
CRS-2676: Start of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2676: Start of 'ora.oc4j' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac2'
CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'
CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'
CRS-2673: Attempting to stop 'ora.crf' on 'rac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'
CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/11.2.0/grid

 

18. GRID 패치

18-1.  PSU 패치 파일 업로드 및 UNZIP

-- 2번 노드

# PSU 패치 파일을 업로드 할 디렉토리 생성합니다.
[grid@+ASM2 ~]$ mkdir media
[grid@+ASM2 ~]$ cd media/

# PSU 패치 파일 업로드한 후 unzip 합니다.
[grid@+ASM2 media]$ unzip p31718723_112040_Linux-x86-64.zip

 

18-2.  OCW 패치

-- 2번 노드

[grid@+ASM2 media]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /home/grid/media/31718723/29938455
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-00-47오후_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-00-52오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29938455

계속하겠습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
Backing up files...
OH '/u01/app/11.2.0/grid'에 Interim 패치 '29938455'을(를) 적용하는 중

oracle.crs, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29938455 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-00-52오후_1.log

OPatch succeeded.

 

18-3.  ACFS 패치

-- 2번 노드

[grid@+ASM2 media]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /home/grid/media/31718723/29509309
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-03-18오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29509309

계속하겠습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
Backing up files...
OH '/u01/app/11.2.0/grid'에 Interim 패치 '29509309'을(를) 적용하는 중

oracle.usm, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29509309 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-03-18오후_1.log

OPatch succeeded.

 

18-4.  DB PSU 패치

-- 2번 노드

[grid@+ASM2 media]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /home/grid/media/31718723/31537677
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/11.2.0/grid
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/11.2.0/grid/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2023-11-05_18-04-53오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677

계속하겠습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/11.2.0/grid')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
Backing up files…

 

19. GRID 패치 버전 확인

-- 2번 노드

[grid@+ASM2 media]$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)
29509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309)
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

 

20. PSU 패치 파일 업로드 및 UNZIP

-- 2번 노드

# PSU 패치 파일을 업로드 할 디렉토리 생성합니다.
[oracle@racdb2 ~]$ mkdir media
[oracle@racdb2 ~]$ cd media/

# PSU 패치 파일 업로드한 후 unzip 합니다.
[oracle@racdb2 media]$ unzip p31718723_112040_Linux-x86-64.zip

 

21. DB 패치 

21-1. DB 패치 전 사전확인

-- 2번 노드

[oracle@racdb2 media]$ /home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh completed successfully.

 

21-2.  OCW 패치

-- 2번 노드

[oracle@racdb2 media]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /home/oracle/media/31718723/29938455//custom/server/29938455
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_18-17-06오후_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_18-17-11오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29938455

계속하겠습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/oracle/product/11.2.0/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y <-- [ y 입력 ]
User Responded with: Y
Backing up files...
OH '/u01/app/oracle/product/11.2.0/db_1'에 Interim 패치 '29938455'을(를) 적용하는 중

oracle.rdbms, 11.2.0.4.0 구성요소를 패치하는 중...
Patch 29938455 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_18-17-11오후_1.log

OPatch succeeded.

 

21-3. DB PSU 패치

-- 2번 노드

[oracle@racdb2 media]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /home/oracle/media/31718723/31537677
Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_18-18-46오후_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim 패치 설치 프로그램 버전 11.2.0.3.44
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle 홈: /u01/app/oracle/product/11.2.0/db_1
중앙 인벤토리: /u01/app/oraInventory
   출처: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch 버전: 11.2.0.3.44
OUI 버전: 11.2.0.4.0
로그 파일 위치: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2023-11-05_18-18-53오후_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  28204707  28729262  29141056  29497421  29913194  30298532  30670774  31103343  31537677

계속하겠습니까? [y|n]
Y  <-- [ y 입력 ]
User Responded with: Y
All checks passed.

로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오.
(Oracle 홈 = '/u01/app/oracle/product/11.2.0/db_1')


로컬 시스템이 패치할 준비가 되었습니까? [y|n]
Y  <-- [ y 입력 ]
User Responded with: Y
Backing up files...

 

22. 패치 후 확인

-- 2번 노드

[oracle@racdb2 media]$ /home/oracle/media/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /u01/app/oracle/product/11.2.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/11.2.0/db_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.2.0/db_1/bin/crsdiag.pl
Postpatch completed successfully

 

 

23. DB 패치 버전 확인

-- 2번 노드

[oracle@racdb2 ~]$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677)
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

 

24. 패치 마무리

-- 2번 노드

- rootcrs.pl 스크립트 입력시 grid 기동됩니다

- rootadd_rdbms.sh 는 relink 작업을 해주는 스크립트 입니다.

[root@rac2 ~]# $GRID_HOME/crs/install/rootcrs.pl -patch
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

 

25. DB OPEN

-- 2번 노드

SQL> startup

ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2253784 bytes
Variable Size            1090522152 bytes
Database Buffers          553648128 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.

 

26. 패치된 sql 파일을 db에 적용

-- 1개의 노드에서만 진행하면 됩니다.

SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> @?/rdbms/admin/utlrp.sql

 

27. 패치 내역을 확인합니다.

-- 1번 노드

SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A20
SQL> COLUMN NAMESPACE FORMAT A20
SQL> COLUMN VERSION FORMAT A10
SQL> COLUMN COMMENTS FORMAT A30
SQL> COLUMN BUNDLE_SERIES FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME,
     ACTION,NAMESPACE,VERSION,ID,COMMENTS,BUNDLE_SERIES
     FROM   DBA_REGISTRY_HISTORY
     ORDER BY ACTION_TIME
     / 

ACTION_TIME        ACTION    NAMESPACE   VERSION    ID         COMMENTS             BUNDLE_SER
------------------ --------- ----------- ---------- ---------- -------------------- -----------
20130824 12:03:45  APPLY     SERVER      11.2.0.4            0 Patchset 11.2.0.2.0  PSU
20231022 04:04:28  APPLY     SERVER      11.2.0.4            0 Patchset 11.2.0.2.0  PSU
20231105 18:28:56  APPLY     SERVER      11.2.0.4       201020 PSU 11.2.0.4.201020  PSU

 

-- 2번 노드 

SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A20
SQL> COLUMN NAMESPACE FORMAT A20
SQL> COLUMN VERSION FORMAT A10
SQL> COLUMN COMMENTS FORMAT A30
SQL> COLUMN BUNDLE_SERIES FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME,
     ACTION,NAMESPACE,VERSION,ID,COMMENTS,BUNDLE_SERIES
     FROM DBA_REGISTRY_HISTORY
     ORDER BY ACTION_TIME
     / 

ACTION_TIME        ACTION    NAMESPACE   VERSION    ID         COMMENTS             BUNDLE_SER
------------------ --------- ----------- ---------- ---------- -------------------- -----------
20130824 12:03:45  APPLY     SERVER      11.2.0.4            0 Patchset 11.2.0.2.0  PSU
20231022 04:04:28  APPLY     SERVER      11.2.0.4            0 Patchset 11.2.0.2.0  PSU
20231105 18:28:56  APPLY     SERVER      11.2.0.4       201020 PSU 11.2.0.4.201020  PSU

 

28. invalid object 검사

-- 1번 노드

SQL> select count(*) from dba_objects where status!='VALID';

  COUNT(*)
----------
         0

 

-- 2번 노드 

SQL> select count(*) from dba_objects where status!='VALID';

  COUNT(*)
----------
         0

 

 

참고 : https://positivemh.tistory.com/715

티스토리툴바