• ZDM 21.4.3 patch apply – Support for Sequences

    One of the issues associated with a ZDM online Logical Migration was that the database Sequences were not replicated as part of the ZDM migration process. Sequences had to manually advanced as part of the outage window in order to avoid the ORA-00001 unique constraint violation error once the application…

  • Using Terraform to manage OCI GoldenGate Cloud Service

    Terraform by Hashicorp is an Infrastructure as code (IaC) tool and provides automation to provision and manage resources in any cloud including Oracle Cloud Infrastructure (OCI). The OCI provider enables usage of Terraform to interact with Oracle Cloud Infrastructure resources including Oracle GoldenGate Cloud Service. The link below shows the…

  • Managing OCI GoldenGate with OCI Command Line Interface (OCI CLI)

    One of the tools available to manage and administer OCI GoldenGate is the OCI Command Line Interface (OCI CLI). The link below provides a list of the available Oracle Cloud Infrastructure GoldenGate CLI commands. https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.37.0/oci_cli_docs/cmdref/goldengate/trail-sequence-summary/list-trail-sequences.html This note describes the usage of OCI CLI commands to perform the following tasks: Creating…

  • Oracle Database 19c Software Cloning using Gold Image (Windows)

    This note describes the process used to create a Oracle Database 19c software Gold Image and using that Gold Image to clone a separate Oracle 19c database software home on a Windows platform. The following issues were encountered in creating the Gold Image as well as when running setup.exe from…

  • Oracle 23c Lock-Free Reservations and GoldenGate 23c Replication support

    One of the new features in Oracle Database 23c is Lock-Free Reservations. In earlier versions, an update to the same row of the same table by two concurrent transactions would impose a row level TX lock – but not any more in Oracle Database 23c! A new RESERVABLE key word…

  • Oracle Database 23c New Feature – Domains

    One of the top new features of Oracle Database 23c is Domains – or SQL Domains or Application Domains or Usage Domains. In short what ever the name – the emphasis is that domains are meant to help the in the development of applications – ensuring data quality and data…

  • GoldenGate23c Replication with Oracle Database New Feature – BOOLEAN Data Type

    Oracle Database 23c introduced the SQL boolean data type which stores the values ‘TRUE’ or ‘FALSE’ in the boolean columns in the table. We can use the keywords BOOLEAN or BOOL in the CREATE TABLE or ALTER TABLE statement. We can use literals to represent “TRUE” and “FALSE” state in…

  • GoldenGate 23c Tutorial – Create Pipelines

    In the earlier tutorial we learned how to create a GoldenGate 23c connection. In this tutorial post we will learn about a new concept in GoldenGate 23c called Pipelines. A Pipeline essentially is an abstract presentation of the entire GoldenGate replication process. All the tasks which were earlier manually performed…

  • GoldenGate 23c Tutorial – Create a database connection

    In pre-23c GoldenGate days, quite a few steps had to be manually performed in the Oracle database which were prerequisites for a GoldenGate configuration. In GoldenGate 23c now all the same steps can be automated when we use the option “Create database connection“. Prerequisites are automatically checked and validated at…

  • Install Oracle GoldenGate 23c Free Release (Part 1 – using Docker)

    At the recent Oracle Cloud World 2023 conference which just concluded at Las Vegas, Oracle has made an announcement about the new Oracle GoldenGate 23c “Free“ release. The free GoldenGate 23c release provides support for all the new Oracle Database 23c objects and data types including blockchain, immutable tables, Boolean…

  • Install Oracle 23c Free Developer Release via Linux RPM

    This note describes the process used to install and configure Oracle 23c Free Developer Release on Oracle Linux 8 using an RPM file. Download the RPM for Oracle Linux via the URL below. https://www.oracle.com/au/database/free/get-started/ Install the oraclelinux-developer-release-el8 package. [root@db23c ~]# dnf install -y oraclelinux-developer-release-el8 Oracle Linux 8 BaseOS Latest (x86_64)…

  • Oracle Database 23c New Feature – SQL Firewall

    One of the new features related to database security introduced in Oracle Database 23c is SQL Firewall. It is embedded in the Oracle Database 23c kernel and conceptually is quite similar to Database Firewall (Audit Vault and Database Firewall AVDF). SQL Firewall offers real-time protection to the database from external…

  • Oracle Database 23c New Feature – DB_DEVELOPER_ROLE

    One of the nice new features in Oracle Database 23c is the new role called DB_DEVELOPER_ROLE. Rather than grant and revoke individual privileges to an application developer, we can just grant the single DB_DEVELOPER_ROLE role which contains (most of) the common and necessary privileges to design, develop, and deploy applications….

  • Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 6

    Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure. ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online. In a Logical Online migration, users are still connected to a live…

  • Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 5

    Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online. In a Logical Online migration, users are still connected to a live database…

  • Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 4

    Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online. In a Logical Online migration, users are still connected to a live database…

  • Enterprise Manager Cloud Control 13c Release 5 Upgrade

    This note describes the procedure used to upgrade Oracle Enterprise Manager Cloud Control 13c Release 3 to Oracle Enterprise Manager Cloud Control 13c Release 5 on a Linux platform. Edit /etc/security/limits.conf file [root@oemprod~]# vi /etc/security/limits.conf oracle soft nofile 30000 Set the following parameters on the OEM Repository database alter system…