Machine Learning with Oracle Database Advanced Analytics

TL;DR: Oracle DB + Oracle Data Mining + Oracle R Enterprise = Database Advanced Analytics (OAA) The Database Advanced Analytics option allows running Machine Learning algorithms within the database itself. The on-prem flavor of OAA is available as part of database Enterprise Edition 12c and upward releases. In OPC, OAA is available as part of […]

UTL_Match and Soundex for ‘Fuzzy’ Matching of Data in an Oracle Database

For other A-Team articles by Richard, click here Introduction In today’s data-centric world, the BI professional is often faced with the problem of joining data sets from different sources. In a normalized relational database, you can typically just join column A to column B, and be on your way. Unfortunately that’s always not the case.  Take the […]

Remounting DBFS Shared Storage in SOACS and MFTCS Clusters

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 […]

SOA Cloud Service – Quick and Simple Setup of an SSH Tunnel for On-Premises Database Connectivity

Executive Overview With the current release of SOA Cloud Service (SOACS) a common requirement often requested is to connect to an on-premise  database from the cloud SOACS instance. This article outlines a quick and simple method to establish the connectivity between the single-node SOACS instance and the on-premise database server using an SSH tunnel. Solution […]

Getting Started with Oracle Database Cloud Service – Virtual Image – Creating a database

Introduction The Oracle Database Cloud Service – Virtual Image option gives great flexibility on how to deploy databases in the Oracle Cloud. It allows customization options in almost all aspects of the database (e.g. file system layout, memory management, etc.). This makes this option very beneficial – for example – in highly customized database deployments […]

Configuring your Oracle Database for Kerberos authentication

Introduction I have two goals with this post. To show how to setup Kerberos authentication for the Oracle Database and also demonstrate that the use/configuration of Kerberos is pretty straightforward. At least with the versions and OS I have used for this setup. The Kerberos functionality is provided by the Advanced Security Option of the […]

Getting The Most Out Of Your WebCenter Content Database Metadata Search Engine configuration On Oracle 11g Database

  Introduction Being able to retrieve information as quickly as possible in a Content Management implementation is extremely important to provide knowledge workers with the data they need to do their jobs as efficiently as possible. This article is targeted at providing information on some recent discoveries on ways to keep your WebCenter Content Metadata search at […]

Oracle GoldenGate in a distributed file system with file locking

Introduction This write up illustrates Oracle GoldenGate’s behavior in a distributed file system environment that supports file locking. Oracle GoldenGate(OGG) is very commonly used in an Oracle RAC environment. When OGG is installed in a distributed file system in a RAC environment, at any given time the OGG processes run in a single node of the cluster. To prevent accidental startup […]

Correlating SQL statement in DB Sessions with ODI Sessions in ODI 11.1.1.7

Jayant Mahto from the ODI Product Management team has published an excellent blog explaining how to correlate database sessions with ODI sessions. You can find his post here: https://blogs.oracle.com/biapps/entry/correlating_sql_statement_in_db For more ODI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit “Oracle A-Team Chronicles for […]

How to Understand and Diagnose ODI Connectivity Issues

Introduction Understanding connectivity issues in an ODI environment requires a good grasp of the ODI architecture, as well a good understanding of where to look for information when such problems arise. We will review all these elements to help with diagnosis and resolution. How to Understand and Diagnose ODI Connectivity Issues We will start with […]

A convenience method for closing multiple resources

Introduction Ensuring that resources (e.g. database connections) are properly closed to avoid leaks can make your code cumbersome. This article offers a simplification for this issue. Main Article As with all things Java, it’s often best to show by example. So that’s exactly what I’m going to do. The example that we’ll work with is […]

Bulk loading a Coherence cache from an Oracle Database

Recently, I’ve worked on a couple of projects that required pre-loading data from an Oracle Database table into an Oracle Coherence cache. There are many ways to accomplish this task, but what I’ve found to work well is to distribute the load processing to the Coherence grid itself. To do this, I use the Coherence Invocation Service. To get […]

Memory requirement for Oracle GoldenGate Integrated Extract

Introduction  This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated Extract(log mining server) comes from the “STREAMS POOL” portion of the System Global Area (SGA) in the database. Therefore, you must set  it high enough to keep enough memory available for the number of Extract processes […]

Database Objects Creation Sequence Could Impact Oracle GoldenGate DDL Replication

Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even […]

Oracle GoldenGate Best Practices: GoldenGate Downstream Extract with Oracle Data Guard

Introduction Oracle’s customers are seeking the highest level of data protection and availability.  In doing so, they have deployed complex configurations using the latest HA and DR solutions.  The goal of this blog post is to discuss an approach of integrating Oracle GoldenGate Downstream Integrated Extract with Oracle Data Guard. Main Article   Downstream Integrated […]

Oracle GoldenGate Best practices: GoldenGate parameter files

Introduction  This paper provides an example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication that complies with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Main Article Most Oracle GoldenGate functionality is controlled by means of parameters […]

Oracle GoldenGate Best Practices: Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes

Introduction This technical document describes how to combine the GoldenGate logdump utility, UNIX shell scripting and MS Excel to generate a detailed summary report to aid in manual load balancing of tables across multiple GoldenGate replication processes. This document is not intended to be a comprehensive overview of all replication performance techniques; it is limited […]

Oracle GoldenGate Best Practices: Extracting object ID’s for ALTID Table Mapping

Introduction In some cases it may be necessary to use the object ID’s to extract table data. This document covers the steps necessary to convert a list of tables into a list of object ID’s that can be used in an extract process as ALTID’s.   ALTID’s can be used in the case where a source […]

Oracle GoldenGate Best Practices: Oracle Streams to Oracle GoldenGate Conversion for Reporting Databases

Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue to be supported, but will not be enhanced. For this reason, some Oracle Streams customers may prefer to migrate their replication environments to Oracle GoldenGate. Main Article The goal […]

Oracle GoldenGate Best Practices: Dual Apply

Introduction Oracle GoldenGate provides a real-time, log-based change data capture and replication software platform that enables high volumes of transactional data to be moved between homogenous and heterogeneous platforms and databases, even bi-directionally, in sub-second speed, with no impact. With this technology, Oracle provides continuous availability and real-time data integration solutions to deliver real-time access […]