 |
 |
********************************************************************************
* Description: Oracle Golden Gate 19c configuration with 19c database on RHEL 8
* Date: 03:00 PM EST, 12/30/2020
********************************************************************************
<1> Environment Overview:
|
|__ o. The infrastructure is based on AWS Cloud platform with 2 t2.xlarge EC2 instances.
|
|__ o. Database version: 19.3.0.0.0
|
|__ o. Goldengate version: 19.1.0.0.4
|
|__ o. Server OS: RHEL8 [AWS only provides RHEL8 EC2 image. Until now, DB 19c is certified compatability by RHEL8, but not GG 19c]
|
|__ $ cat /etc/*release*
NAME="Red Hat Enterprise Linux"
VERSION="8.3 (Ootpa)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="8.3"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Red Hat Enterprise Linux 8.3 (Ootpa)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:8.3:GA"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"
REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 8"
REDHAT_BUGZILLA_PRODUCT_VERSION=8.3
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.3"
Red Hat Enterprise Linux release 8.3 (Ootpa)
Red Hat Enterprise Linux release 8.3 (Ootpa)
cpe:/o:redhat:enterprise_linux:8.3:ga
<2> Preinstall - Mount 50 GB disk as data file system as "root":
|
|__ $ fdisk /dev/xvdb
|
| Welcome to fdisk (util-linux 2.32.1).
| Changes will remain in memory only, until you decide to write them.
| Be careful before using the write command.
|
| Device does not contain a recognized partition table.
| Created a new DOS disklabel with disk identifier 0x198bec7f.
|
| Command (m for help): n
| Partition type
| p primary (0 primary, 0 extended, 4 free)
| e extended (container for logical partitions)
| Select (default p): p
| Partition number (1-4, default 1): 1
| First sector (2048-104857599, default 2048):
| Last sector, +sectors or +size{K,M,G,T,P} (2048-104857599, default 104857599):
|
| Created a new partition 1 of type 'Linux' and of size 50 GiB.
|
| Command (m for help): p
| Disk /dev/xvdb: 50 GiB, 53687091200 bytes, 104857600 sectors
| Units: sectors of 1 * 512 = 512 bytes
| Sector size (logical/physical): 512 bytes / 512 bytes
| I/O size (minimum/optimal): 512 bytes / 512 bytes
| Disklabel type: dos
| Disk identifier: 0x198bec7f
|
| Device Boot Start End Sectors Size Id Type
| /dev/xvdb1 2048 104857599 104855552 50G 83 Linux
|
| Command (m for help): w
| The partition table has been altered.
| Calling ioctl() to re-read partition table.
| Syncing disks.
|
|
|
|__ $ mkfs -t ext4 /dev/xvdb1
|
| mke2fs 1.45.6 (20-Mar-2020)
| Creating filesystem with 13106944 4k blocks and 3276800 inodes
| Filesystem UUID: 198ee540-f834-4539-8cc1-a8b50586dc78
| Superblock backups stored on blocks:
| 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
| 4096000, 7962624, 11239424
|
| Allocating group tables: done
| Writing inode tables: done
| Creating journal (65536 blocks): done
| Writing superblocks and filesystem accounting information: done
|
|
|__ $ mkdir /u01
|
|__ $ mount /dev/xvdb1 /u01
|
|__ $ sudo -i blkid
|
| /dev/xvda2: UUID="949779ce-46aa-434e-8eb0-852514a5d69e" BLOCK_SIZE="512" TYPE="xfs" PARTUUID="f3dc379a-e15b-46c0-82ff-b9c089f7f27f"
| /dev/xvda1: PARTUUID="1227fbb3-a2f6-4933-a7ac-98432f8f15af"
| /dev/xvdb1: UUID="198ee540-f834-4539-8cc1-a8b50586dc78" BLOCK_SIZE="4096" TYPE="ext4" PARTUUID="198bec7f-01"
|
|
|__ $ vi /etc/fstab
UUID=198ee540-f834-4539-8cc1-a8b50586dc78 /u01 ext4 defaults,nofail 1 2
<3> Preinstall - Create 15 GB swap file to meet minimum 19c RDBMS software installation critieria:
|
|__ $ mkdir -p /u01/system
|
|__ $ dd if=/dev/zero of=/u01/system/swapfile bs=1024 count=5242880
| dd if=/dev/zero of=/u01/system/swapfile01 bs=1024 count=15728640
|
| 5242880+0 records in
| 5242880+0 records out
| 5368709120 bytes (5.4 GB, 5.0 GiB) copied, 80.9784 s, 66.3 MB/s
|
|
|__ $ mkswap /u01/system/swapfile
| mkswap /u01/system/swapfile01
|
| mkswap: /u01/system/swapfile: insecure permissions 0644, 0600 suggested.
| Setting up swapspace version 1, size = 5 GiB (5368705024 bytes)
| no label, UUID=d9eab043-78f4-4843-89e0-251ee3a4101a
|
|
|__ $ chmod 600 /u01/system/swapfile
| chmod 600 /u01/system/swapfile01
|
|
|__ $ swapon /u01/system/swapfile
| swapon /u01/system/swapfile01
|
|
|__ $ swapon -s
|
| Filename Type Size Used Priority
| /u01/system/swapfile file 5242876 5632 -2
| /u01/system/swapfile01 file 15728636 0 -3
|
|
|__ $ vi /etc/fstab
/u01/system/swapfile swap swap defaults 0 0
/u01/system/swapfile01 swap swap defaults 0 0
<4> Preinstall - Update latest .RPM packages, and install Oracle prerequest packages:
|
|__ $ yum update -y
|
|__ $ dnf install -y https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:29:16 ago on Fri 18 Dec 2020 03:23:32 PM UTC.
oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm 295 kB/s | 24 kB 00:00
Dependencies resolved.
===================================================================================================================================
Package Architecture Version Repository Size
===================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-1.el8 @commandline 24 k
Installing dependencies:
bc x86_64 1.07.1-5.el8 rhel-8-baseos-rhui-rpms 129 k
bind-libs x86_64 32:9.11.20-5.el8 rhel-8-appstream-rhui-rpms 172 k
bind-libs-lite x86_64 32:9.11.20-5.el8 rhel-8-appstream-rhui-rpms 1.2 M
bind-license noarch 32:9.11.20-5.el8 rhel-8-appstream-rhui-rpms 101 k
bind-utils x86_64 32:9.11.20-5.el8 rhel-8-appstream-rhui-rpms 445 k
binutils x86_64 2.30-79.el8 rhel-8-baseos-rhui-rpms 5.7 M
glibc-devel x86_64 2.28-127.el8 rhel-8-baseos-rhui-rpms 1.0 M
glibc-headers x86_64 2.28-127.el8 rhel-8-baseos-rhui-rpms 475 k
gssproxy x86_64 0.8.0-16.el8 rhel-8-baseos-rhui-rpms 118 k
kernel-headers x86_64 4.18.0-240.8.1.el8_3 rhel-8-baseos-rhui-rpms 5.5 M
keyutils x86_64 1.5.10-6.el8 rhel-8-baseos-rhui-rpms 63 k
ksh x86_64 20120801-254.el8 rhel-8-appstream-rhui-rpms 926 k
libICE x86_64 1.0.9-15.el8 rhel-8-appstream-rhui-rpms 74 k
libSM x86_64 1.2.3-1.el8 rhel-8-appstream-rhui-rpms 48 k
libX11 x86_64 1.6.8-3.el8 rhel-8-appstream-rhui-rpms 611 k
libX11-common noarch 1.6.8-3.el8 rhel-8-appstream-rhui-rpms 158 k
libX11-xcb x86_64 1.6.8-3.el8 rhel-8-appstream-rhui-rpms 14 k
libXau x86_64 1.0.9-3.el8 rhel-8-appstream-rhui-rpms 37 k
libXcomposite x86_64 0.4.4-14.el8 rhel-8-appstream-rhui-rpms 29 k
libXext x86_64 1.3.4-1.el8 rhel-8-appstream-rhui-rpms 45 k
libXi x86_64 1.7.10-1.el8 rhel-8-appstream-rhui-rpms 49 k
libXinerama x86_64 1.1.4-1.el8 rhel-8-appstream-rhui-rpms 16 k
libXmu x86_64 1.1.3-1.el8 rhel-8-appstream-rhui-rpms 75 k
libXrandr x86_64 1.5.2-1.el8 rhel-8-appstream-rhui-rpms 34 k
libXrender x86_64 0.9.10-7.el8 rhel-8-appstream-rhui-rpms 33 k
libXt x86_64 1.1.5-12.el8 rhel-8-appstream-rhui-rpms 185 k
libXtst x86_64 1.2.3-7.el8 rhel-8-appstream-rhui-rpms 22 k
libXv x86_64 1.0.11-7.el8 rhel-8-appstream-rhui-rpms 20 k
libXxf86dga x86_64 1.1.5-1.el8 rhel-8-appstream-rhui-rpms 26 k
libXxf86misc x86_64 1.0.4-1.el8 rhel-8-appstream-rhui-rpms 23 k
libXxf86vm x86_64 1.1.4-9.el8 rhel-8-appstream-rhui-rpms 19 k
libaio x86_64 0.3.112-1.el8 rhel-8-baseos-rhui-rpms 33 k
libaio-devel x86_64 0.3.112-1.el8 rhel-8-baseos-rhui-rpms 19 k
libdmx x86_64 1.1.4-3.el8 rhel-8-appstream-rhui-rpms 22 k
libnsl x86_64 2.28-127.el8 rhel-8-baseos-rhui-rpms 99 k
libpkgconf x86_64 1.4.2-1.el8 rhel-8-baseos-rhui-rpms 35 k
libstdc++-devel x86_64 8.3.1-5.1.el8 rhel-8-appstream-rhui-rpms 2.0 M
libverto-libevent x86_64 0.3.0-5.el8 rhel-8-baseos-rhui-rpms 16 k
libxcb x86_64 1.13.1-1.el8 rhel-8-appstream-rhui-rpms 229 k
libxcrypt-devel x86_64 4.1.1-4.el8 rhel-8-baseos-rhui-rpms 25 k
lm_sensors-libs x86_64 3.4.0-21.20180522git70f7e08.el8 rhel-8-baseos-rhui-rpms 59 k
make x86_64 1:4.2.1-10.el8 rhel-8-baseos-rhui-rpms 498 k
nfs-utils x86_64 1:2.3.3-35.el8 rhel-8-baseos-rhui-rpms 494 k
pkgconf x86_64 1.4.2-1.el8 rhel-8-baseos-rhui-rpms 38 k
pkgconf-m4 noarch 1.4.2-1.el8 rhel-8-baseos-rhui-rpms 17 k
pkgconf-pkg-config x86_64 1.4.2-1.el8 rhel-8-baseos-rhui-rpms 15 k
python3-bind noarch 32:9.11.20-5.el8 rhel-8-appstream-rhui-rpms 149 k
quota x86_64 1:4.04-10.el8 rhel-8-baseos-rhui-rpms 214 k
quota-nls noarch 1:4.04-10.el8 rhel-8-baseos-rhui-rpms 94 k
rpcbind x86_64 1.2.5-7.el8 rhel-8-baseos-rhui-rpms 70 k
smartmontools x86_64 1:7.1-1.el8 rhel-8-baseos-rhui-rpms 544 k
sysstat x86_64 11.7.3-5.el8 rhel-8-appstream-rhui-rpms 425 k
unzip x86_64 6.0-43.el8 rhel-8-baseos-rhui-rpms 195 k
xorg-x11-utils x86_64 7.5-28.el8 rhel-8-appstream-rhui-rpms 135 k
xorg-x11-xauth x86_64 1:1.0.9-12.el8 rhel-8-appstream-rhui-rpms 39 k
Transaction Summary
======================================================================================================================================
Install 56 Packages
Total size: 23 M
Total download size: 23 M
Installed size: 65 M
Downloading Packages:
(1/55): libXxf86vm-1.1.4-9.el8.x86_64.rpm 149 kB/s | 19 kB 00:00
(2/55): xorg-x11-utils-7.5-28.el8.x86_64.rpm 1.0 MB/s | 135 kB 00:00
(3/55): libX11-common-1.6.8-3.el8.noarch.rpm 1.1 MB/s | 158 kB 00:00
(4/55): libXtst-1.2.3-7.el8.x86_64.rpm 210 kB/s | 22 kB 00:00
(5/55): sysstat-11.7.3-5.el8.x86_64.rpm 3.8 MB/s | 425 kB 00:00
(6/55): libX11-xcb-1.6.8-3.el8.x86_64.rpm 138 kB/s | 14 kB 00:00
(7/55): python3-bind-9.11.20-5.el8.noarch.rpm 1.3 MB/s | 149 kB 00:00
(8/55): libXrender-0.9.10-7.el8.x86_64.rpm 304 kB/s | 33 kB 00:00
(9/55): libXext-1.3.4-1.el8.x86_64.rpm 412 kB/s | 45 kB 00:00
(10/55): bind-utils-9.11.20-5.el8.x86_64.rpm 3.9 MB/s | 445 kB 00:00
(11/55): libICE-1.0.9-15.el8.x86_64.rpm 713 kB/s | 74 kB 00:00
(12/55): bind-license-9.11.20-5.el8.noarch.rpm 911 kB/s | 101 kB 00:00
(13/55): libXmu-1.1.3-1.el8.x86_64.rpm 691 kB/s | 75 kB 00:00
(14/55): libXau-1.0.9-3.el8.x86_64.rpm 272 kB/s | 37 kB 00:00
(15/55): libxcb-1.13.1-1.el8.x86_64.rpm 1.5 MB/s | 229 kB 00:00
(16/55): libXi-1.7.10-1.el8.x86_64.rpm 467 kB/s | 49 kB 00:00
(17/55): libX11-1.6.8-3.el8.x86_64.rpm 4.8 MB/s | 611 kB 00:00
(18/55): libXt-1.1.5-12.el8.x86_64.rpm 1.7 MB/s | 185 kB 00:00
(19/55): ksh-20120801-254.el8.x86_64.rpm 6.8 MB/s | 926 kB 00:00
(20/55): libXxf86dga-1.1.5-1.el8.x86_64.rpm 259 kB/s | 26 kB 00:00
(21/55): libdmx-1.1.4-3.el8.x86_64.rpm 217 kB/s | 22 kB 00:00
(22/55): libXxf86misc-1.0.4-1.el8.x86_64.rpm 205 kB/s | 23 kB 00:00
(23/55): libXrandr-1.5.2-1.el8.x86_64.rpm 335 kB/s | 34 kB 00:00
(24/55): libXcomposite-0.4.4-14.el8.x86_64.rpm 251 kB/s | 29 kB 00:00
(25/55): libXv-1.0.11-7.el8.x86_64.rpm 182 kB/s | 20 kB 00:00
(26/55): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 322 kB/s | 39 kB 00:00
(27/55): bind-libs-lite-9.11.20-5.el8.x86_64.rpm 7.6 MB/s | 1.2 MB 00:00
(28/55): bind-libs-9.11.20-5.el8.x86_64.rpm 1.5 MB/s | 172 kB 00:00
(29/55): libSM-1.2.3-1.el8.x86_64.rpm 454 kB/s | 48 kB 00:00
(30/55): libstdc++-devel-8.3.1-5.1.el8.x86_64.rpm 13 MB/s | 2.0 MB 00:00
(31/55): libXinerama-1.1.4-1.el8.x86_64.rpm 130 kB/s | 16 kB 00:00
(32/55): quota-nls-4.04-10.el8.noarch.rpm 781 kB/s | 94 kB 00:00
(33/55): libxcrypt-devel-4.1.1-4.el8.x86_64.rpm 210 kB/s | 25 kB 00:00
(34/55): libpkgconf-1.4.2-1.el8.x86_64.rpm 321 kB/s | 35 kB 00:00
(35/55): bc-1.07.1-5.el8.x86_64.rpm 1.2 MB/s | 129 kB 00:00
(36/55): libverto-libevent-0.3.0-5.el8.x86_64.rpm 139 kB/s | 16 kB 00:00
(37/55): quota-4.04-10.el8.x86_64.rpm 1.9 MB/s | 214 kB 00:00
(38/55): pkgconf-pkg-config-1.4.2-1.el8.x86_64.rpm 153 kB/s | 15 kB 00:00
(39/55): pkgconf-1.4.2-1.el8.x86_64.rpm 328 kB/s | 38 kB 00:00
(40/55): pkgconf-m4-1.4.2-1.el8.noarch.rpm 166 kB/s | 17 kB 00:00
(41/55): keyutils-1.5.10-6.el8.x86_64.rpm 533 kB/s | 63 kB 00:00
(42/55): libaio-0.3.112-1.el8.x86_64.rpm 261 kB/s | 33 kB 00:00
(43/55): libaio-devel-0.3.112-1.el8.x86_64.rpm 173 kB/s | 19 kB 00:00
(44/55): unzip-6.0-43.el8.x86_64.rpm 1.7 MB/s | 195 kB 00:00
(45/55): lm_sensors-libs-3.4.0-21.20180522git70f7e08.el8.x86_64.rpm 546 kB/s | 59 kB 00:00
(46/55): rpcbind-1.2.5-7.el8.x86_64.rpm 649 kB/s | 70 kB 00:00
(47/55): make-4.2.1-10.el8.x86_64.rpm 4.1 MB/s | 498 kB 00:00
(48/55): gssproxy-0.8.0-16.el8.x86_64.rpm 1.1 MB/s | 118 kB 00:00
(49/55): libnsl-2.28-127.el8.x86_64.rpm 897 kB/s | 99 kB 00:00
(50/55): nfs-utils-2.3.3-35.el8.x86_64.rpm 2.9 MB/s | 494 kB 00:00
(51/55): binutils-2.30-79.el8.x86_64.rpm 20 MB/s | 5.7 MB 00:00
(52/55): smartmontools-7.1-1.el8.x86_64.rpm 3.6 MB/s | 544 kB 00:00
(53/55): glibc-headers-2.28-127.el8.x86_64.rpm 3.0 MB/s | 475 kB 00:00
(54/55): glibc-devel-2.28-127.el8.x86_64.rpm 7.6 MB/s | 1.0 MB 00:00
(55/55): kernel-headers-4.18.0-240.8.1.el8_3.x86_64.rpm 22 MB/s | 5.5 MB 00:00
------------------------------------------------------------------------------------------------------------------------
Total 8.9 MB/s | 23 MB 00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : bind-license-32:9.11.20-5.el8.noarch 1/56
Installing : bind-libs-lite-32:9.11.20-5.el8.x86_64 2/56
Installing : libaio-0.3.112-1.el8.x86_64 3/56
Installing : libXau-1.0.9-3.el8.x86_64 4/56
Installing : libxcb-1.13.1-1.el8.x86_64 5/56
Installing : libICE-1.0.9-15.el8.x86_64 6/56
Installing : libSM-1.2.3-1.el8.x86_64 7/56
Installing : libaio-devel-0.3.112-1.el8.x86_64 8/56
Installing : bind-libs-32:9.11.20-5.el8.x86_64 9/56
Installing : python3-bind-32:9.11.20-5.el8.noarch 10/56
Installing : bind-utils-32:9.11.20-5.el8.x86_64 11/56
Installing : kernel-headers-4.18.0-240.8.1.el8_3.x86_64 12/56
Running scriptlet: glibc-headers-2.28-127.el8.x86_64 13/56
Installing : glibc-headers-2.28-127.el8.x86_64 13/56
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 14/56
Installing : smartmontools-1:7.1-1.el8.x86_64 14/56
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 14/56
Installing : libnsl-2.28-127.el8.x86_64 15/56
Installing : binutils-2.30-79.el8.x86_64 16/56
Running scriptlet: binutils-2.30-79.el8.x86_64 16/56
Installing : make-1:4.2.1-10.el8.x86_64 17/56
Running scriptlet: make-1:4.2.1-10.el8.x86_64 17/56
Running scriptlet: rpcbind-1.2.5-7.el8.x86_64 18/56
Installing : rpcbind-1.2.5-7.el8.x86_64 18/56
Running scriptlet: rpcbind-1.2.5-7.el8.x86_64 18/56
Installing : lm_sensors-libs-3.4.0-21.20180522git70f7e08.el8.x86_64 19/56
Running scriptlet: lm_sensors-libs-3.4.0-21.20180522git70f7e08.el8.x86_64 19/56
Installing : sysstat-11.7.3-5.el8.x86_64 20/56
Running scriptlet: sysstat-11.7.3-5.el8.x86_64 20/56
Installing : unzip-6.0-43.el8.x86_64 21/56
Installing : keyutils-1.5.10-6.el8.x86_64 22/56
Installing : pkgconf-m4-1.4.2-1.el8.noarch 23/56
Installing : libverto-libevent-0.3.0-5.el8.x86_64 24/56
Installing : gssproxy-0.8.0-16.el8.x86_64 25/56
Running scriptlet: gssproxy-0.8.0-16.el8.x86_64 25/56
Installing : bc-1.07.1-5.el8.x86_64 26/56
Running scriptlet: bc-1.07.1-5.el8.x86_64 26/56
Installing : libpkgconf-1.4.2-1.el8.x86_64 27/56
Installing : pkgconf-1.4.2-1.el8.x86_64 28/56
Installing : pkgconf-pkg-config-1.4.2-1.el8.x86_64 29/56
Installing : glibc-devel-2.28-127.el8.x86_64 30/56
Running scriptlet: glibc-devel-2.28-127.el8.x86_64 30/56
Installing : libxcrypt-devel-4.1.1-4.el8.x86_64 31/56
Installing : quota-nls-1:4.04-10.el8.noarch 32/56
Installing : quota-1:4.04-10.el8.x86_64 33/56
Running scriptlet: nfs-utils-1:2.3.3-35.el8.x86_64 34/56
Installing : nfs-utils-1:2.3.3-35.el8.x86_64 34/56
Running scriptlet: nfs-utils-1:2.3.3-35.el8.x86_64 34/56
Installing : libstdc++-devel-8.3.1-5.1.el8.x86_64 35/56
Installing : ksh-20120801-254.el8.x86_64 36/56
Running scriptlet: ksh-20120801-254.el8.x86_64 36/56
Installing : libX11-xcb-1.6.8-3.el8.x86_64 37/56
Installing : libX11-common-1.6.8-3.el8.noarch 38/56
Installing : libX11-1.6.8-3.el8.x86_64 39/56
Installing : libXext-1.3.4-1.el8.x86_64 40/56
Installing : libXi-1.7.10-1.el8.x86_64 41/56
Installing : libXrender-0.9.10-7.el8.x86_64 42/56
Installing : libXrandr-1.5.2-1.el8.x86_64 43/56
Installing : libXtst-1.2.3-7.el8.x86_64 44/56
Installing : libXxf86vm-1.1.4-9.el8.x86_64 45/56
Installing : libXxf86dga-1.1.5-1.el8.x86_64 46/56
Installing : libdmx-1.1.4-3.el8.x86_64 47/56
Installing : libXxf86misc-1.0.4-1.el8.x86_64 48/56
Installing : libXv-1.0.11-7.el8.x86_64 49/56
Installing : libXinerama-1.1.4-1.el8.x86_64 50/56
Installing : libXt-1.1.5-12.el8.x86_64 51/56
Installing : libXmu-1.1.3-1.el8.x86_64 52/56
Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 53/56
Installing : libXcomposite-0.4.4-14.el8.x86_64 54/56
Installing : xorg-x11-utils-7.5-28.el8.x86_64 55/56
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el8.x86_64 56/56
Installing : oracle-database-preinstall-19c-1.0-1.el8.x86_64 56/56
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el8.x86_64 56/56
Verifying : libX11-common-1.6.8-3.el8.noarch 1/56
Verifying : libXxf86vm-1.1.4-9.el8.x86_64 2/56
Verifying : xorg-x11-utils-7.5-28.el8.x86_64 3/56
Verifying : libXtst-1.2.3-7.el8.x86_64 4/56
Verifying : sysstat-11.7.3-5.el8.x86_64 5/56
Verifying : libX11-xcb-1.6.8-3.el8.x86_64 6/56
Verifying : python3-bind-32:9.11.20-5.el8.noarch 7/56
Verifying : libXrender-0.9.10-7.el8.x86_64 8/56
Verifying : libXext-1.3.4-1.el8.x86_64 9/56
Verifying : bind-utils-32:9.11.20-5.el8.x86_64 10/56
Verifying : bind-license-32:9.11.20-5.el8.noarch 11/56
Verifying : libICE-1.0.9-15.el8.x86_64 12/56
Verifying : libXau-1.0.9-3.el8.x86_64 13/56
Verifying : libxcb-1.13.1-1.el8.x86_64 14/56
Verifying : libXmu-1.1.3-1.el8.x86_64 15/56
Verifying : libXi-1.7.10-1.el8.x86_64 16/56
Verifying : libX11-1.6.8-3.el8.x86_64 17/56
Verifying : libXt-1.1.5-12.el8.x86_64 18/56
Verifying : ksh-20120801-254.el8.x86_64 19/56
Verifying : libXxf86dga-1.1.5-1.el8.x86_64 20/56
Verifying : libdmx-1.1.4-3.el8.x86_64 21/56
Verifying : libXxf86misc-1.0.4-1.el8.x86_64 22/56
Verifying : libXcomposite-0.4.4-14.el8.x86_64 23/56
Verifying : libXrandr-1.5.2-1.el8.x86_64 24/56
Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 25/56
Verifying : bind-libs-lite-32:9.11.20-5.el8.x86_64 26/56
Verifying : libXv-1.0.11-7.el8.x86_64 27/56
Verifying : bind-libs-32:9.11.20-5.el8.x86_64 28/56
Verifying : libstdc++-devel-8.3.1-5.1.el8.x86_64 29/56
Verifying : libSM-1.2.3-1.el8.x86_64 30/56
Verifying : libXinerama-1.1.4-1.el8.x86_64 31/56
Verifying : quota-nls-1:4.04-10.el8.noarch 32/56
Verifying : libxcrypt-devel-4.1.1-4.el8.x86_64 33/56
Verifying : libpkgconf-1.4.2-1.el8.x86_64 34/56
Verifying : bc-1.07.1-5.el8.x86_64 35/56
Verifying : libverto-libevent-0.3.0-5.el8.x86_64 36/56
Verifying : quota-1:4.04-10.el8.x86_64 37/56
Verifying : pkgconf-pkg-config-1.4.2-1.el8.x86_64 38/56
Verifying : pkgconf-1.4.2-1.el8.x86_64 39/56
Verifying : pkgconf-m4-1.4.2-1.el8.noarch 40/56
Verifying : keyutils-1.5.10-6.el8.x86_64 41/56
Verifying : libaio-0.3.112-1.el8.x86_64 42/56
Verifying : libaio-devel-0.3.112-1.el8.x86_64 43/56
Verifying : unzip-6.0-43.el8.x86_64 44/56
Verifying : lm_sensors-libs-3.4.0-21.20180522git70f7e08.el8.x86_64 45/56
Verifying : rpcbind-1.2.5-7.el8.x86_64 46/56
Verifying : make-1:4.2.1-10.el8.x86_64 47/56
Verifying : gssproxy-0.8.0-16.el8.x86_64 48/56
Verifying : binutils-2.30-79.el8.x86_64 49/56
Verifying : libnsl-2.28-127.el8.x86_64 50/56
Verifying : nfs-utils-1:2.3.3-35.el8.x86_64 51/56
Verifying : smartmontools-1:7.1-1.el8.x86_64 52/56
Verifying : glibc-headers-2.28-127.el8.x86_64 53/56
Verifying : glibc-devel-2.28-127.el8.x86_64 54/56
Verifying : kernel-headers-4.18.0-240.8.1.el8_3.x86_64 55/56
Verifying : oracle-database-preinstall-19c-1.0-1.el8.x86_64 56/56
Installed:
bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.20-5.el8.x86_64 bind-libs-lite-32:9.11.20-5.el8.x86_64
bind-license-32:9.11.20-5.el8.noarch bind-utils-32:9.11.20-5.el8.x86_64 binutils-2.30-79.el8.x86_64
glibc-devel-2.28-127.el8.x86_64 glibc-headers-2.28-127.el8.x86_64 gssproxy-0.8.0-16.el8.x86_64
kernel-headers-4.18.0-240.8.1.el8_3.x86_64 keyutils-1.5.10-6.el8.x86_64 ksh-20120801-254.el8.x86_64
libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64 libX11-1.6.8-3.el8.x86_64
libX11-common-1.6.8-3.el8.noarch libX11-xcb-1.6.8-3.el8.x86_64 libXau-1.0.9-3.el8.x86_64
libXcomposite-0.4.4-14.el8.x86_64 libXext-1.3.4-1.el8.x86_64 libXi-1.7.10-1.el8.x86_64
libXinerama-1.1.4-1.el8.x86_64 libXmu-1.1.3-1.el8.x86_64 libXrandr-1.5.2-1.el8.x86_64
libXrender-0.9.10-7.el8.x86_64 libXt-1.1.5-12.el8.x86_64 libXtst-1.2.3-7.el8.x86_64
libXv-1.0.11-7.el8.x86_64 libXxf86dga-1.1.5-1.el8.x86_64 libXxf86misc-1.0.4-1.el8.x86_64
libXxf86vm-1.1.4-9.el8.x86_64 libaio-0.3.112-1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64
libdmx-1.1.4-3.el8.x86_64 libnsl-2.28-127.el8.x86_64 libpkgconf-1.4.2-1.el8.x86_64
libstdc++-devel-8.3.1-5.1.el8.x86_64 libverto-libevent-0.3.0-5.el8.x86_64 libxcb-1.13.1-1.el8.x86_64
libxcrypt-devel-4.1.1-4.el8.x86_64 lm_sensors-libs-3.4.0-21.20180522git70f7e08.el8.x86_64 make-1:4.2.1-10.el8.x86_64
nfs-utils-1:2.3.3-35.el8.x86_64 oracle-database-preinstall-19c-1.0-1.el8.x86_64 pkgconf-1.4.2-1.el8.x86_64
pkgconf-m4-1.4.2-1.el8.noarch pkgconf-pkg-config-1.4.2-1.el8.x86_64 python3-bind-32:9.11.20-5.el8.noarch
quota-1:4.04-10.el8.x86_64 quota-nls-1:4.04-10.el8.noarch rpcbind-1.2.5-7.el8.x86_64
smartmontools-1:7.1-1.el8.x86_64 sysstat-11.7.3-5.el8.x86_64 unzip-6.0-43.el8.x86_64
xorg-x11-utils-7.5-28.el8.x86_64 xorg-x11-xauth-1:1.0.9-12.el8.x86_64
Complete!
<5> Preinstall - Check following OS config file. Before Step3, below files either are empty, or were not created:
|
|__ $ cat /etc/sysctl.conf
|
| # sysctl settings are defined through files in
| # /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
| #
| # Vendors settings live in /usr/lib/sysctl.d/.
| # To override a whole file, create a new file with the same in
| # /etc/sysctl.d/ and put new settings there. To override
| # only specific settings, add a file with a lexically later
| # name in /etc/sysctl.d/ and put new settings there.
| #
| # For more information, see sysctl.conf(5) and sysctl.d(5).
|
| # oracle-database-preinstall-19c setting for fs.file-max is 6815744
| fs.file-max = 6815744
|
| # oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
| kernel.sem = 250 32000 100 128
|
| # oracle-database-preinstall-19c setting for kernel.shmmni is 4096
| kernel.shmmni = 4096
|
| # oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64
| kernel.shmall = 1073741824
|
| # oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64
| kernel.shmmax = 4398046511104
|
| # oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317
| kernel.panic_on_oops = 1
|
| # oracle-database-preinstall-19c setting for net.core.rmem_default is 262144
| net.core.rmem_default = 262144
|
| # oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304
| net.core.rmem_max = 4194304
|
| # oracle-database-preinstall-19c setting for net.core.wmem_default is 262144
| net.core.wmem_default = 262144
|
| # oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576
| net.core.wmem_max = 1048576
|
| # oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2
| net.ipv4.conf.all.rp_filter = 2
|
| # oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2
| net.ipv4.conf.default.rp_filter = 2
|
| # oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576
| fs.aio-max-nr = 1048576
|
| # oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
| net.ipv4.ip_local_port_range = 9000 65500
|
|
|
|__ $ cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock 134217728
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock 134217728
# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle hard data unlimited
<6> Preinstall - Additional packages are needed:
|
|__ $ dnf install -y bc
dnf install -y binutils
dnf install -y compat-libcap1
dnf install -y compat-libstdc++-33
dnf install -y dtrace-modules
dnf install -y dtrace-modules-headers
dnf install -y dtrace-modules-provider-headers
dnf install -y dtrace-utils
dnf install -y elfutils-libelf
dnf install -y elfutils-libelf-devel
dnf install -y fontconfig-devel
dnf install -y glibc
dnf install -y glibc-devel
dnf install -y ksh
dnf install -y libaio
dnf install -y libaio-devel
dnf install -y libdtrace-ctf-devel
dnf install -y libXrender
dnf install -y libXrender-devel
dnf install -y libX11
dnf install -y libXau
dnf install -y libXi
dnf install -y libXtst
dnf install -y libgcc
dnf install -y librdmacm-devel
dnf install -y libstdc++
dnf install -y libstdc++-devel
dnf install -y libxcb
dnf install -y make
dnf install -y net-tools # Clusterware
dnf install -y nfs-utils # ACFS
dnf install -y python # ACFS
dnf install -y python-configshell # ACFS
dnf install -y python-rtslib # ACFS
dnf install -y python-six # ACFS
dnf install -y targetcli # ACFS
dnf install -y smartmontools
dnf install -y sysstat
dnf install -y unixODBC
# New for OL8
dnf install -y libnsl
dnf install -y libnsl.i686
dnf install -y libnsl2
dnf install -y libnsl2.i686
<7> Preinstall - Create OS user for Oracle database as "root":
|
|__ $ groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle
<8> Preinstall - Ensure Linux in correct security setting:
|
|__ $ vi /etc/selinux/config
|
| # This file controls the state of SELinux on the system.
| # SELINUX= can take one of these three values:
| # enforcing - SELinux security policy is enforced.
| # permissive - SELinux prints warnings instead of enforcing.
| # disabled - No SELinux policy is loaded.
| SELINUX=permissive
| #SELINUX=enforcing
| # SELINUXTYPE= can take one of these three values:
| # targeted - Targeted processes are protected,
| # minimum - Modification of targeted policy. Only selected processes are protected.
| # mls - Multi Level Security protection.
| SELINUXTYPE=targeted
|
|
|__ $ setenforce Permissive [This command is for restart]
<9> Preinstall - Shutting down the firewall in case of blocking ports:
|
|__ $ systemctl stop firewalld
|
|__ $ systemctl disable firewalld
<10> Preinstall - Create folder for RDBMS software:
|
|__ $ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
|
|__ $ chown -R oracle:oinstall /u01
|
|__ $ chmod -R 775 /u01
<11> Preinstall - Adding following variables within .bash_profile of "oracle":
export ORACLE_SID=emeralit
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export GG_HOME=/u01/app/oracle/product/19.0.0/gghome_1
export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=$GG_HOME:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
<12> Preinstall - Ensure the XSERVER/GUI can come up:
|
|__ $ xterm [xclock was not found in RHEL8 RPM repository]
|
|__ $ subscription-manager register
|
| Registering to: subscription.rhsm.redhat.com:443/subscription
| Username: emeralit
| Password:
| The system has been registered with ID: ef8976573-6ded-4743-bw24b-3ba2020f6d22
| The registered system name is: ip-172-30-22-99.ec2.internal
|
|__ $ subscription-manager repos --enable=codeready-builder-for-rhel-8-x86_64-rpms
<13> Start Oracle RDBMS 19c installation, and use DBCA to create database:
|
|__ o. Unzip the package LINUX.X64_193000_db_home.zip to $ORACLE_HOME [MUST & CRITICAL], and execute ./runInstaller.
|
|__ o. When DB 19c installation wizard comes up, error [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck' appears.
| | This is because Oracle database 19.3 supports Oracle Linux up to 8.1, not 8.2. As solution below, and retry OUI:
| |
| |__ $ vi $ORACLE_HOME/cv/admin/cvu_config
|
| CV_ASSUME_DISTID=OEL8.1
|
|
|__ $/u01/app/oracle/product/19.0.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.0.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
/u01/app/oracle/product/19.0.0/dbhome_1/bin/tfactl
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed
<14> Oracle Goldengate Software 19c installation:
|
|__ o. Create GG_HOME, and upload the installation package within that folder:
| |
| |__ $ mkdir -p /u01/app/oracle/product/19.0.0/gghome_1
|
|__ $ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip
|
|__ $ /u01/software/GG/fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
<15> Create DB user and table for Goldegate testing purpose, and AMI the EC2 instance to create target DB server [TNSNAME & SQLNET.ora needs to be revised]:
|
|__ SQL> create user emeralit identified by password;
| grant dba to emeralit;
|
|
|__ SQL> create table stores (
| store_id integer generated by default on null as identity ,
| store_name varchar2(255 char) not null,
| web_address varchar2(100 char),
| physical_address varchar2(512 char),
| latitude number,
| longitude number,
| logo blob,
| logo_mime_type varchar2(512 char),
| logo_filename varchar2(512 char),
| logo_charset varchar2(512 char),
| logo_last_updated date
| );
|
|
|__ o. With the above DDL, Goldegate will treat all columns as key colums, which cause issue in real working scenorio:
|
|__ o. OGG-06439 No unique key is defined for table STORES.
| All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
| Oracle Goldengate marked following column as key columns on table EMERALIT.STORES:
| STORE_ID, STORE_NAME, WEB_ADDRESS, PHYSICAL_ADDRESS, LATITUDE, ..., LOGO_CHARSET, LOGO_LAST_UPDATED.
|
|
|__ SQL> alter table stores add constraint stores_pk primary key (store_id);
|
|
|__ o. OGG-01896 Table EMERALIT.STORES has an identity column which is not supported. This table will be ignored by Extract.
| This warning is serious, which will cause issue by identity-column. Please review the second link in Reference section below.
|
|__ SQL> SQL> ALTER TABLE stores MODIFY STORE_ID DROP IDENTITY;
<16> Oracle Goldegate Basic Processes Structure:
<17> Oracle GoldenGate Subdirectories:
|
|__ o. Each time login GGSCI, highly recommand entering $GG_HOME first, since some of the GGSCI will search the utiliy in current directory only.
|
|__ Reference: https://docs.oracle.com/goldengate/c1221/gg-winux/GISMX/GUID-838235F3-B3C0-4517-B271-6361AB1C6E9C.htm#GISMX167
<18> Oracle GoldenGate Config - Prerequsite Parameters on Source Server (DB & Table level Supplemental Logging Enabling):
|
|__ o. Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/setup.htm#GIORA367
|
|__ SQL> alter database add supplemental log data;
|
|__ SQL> alter system switch logfile;
|
|__ SQL> select supplemental_log_data_min from v$database;
|
|
| SUPPLEME
| --------
| YES
|
|
|__ GGSCI> dblogin userid emeralit, password emeralit
|
|__ GGSCL> add trandata emeralit.stores [Syntax: No Semi-column is needed. ]
|
|__ GGSCI> info trandata emeralit.stores
OGG-15132 Logging of supplemental redo data enabled for table EMERALIT.STORES.
OGG-15133 TRANDATA for scheduling columns has been added on table EMERALIT.STORES.
OGG-15135 TRANDATA for instantiation CSN has been added on table EMERALIT.STORES.
<19> Oracle GoldenGate Config - Prerequsite Parameters on Target Server (Parameter ENABLE_GOLDENGATE_REPLICATION Enabling):
|
|__ o. Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams086.htm
|
|__ SQL> alter system set ENABLE_GOLDENGATE_REPLICATION=TRUE;
<20> Oracle Manger Process:
|
|__ $ cd $GG_HOME
|
|__ GGSCI> edit params mgr
<21> Oracle GoldenGate Initial Load - Extract Process Creation of Source DB:
|
|__ GGSCI> dblogin userid emeralit, password emeralit
|
|__ GGSCI> add extract einikk, sourceistable << SOURCEISTABLE: Creates an Extract task that extracts entire records from the database for an initial load.
| << Reference - https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands006.htm#GWURF122
|__ GGSCI> edit params einikk
extract einikk
userid emeralit, password "emeralit"
RMTHOST 52.44.99.34, MGRPORT 7809
RMTTASK REPLICAT, GROUP RINIKK
table emeralit.stores;
<22> Oracle GoldenGate Initial Load - Extract Process Creation of Target DB:
|
|__ GGSCI> add replicat rinikk, specialrun << The replicate process will start as special task(initial-load) process, and will be terminated upon completing the initial-load.
|
|__ GGSCI> edit params rinikk
replicat rinikk
assumetargetdefs << When the source and target objects specified in a MAP statement have identical column structure.
userid emeralit, password emeralit
discardfile ./dirrpt/RINIKK.dsc purge << Create a file containing records discarded(many reasons), such as attempting to update a missing record.
MAP emeralit.stores, TARGET emeralit.stores;
<23> Start Initial Load Process on Source side, and afterwards, empty table will be loaded with data on Target side:
|
|__ GGSCI> start einikk
|
|__ o. Since the replicat process was marked with "SPECIALRUN", so NO need to start the replicat on target side.
<24> Create Extract Process of Source DB for Regular Table Syncing:
|
|__ GGSCI> add extract eorakk, tranlog
|
|__ GGSCI> edit params eorakk
|
| extract eorakk
| userid emeralit, password emeralit
| RMTHOST 52.44.99.34, MGRPORT 7809
| RMTTRAIL ./dirdat/kk
| TABLE emeralit.stores;
|
|
|__ GGSCI> add rmttrail ./dirdat/kk, extract eorakk, megabytes 5
|
|__ GGSCI> info rmttrail
|
| Extract Trail: ./dirdat/kk
| Seqno Length: 6
| Flip Seqno Length: yes
| Extract: EORAKK
| Seqno: 0
| RBA: 0
| File Size: 5M
|
|
|__ GGSCI> start extract eorakk
|
| Sending START request to MANAGER ...
| EXTRACT EORAKK starting
|
|
|__ GGSCI> info all
|
| Program Status Group Lag at Chkpt Time Since Chkpt
| MANAGER RUNNING
| EXTRACT RUNNING EORAKK 00:09:32 00:00:04
|
|
|__ GGSCI> info extract eorakk, detail
EXTRACT EORAKK Last Started 2020-12-22 21:28 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 3471
Log Read Checkpoint Oracle Redo Logs
2020-12-22 21:28:47 Seqno 6, RBA 87292928
SCN 0.2139500 (2139500)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/kk 0 1340 5 RMTTRAIL
Extract Source Begin End
/u01/app/oracle/oradata/EMERALIT/redo03.log 2020-12-22 21:18 2020-12-22 21:28
Not Available * Initialized * 2020-12-22 21:18
Not Available * Initialized * 2020-12-22 21:18
Not Available * Initialized * 2020-12-22 21:18
Current directory /u01/app/oracle/product/19.0.0/gghome_1
Report file /u01/app/oracle/product/19.0.0/gghome_1/dirrpt/EORAKK.rpt
Parameter file /u01/app/oracle/product/19.0.0/gghome_1/dirprm/eorakk.prm
Checkpoint file /u01/app/oracle/product/19.0.0/gghome_1/dirchk/EORAKK.cpe
Process file
Error log /u01/app/oracle/product/19.0.0/gghome_1/ggserr.log
<25> Create Replicat Process of Target DB for Regular Table Syncing:
|
|__ GGSCI> edit params ./GLOBALS
|
| CHECKPOINTTABLE emeralit.ggchktable
|
|__ GGSCI> exit << Need to exit first to make the GLOBAL Parameter active.
|
|
|__ GGSCI> dblogin userid emeralit, password emeralit
|
| Successfully logged into database.
|
|
|__ GGSCI> add checkpointtable
|
| No checkpoint table specified. Using GLOBALS specification emeralit.ggchktable...
| Successfully created checkpoint table emeralit.ggchktable.
|
|
|__ SQL> desc emeralit.ggchktable;
|
| Name Null? Type
| ---------------------- -------- -------------------
| GROUP_NAME NOT NULL VARCHAR2(8)
| GROUP_KEY NOT NULL NUMBER(19)
| SEQNO NUMBER(10)
| RBA NOT NULL NUMBER(19)
| AUDIT_TS VARCHAR2(29)
| CREATE_TS NOT NULL DATE
| LAST_UPDATE_TS NOT NULL DATE
| CURRENT_DIR NOT NULL VARCHAR2(255)
| LOG_BSN VARCHAR2(128)
| LOG_CSN VARCHAR2(128)
| LOG_XID VARCHAR2(128)
| LOG_CMPLT_CSN VARCHAR2(128)
| LOG_CMPLT_XIDS VARCHAR2(2000)
| VERSION NUMBER(3)
|
|
|
|__ GGSCI> add replicat rorakk, exttrail ./dirdat/kk
|
| REPLICAT added.
|
|
|__ GGSCI> edit params rorakk
|
| replicat rorakk
| userid emeralit, password emeralit
| handlecollisions
| assumetargetdefs
| discardfile ./dirrpt/RORAKK.DSC, PURGE
| map emeralit.stores, target emeralit.store;
|
|
|__ GGSCI> start replicat rorakk
|
| Sending START request to MANAGER ...
| REPLICAT RORAKK starting
|
|
|__ GGSCI> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORAKK 00:00:00 00:00:01
Reference:
|
|__ o. Oracle 19c Installation - https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-8#oracle_installation_prerequisites
|
|__ o. Oracle GoldenGate Access Rule Parameter - https://www.perftuning.com/blog/goldengate-12-2-ogg-01201-error-reported-by-mgr-access-denied/
|
|__ o. https://docs.oracle.com/en/database/other-databases/nosql-database/19.3/java-driver-table/altering-or-dropping-identity-column.html
|
|__ o. https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_about_gg.htm#GWUAD128
|
|__ o. https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_manager.htm#GWUAD138
Your Comments