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://positivemh.tistory.com/773) 패치 후
롤링으로 롤백하는 방법에 대해 설명함
기존 패치내역 확인
|
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
|
11.2.0.4 181016 패치가 존재함
OPatch 에서도 패치내역 확인
|
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
|
GRID
$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME
Oracle Interim Patch Installer version 11.2.0.3.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /app/grid/product/11.2.0/grid
Central Inventory : /app/oraInventory
from : /app/grid/product/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.28
OUI version : 11.2.0.4.0
Log file location : /app/grid/product/11.2.0/grid/cfgtoollogs/opatch/opatch2021-10-20_11-12-19AM_1.log
Lsinventory Output file location : /app/grid/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2021-10-20_11-12-19AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 28204939 : applied on Wed Oct 20 10:49:17 EDT 2021
Unique Patch ID: 22366206
Patch description: "ACFS Patch Set Update : 11.2.0.4.181016 (28204939)"
Created on 31 Jul 2018, 08:37:40 hrs PST8PDT
Bugs fixed:
DB
$ $ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /app/oracle/product/11.2.0/db_1
Central Inventory : /app/oraInventory
from : /app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.28
OUI version : 11.2.0.4.0
Log file location : /app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-10-20_11-12-28AM_1.log
Lsinventory Output file location : /app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-10-20_11-12-28AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 28204707 : applied on Wed Oct 20 10:44:02 EDT 2021
Unique Patch ID: 22491169
Patch description: "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
Created on 19 Sep 2018, 03:24:06 hrs PST8PDT
|
PSU 롤백 진행(GRID, DB 동시 진행)(1번 노드)(root 유저)
|
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/ -rollback -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 -rollback -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_11-15-22.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_11-15-22.report.log
2021-10-20 11:15:22: 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 27735020 rollback successful for home /app/oracle/product/11.2.0/db_1
patch 28204707 rollback successful for home /app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 27735020 rollback successful for home /app/grid/product/11.2.0/grid
patch 28204707 rollback successful for home /app/grid/product/11.2.0/grid
patch 28204939 rollback 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_11-15-22.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/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
4: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
5: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
6: /app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole
7: /app/oracle/product/11.2.0/db_1/bin/emctl stop agent
8: /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
9: /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
10: /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
11: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/prepatch.sh -dbhome /app/oracle/product/11.2.0/db_1
12: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable -id 27735020 -oh /app/oracle/product/11.2.0/db_1
13: /app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 27735020 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
14: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable -id 28204707 -oh /app/oracle/product/11.2.0/db_1
15: /app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 28204707 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
16: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/postpatch.sh -dbhome /app/oracle/product/11.2.0/db_1
17: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root
18: /app/grid/product/11.2.0/grid/tfa/bin/tfactl stop : run as root
19: /sbin/fuser -k /app/grid/product/11.2.0/grid/bin/crsctl.bin : run as root
20: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
21: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
22: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
23: /app/grid/product/11.2.0/grid/OPatch/opatch prereq checkRollbackable -id 27735020 -oh /app/grid/product/11.2.0/grid
24: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 27735020 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
25: /app/grid/product/11.2.0/grid/OPatch/opatch prereq checkRollbackable -id 28204707 -oh /app/grid/product/11.2.0/grid
26: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 28204707 -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 prereq checkRollbackable -id 28204939 -oh /app/grid/product/11.2.0/grid
28: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 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 유저)
|
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/ -rollback -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 -rollback -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_11-24-38.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_11-24-38.report.log
2021-10-20 11:24:38: 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 27735020 rollback successful for home /app/oracle/product/11.2.0/db_1
patch 28204707 rollback successful for home /app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 27735020 rollback successful for home /app/grid/product/11.2.0/grid
patch 28204707 rollback successful for home /app/grid/product/11.2.0/grid
patch 28204939 rollback 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_11-24-38.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/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
4: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
5: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
6: /app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole
7: /app/oracle/product/11.2.0/db_1/bin/emctl stop agent
8: /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
9: /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
10: /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
11: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/prepatch.sh -dbhome /app/oracle/product/11.2.0/db_1
12: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable -id 27735020 -oh /app/oracle/product/11.2.0/db_1
13: /app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 27735020 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
14: /app/oracle/product/11.2.0/db_1/OPatch/opatch prereq checkRollbackable -id 28204707 -oh /app/oracle/product/11.2.0/db_1
15: /app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 28204707 -local -silent -oh /app/oracle/product/11.2.0/db_1 -invPtrLoc /app/oracle/product/11.2.0/db_1/oraInst.loc
16: /app/media/28429134/27735020/custom/server/27735020/custom/scripts/postpatch.sh -dbhome /app/oracle/product/11.2.0/db_1
17: /app/grid/product/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root
18: /app/grid/product/11.2.0/grid/tfa/bin/tfactl stop : run as root
19: /sbin/fuser -k /app/grid/product/11.2.0/grid/bin/crsctl.bin : run as root
20: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/27735020 -oh /app/grid/product/11.2.0/grid
21: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204707 -oh /app/grid/product/11.2.0/grid
22: /app/grid/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /app/media/28429134/28204939 -oh /app/grid/product/11.2.0/grid
23: /app/grid/product/11.2.0/grid/OPatch/opatch prereq checkRollbackable -id 27735020 -oh /app/grid/product/11.2.0/grid
24: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 27735020 -local -silent -oh /app/grid/product/11.2.0/grid -invPtrLoc /app/grid/product/11.2.0/grid/oraInst.loc
25: /app/grid/product/11.2.0/grid/OPatch/opatch prereq checkRollbackable -id 28204707 -oh /app/grid/product/11.2.0/grid
26: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 28204707 -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 prereq checkRollbackable -id 28204939 -oh /app/grid/product/11.2.0/grid
28: /app/grid/product/11.2.0/grid/OPatch/opatch rollback -id 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
|
롤백 로그를 보면 어떤 명령을 사용해서 패치를 진행했는지 알수 있음
롤백 sql 실행
수정(롤백)된 sql 파일을 db에도 적용 및 invalid object 검사(한쪽 노드에서만)
|
1
2
|
SQL> @?/rdbms/admin/catbundle_PSU_RACDB_ROLLBACK.sql
SQL> @?/rdbms/admin/utlrp.sql
|
GRID, DB opatch 패치정보 확인(1번, 2번 노드)
|
1
2
3
4
5
6
7
8
9
|
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
18370031;Grid Infrastructure Patch Set Update : 11.2.0.4.x (gibugno)
OPatch succeeded.
$ $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.
|
PSU 패치내역이 사라짐
롤백 내역 확인
|
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
|
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
20211020 11:34:43 ROLLBACK SERVER 11.2.0.4 181016 PSU 11.2.0.4.181016 PSU
20211020 11:34:43 APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 PSU
7 rows selected.
|
정상적으로 롤백됨
참조 : 28429134, 28204707 readme 문서, 2217053.1, 2265726.1, 1641136.1
https://positivemh.tistory.com/773
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) 1.2.0.4 기본 설치만 되어있는 2node RAC db에 opatch auto로 181016..
positivemh.tistory.com
https://positivemh.tistory.com/769
blog.naver.com/hanajava/220734801954
'ORACLE > Install' 카테고리의 다른 글
| Oracle Linux 8.4에 Oracle 19c ADG 설치 가이드_Part 2 (1) | 2022.03.28 |
|---|---|
| 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 |