Error while compiling program with oci.h

I was developing small utility using C++ some time ago and used Visual Studio as IDE and compiler. I’ve included oci.h to connect to Oracle Database like this #include <stdio.h> #include “oci.h” but got following errors Error    C2371    ‘BOOLEAN’: redefinition; different basic types Error    C2632    ‘char’ followed by ‘int’ is illegal Warning    C4091    ‘typedef ‘: …

Continue reading ‘Error while compiling program with oci.h’ »

GoldenGate 12.3: announcement, new features and installation

Oracle has release new version of GoldenGate 12.3 in 18 August. This is very long awaited version – it postponed 2 or 3 times because of some very important new features. See some useful links for GoldenGate 12.3: We can download GoldenGate 12.3 here http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Documentation is available here: http://docs.oracle.com/goldengate/c1230/gg-winux/docs.htm

Oracle DataSource for Apache Hadoop (OD4H): introduction

Introduction Currently we see that Hadoop is becoming part of Enterprise Data Warehouse family. But family should be connected to each other. Sometimes we need access to Hadoop from Oracle Database. Sometimes Hadoop users need enterprise data stored in Oracle database. Hive has very interesting concept – External Tables which allow you to define Java …

Continue reading ‘Oracle DataSource for Apache Hadoop (OD4H): introduction’ »

GoldenGate Cloud Service (GGCS): Configure GoldenGate to replicate data

GoldenGate Cloud Service is part of Oracle’s PaaS portfolio. From technical perspective it is just standard GoldenGate deployed on VM in Oracle Cloud. So same already proven architecture works in Cloud. GGCS can be used for different cases from zero downtime migration to real-time DWH feeding. More cases like BigData and data pipeline feeding are …

Continue reading ‘GoldenGate Cloud Service (GGCS): Configure GoldenGate to replicate data’ »

Oracle Database Cloud Service: Create database

Oracle Cloud provides several Oracle Database offerings. You can choose from a single schema based service virtual machine with a fully configured and running Oracle Database Instance Exadata Service with all the database features. You can look into details here: https://cloud.oracle.com/en_US/database We will talk about Database as a Service and not about Schema or Exadata …

Continue reading ‘Oracle Database Cloud Service: Create database’ »

Oracle Storage Cloud Service: Creating Containers Using the REST API

Introduction Let’s define terms which Oracle uses in Oracle Cloud Services. Block Storage – optimizes storage for IOPS and block-based access and provides POSIX-compliant file systems for Oracle Compute Cloud Service instances. This is just standard disk device. Sometimes it is only one drive, sometimes it is RAID device. But anyway application access it using …

Continue reading ‘Oracle Storage Cloud Service: Creating Containers Using the REST API’ »

GoldenGate Studio: Quick Start

Introduction You work with GoldenGate then you know that there was tool GoldenGate Director for configuration, deployment, monitoring and management. Really these responsibilities are distributed among development and support. So there should be two tools: for development and for support. Oracle is following this ideology and has created two tools:   GoldenGate Monitor (or GG …

Continue reading ‘GoldenGate Studio: Quick Start’ »

Configuring GoldenGate to replicate data from MSSQL Standard Edition (CDC, Change Data Capture)

Introduction One of GoldenGate 12.2 new features is replication support for MSSQL Standard Edition. In the previous GoldenGate 12.1 release, GoldenGate supported capture of DML only from SQL Server Enterprise Edition, due to the method of enabling Supplemental Logging, which is done via a feature only available to Enterprise Editions of SQL Server. Fortunately, beginning …

Continue reading ‘Configuring GoldenGate to replicate data from MSSQL Standard Edition (CDC, Change Data Capture)’ »