Steps to Create Oracle Database 18c

Machine : Oracle VirtualBox

OS           : RHEL 6.9

[oracle@nk2b ~]$ lsb_release -a

LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description:    Red Hat Enterprise Linux Server release 6.9 (Santiago)

Release:        6.9

Codename:       Santiago

RAM     : 8gb

Storage  : 100gb

18c Database Software : V978967-01.zip

Accessing Enterprise Manager Database Express 12c

Connect to your database:-

$ sqlplus / as sysdba

SQL> select dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0

SQL> exec dbms_xdb_config.sethttpsport(5501);
PL/SQL procedure successfully completed.

SQL> execute dbms_xdb_config.setglobalportenabled(TRUE);

Configure Goldengate to Replicate data to Kafka

In this article we would configure Oracle GoldenGate for Big Data Kafka Handler to replicate change capture data from a Oracle GoldenGate trail to a Kafka topic. We would use 2 different servers, hosing multiple applications. Please find below details:-

Host      : fangorn.oradba.com
Database  : Oracle 11gR2
GG        : Oracle GoldenGate (12.2.0.1.0) 

Host      : hyd01db001.oradba.com
Zookeeper : zookeeper-3.4.10
Kafka     : Kafka 2.11-0.11
GG        : Oracle GoldenGate for Big Data (12.2.0.1.0)

Note: Throughout the entire installation and configuration, my OS user is "oracle" on both servers, unless mentioned.

Update host entries on both server:-

[oracle@fangorn ~]$ sudo su - 
[root@fangorn ~]# vi /etc/hosts
172.3.21.102   hyd01db001.oradba.com    hyd01db001
172.3.21.32    fangorn.oradba.com       fangorn

Then copy the same /etc/hosts file on hyd01db001 server as well

[root@fangorn ~]# scp /etc/hosts root@172.3.21.102:/etc/