Tag: Oracle

Save time with this quick OCI CLI installation

This is more of a personal reminder than anything else, but hopefully it helps save some time for others trying to install the OCI CLI on their local Linux machines. The idea is to have a very basic set of…

Read More >

How to configure X11 for Vagrant Box

“Good artists copy, great artists steal” – Pablo Picasso I am currently using Vagrant boxes from Mikael Sandström (oravirt) and unfortunately, it did not have X11 configured. Typically, using CLI is better for automation; however, there may come a time…

Read More >

Pythian is at COLLABORATE 19 – Join us in San Antonio!

COLLABORATE is the largest independently run Oracle conference in the world and as always, Pythian will be there in full force with several of our Oracle experts speaking on topics ranging from Oracle to open-source to cloud and more. This…

Read More >

Why you shouldn’t delete GoldenGate README

When installing Oracle GoldenGate for Big Data, it’s better to not delete the README file as it provides the version for GoldenGate Java Adapter. The version for GoldenGate ggsci is 12.2.0.1 while the version for Java Adapter is 12.3.0.1. The…

Read More >

How to accurately measure data guard lag events

If you work with Data Guard, the lag between the primary and standby database is an informative but difficult metric to measure. I’ve encountered some “solutions” that use the COMPLETION_TIME in (G)V$ARCHIVED_LOG for the standby destination as the time of…

Read More >

How to simplify automation: using environment variables

Michael Dinh provides simple solutions for automating GoldenGate processes from source to destination.

Read More >

How to retrieve growth history for oracle tablespaces

A customer recently asked us to identify tablespaces that most contributed to sudden space consumption on ASM. It’s easy enough to find what’s using the most space, but finding what’s been growing is a little less straightforward. Fortunately, Oracle keeps…

Read More >

Gathering GoldenGate deployment status

The objective of this post is to demonstrate how to gather existing GoldenGate deployment status. The rationale is to gather all the pertinent information for GoldeGate deployment using RAC in order to relocate the GoldenGate trail from DBFS to ACFS…

Read More >

Accessing Oracle Cloud Infrastructure (OCI) using Google G Suite SSO

Background One of the nice things about so many web apps these days is how easily they integrate with Google authentication and Single Sign-on (SSO). This is thanks to web-based authentication and authorization technologies such as SAML and OAuth. So…

Read More >

An Oracle-based approach to the “taxi fare” prediction problem – episode 2

This is the second part of the series on the Taxi Fare prediction problem from an Oracle perspective. You can read Episode 1 here. In this Episode, I will put our model to work. That is, I will show several…

Read More >
Page 4 of 158« First Page...23456...10...Last Page »