GGSCI - Golden gate 19c Installation on linux machine

 GGSCI - Golden gate 19c Installation on linux machine  

Installation with manager options

• [oracle@srv3 Disk1]$ ./runInstaller 

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 3797 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 8191 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-11-10_04-47-34PM. Please wait ...[oracle@srv3 Disk1]$ 

• Add gg_home and ld_library on bash_profile

[oracle@srv3 ~]$ source ~/.bash_profile

[oracle@srv3 ~]$ cd $GG_HOME

[oracle@srv3 sourcegg1]$ ./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 (srv3.example.com) 1>

GGSCI (srv3.example.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (srv3.example.com) 2>

• Installation of golden gate without  manager prcocess 

[oracle@srv4 ~]$ cd fbo_ggs_Linux_x64_shiphome/

[oracle@srv4 fbo_ggs_Linux_x64_shiphome]$ ll

total 4

drwxrwxr-x. 5 oracle oinstall 4096 Oct 18  2019 Disk1

[oracle@srv4 fbo_ggs_Linux_x64_shiphome]$ cd Disk1/

[oracle@srv4 Disk1]$ ll

total 16

drwxrwxr-x.  4 oracle oinstall 4096 Oct 18  2019 install

drwxrwxr-x.  2 oracle oinstall 4096 Oct 18  2019 response

-rwxrwxr-x.  1 oracle oinstall  918 Oct 18  2019 runInstaller

drwxrwxr-x. 12 oracle oinstall 4096 Oct 18  2019 stage

[oracle@srv4 Disk1]$ ./runInstaller 

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 3367 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 8184 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-11-11_04-56-53PM. Please wait ...[oracle@srv4 Disk1]$ 

• Set golden gate home in bash_profile

[oracle@srv4 ~]$ source ~./bash_profile

bash: ~./bash_profile: No such file or directory

[oracle@srv4 ~]$ source ~/.bash_profile

[oracle@srv4 ~]$ cd $GG_HOME

[oracle@srv4 targetgg1]$ pwd

/u01/app/oracle/product/targetgg1

[oracle@srv4 targetgg1]$ ./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 (srv4.example.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

• Create sub directories

GGSCI (srv4.example.com) 2> create subdirs

Creating subdirectories under current directory /u01/app/oracle/product/targetgg1

Parameter file                 /u01/app/oracle/product/targetgg1/dirprm: created.

Report file                    /u01/app/oracle/product/targetgg1/dirrpt: created.

Checkpoint file                /u01/app/oracle/product/targetgg1/dirchk: created.

Process status files           /u01/app/oracle/product/targetgg1/dirpcs: created.

SQL script files               /u01/app/oracle/product/targetgg1/dirsql: created.

Database definitions files     /u01/app/oracle/product/targetgg1/dirdef: created.

Extract data files             /u01/app/oracle/product/targetgg1/dirdat: created.

Temporary files                /u01/app/oracle/product/targetgg1/dirtmp: created.

Credential store files         /u01/app/oracle/product/targetgg1/dircrd: created.

Masterkey wallet files         /u01/app/oracle/product/targetgg1/dirwlt: created.

Dump files                     /u01/app/oracle/product/targetgg1/dirdmp: created.

GGSCI (srv4.example.com) 3>

[oracle@srv4 targetgg1]$ ./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.

• Set manager process information 

GGSCI (srv4.example.com) 1> start mgr

ERROR: Parameter file /u01/app/oracle/product/targetgg1/dirprm/mgr.prm does not exist.

GGSCI (srv4.example.com) 6> edit param mgr

with add the port number : 

port 8080

GGSCI (srv4.example.com) 7> start mgr

Manager started.

GGSCI (srv4.example.com) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (srv4.example.com) 9>

[oracle@srv4 dirprm]$ pwd

/u01/app/oracle/product/targetgg1/dirprm

[oracle@srv4 dirprm]$

[oracle@srv4 targetgg1]$ cd dirprm

[oracle@srv4 dirprm]$ ll

total 4

-rw-r-----. 1 oracle oinstall 11 Nov 11 17:20 mgr.prm

[oracle@srv4 dirprm]$ cat mgr.prm

PORT 8080

[oracle@srv4 dirprm]$

• login source GG server   srv6 using ggsci

GGSCI (srv6.example.com) 9> dblogin userid c##ggsource@gg1,password ggsource

Successfully logged into database GG1.

GGSCI (srv6.example.com as c##ggsource@sourcegg1/GG1) 10>

• login target GG Server srv7 using ggsci

GGSCI (srv7.example.com) 5>  dblogin userid c##ggtarget@ggt,password ggtarget

Successfully logged into database GGT.

GGSCI (srv7.example.com as c##ggtarget@targetgg/GGT) 6>