标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-01595 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,738)
- DB2 (22)
- MySQL (75)
- Oracle (1,588)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (582)
- Oracle安装升级 (95)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (83)
- PostgreSQL (27)
- pdu工具 (5)
- PostgreSQL恢复 (9)
- SQL Server (29)
- SQL Server恢复 (10)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- ORA-39773: parse of metadata stream failed故障处理
- sql数据库备份失败—失败: 23(数据错误(循环冗余检查)
- vmdk文件被加密恢复(虚拟机文件加密)
- 差点被误操作的ORA-600 kcratr_nab_less_than_odr故障
- win平台19c 打patch遭遇2个小问题汇总
- pg单个数据库目录恢复-pdu恢复单个数据库目录数据
- pg删除数据恢复—pdu恢复pg delete数据
- .[OnlyBuy@cyberfear.com].REVRAC勒索mysql恢复
- 表dml操作权限授权给public,导致只读用户失效
- 21c数据库恢复遭遇ora-600 ktugct: corruption detected
- pg_control丢失/损坏处理
- 当前主流数据库版本服务支持周期-202503
- pg启动报invalid checkpoint record处理
- 删除redo导致ORA-00313 ORA-00312故障处理
- Navicat连接postgresql时出现column “datlastsysoid” does not exist错误解决
- aix磁盘损坏oracle数据库恢复
- pg误删除数据恢复(PostgreSQL delete数据恢复)
- PostgreSQL表文件损坏恢复—pdu恢复损坏的表文件
- linux rm -rf 删除数据文件恢复
- PostgreSQL恢复工具—pdu恢复单个表文件
标签归档:goldengate 19安装
GoldenGate 19安装和打patch
1. 下载V983658-01.zip,并上传到/tmp中
2. 安装19.1.0.0.4版本ogg,需要修改静默文件/tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp中修改这两个参数
INSTALL_OPTION=ORA19c SOFTWARE_LOCATION=/tmp/ogg
3. 静默安装ogg
[oracle@ora19c:/home/oracle]$ /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller -silent \ -responseFile /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 6106 MB Passed Checking swap space: must be greater than 150 MB. Actual 1257 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-12-02_10-57-00PM. Please wait ... [oracle@ora19c:/home/oracle]$ You can find the log of this install session at: /data/app/oraInventory/logs/installActions2024-12-02_10-57-00PM.log Successfully Setup Software. The installation of Oracle GoldenGate Core was successful. Please check '/data/app/oraInventory/logs/silentInstall2024-12-02_10-57-00PM.log' for more details. [oracle@ora19c:/home/oracle]$ cd /tmp/ogg [oracle@ora19c:/tmp/ogg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29 Operating system character set identified as UTF-8. Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved. GGSCI (ora19c) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED GGSCI (ora19c) 2> create subdirs Creating subdirectories under current directory /tmp/ogg Parameter file /tmp/ogg/dirprm: created. Report file /tmp/ogg/dirrpt: created. Checkpoint file /tmp/ogg/dirchk: created. Process status files /tmp/ogg/dirpcs: created. SQL script files /tmp/ogg/dirsql: created. Database definitions files /tmp/ogg/dirdef: created. Extract data files /tmp/ogg/dirdat: created. Temporary files /tmp/ogg/dirtmp: created. Credential store files /tmp/ogg/dircrd: created. Masterkey wallet files /tmp/ogg/dirwlt: created. Dump files /tmp/ogg/dirdmp: created. GGSCI (ora19c) 3> exit
4. 下载patch p37236684_1925000OGGRU_Linux-x86-64.zip 和opatch p6880880_190000_Linux-x86-64.zip(12.2.0.1.44版本) 并解压
[oracle@ora19c:/tmp]$ cd /tmp/ [oracle@ora19c:/tmp]$ unzip p37236684_1925000OGGRU_Linux-x86-64.zip [oracle@ora19c:/tmp]$ cd /tmp/ogg [oracle@ora19c:/tmp/ogg]$ mv OPatch/ OPatch_bak [oracle@ora19c:/tmp/ogg]$ unzip /tmp/p6880880_190000_Linux-x86-64.zip [oracle@ora19c:/tmp/ogg]$ /tmp/ogg/OPatch/opatch version OPatch Version: 12.2.0.1.44 OPatch succeeded.
5. 对19.1.0.0.4版本ogg 打上最新patch(37236684)
[oracle@ora19c:/tmp/ogg]$ export ORACLE_HOME=/tmp/ogg [oracle@ora19c:/tmp/ogg]$ OPatch/opatch apply /tmp/37236684/ Oracle Interim Patch Installer version 12.2.0.1.44 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /tmp/ogg Central Inventory : /data/app/oraInventory from : /tmp/ogg/oraInst.loc OPatch version : 12.2.0.1.44 OUI version : 12.2.0.4.0 Log file location : /tmp/ogg/cfgtoollogs/opatch/opatch2024-12-02_23-04-26PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 37236684 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 = '/tmp/ogg') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '37236684' to OH '/tmp/ogg' Patching component oracle.oggcore.ora19c, 19.1.0.0.0... Patch 37236684 successfully applied. Log file location: /tmp/ogg/cfgtoollogs/opatch/opatch2024-12-02_23-04-26PM_1.log OPatch succeeded. [oracle@ora19c:/tmp/ogg]$ OPatch/opatch lspatches 37236684; OPatch succeeded. [oracle@ora19c:/tmp/ogg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 19.25.0.0.241105 OGGCORE_19.25.0.0.0OGGRU_PLATFORMS_241118.0932_FBO Linux, x64, 64bit (optimized), Oracle 19c on Nov 18 2024 13:19:46 Operating system character set identified as UTF-8. Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved. GGSCI (ora19c) 1>