내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.4 (64bit)
DB 환경 : Oracle Database 11.2.0.4 RAC
방법 : Oracle 11g R2 RAC PSU 패치 가이드(opatch auto)
1.2.0.4 기본 설치만 되어있는 2node RAC db에 opatch auto로 181016 PSU를 적용하는 내용
롤링 방식으로 1번 노드 패치완료 후 2번 노드도 패치를 진행함
Patch 28429134 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.181016
패치파일 support.oracle.com/ 에서 다운로드 후 진행
#는 root 유저를 $는 oracle 유저를 나타냄
패치전 백업
Oracle 11g R2 RAC PSU 패치전 백업 가이드(https://positivemh.tistory.com/769) 참조
기존 패치 내역 확인(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A20
COLUMN NAMESPACE FORMAT A20
COLUMN VERSION FORMAT A10
COLUMN COMMENTS FORMAT A30
COLUMN BUNDLE_SERIES FORMAT A10
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
-------------------- -------------------- -------------------- ---------- ---------- ------------------------------ ----------
20180313 02:30:34 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
20211020 07:52:45 APPLY SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
20211020 09:51:33 ROLLBACK SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
20211020 09:51:33 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
|
db 패치가 적용되어있지 않음
사전작업
OPatch 버전 확인(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
|
GRID OPatch
$ $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.18
OPatch succeeded.
DB OPatch
$ $ORACLE_HOME/OPatch/opatch version -oh $ORACLE_HOME
OPatch Version: 11.2.0.3.4
OPatch succeeded.
|
grid opatch 버전은 .18, db opatch 버전은 .4임
최신 OPatch, PSU 파일 업로드(1번, 2번 노드)
|
1
2
3
4
5
6
|
$ ls -al /home/oracle/media/
total 1033124
drwxr-xr-x 2 oracle dba 87 Apr 17 08:10 .
drwxr-xr-x. 10 oracle dba 4096 Apr 17 08:10 ..
-rw-r--r-- 1 oracle dba 935171743 Apr 17 08:02 p28429134_112040_Linux-x86-64.zip
-rw-r--r-- 1 oracle dba 122739146 Apr 17 08:02 p6880880_112000_Linux-x86-64.zip
|
패치파일 unzip(1번, 2번 노드)
|
1
2
|
$ cd /home/oracle/media/
$ unzip p28429134_112040_Linux-x86-64.zip
|
OPatch 최신버전으로 교체(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
(1번, 2번 노드)
# cd $GRID_HOME
# mv OPatch/ OPatchold
# unzip /home/oracle/media/p6880880_112000_Linux-x86-64.zip
# chown -R oracle:dba OPatch/
# $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 11.2.0.3.28
OPatch succeeded.
DB OPatch
$ cd $ORACLE_HOME
$ mv OPatch/ OPatchold
$ unzip /home/oracle/media/p6880880_112000_Linux-x86-64.zip
$ $ORACLE_HOME/OPatch/opatch version -oh $ORACLE_HOME
OPatch Version: 11.2.0.3.28
OPatch succeeded.
|
OPatch version : 11.2.0.3.28 로 교체됨
기존 invalid object 확인(1번, 2번 노드)
|
1
2
3
4
5
|
SQL> select count(*) from dba_objects where status!='VALID';
COUNT(*)
----------
0
|
db, grid 패치 버전 확인(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
|
GRID
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
18370031;Grid Infrastructure Patch Set Update : 11.2.0.4.x (gibugno)
OPatch succeeded.
DB
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
There are no Interim patches installed in this Oracle Home "/app/oracle/product/11.2.0/db_1".
OPatch succeeded.
|
ocm.rsp 파일생성(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
$ cd $GRID_HOME/OPatchold/ocm/bin
$ ls
emocmrsp
$ ./emocmrsp
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: <-- 엔터 입력
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y <-- y 입력
The OCM configuration response file (ocm.rsp) was successfully created.
$ ls
emocmrsp ocm.rsp
$ cp ocm.rsp /app/media/ |
ocm.rsp 파일이 생성됨
PSU 패치 진행(GRID, DB 동시 진행)(1번 노드)(root 유저)
자동으로 grid, db를 내리고 패치작업을 진행함
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# opatch auto /app/media/28429134/ -ocmrf /app/media/ocm.rsp
Executing /app/grid/product/11.2.0/grid/perl/bin/perl /app/grid/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /app/media -patchn 28429134 -ocmrf /app/media/ocm.rsp -paramfile /app/grid/product/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-41-27.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-41-27.report.log
2021-10-20 10:41:27: Starting Clusterware Patch Setup
Using configuration parameter file: /app/grid/product/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /app/oracle/product/11.2.0/db_1 ...
Stopped RAC /app/oracle/product/11.2.0/db_1 successfully
patch /app/media/28429134/27735020/custom/server/27735020 apply successful for home /app/oracle/product/11.2.0/db_1
patch /app/media/28429134/28204707 apply successful for home /app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /app/media/28429134/27735020 apply successful for home /app/grid/product/11.2.0/grid
patch /app/media/28429134/28204707 apply successful for home /app/grid/product/11.2.0/grid
patch /app/media/28429134/28204939 apply successful for home /app/grid/product/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /app/oracle/product/11.2.0/db_1 ...
Started RAC /app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
|
패치 로그(1번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
# tail -f /app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-41-27.report.log
*********** Configuration Data ***********
* It shows only those targets that will be patched in this session *
crs_home=/app/grid/product/11.2.0/grid owner=oracle opatch_ver=11.2.0.3.28
rac_home=/app/oracle/product/11.2.0/db_1 owner=oracle opatch_ver=11.2.0.3.28
*********** Steps to be executed as owner unless specified as root ***********
1: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
2: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
3: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
4: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
5: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
6: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
7: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
8: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
9: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
10: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
11: /app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole
12: /app/oracle/product/11.2.0/db_1/bin/emctl stop agent
13: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
14: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
15: /app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /app/oracle/product/11.2.0/db_1 -s /app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac1 -f
16: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/prepatch.sh -dbhome /app/oracle/product/11.2.0/db_1
17: /app/oracle/product/11.2.0/db_1/OPatch/opatch napply /app/media/28429134/27735020/custom/server/27735020 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
18: /app/oracle/product/11.2.0/db_1/OPatch/opatch napply /app/media/28429134/28204707 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
19: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/postpatch.sh -dbhome /app/oracle/product/11.2.0/db_1
20: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root
21: /app/grid/product/11.2.0/grid/tfa/bin/tfactl stop : run as root
22: /sbin/fuser -k /app/grid/product/11.2.0/grid/bin/crsctl.bin : run as root
23: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
24: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
25: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
26: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/27735020 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
27: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/28204707 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
28: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/28204939 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
29: /app/grid/product/11.2.0/grid/bin/emctl start dbconsole
30: /app/grid/product/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root
31: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root
32: /app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
33: /app/oracle/product/11.2.0/db_1/bin/emctl start agent
34: /app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /app/oracle/product/11.2.0/db_1 -s /app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac1
|
패치 로그를 보면 어떤 명령을 사용해서 패치를 진행했는지 알수 있음
PSU 패치 진행(GRID, DB 동시 진행)(2번 노드)(root 유저)
자동으로 GRID, DB를 내리고 패치작업을 진행함
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# opatch auto /app/media/28429134/ -ocmrf /app/media/ocm.rsp
Executing /app/grid/product/11.2.0/grid/perl/bin/perl /app/grid/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /app/media -patchn 28429134 -ocmrf /app/media/ocm.rsp -paramfile /app/grid/product/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-55-21.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-55-21.report.log
2021-10-20 10:55:21: Starting Clusterware Patch Setup
Using configuration parameter file: /app/grid/product/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /app/oracle/product/11.2.0/db_1 ...
Stopped RAC /app/oracle/product/11.2.0/db_1 successfully
patch /app/media/28429134/27735020/custom/server/27735020 apply successful for home /app/oracle/product/11.2.0/db_1
patch /app/media/28429134/28204707 apply successful for home /app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /app/media/28429134/27735020 apply successful for home /app/grid/product/11.2.0/grid
patch /app/media/28429134/28204707 apply successful for home /app/grid/product/11.2.0/grid
patch /app/media/28429134/28204939 apply successful for home /app/grid/product/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /app/oracle/product/11.2.0/db_1 ...
Started RAC /app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
|
패치 로그(2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
$ tail -f /app/grid/product/11.2.0/grid/cfgtoollogs/opatchauto2021-10-20_10-55-21.report.log
*********** Configuration Data ***********
* It shows only those targets that will be patched in this session *
crs_home=/app/grid/product/11.2.0/grid owner=oracle opatch_ver=11.2.0.3.28
rac_home=/app/oracle/product/11.2.0/db_1 owner=oracle opatch_ver=11.2.0.3.28
*********** Steps to be executed as owner unless specified as root ***********
1: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
2: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
3: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
4: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
5: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
6: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
7: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
8: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
9: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
10: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
11: /app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole
12: /app/oracle/product/11.2.0/db_1/bin/emctl stop agent
13: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020/custom/server/27735020 -oh /app/oracle/product/11.2.0/db_1
14: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/oracle/product/11.2.0/db_1
15: /app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /app/oracle/product/11.2.0/db_1 -s /app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac2 -f
16: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/prepatch.sh -dbhome /app/oracle/product/11.2.0/db_1
17: /app/oracle/product/11.2.0/db_1/OPatch/opatch napply /app/media/28429134/27735020/custom/server/27735020 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
18: /app/oracle/product/11.2.0/db_1/OPatch/opatch napply /app/media/28429134/28204707 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
19: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/postpatch.sh -dbhome /app/oracle/product/11.2.0/db_1
20: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root
21: /app/grid/product/11.2.0/grid/tfa/bin/tfactl stop : run as root
22: /sbin/fuser -k /app/grid/product/11.2.0/grid/bin/crsctl.bin : run as root
23: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
24: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
25: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
26: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/27735020 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
27: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/28204707 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
28: /app/grid/product/11.2.0/grid/OPatch/opatch napply /app/media/28429134/28204939 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
29: /app/grid/product/11.2.0/grid/bin/emctl start dbconsole
30: /app/grid/product/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root
31: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root
32: /app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
33: /app/oracle/product/11.2.0/db_1/bin/emctl start agent
34: /app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /app/oracle/product/11.2.0/db_1 -s /app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n rac2
|
패치 로그를 보면 어떤 명령을 사용해서 패치를 진행했는지 알수 있음
GRID, DB 패치정보 확인(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
10
11
12
|
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
28204939;ACFS Patch Set Update : 11.2.0.4.181016 (28204939)
27735020;OCW Patch Set Update : 11.2.0.4.181016 (27735020)
OPatch succeeded.
$ $ORACLE_HOME/OPatch/opatch lspatches -oh $ORACLE_HOME
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
27735020;OCW Patch Set Update : 11.2.0.4.181016 (27735020)
OPatch succeeded.
|
수정(패치)된 sql 파일을 db에도 적용 및 invalid object 검사(한쪽 노드에서만)
|
1
2
|
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> @?/rdbms/admin/utlrp.sql
|
패치 내역 확인(한쪽 노드에서만)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A20
COLUMN NAMESPACE FORMAT A20
COLUMN VERSION FORMAT A10
COLUMN COMMENTS FORMAT A30
COLUMN BUNDLE_SERIES FORMAT A10
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
-------------------- -------------------- -------------------- ---------- ---------- ------------------------------ ----------
20180313 02:30:34 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
20211020 07:52:45 APPLY SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
20211020 09:51:33 ROLLBACK SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
20211020 09:51:33 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
20211020 11:08:41 APPLY SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
|
PSU 패치가 정상적으로 적용됨
참조 : 28429134, 28204707 readme 문서, 2217053.1, 2265726.1, 1641136.1
https://positivemh.tistory.com/774
Oracle 11g R2 RAC PSU 롤백 가이드(opatch auto)
OS환경 : Oracle Linux 7.4 (64bit) DB 환경 : Oracle Database 11.2.0.4 RAC 방법 : Oracle 11g R2 RAC PSU 롤백 가이드(opatch auto) Oracle 11g R2 RAC PSU 패치 가이드(opatch auto)(https://positivem..
positivemh.tistory.com
https://positivemh.tistory.com/769
blog.naver.com/hanajava/220734801954
'ORACLE > Install' 카테고리의 다른 글
| Oracle Linux 8.4에 Oracle 19c ADG 설치 가이드_Part 1 (0) | 2022.03.28 |
|---|---|
| Oracle 11g R2 RAC PSU 롤백 가이드(opatch auto) (0) | 2021.10.21 |
| Oracle 11g R2 RAC PSU 롤백 가이드 (0) | 2021.10.20 |
| Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 3 (9) | 2021.10.15 |
| Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 2 (13) | 2021.10.15 |