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 >

How to build your very own Cassandra 4.0 release

Over the last few months, I have been seeing references to Cassandra 4.0 and some of its new features. When that happens with a technology I am interested in, I go looking for the preview releases to download and test….

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 >

Rotating your ProxySQL log files

Recently I received several questions about rotating log files for ProxySQL, so I decided to draft it up as a blog post. Let me go by this using an example. In my testing lab, I have set up a fairly…

Read More >

Achieving rock-solid maintenance with template-based action plans

Pythian has always been serious about reducing human mistakes. Our consultants have always been required to log all terminal outputs for the work we execute so that the information is available to our clients, and to make sure the same…

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 >

Monitoring your 5.7 InnoDB cluster status

Recently we had a customer who came to us for help with monitoring their InnoDB cluster setup. They run a 5.7 InnoDB cluster and suffered from a network outage that split up their cluster leaving it with no writeable primaries….

Read More >

How to determine RMAN backup size

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation for the SQL query. Why is this important? Because, as part of a backup review, it’s good to know the growth for the backup…

Read More >
Page 3 of 33812345...10...Last Page »