How to install Oracle 19.1.0.0.4 GoldenGate on Linux 7

Installing Oracle 19.1.0.0.4 GoldenGate on Linux 7

Step 1:- unzip the software

[oracle@oel7 u01]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip

[oracle@oel7 u01]$ ls -ltr

total 543540

-rw-r--r-- 1 oracle oinstall      1413 May 29  2019 OGG-19.1.0.0-README.txt

drwxr-xr-x 3 oracle oinstall        19 Oct 18  2019 fbo_ggs_Linux_x64_shiphome

-rw-r--r-- 1 oracle oinstall    332523 Oct 21  2019 OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf

-rw-r--r-- 1 oracle oinstall 556240981 May 11 18:58 191004_fbo_ggs_Linux_x64_shiphome.zip

Step:2 Create the  directory where goldengate would be installed

How to apply RUR Patch in Dataguard Environment in 19c

Applying RUR(Release Update Revision) Patch in a dataguard (Physical Standby) environment.

Here is a brief explanation on how to apply RUR (Release Update Revision) in a dataguard environment

Here I will be  applying RUR 19.5.1.0 on the Primary and standby databases.

Primary database Server : primary

Standby database Server : standby

Primary db_unique_name : orclcdb

Standby db_unique_name : orclstd

How To Clone A Pluggable Database from a Existing PDB in 19C

How To Clone A Pluggable Database from a Existing PDB

Step 1. 

Put PDB in read only mode , which would be cloned.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB1                       READ WRITE NO

Rolling Forward Standby Database When Archive log is missing in Primary DB

Problem statement :- standby database goes out of sync as the archive logs are missing from primary site.

Environment:

Primary:

Primary database node     : primary.soumya.com

Database name              : orclcdb

Primary DB UNIQUE NAME     : orclcdb

Primary database instances : orclcdb

DB Version: 19.0.0 

Standby:

Standby database node     : standby.soumya.com

Database name              : orclcdb

Standby DB UNIQUE NAME     : orclstd

Standby database instances : orclcdb

DB Version: 19.0.0 

ORA-16698 member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

In primary DATABASE:-

Primary DB:- orclcdb

Standby DB:- orclstd

oracle@primary flashback]$ dgmgrl sys/admin123#@orclcdb

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Apr 13 19:05:31 2020

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected to "orclcdb"

Connected as SYSDBA.

DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS orclcdb CONNECT IDENTIFIER IS orclcdb;

How to create physical standby database on Oracle 19c

OS Version:-Oracle Linux 7

Oracle version:- Oracle Database 19c Enterprise Edition Release 19.3.0 64bit

System Configuration

primary server:-

edit the following files

cat /etc/hosts

[oracle@primary ~]$ cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.110   primary.soumya.com      primary

192.168.0.120   standby.soumya.com      standby

Oracle Database 19c Installation On Oracle Linux 7

Oracle Database 19c Installation On Oracle Linux 7 

• Download Software

Oracle Database 19c (19.3) Software (64-bit)

 Add hosts entry in hosts file

[root@oel7 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.118.128 oel7.soumya.com oel7

 

 

Install the "oracle-database-preinstall-19c" package to perform all the prerequisite setup

# yum install -y oracle-database-preinstall-19c