Tag: Oracle

Cloning a PDB with encrypted data in united mode – avoid ORA-00283

The purpose of this blog post is to give you some guidelines on how to avoid “ORA-00283: recovery session canceled due to errors” during a PDB clone operation and troubleshoot the same. In the Oracle documentation (link), it notes the…

Read More >

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

Although I haven’t produced a lot of posts, those I have produced were always strictly related to the Oracle RDBMS as a whole product, basically a record of interesting findings that came up during my day-to-day job. Now, this is…

Read More >

Automating Oracle patching with an Ansible module

This is a blog post I had on my To Do list for quite some time. I finally found some time to write about it. I will try to keep it short and clear. In 2017 when I discovered Ansible,…

Read More >

Listener over Infiniband on Exadata (part 1)

Nice topic, right? Beautiful thing to work with when you have Oracle Engineered Systems. So, why would you configure a listener over the InfiniBand Network? How does that make sense in your environment and how would you leverage that? Background…

Read More >

Reviewing the operation modes of Oracle GoldenGate BigQuery Handler

GoldenGate for Big Data 12.3.2.1.1 introduces a new target – Google BigQuery. BigQuery handler can work in two Audit log modes: 1. auditLogMode = true 2. auditLogMode = false I want to review the differences between these two operation modes…

Read More >

Log buffer #558: a carnival of vanities for DBAs

This log buffer edition overs cloud, Oracle, PostgreSQL and MySQL. Cloud On December 4, 2018 Microsoft’s Azure Database for Open Sources announced the general availability of MariaDB. This blog intends to share some guidance and best practices for alerting on…

Read More >

Using RDA to check Oracle Database preinstallation

Remote Diagnostic Agent (RDA) is often under-utilized. It has some very nice features such as database preinstallation check. Remote Diagnostic Agent (RDA) – FAQ (Doc ID 330363.1) Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1) Stay with me…

Read More >

How to create an Oracle 18c client image in Docker

Use docker and Oracle Dockerfile to easily install new Oracle client software.

Read More >

GoldenGate: relative or absolute path for trail files?

When implementing GoldeGate solutions, something as simple as path to trail files can create havoc. What is the correct path for trail format? It depends. There is one important factor to consider. You can change any of the attributes specified…

Read More >

How to use Oracle Instant Client Docker images

Learn how to use Oracle Instant Client Docker images in your environment.

Read More >
Page 5 of 158« First Page...34567...10...Last Page »