富达主管{7288481}Oracle Goldengate 12c打pus补丁
1.验证opatch是否正常显示相关信息
1.1切换到设置ogg的ORACLE_HOME
|
1 |
export
ORACLE_HOME=
/opt/app/OGG_12 |
1.2执行 optch lsinventory
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 |
/opt/app/OGG_12/OPatch/optch
lsinventory
oracle@bd-dev-oracle-104:
/opt/app/oraInventory/ContentsXML
$
/opt/app/OGG_12/OPatch/opatch
lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home :
/opt/app/OGG_12
Central Inventory :
/opt/app/oraInventory
from :
/etc/oraInst
.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log
file
location :
/opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_13-52-07PM
.log
Lsinventory Output
file
location :
/opt/app/OGG_12/cfgtoollogs/opatch/lsinv/lsinventory2018-12-18_13-52-07PM
.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle GoldenGate Core 12.2.0.0.0
There are 1 products installed
in
this Oracle Home.
There are no Interim patches installed
in
this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded. |
2.开始打PSU补丁
2.1 上传补丁包到/opt/app,并解压
|
1 |
unzip p24449451_12201160823_Linux-x86-64.zip |
2.2 停止ogg所有进程，停止mgr,并查看所有进程状态是否为stop
|
1
2
3 |
GGSCI (bd-dev-oracle-104) 1>STOP FH_E01
GGSCI (bd-dev-oracle-104) 2>STOP MGR
GGSCI (bd-dev-oracle-104) 3>INFO
ALL |
2.3 进入解压目录,执行打补丁命令
|
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 |
oracle@bd-dev-oracle-104:
/opt/app
$
cd
24449451/
oracle@bd-dev-oracle-104:
/opt/app/24449451
$
/opt/app/OGG_12/OPatch/opatch
apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home :
/opt/app/OGG_12
Central Inventory :
/opt/app/oraInventory
from :
/etc/oraInst
.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log
file
location :
/opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_16-07-26PM
.log
Applying interim patch
'24449451'
to OH
'/opt/app/OGG_12'
Verifying environment and performing prerequisite checks...
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please
shutdown
Oracle instances running out of this ORACLE_HOME on the
local
system.
(Oracle Home =
'/opt/app/OGG_12'
)
Is the
local
system ready
for
patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.oggcore.ora11g, 12.2.0.0.0...
Patch 24449451 successfully applied
Log
file
location:
/opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_16-07-26PM
.log
OPatch succeeded. |
2.4 切换ORACLE_HOME环境变量指向ORACLE DATABASE
|
1
2 |
oracle@bd-dev-oracle-104:
/opt/app/24449451
$
cd
oracle@bd-dev-oracle-104:~$
source
.bash_profile |
2.5 启动Ogg mgr和相关进程
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 |
oracle@bd-dev-oracle-104:~$
cd
/opt/app/OGG_12/
oracle@bd-dev-oracle-104:
/opt/app/OGG_12
$.
/ggsci
Oracle GoldenGate Command Interpreter
for
Oracle
Version 12.2.0.1.160823 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160805.1058_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 5 2016 22:07:01
Operating system character
set
identified as UTF-8.
Copyright (C) 1995, 2016, Oracle and
/or
its affiliates. All rights reserved.
GGSCI (bd-dev-oracle-104) 1> info all
GGSCI (bd-dev-oracle-104) 2> start mgr
Manager started.
GGSCI (bd-dev-oracle-104) 5> start FH_E01
Sending START request to MANAGER ...
EXTRACT FH_E01 starting
GGSCI (bd-dev-oracle-104) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING FH_E01 00:00:05 00:02:40 |
3.回退步骤
3.1.停止ogg mgr和相关进程
|
1
2
3 |
GGSCI (bd-dev-oracle-104) 1>STOP FH_E01
GGSCI (bd-dev-oracle-104) 2>STOP MGR
GGSCI (bd-dev-oracle-104) 3>INFO
ALL |
3.2 切换ORACLE_HOME环境变量指向OGG
|
1 |
export
ORACLE_HOME=
/opt/app/OGG_12 |
3.3 进入解压目录执行
|
1 |
oracle@bd-dev-oracle-104:
/opt/app/24449451
$
/opt/app/OGG_12/OPatch/opatch
rollback -
id
24449451 |
3.4 切换ORACLE_HOME环境变量指向ORACLE DATABASE
|
1
2 |
oracle@bd-dev-oracle-104:~$
cd
/opt/app/OGG_12/
oracle@bd-dev-oracle-104:
/opt/app/OGG_12
$.
/ggsci |
3.5 启动Ogg mgr和相关进程
|
1
2
3
4
5
6
7
8
9
10
11 |
GGSCI (bd-dev-oracle-104) 1>START MGR
Manager started.
GGSCI (bd-dev-oracle-104) 2>START FH_E01
Sending START request to MANAGER ...
EXTRACT FH_E01 starting
GGSCI (bd-dev-oracle-104) 3>INFO ALL
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING FH_E01 00:00:05 00:02:40
|
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/69989788/viewspace-2739592/，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
