Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are...
Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable Database to Teradata using Oracle GoldenGate for real-time data replication along with Oracle...
Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this;...
Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the...
Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In this part, we will do the same zero-downtime migration using Oracle SQL Developer to create the target schema and instantiate the tables, and use Oracle GoldenGate to replicate real-time SQL Server database transactions to an Oracle Pluggable...
Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export...
Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In Part 2, we performed the same zero-downtime migration using Oracle SQL Developer and Oracle GoldenGate. In this part, we again perform the same zero-downtime migration, this time using only Oracle GoldenGate to instantiate the Oracle tables and...
Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with...
Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with target database instantiation. In this series of articles we shall explore three options for migrating a Microsoft SQL Server Database to an Oracle Database. In Part 1, we'll use the Microsoft Import and Export Data Wizard to export the source SQL Server Database, create and instantiate the target Oracle Database Schema,...
Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with target database instantiation. In this...
In this blog article I will introduce you to the Oracle Content & Experience Content as a Service REST API. In this blog I will discuss the most used read...
In this blog article I will introduce you to the Oracle Content & Experience Content as a Service REST API. In this blog I will discuss the most used read operations. In a following blogs I will introduce writing content items. This blog discusses a non-public API. The API might change without warning. A Content as a Service API might be published later as part of the Content & Experience Cloud. Recently Oracle released Content as a Service as part of Content & Experience...
In this blog article I will introduce you to the Oracle Content & Experience Content as a Service REST API. In this blog I will discuss the most used read operations. In a following blogs I...
Introduction This post will walk a user through creating a storage volume, and an instance with that volume attached in the Oracle Public Cloud(OPC) via REST...
Introduction This post will walk a user through creating a storage volume, and an instance with that volume attached in the Oracle Public Cloud(OPC) via REST API's. While this article will use curl to demonstrate the calls, these steps can be replicated with any REST client of your choosing. Prerequisites In order to execute this process on your own, you must have: An Oracle Public Cloud domain with enough free resources to work in An account in your domain with the...
Introduction This post will walk a user through creating a storage volume, and an instance with that volume attached in the Oracle Public Cloud(OPC) via REST API's. While this article will use curl to...
Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall...
Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall present best practices when instantiating a target Microsoft SQL Server database from a source SQL Server database when implementing Oracle GoldenGate. Main Article When planning a target database instantiation, there are several questions you must first ask yourself: 1. Are we taking the source database off-line, or will...
Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall present best practices when instantiating...
When monitoring and/or troubleshooting the ICS Connectivity Agent server, it is important to not only have the standard logs (e.g., AdminServer-diagnostic.log)...
When monitoring and/or troubleshooting the ICS Connectivity Agent server, it is important to not only have the standard logs (e.g., AdminServer-diagnostic.log) but also the standard out/error (stdout/stderr). One of the big challenges of capturing the stdout is not exhausting the disk storage over time. Since the ICS Connectivity Agent is a WebLogic server installation, there are out-of-the-box options available for redirecting the stdout/stderr (see WebLogic Server logging...
When monitoring and/or troubleshooting the ICS Connectivity Agent server, it is important to not only have the standard logs (e.g., AdminServer-diagnostic.log) but also the standard...
Executive Overview Oracle Database File System (DBFS) is used in providing shared storage mount points within SOACS and MFTCS clusters. DBFS provides a standard...
Executive Overview Oracle Database File System (DBFS) is used in providing shared storage mount points within SOACS and MFTCS clusters. DBFS provides a standard file system interface for directories and files on top of database tables[1] . So, by using the database running in the DBCS instance associated with any SOACS or MFTCS instance, DBFS provides a shared network file system similar to NFS that appears like a local file system. This shared network file system provided by...
Executive Overview Oracle Database File System (DBFS) is used in providing shared storage mount points within SOACS and MFTCS clusters. DBFS provides a standard file system interface for directories...
