Oracle Goldengate 12c打pus補丁
Goldengate 12c生產環境抽取程式遇到一個故障,上mos查了下報錯,發現是ogg的一個bug,需要打psu補丁解決。ogg打補丁的步驟如下:
1.驗證opatch是否正常顯示相關資訊
1.1切換到設定ogg的ORACLE_HOME
export ORACLE_HOME=/opt/app/OGG_12
1.2執行 optch lsinventory
/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,並解壓
unzip p24449451_12201160823_Linux-x86-64.zip
2.2 停止ogg所有程式,停止mgr,並檢視所有程式狀態是否為stop
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 進入解壓目錄,執行打補丁命令
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
oracle@bd-dev-oracle-104:/opt/app/24449451$cd oracle@bd-dev-oracle-104:~$source .bash_profile
2.5 啟動Ogg mgr和相關程式
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和相關程式
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
export ORACLE_HOME=/opt/app/OGG_12
3.3 進入解壓目錄執行
oracle@bd-dev-oracle-104:/opt/app/24449451$/opt/app/OGG_12/OPatch/opatch rollback -id 24449451
3.4 切換ORACLE_HOME環境變數指向ORACLE DATABASE
oracle@bd-dev-oracle-104:~$cd /opt/app/OGG_12/ oracle@bd-dev-oracle-104:/opt/app/OGG_12$./ggsci
3.5 啟動Ogg mgr和相關程式
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/69982136/viewspace-2716146/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle打補丁回顧Oracle
- Oracle EBS中打補丁Oracle
- 關於12c安裝後打補丁
- 使用OPatch給Oracle打補丁Oracle
- ORACLE打補丁的方法和案例Oracle
- ORACLE11G DG打補丁Oracle
- Oracle資料庫打補丁方法Oracle資料庫
- oracle 小補丁能全部打嗎?Oracle
- 【opatch】Oracle打補丁工具opatch簡介Oracle
- 在windows上打Oracle的CPU補丁WindowsOracle
- 給Oracle資料庫打補丁(轉)Oracle資料庫
- MAX-OPEN-SOCK-COUNT weblogic 12C 打補丁方法Web
- 【UP_ORACLE】如何給Oracle DG打補丁(二)備庫安裝補丁步驟Oracle
- 【UP_ORACLE】如何給Oracle DG打補丁(三)主庫安裝補丁步驟Oracle
- Oracle RAC 19.3打19.5.1 RU補丁Oracle
- 12C RAC 打31720486補丁 後報錯處理
- 打Oracle最新CPU patch與打臨時補丁的區別Oracle
- Oracle EBS APP & DB 打補丁過程簡述OracleAPP
- 給oracle打Patch 9352237補丁Oracle
- oracle 補丁Oracle
- Linux檔案打補丁Linux
- SAP打補丁(Tcode:SPAM)
- windows oracle 11201打補丁報錯WindowsOracle
- oracle 19c rac打補丁常見錯誤Oracle
- oracle12c之 單機12.1.0.1打補丁Oracle
- 安裝oracle 11g RAC時打8670579?補丁Oracle
- Oracle打補丁時無法正確顯示英文Oracle
- 安裝oraInventory和使用opatch給Oracle打補丁AIOracle
- zt_使用opatch給oracle打補丁patch_bugOracle
- 記一次12c pdb打補丁失敗處理過程
- 【UP_ORACLE】如何給Oracle DG打補丁(一)整體思路Oracle
- Oracle的補丁Oracle
- weblogic的版本及打補丁Web
- opatch 工具打補丁使用說明
- 批處理打補丁的方法
- Oracle 19c RAC打補丁過程避坑指南Oracle
- Oracle 11g RAC自動打GI PSU補丁Oracle
- ORACLE RAC的全自動 打補丁標準化文件Oracle