카테고리 없음
오라클 11g RAC PSU 롤링 패치
딘스톤
2023. 11. 7. 18:03
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.zip11. 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