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 >

Creating a custom Oracle EBS preinstall RPM for RHEL7

Oracle, by default, ships preinstall RPMs only for Oracle Linux. Preinstall RPMs make the life of DBA very easy by taking care of installing full laundry lists of required prereq RPMs for Oracle E-Business Suite, as well as setting all required…

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 >

How to create an Oracle 18c client image in Docker

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

Read More >

How to use Oracle Instant Client Docker images

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

Read More >

Using Docker to provide self-service database patching

I’ve been looking into how Vagrant and/or Docker can be used to improve the life of DBAs and maybe others, too. I did this mostly to practice using these tools – especially Docker – that are becoming more and more important…

Read More >

HCC compression on Oracle Live SQL

I’ve written previously about “Oracle Live SQL”, a free service from Oracle where you can try your coding skills and learn using its vast code library. Today I want to mention one of its other features which may not be…

Read More >

How to test an Oracle database upgrade using a physical standby

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to 11.2.0.4 right on Friday. This is just to make clear that I did not have much…

Read More >

Shutdown while upgrading to 18c

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

Read More >
Page 1 of 1812345...10...Last Page »