Setup Source Database

Source Database in ARCHIVELOG Mode

The source Oracle database must operate in ARCHIVELOG mode. Helyx relies on archived redo logs to capture transactional changes reliably.

Docker Network

Create a Docker network with the below command :

docker network create helyx-net

Enable Supplemental Logging

Create a Docker network with the below command :

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Create Helyx User at Source Database

Create a dedicated database user for Helyx replication activities.

CREATE USER helyx IDENTIFIED BY <password>;

Grant Required Privileges

Grant the following privileges to the helyx user :

GRANT CONNECT, RESOURCE TO helyx;

ALTER USER helyx QUOTA UNLIMITED ON USERS;

GRANT UNLIMITED TABLESPACE TO helyx;

Example :

CREATE USER helyx IDENTIFIED BY <password> DEFAULT TABLESPACE tblspc_helyx QUOTA UNLIMITED ON tblspc_helyx;

Create Helyx Signal Table at Source database

The Debezium signal table is required for snapshot control and runtime signaling.

CREATE TABLE helyx.debezium_signal (id VARCHAR2(42) PRIMARY KEY,type VARCHAR2(32) NOT NULL,data VARCHAR2(400));

GRANT SELECT, INSERT, UPDATE, DELETE ON HELYX.DEBEZIUM_SIGNAL TO helyx;

Configuring and Creating Export Dump for Source Oracle Database

To enable replication using Helyx, it is essential to export the schemas and tables from the source Oracle database that you intend to replicate.

Follow the steps below to ensure a successful export and subsequent import at the destination host :

• Identify Schemas and Tables for Replication.
• Review the list of schemas and tables required for replication.
• Ensure only necessary objects are included to streamline the replication process.
• Create Export Backup Using Oracle Data Pump.
• Use Oracle Data Pump (expdp) to export the identified schemas and tables.
  Copy

  expdp helyx/password@source_db schemas=SCHEMA_NAME tables=TABLE_NAME directory=EXPORT_DIR dumpfile=export_dump.dmp logfile=export_dump.log

• Verify the export completion and check the log file for errors.
• Transfer Export Dump to Destination Host.
• Securely copy the generated export dump (.dmp) file to the destination server using SCP, SFTP, or another secure file transfer method.
• Ensure proper file permissions and integrity after transfer.
• Import Schema and Tables at Destination Database.
• On the destination Oracle database, use Oracle Data Pump (impdp) to import the schema and tables.
  Copy

  impdp helyx/password@destination_db schemas=SCHEMA_NAME directory=IMPORT_DIR dumpfile=export_dump.dmp logfile=import_dump.log

• Verify the import completion and review the log file for any issues.
• Post-Import Validation.
• Validate the imported schemas and tables to ensure all objects are present and correct.
• Confirm that the destination database is ready for Helyx replication setup.

These above steps will ensure that the required schemas and tables are properly exported from the source Oracle database, transferred, and imported into the destination host, laying the groundwork for successful replication with Helyx.

Operating System Requirements

• Operating System: Linux (RHEL, CentOS, Rocky Linux, Oracle Linux, Fedora)
• Privileges: Root or sudo access
• Package Manager: yum or dnf
• Network Access: Access to configured YUM repository