Thursday, 19 October 2023

Install Oracle GoldenGate 19c on Linux 7

STEPS :

Environment
Download oracle 19c goldengate software
Create a separate directory to copy and unzip the software
Install Oracle 19c Goldengate using the install wizard

Verify Central Inventory
Set Environmental Variables
Login to ggsci prompt and verify the manager process status

Environment

Server Name                 : Standby OS Version                 : Red Hat Enterprise Linux Server release 7.5 Database Version         : 19.3.0.0 GoldenGate Version         : 19.1.0.0.4 for oracle db 19 Oracle Home                 : /u02/app/oracle/product/19c/dbhome_1 GoldenGate Home : /u01/app/GG_HOME
Download oracle 19c goldengate software

or
https://edelivery.oracle.com >> Select a Product Pack: Oracle Fusion Middleware

Create a separate directory to copy and unzip the software

[oracle@standby ~]$ cd /u01/
[oracle@standby u01]$ mkdir -p /u01/GG_SOFT
[oracle@standby u01]$ cd /u01/GG_SOFT
[oracle@standby GG_SOFT]$ ls
V983658-01.zip
[oracle@standby GG_SOFT]$ unzip V983658-01.zip

Install Oracle 19c Goldengate using the install wizard

[oracle@standby u01]$ mkdir -p /u01/app/GG_HOME


Install Oracle 19c Goldengate using the install wizard







 Verify Central Inventory

[oracle@standby ContentsXML]$ pwd /u01/app/oraInventory/ContentsXML [oracle@standby ContentsXML]$ [oracle@standby ContentsXML]$ cat inventory.xml | grep -i /u01/app/GG_HOME <HOME NAME="OraHome1" LOC="/u01/app/GG_HOME" TYPE="O" IDX="2"/> [oracle@standby ContentsXML]$

Set Environmental Variables

[oracle@standby ~]$ cat 19cogg.env GG19C=/u01/app/GG_HOME; export GG19C ORACLE_HOME=/u02/app/oracle/product/19c/dbhome_1; export ORACLE_HOME ORACLE_SID=standby; export ORACLE_SID PATH=$PATH:/u01/app/GG_HOME; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/GG_HOME; export LD_LIBRARY_PATH alias ggsci='cd $GG19C; ./ggsci' [oracle@ standby ~]$

Login to ggsci prompt and verify the manager process status

[oracle@standby ~]$ 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 18 2019 01:38:51 Operating system character set identified as UTF-8. Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved. Login to ggsci prompt and verify the manager status GGSCI (standby) 1> GGSCI (standby) 2> info mgr Manager is running (IP port TCP:standby.7809, Process ID 14663). GGSCI (standby) 3>

Oracle GoldenGate 19c is installed successfully





I hope this article helped you. Your suggestions/feedback are most welcome.

Keep learning... Have a great day!!!


Thank you,
Amit Pawar
Email: amitpawar.dba@gmail.com
WhatsApp No: +91-8454841011




No comments:

Post a Comment