Protect your databases Every company has one or more firewalls that control access to their servers and PC’s. Almost every company has a Windows domain where policies and access to resources are configured. But only a few companies control the SQL traffic to their databases. Of course, database administrators can define access rights in the…
When I started one (of the many things) that struggled with was how to assign a reserved public ip to a guest when using Terraform. And as I don’t seem to be to only one, I decided to write a quick blog post to explain how to do it. But first, some background. Terraform Terraform…
Past month I presented my “DBAs in the mist” presentation about the Oracle Cloud during one of the Exitas Technical Lunches. This presentation was an updated version (cloud changes fast) of the one I presented in February at the Belgium Tech Days As there seems to be some demand for an introduction presentation on the…
I must admit that this post was for me the most difficult one yet to write in this series. Partly because it also touches how to structure things to keep it manageable in the future. I have also been told it is a long post. So reserve some time, grab a coffee, tea or your…
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….