Tag: Oracle

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…

“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…

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…

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…

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…

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

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…

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…

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…

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…