TimesTen: Parallel Thread Reads from Checkpoint Files – More is not always better

I wanted to get around to to some performance improvements with Oracle TimesTen Database. As you know, the Oracle TimesTen database creates a checkpoint file for persistence of the In-Memory database. In the event you need to load the database into memory, depending upon the size of the checkpoint, this can take some time. In …


TimesTen: Failed to retrieve IP address of the system

In my quest to understand TimesTen a bit more, I built a VM with VirtualBox, OL 6.5, and TimesTen 11.2.2. I verified that I could connect to TimesTen from the VM instance, but when I tried to connect to the TimesTen database from my host (MacBook Pro), I received the following error:

I even tried …

Oracle, TimesTen

Oracle TimesTen not using Large Pages

 Oracle TimesTen Database, was not using Huge/Large pages. Well at least when I executed a ttStatus command, I saw the following: Shared Memory KEY 0x0c0504dd ID 1838710795 (LOCKED) when I expected to see Shared Memory KEY 0x0c0504dd ID 1838710795 (Large Pages,LOCKED)

My ttendaemon.options file was configured correctly (see snippet below): -linuxLargePageAlignment 2

Memory …

Oracle, SQLDev, TimesTen

SQL Developer with Oracle TimesTen ttStats

I’ve had the opportunity to work on with the TimesTen database on the Oracle Exalytics platform, and once again I got to use my favorite tool to make life so much easier. If you’ve ever used TimesTen, then the ttIsql command line should be familiar to you. In this post, I’ll show you how to …

Data Integration, GoldenGate, Oracle, Virtual Box

Create Wallet causes Segmentation Fault in Oracle GoldenGate12c and VBox5

Today’s blog will be quick. I’m operating in the following environment: Oracle Virtual Box 5.0.12 MacBook Pro (Retina, 15-inch, Mid 2014) Processor: 2.2 GHz Intel Core i7 Oracle 12c Oracle GoldenGate 12c A few weeks ago I attempted to create a wallet in Oracle GoldenGate and got this: GGSCI (trg.localdomain) 1> create wallet Source Context : …

Database, Oracle, Perl, Virtual Box

Oracle DB12c / OL7 / VBox 5 – Perl Segmentation Fault

Back on August 22, 2015, I wrote a post about some challenges I was experiencing while trying to install Oracle DB12c on Linux 7 using VirtualBox 5.x. You can read that here. Since then, I have had the opportunity to work with Simon Coter, Principal Product Manager for Oracle VM and VirtualBox to get to …

Data Integration, GoldenGate, Oracle

Initial Direct Load Access Denied in Oracle GoldenGate 12.2

Over the last few days, I’ve been checking out the Initial Load process in Oracle GoldenGate 12.2. While it seems straight forward, I kept running into an Access denied error. To be more specific the ggserr.log says: ERROR   OGG-01201  Oracle GoldenGate Capture for Oracle, eload01.prm:  Error reported by MGR : Access denied. How do we fix …

cloud, Oracle

My thoughts on Hybrid Cloud

My Thoughts on Hybrid Cloud Every now and then, I find myself getting into discussions about cloud computing, and recently had the opportunity to hang out at Oracle HQ with some Oracle ACE Directors and the OAUX team to see what they were doing. Following that up with a week at Oracle Open World 2015, …

cloud, Oracle Data Integrator

Connecting ODI 12c to Oracle Public Cloud (OPC)

Connecting ODI 12c to the Oracle Public Cloud Recently I had the opportunity to subscribe to the Oracle Public Cloud DBaaS, and since I’ve been working with ODI 12c in my test lab, what better thing to do than explore some opportunities to utilize these two technologies. This post will cover the steps necessary to …