preparing source target and mining database for GG integrated setup 11.2.0.3

Setup

Environment details

1. Prerequisite

/etc/hosts file

[root@oel6-node05 ~]# vi /etc/hosts
[root@oel6-node05 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.189.105 oel6-node05.localdomain oel6-node05
192.168.189.103 oel6-node03.localdomain oel6-node03


[root@oel6-node03 ~]# vi /etc/hosts
[root@oel6-node03 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.189.105 oel6-node05.localdomain oel6-node05
192.168.189.103 oel6-node03.localdomain oel6-node03

[oracle@oel6-node04 dpdump]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.189.105 oel6-node05.localdomain oel6-node05
192.168.189.103 oel6-node03.localdomain oel6-node03
192.168.189.104 oel6-node04.localdomain oel6-node04

Bash profile

[oracle@oel6-node05 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=oel6-node05.localdomain
export ORACLE_UNQNAME=mngdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=mngdb

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=/home/oracle/goldengate:$PATH
export LD_LIBRARY_PATH=/home/oracle/goldengate:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib




[oracle@oel6-node03 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=oel6-node03.localdomain
export ORACLE_UNQNAME=mngdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=mngdb

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=/home/oracle/goldengate:$PATH
export LD_LIBRARY_PATH=/home/oracle/goldengate:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


[oracle@oel6-node04 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=oel6-node04.localdomain
export ORACLE_UNQNAME=tgtdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=tgtdb
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=/home/oracle/goldengate:$PATH
export LD_LIBRARY_PATH=/home/oracle/goldengate:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

/dev/shm setting – for my test env, I have made these changes. to make changes persistent add this line in /etc/fstab as shown below shmfs /dev/shm tmpfs size=7g 0

[root@oel6-node05 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6node01-lv_root
                       50G   16G   32G  33% /
tmpfs                 1.9G  172K  1.9G   1% /dev/shm
/dev/sda1             477M  155M  294M  35% /boot
/dev/mapper/vg_oel6node01-lv_home
                      144G  678M  136G   1% /home
/dev/sr0               57M   57M     0 100% /media/VBox_GAs_6.1.6
Software              932G  524G  408G  57% /shared_dir

[root@oel6-node05 ~]# mount -t tmpfs shmfs -o size=7g /dev/shm
[root@oel6-node05 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6node01-lv_root
                       50G   16G   32G  33% /
tmpfs                 7.0G     0  7.0G   0% /dev/shm
/dev/sda1             477M  155M  294M  35% /boot
/dev/mapper/vg_oel6node01-lv_home
                      144G  678M  136G   1% /home
/dev/sr0               57M   57M     0 100% /media/VBox_GAs_6.1.6
Software              932G  524G  408G  57% /shared_dir
shmfs                 7.0G     0  7.0G   0% /dev/shm

[root@oel6-node05 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon May  4 06:54:40 2020
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_oel6node01-lv_root /                       ext4    defaults        1 1
UUID=81245e6d-58c2-42a6-bc2b-bb57768e9a05 /boot                   ext4    defaults        1 2
/dev/mapper/vg_oel6node01-lv_home /home                   ext4    defaults        1 2
/dev/mapper/vg_oel6node01-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
shmfs /dev/shm tmpfs size=7g 0



[root@oel6-node03 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6node01-lv_root
                       50G   17G   30G  37% /
tmpfs                 1.9G  188K  1.9G   1% /dev/shm
/dev/sda1             477M  155M  294M  35% /boot
/dev/mapper/vg_oel6node01-lv_home
                      144G  678M  136G   1% /home
Software              932G  524G  408G  57% /shared_dir
[root@oel6-node03 ~]# mount -t tmpfs shmfs -o size=7g /dev/shm
[root@oel6-node03 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6node01-lv_root
                       50G   17G   30G  37% /
tmpfs                 7.0G     0  7.0G   0% /dev/shm
/dev/sda1             477M  155M  294M  35% /boot
/dev/mapper/vg_oel6node01-lv_home
                      144G  678M  136G   1% /home
Software              932G  524G  408G  57% /shared_dir
shmfs                 7.0G     0  7.0G   0% /dev/shm
[root@oel6-node03 ~]# vi /etc/fstab
[root@oel6-node03 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon May  4 06:54:40 2020
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_oel6node01-lv_root /                       ext4    defaults        1 1
UUID=81245e6d-58c2-42a6-bc2b-bb57768e9a05 /boot                   ext4    defaults        1 2
/dev/mapper/vg_oel6node01-lv_home /home                   ext4    defaults        1 2
/dev/mapper/vg_oel6node01-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
shmfs /dev/shm tmpfs size=7g 0

Create srcdb db

Create Target DB – tgtdb

Click finish

Create Mining database – mngdb

Tns entry – Add this in tnsnames.ora on all three servers

MNGDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol6-node05.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mngdb)
    )
  )

SRCDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol6-node03.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = srcdb)
    )
  )

TGTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol6-node04.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = tgtdb)
    )
  )

Run post install on mngdb for patch –

Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of PSU 11.2.0.3.15 in the Oracle Home. There are no actions required for databases that have been upgraded or created after installation of PSU 11.2.0.3.15.

Install 21373865 on mngdb

Mining database need to be applied with 21373865 patch in order to have integrated capture.

11.2.0.3 Database Specific Bundle Patches for Integrated Extract 11.2.x (Doc ID 1411356.1)

[oracle@oel6-node05 ~]$ cd /shared_dir/patches/21373865/21373865
[oracle@oel6-node05 21373865]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.25
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-05-18_12-26-57PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@oel6-node05 21373865]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.25
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-05-18_12-27-23PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21373865

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 = '/u01/app/oracle/product/11.2.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21373865' to OH '/u01/app/oracle/product/11.2.0/db_1'

Patching component oracle.rdbms.oci, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patch 21373865 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-05-18_12-27-23PM_1.log

OPatch succeeded.
[oracle@oel6-node05 21373865]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.25
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-05-18_12-28-50PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-18_12-28-50PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel6-node05.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

Patch  21373865     : applied on Mon May 18 12:27:47 IST 2020
Unique Patch ID:  19108349
   Created on 14 Jul 2015, 17:45:48 hrs PST8PDT
   Bugs fixed:
     17889549, 16306373, 14692460, 17889583, 16238044, 13516727, 20686773
     18853853, 13652437, 16796277, 16233738, 16964686, 17596908, 16620682
     18673090, 17655634, 14744263, 18202441, 17835627, 15913355, 14050233
     17569430, 20926021, 14705949, 13328193, 14175146
   This patch overlays patches:
     20760997
   This patch needs patches:
     20760997
   as prerequisites

Patch  20760997     : applied on Mon May 18 10:41:32 IST 2020
Unique Patch ID:  18966522
……..
……
--------------------------------------------------------------------------------

OPatch succeeded.

Run post patch

[oracle@oel6-node05 21373865]$ pwd
/shared_dir/patches/21373865/21373865

[oracle@oel6-node05 21373865]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon May 18 12:36:57 2020

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @?/sqlpatch/21373865/postinstall.sql





SQL> set lines 300
col action_time for a28
col action for a6
col namespace for a9
col version for a10
col id for 99999999
col comments for a30
select * from registry$history;SQL> SQL> SQL> SQL> SQL> SQL> SQL>

17-SEP-11 10.21.11.595816 AM APPLY  SERVER    11.2.0.3           0 Patchset 11.2.0.2.0            PSU
18-MAY-20 12.09.00.539769 PM APPLY  SERVER    11.2.0.3          15 PSU 11.2.0.3.15                PSU
18-MAY-20 12.37.09.000000 PM APPLY                        21373865 Patch 21373865 applied

3 rows selected.

Firewall should be off

[root@oel6-node03 ~]# service iptables status
iptables: Firewall is not running.

[root@oel6-node05 ~]# service iptables status
iptables: Firewall is not running.
[root@oel6-node04 ~]# service iptables status
iptables: Firewall is not running.

One thought on “preparing source target and mining database for GG integrated setup 11.2.0.3”

Pingback: Integarted downstream replication in 11.2.0.3 – DBATracker

Setup

Environment details

1. Prerequisite

Share this:

Like this:

Related

One thought on “preparing source target and mining database for GG integrated setup 11.2.0.3”

Leave a Reply Cancel reply