Recently I needed to investigate a performance problem for 2 customers, which turned out to be problematic execution plans. It had the smell of Oracle optimizer bugs all over them. Although the first one is maybe somewhat self-inflicted injury. Both environments were using Oracle 12.1.0.2 with the October 2017 patch set. Case 1: functions on…
Allow DBaaS access to your company In the previous post we connected to our database using ssh port forwarding. Although this works well for client connections, it can be clumsy (and an added dependency) to use this method on servers. Of course, Oracle has solutions such as VPN-as-a-Service or FastConnect to tackle this, but for…
So far we have created our Oracle Cloud Account, set a storage georeplication policy, created a backup user and private IP subnet. Now, it is time to create our DBaaS guest. Oracle DBaaS guest creation From the dashboard page, open the “navigation menu” and click on “Database”. As this is our first guest, we are…
In Oracle Cloud, going down the rabbit hole – Part 1 of this series we created our cloud account, in this second part we will create our DBaaS guest. But before we can actually create our guest, we first need to do some ground work. Storage Replication When you create your DBaaS guest, you can…
A journey of a thousand miles begins with a single step. In our cloud journey, it begins with creating our Oracle Cloud “Account”. Luckily Oracle has a free trial option, which consists out of € 250 worth of cloud credits during a 1 month period. So browse to https://cloud.oracle.com and click on the “Try for…
There are not many companies in Belgium that are already doing a lot of real work with the Oracle Cloud. Although people are interested, they also fear the unknown. In order to be able to help our customers, we at Exitas needed to get some experience with the Oracle Cloud beyond the theory or workshops….
When applying an ODA patch, you use a dedicated patch bundle which include the patches for all the different component ranging from the disk firmware and the OS to the database software itself. These patch bundles are then installed using oakcli (or odacli, depending on your ODA version). Given this patch methodology and given that…
One of my customers had a problem with a query which ran fine for one person, but would result in a disconnected session for another user. Checking the alert file showed that the reason for the disconnect was an ORA-07445 [evaopn3()+107] exception. Unfortunately that answer was not sufficient for them, they also wanted to know…