• 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…

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

    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 1

    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 GoldenGate Cloud Service for MS SQL Server

    In March earlier this year Oracle announced Oracle GoldenGate Cloud Service support for more than 40 source and target technologies including Snowflake, MongoDB, Microsoft SQL Server, Azure SQL Database, Oracle Autonomous JSON Database, Oracle NoSQL, Azure Cosmos DB for MongoDB among others. https://blogs.oracle.com/dataintegration/post/oci-goldengate-adds-support-for-snowflake-mongodb-microsoft-sql-server-azure-sql-database-oracle-autonomous-json-database-oracle-nosql-azure-cosmos-db-for-mongodb-and-more In this example, we will see how…

  • Oracle 23c Schema Level Privileges and Schema-Only Users

    Oracle Database 23c now supports schema level privileges in addition to the existing object and system privileges. Application access can be granted at the schema level as opposed to individual objects like tables or views. Prior to Oracle 23c, if a new object is created in a particular schema, we…

  • Oracle GoldenGate Cloud Service – Purge Trail Files using REST API

    GoldenGate Cloud Service Trail Files can be purged either using the browser based OCI console as well as via the command line using REST API calls as shown below. Purging trail files via the OCI GoldenGate Deployment Console is very straight forward and simple! From the Configuration/Tasks menu, we can…

  • Resolving ORA-29003: SSL transport detected mismatched server certificate

    Recently production Oracle GoldenGate Cloud Service deployments Extract and Replicat processes ABENDED with the error message: OGG-00664  OCI Error ORA (status = 29003-ORA-29003: SSL transport detected mismatched server certificate. These Extract and Replicat processes were connected to an Oracle Autonomous Database on shared infrastructure. Both Oracle GoldenGate as well as…

  • OCI GoldenGate Cloud Service data streaming to Azure Data Lake Storage

    This note describes the procedure used to ingest data into an Azure Blob Storage Container using Oracle GoldenGate Cloud Service from a source Oracle Cloud Autonomous Database. One of the new features introduced late 2022 for OCI GoldenGate Cloud Service was to add Azure Data Lake Storage as a GoldenGate…

  • Oracle 19c Database and Windows AD Integration

    This step-by-step tutorial demonstrates how to configure Kerberos-based authentication in an Oracle 19c database and also how to configure Centrally Managed Users (CMU). CMU is the integration of the Oracle database with Microsoft Active Directory to allow centralized authentication and authorization of users. Download the note below.

  • Oracle AVDF 20.4 and OCI Autonomous Database Auditing

    This note describes the process used to configure and deploy Oracle Audit Vault and Database Firewall 20.4 in Oracle Cloud Infrastructure OCI via Cloud Marketplace. The note also covers the installation of the AVDF Agent on an OCI compute node and enabling auditing of an Autonomous Transaction Processing 19c database…

  • Auditing SQL Server 2019 with AVDF 20.4

    In this note we will see how we can add the MS SQL Server 2019 Adventure Works database to be a target in AVDF 20 Release 4. Enable auditing for the HumanResources.EmployeePayHistory table in SQL Server Adventure Works database. Access the HumanResources.EmployeePayHistory table and note that the audit file with…

  • Oracle GoldenGate and Audit Vault working together!

    The Oracle GoldenGate Integrated Extract process will capture changes from the transaction logs (in the case of Oracle database, the redo log files) and then these are written to GoldenGate trail files in XML format. Oracle Audit Vault and Database Firewall Transaction Log collector will forward transaction log records from…